Financial Modeling Training


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. Financial Modeling 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.


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



There are no reviews yet.

Be the first to review “Financial Modeling Training”

Your email address will not be published. Required fields are marked *