MS Office Training Course Provider
 
Go to Mouse Training Home Page All Software,  Computer and IT Training Courses in London and the UK Personal Development and Management Training Courses Bespoke System Training Experts in London MS Office - Excel, Access, Word and PowerPoint Consultancy in London All Mouse Training Services About Mouse Training - The Best London Training Course Provider Contact the Experts - Mouse Training!

London Training Courses

Microsoft Courses

IT Training Courses

Mac Office Courses

IT Training Courses

Adobe Courses

IT Training Courses

More Courses

IT Training Courses

Google Docs Courses

IT Training Courses

Get Expert Tailored Training Solutions

 
MS Office Training Provider

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 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,
  • 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
 

More Focused Excel Courses

Excel Database and List Training Course
Excel Functions and Formulae Training Course
Excel Modeling Training Course

We also run standard Excel Training Courses from Beginners to VBA

How to book your course

How to book

  • Contact us via email or call us on 020 7920 9500
  • We agree a date and course outline with you
  • Confirmation takes place by email or phone
  • That's it!

Contact Us for Training course advice and tailoring

Training Course Costs On-Site

Training Course Info

You can also download our MS Office Training Manuals for Microsoft Office 2000, 2002(XP) and 2003

Training Course Costs On-Site

Course Costs

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.
Get an Instant Quote for your training course

On-site Training Course Quote

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

Custom Course Builder

Tailored Access  Training Courses Access
Tailored Excel Training Courses Excel
Tailored PowerPoint  Custom Training Courses PowerPoint
Tailored Word Custom Training Courses Word
Tailored Project Custom Training Course Project
Outlook Custom Training Course Outlook
Visio Custom Training Course Visio
Publisher Custom Training Course Publisher
Home | Software Training | Soft skills Training | Bespoke Training | Consultancy | Services | About Us | Contact Us | Privacy Statement | Links | Sitemap © 2007 MTC All rights reserved