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 07 December 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

Masking

  • Training topicAvoiding the IF function
  • Training topicCreating a mask

Styles

  • 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

Validation

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

Protection

  • 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

Scenarios

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

Covered if time allows If time

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

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

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

Mary Filipowicz (Envigo Research Ltd)

"Manuals are very helpful - great that we can keep them! Trainer was wonderful. I enjoyed the course very much, found it very well integrated and will definitely consider attending one of those other courses you've suggested - probably early next year."

Paola Gutiérrez (Frontiers Media)

"Really enjoyable, good pace, aimed well and relevant questions/topics."

Rik Potter (Ombudsman Services Ltd)

"Trainer was really, really good. (Excel Business Modelling) The trainer explains things at the perfect speed. Content is pitched at correct level. (Excel VBA macros)"

David Pearson (BAE Systems)

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

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 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 or VBA macros blogs

This page has 0 threads Add post