Advanced Excel and Financial Modeling Training

₦85,000.00

We live in a high paced business environment with critical transactions, calculations, analysis and data constantly dictating the extent of business success. Simply put, the 21st-century business is transacted at the speed of light. Companies who operate at annual speed and transact business the old way, generally find themselves left behind. Microsoft Excel is one critical tool at the force of this business revolution. It allows organizations to operate at remarkable speed and a respectable level of accuracy. Using Excel allows data of large volume to be processed very quickly and easily. This course places Microsoft Excel at the fingertips of participants.

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