Virtual Training Course

Excel for Accounting and Audit Trainees

>> Click here to book this training as an In-House course <<

This Course is not part of the MUS Subscriber discount structure.

Price: R690.00 (VAT Incl.) Per Person
Presenter: Mr Tristan White
Date: 27 Jan '22
Times: Registration:08H00 Start:08H30 End:11H30
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)
Platform: Web Based (Online)
Course Facilitator: Tristan White
T:  011-886-1395
Back Book Now

Trainees need to hit the ground running when they join a firm but one of the biggest things that slow trainees down is Microsoft Excel. Imagine what the wasteful labour cost must be from using it inefficiently? Put your trainees in the lead by allowing ProBeta to help them be more efficient as we practically navigate the Excel functions / scenarios most often encountered in practice.

• Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / various ways to Paste data • Recovering Lost Documents: Finding lost documents / Attaching to emails • Built in Templates: Invoices / Loan amortisation schedule • Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks. • Data Editing: Sorting / filtering / Subtotal formula / conditional formatting. • Data Searching: VLookUps / Search and Replace text. • Data Extraction: Flash fill / Text-to-Columns / Concatenate. • If Statements: If and CountIf formulae. • Clean up GL: Various helpful tools to clean up general ledger accounts • Building Formulae: Cell referencing within formulae i.e. relative and absolute references. • Tables / Graphs: Create pivot tables.

Investment managers First year SAICA Trainees Second year SAICA trainees Third year SAICA trainees

Strong / stable internet connection