Advanced Ms. Excel II

Advanced Ms. Excel I



Pre-requisite

- Completion of Ms Excel Advance I class

 

Who should attend?

- Account/ HR/ Audit officers

- Financial controllers

- Financial reporting staff and managers

 

Course Outline

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