Attendance at this seminar will secure 4.5 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
YVONNE ROSSOUW
yvonner@probetatraining.co.za
Excel Advanced: Data Extraction and Manipulation (Half Day, focusing on certain topics only
TBA
1. Setting up the ODBC Drivers
2. Imputing data from Pastel
3.VLOOKUP function/XLOOKUP Function
4.Filtering of data
5.Create unique lists
6. Create a pivot table
7. Creating queries using the Query wizard
8.Practical accounting and audit examples
Financial managers
Auditors
Bookkeepers
Financial accountants
First year SAICA Trainees
Second year SAICA trainees
Third year SAICA trainees
Fourth year SAICA trainees
Fifth year SAICA trainees
Audit mangers
Audit partners
