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.
If this sounds like the training course you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.
Excel Modeling Training Course Contents
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 spreasheet formula building
Function Auditing
Tracing Dependent, Precendents
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 - Combobox, Check, Option Buttons, Lists,
1-to-1 training courses are charged at £450 per day. (Our offices or your venue)
All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.
We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.
For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Build your course
With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page
