Description of Course
This program is recommended for Executives, Accountants or the like who has a basic knowledge in MS excel and they need to master the advance functions of Excel.
Entry Requirements
All IT and non IT professionals
Course Content
- Using Advanced Functions
- Using Other Functions
- Working with Tables
- Working with Data Series
- Using Scenario and Goal Seeking
- Using Worksheet Protection
- Consolidating Worksheets
- Using Templates
- Working with Views
- Creating/Revising PivotTables
- Sharing Workbooks
- Using Data Tables
- Using Auditing Tools
- Interdiction to VBA
- Interdiction to Macros