As an auditor or accountant, you will use excel on a daily basis to compile working papers and perform calculations. Are you aware of the functions available to increase your productivity? You can create powerful audit and exception reports, by making use of ODBC, Microsoft Query and various excel techniques. In this session we look at creating reports in excel using ODBC for Pastel and using excel techniques to edit and work with the data. This session is beneficial even if you do not use Pastel, as a majority of the session is focused on the excel techniques.
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 managers Audit partners