Course Recording

Excel - Intermediate

Recording Link
Firm/Group/Company - R1460.50 (VAT Incl.)
Individuals - R598.00 (VAT Incl.)
Recording Link
Price (MLU Subscriber):
Firm/Group/Company - R1092.50 (VAT Incl.)
Individuals - R460.00 (VAT Incl.)
Presenter: Mr Tristan White
CPD Hours: 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.
Platform: Web Based (Online)
Course Facilitator: Tristan White
T:  0118861395
Back Order Now

If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour 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 - Freshen up 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 Financial formulae, 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 complexities of formula referencing o Introduction to intermediate functionality including Pivot Tables, VLookUps and Financial formulae

• Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula. • Data Searching: VLookUps / CountIf formula / If statements / Search and Replace text. • Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate. • Building Formulae: Cell referencing within formulae i.e. relative and absolute references. • Financial Functions: PMT, RATE, IPMT, NPV, FV and PV • Tables / Graphs: Pivot tables.

• 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.