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