Attendance at this seminar will secure 3 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
Tristan White
0118861395
nerissa@probetatraining.co.za
If you or your firm use Excel for multiple hours each day, imagine what the wasteful labor cost must be from using it inefficiently.
ProBeta Training has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting, or office administration.
The goal of this course is to
- Build up on your Basic Excel knowledge,
- Improve your efficiency and
- Show you alternative ways to get the same things done.
This session focuses on the value-add elements like VLookUps, Pivot Tables, Concatenating text, and Conditional formatting, formula referencing, amongst others -- for those with an already established basic level of Excel knowledge.
Enabling delegates to:
o Enter and edit data in a variety of ways
o Understand the complexities of formula referencing
o Introduction to intermediate functionality including Pivot Tables, VLookUps, and Formulae referencing
• Introduction: Terminology/layout and interface/move or copy sheets / Status Bar / various ways to Paste data
• Recovering Lost Documents: Finding lost documents / Attaching them to emails
• Built-in Templates: Invoices / Loan amortization schedule
• Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.
• Data Editing: Sorting/filtering / Subtotal formula / conditional formatting.
