Attending the course and successfully completing the post-assessment, will grant you
2 hour/s verifiable CPD, recognised by the various
professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc). Please note that the
CPD certificate will only be issued once the post-assessment has been completed.
Web Based (Online)
Select
nerissa@probetatraining.co.za
Have you hired new staff since going back to the office and need them to sharpen their Excel skills? Or are you required to work remotely, but finding the going a bit slow because you are new to Excel?
Start your Excel journey well -- by joining ProBeta Training as we help give new Excel users a back to basics foundation in using Microsoft Excel.
NOTE: This is a practical session whereby the presenter will demonstrate various Excel functions and features.
Enabling delegates to:
o Open and create Excel workbook files
o Use the Excel interface
o Enter and edit data in a variety of ways
o Understand basic formulas and functions
o Use the new Quick Analysis feature
o Format worksheets and data
o Print and share workbooks
• Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / Print Preview / Formatting / Format Painter / various ways to Paste data
• Recovering Lost Documents: Saving documents / Attaching to emails / Auto-save function / Finding lost documents.
• Built in Templates: Budgets / expense tracker / invoices.
• Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.
• Data Editing: Adding filters and sorting
• Building Formulae: Useful everyday formulae / functions, Mathematical operators within Excel.
• Tables / Graphs: Quick analysis / charts.
• Printing: Set print area.
• 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.
