Many of our clients send their staff on our Excel Modeling Training Course to ensure when they attend their business specific Excel modeling course, they do not waste time explaining common Excel tools. The Excel Model building training course will cover aspects required to build any type of model, from Financial to Engineering Models.
Although we do not cover VBA or Visual Basic on the Excel Modeling course, we do offer an Excel VBA Course if required. We will cover recording and running Macros however. Please contact us for any further information.
This is a 1 day training course and our standard rates apply.
Range Names
How to create and edit Range Names for Formula compiling
Applying range names in Formulae
Logical and Lookup Functions
IF, AND, OR
VLOOKUP, , HLOOKUP, other functions on request
Nesting Functions
Understanding Nesting
Nesting using the Functions Dialogue
Nesting using spreadsheet formula building
Function Auditing
Tracing Dependent, Precedents
Tracing Arrows
Worksheet Protection
Protecting only cells that contain Functions or Formulas
Data Validation
What If Analysis
Using Data Tables
Goal Seek
Solver
Scenarios
Creating Form Controls and Protection
Adding Form controls - Combo box, Check, Option Buttons, Lists,