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 10 November 2016
  • Excel Business Modelling course timesTime:09.30-16.30

Course Contents

Building models

  • Training topicFreezing windows
  • Training topicWhat makes a good formula
  • Training topicSeparating inputs and calculations
  • Training topicAvoiding the IF function
  • Training topicMaintaining constant periodicity

Masking

  • Training topicAvoiding the IF function
  • Training topicCreating a mask

Range names and absolute references

  • Training topicAbsolute references ($ symbol)
  • Training topicFixing only the row/column
  • Training topicCreating range names
  • Training topicLabelling ranges automatically

Styles and themes

  • Training topicHow themes work
  • Training topicUsing the default styles
  • Training topicCreating custom styles

Number formatting

  • Training topicCreating custom formats
  • Training topicThe four parts of a format
  • Training topicScaling numbers

Dates and times

  • Training topicHow dates and times are stored
  • Training topicUseful date/time functions
  • Training topicFormatting dates and times

Conditional formatting

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

Validation and protection

  • Training topicSetting cell validation
  • Training topicProtecting cells/worksheets
  • Training topicCell comments
  • Training topicGrouping and outlining

Outlining

  • Training topicCreating outlines
  • Training topicImproving how symbols appear

Multiple worksheets

  • Training topicCopying, moving and renaming
  • Training topicThe dangerous group mode
  • Training topicSumming across worksheets
  • Training topic3-D range names

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
  • Training topicGetting quarterly summary figures

Investment appraisal

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

IF and LOOKUP functions

  • Training topicThe conditional (IF) function
  • Training topicNested IFs are evil
  • Training topicLookup tables

Advanced lookup functions

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

Covered if time allows If time

Advanced formulae tricks

  • Training topicUsing SUMPRODUCT
  • Training topicUsing dynamic ranges

Other functions

  • Training topicText functions in Excel
  • Training topicInspection functions
  • Training topicINFO and CELL

Formulae auditing

  • Training topicError-checking
  • Training topicPrecedents and dependents
  • Training topicEvaluating formulae
  • Training topicWatching cells

Scenarios

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

Goal-seeking

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

"Very useful course. Appropriate level and the trainer was extremely helpful. The exercises reinforced learning - very helpful."

Danielle Green (WorldPay UK Ltd)

"Excellent information and content in manuals and handbook. Found the trainer very helpful, easy to understand and has very good knowledge. This course was recommended to me by a colleague."

Sabina Yasmin (Ingenious )

"Great material. Catered to my needs. Covered additional relevant topics."

Sophie Kelly (Crowe Clark Whitehill)

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

Related Courses

Advanced Excel 2013

Intermediate

2 day course

Excel VBA macros

Advanced

2 day course

PowerPivot / Excel Power BI

Advanced

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