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