Microsoft Office training - Excel Business Modelling (2 days)

This course is for Microsoft Office versions up to 2003 - we also run an equivalent Excel 2007 Business Modelling training course.

This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names.

Excel Business Modelling training - Course Contents

The contents of our Excel Business Modelling course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please call or email us to talk through your options. We want you to be on the right Microsoft Office training course as much as you do!

Building models
  • Freezing windows
  • What makes a good formula
  • Separating inputs and calculations
  • Avoiding the IF function
  • Maintaining constant periodicity
Range names and absolute references
  • Absolute references ($ symbol)
  • Fixing only the row/column
  • Creating range names
  • Labelling ranges automatically
  • The amazing 40% rule
Number formatting
  • Conditional number formats
  • The four parts of a format
  • Creating custom formats
  • Formatting dates and times
Advanced formatting
  • Creating and applying styles
  • Grouping and outlining
  • Data validation
  • Applying protection
Styles
  • Creating formatting styles
  • Using the style drop-down box
  • The NORMAL style
Reference functions
  • Combining MATCH and INDEX
  • Using VLOOKUP
  • Using the OFFSET function
The INDIRECT function
  • How INDIRECT works
  • When to use it
Masking
  • Avoiding the IF function
  • Creating a mask
Cashflow calculations
  • Avoiding circularity
  • Separating interest paid and received
  • Dealing with compound interest rates
  • Getting quarterly summary figures
Investment appraisal
  • Net present value
  • Internal rate of return
  • Non-periodic cashflows
Array formulae
  • Creating array formulae
  • Editing and deleting
  • Strengths and weaknesses
Goal-seeking
  • Goal-seeking
  • Goal-seeking using charts
Scenarios
  • The scenario drop-down tool
  • Adding scenarios
  • What-if analysis
  • Creating a scenario report
Data tables
  • One-way data tables
  • Two-way data tables

To help see if this is the right course for you, you can see and download examples of our Excel courseware. You can also look at the differences between Microsoft Excel versions and see on which Excel version we currently train.

Excel Business Modelling training - Pre-requisites

Delegates should already be very comfortable with using the basics of Excel. Some financial modelling or accountancy background, while not essential, will be very useful.

Excel Business Modelling training - Schedule and Prices

Prices for this Microsoft Office training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft Office training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft Office training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft Office training. This allows you to create a Microsoft Office training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft Office which they need to learn.

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.