Basic Excel – Introduction for Entry-Level Users

In-house course

2
Attendance at this seminar will secure 2 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
Tristan White   0118861395   gillian@probetatraining.co.za

Are you new to Excel? Have you just joined the work force? Is there a new recruit who will need to use Excel to fulfil daily work duties?

If you’ve answered yes to any other above questions, then join us for a two-hour webinar where we introduce you to Microsoft Excel.

Enabling delegates to:
o Open and create Excel workbook files
o Use the 2016 interface
o Format worksheets and data
o Become comfortable with Excel’s interface

• Introduction:
o Terminology
o Layout and interface
o Move or copy sheets
o Status Bar
o Print Preview and set print area

• Completing / Filling in a Spreadsheet

• Working with Data:
o Formatting data (changing appearance, font, size, colour and upper-case / lowercase) and Format Painter
o Inserting Line Breaks
o Various ways to Paste data

• Recovering Lost Documents: Auto-save function.

• Built in Templates: Exploring pre-created templates eg. budgets, expense tracker, invoices

• Creating and Editing a Spreadsheet:
o Insert, delete and adjust rows and columns
o Executing sum formula
o How to do spell-checks

• Navigating Seamlessly:
o Freeze panes
o How to navigate without a mouse
o How to search for text
o Quick access toolbar

• Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area.
• Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management.
• Delegates that prepare reports and need to be able to edit text and numbers.