Shop

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

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.

Be the first to review “Advanced Excel and Financial Modeling Training”

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

X