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.