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.
