Excel Functions & Formulae Training Course

Excel Training Courses London
Expert Excel Training Course Provider
 
 
line decor
Our Expertise: Excel Training Course in London | Advanced Excel Training Courses | VBA Excel Training Course | London's Best Excel Training Courses
line decor
 
 
 
 
 
 

Excel Modeling Training Course

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 understanding 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 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.

Excel Model Building Training Course Information

Duration :
   Our Excel Modeling training course is a 1 day course. The course will start at 09:30 and run until 16:30 to 17:00
Venue :
   We can run your Excel Modeling training course in London either at our Excel Training center in the City or on-site at you office. We can even provide the training equipment if you do not have a dedicated IT training room
Dates:
   We run the Excel Modeling training course when you need it, not to a predefined schedule. That means your team can decide a date that is suitable for all.
Cost :
  

We have a unique pricing structure for our Excel Model Building training course. We charge per day, not per delegate which means last minute changes to your Excel Modeling Preparation course is not affected.

1 to 1 training = £450 per day*. The Excel Modeling course will be tailored to your exact needs and you will not be held up (or holding up) other users on your Excel Modeling Course.

2-8 delegates = £695 per day*. If you have 8 delegates on the course, this equates to less than £100 per person. You will not find a more cost effective rate anywhere else. As mentioned on our home page, clients like Google, HSBC and many more make use of us, as we are the best Excel training course provider with a cost that won't rob your training budget

Excel Modeling Training Course Content

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, MATCH, INDEX 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
Basic List Manipulation
  • Sorting
  • Pivot Tables
  • Using Excel Lists
  • Using Text to Columns
What If Analysis
  • Using Data Tables
  • Goal Seek
  • Solver
  • Scenarios
Creating Form Controls and Protection
  • Adding Form controls - Combobox, Check, Option Buttons, Lists,
  • Protecting Sheets and Workbooks
Setting up Shared Workbooks
  • Sharing workbooks
  • Tracking Changes
  • Accept / Reject Changes
Introduction to Macros
  • Recording Absolute / Relative Macros
  • Running macros from worksheet buttons
  • Attaching macros to form controls
  • Basic Macro Editing
  • Sample VBA Function
 
 

Please note the above Excel Modeling training course content can be customized to suit your exact needs depending on your existing knowledge of Excel. Feel free to contact us to help you build the perfect Excel Modeling Training Course. We believe that we are the best Excel Modeling Training Provider in London and can provide training on any function if requested

* All prices are excluding VAT and subject to a 5 day cancellation period for our Excel Modeling Training Course. Also have a look at our Excel Training Courses from MTC
 
 
 

Contact Us
Tel: 020 7920 9500 info@exceltraininglondon.co.uk

Excel Modeling Training Course Offer
Book your Excel Modeling Training Course before the 01/03/2011 and we will give you an Excel Bible Free!

Free Excel 2010
Advnaced Manual!
You can now download our Excel 2010 Advanced training manual for free!
Excel 2010 Advanced Manual

If you wish to purchase the entire suit of Office 2010 manuals, please contact us

 
 
  
 
Excel Training London is part of the MTC Group of Training Providers  

Mini Site Map