Microsoft Office training -  Excel Business Modelling

Excel Training

Excel Business Modelling (2 days)

£650 + VAT for most venues (£795 + VAT for London)

How many of the following boxes can you tick?

  1. You know Excel well, and use it every day?
  2. You work with financial models?
  3. You know how to create an IF function, but struggle with MATCH?

This two-day course is aimed at those who need to build or work with financial models in Excel. On this course you'll learn best-practice techniques for building models, using range names more than you could ever conceive, and you'll find out about functions like MATCH, INDEX and SUMPRODUCT. Oh, and on the way you'll learn tons of short-cut keys and tips and tricks, we promise!

Course details

  • Locations for Excel Business Modelling coursesLocations:Manchester, London
  • Next Excel Business Modelling course locationNext course:Thu 08 June 2017
  • Excel Business Modelling course timesTime:09.30-16.30

Course Contents

Building models

  • Training topicWhat makes a good formula
  • Training topicSeparating inputs and calculations
  • Training topicMaintaining constant periodicity

Range names and absolute references

  • Training topicFixing cell references ($)
  • Training topicFixing rows/columns only
  • Training topicRange names
  • Training topicLabelling ranges


  • Training topicAvoiding the IF function
  • Training topicCreating a mask


  • Training topicUsing the default styles
  • Training topicCreating custom styles
  • Training topicUsing styles with protection

Formatting numbers and dates

  • Training topicStandard number formats
  • Training topicCreating custom formats
  • Training topicDates and times
  • Training topicScaling, colours and underscores

Conditional formatting

  • Training topicCreating/using cell rules
  • Training topicData bars and colour sets


  • Training topicSetting validation rules
  • Training topicInput messages (a bad idea)
  • Training topicHighlighting validated cells
  • Training topicSingle-cell dropdown lists


  • Training topicUnlocking cells
  • Training topicProtecting worksheets
  • Training topicProtecting workbooks
  • Training topicVery hidden worksheets

Grouping and outlining

  • Training topicGrouping rows/columns
  • Training topicMoving the outline symbols

Multiple worksheets

  • Training topicMoving and copying sheets
  • Training topicGroup editing
  • Training topicConsolidation across sheets

Array formulae

  • Training topicCreating array formulae
  • Training topicEditing and deleting array formulae
  • Training topicStrengths and weaknesses

Cashflow calculations

  • Training topicAvoiding circularity
  • Training topicSeparating interest paid and received
  • Training topicDealing with compound interest rates

Investment appraisal

  • Training topicNet present value
  • Training topicInternal rate of return
  • Training topicNon-periodic cashflows

IF family of functions

  • Training topicThe IF function
  • Training topicNesting Ifs (and why not to)
  • Training topicIFS and SWITCH functions

Lookup functions

  • Training topicExact-match lookup formulae
  • Training topicContinuous value lookups
  • Training topicIntercepting and handling errors

Advanced lookup functions

  • Training topicUsing MATCH to find values
  • Training topicCombining MATCH and INDEX
  • Training topicUsing OFFSET
  • Training topicThe feared INDIRECT function


  • Training topicThe scenario drop-down tool
  • Training topicWhat-if analysis
  • Training topicCreating a scenario report

Covered if time allows If time


  • Training topicTargeting a given value
  • Training topicSetting number of iterations

Data tables

  • Training topicOne-way data tables
  • Training topicTwo-way data tables

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Great manuals! Very informative and well taught course."

Lisa Andronova (Ingenious )

"Very well designed course and delivered excellently by the trainer, who was very helpful and enthusiastic. The option to save the course content means I can continue to get value from what was covered."

Assumpta O'Brien (Ingenious )

"Tutor was very knowledgeable, helpful and approachable...., made SQL interesting. Course material is very detailed and useful. Found the content really useful and something I will definitely use at work."

Vicky Murphy (Berrymans Lace Mawer (BLM))

"Excellent course manual, which will come in very handy as a quick reference guide on my desk. Especially like the USB to take away containing course material, plus workbooks with examples - again, will prove useful to download and quickly reference as and when needed."

Nishchal Patel (Mercer Limited)

"Hits the spot! As always. Would love to have an extra day working through exercises."

Mary Filipowicz (Envigo Research Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

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.  This course uses Excel 2016, but will be just as useful if you're using Excel 2013, 2010 or 2007.

Related Courses

Advanced Excel


2 day course

Excel VBA macros


2 day course

PowerPivot / Excel Power BI


2 day course

Other Microsoft Excel training resources

Excel exercises

Excel exercises

We believe in complete transparency, so we've published all of our Excel exercises online, including the ones used in this Excel Modelling course.

View Excel 2010, Excel VBA or Power BI exercises

Excel videos

Excel videos

The Wise Owl YouTube channel carries lots of videos on Microsoft Excel, among many other subjects.

View Excel VBA, Microsoft Excel or Excel 2013 Power BI Tools videos

Excel skills assessment

Excel skills assessment

Test whether you know Excel as well as your "neighbour" by taking one of our skills assessment tests.

View Excel or Excel VBA skills assessment tests

Excel blogs

Excel blogs

The blogs on this site contains lots of extra tips and tricks about how to use Excel.

View Excel, Power BI - Excel 2013 or VBA macros blogs

This page has 0 threads Add post