Description
Course Outline
MODULE ONE – Analyzing Data
- What if Analysis
- Goal seek
- Data table
- Scenario manager
- Solver
- Using Pivot Tables
MODULE TWO – Macros and Custom Controls
- Working with Macros
- Running Macros
- Adding Custom Controls
MODULE THREE- Security and Proofing
- Security features
- Protecting data
- Worksheet Protection Using Data Validation
MODULE FOUR – Security and Proofing
- Working with Macros
- Running Macros
- Adding Custom Control
MODULE FIVE – Consolidation
Learning Objectives
At the end of the training program, participants will be able to:
- Analyze data using the various tools in excel;
- Control data presentation, movement, tracking, progression and changes in general; and
- Applying security features to data;
- improving productivity; and
- Enhance spreadsheets with charts and formulas
Who Should Attend?
All staff responsible for collecting, analyzing or managing data in Finance, Management, Manufacturing,
Distribution and Retailing, Procurement, Administration, Supply Chain, Logistics and much more
Reviews
There are no reviews yet.