Available Course
Excel Intermediate -
>> Click here to book this training as an In-House course <<
Duration: | 3 Hours |
CPD Hours: | Attendance at this seminar will secure 3 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc) |
Course Facilitator: |
Tristan White
T: 0118861395 E: nerissa@probetatraining.co.za |
Back |
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.