What to expect?

- Advanced Ms Excel Functions

- Time-saving techniques that’ll allow you to get your work done faster with Excel

- Adding and using the Analysis ToolPak to make complex data analysis a snap

- How to create a PivotTable report to quickly analyse volumes of data, generate summary views, see comparisons and reveal patterns in your data

- And much more

Pre-requisite

- Completion of Ms Excel Advance I class

Who should attend?

- Account/ HR/ Audit officers

- Financial controllers

- Financial reporting staff and managers

Course Content

- What If Analysis

- Advanced Excel Course - Working with Functions

- Working with data using financial functions

- Recording and Running Macros in Excel

- Introduction to the Excel VBA Editor

- Creating Procedures and Functions

- Working with the Excel Object Model

- Controlling Program Flow

- Advanced Procedures in Excel VBA

- Debugging and Error Traps