Microsoft Office training -  Excel Business Modelling

Excel Training

Excel Business Modelling Training Course

£750 + VAT for most venues (£895 + VAT for London)

2 days

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:Tue 27 November 2018
  • 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

  • Training topicCreating range names
  • Training topicEditing/deleting range names

Masking

  • Training topicAvoiding the IF function
  • Training topicCreating a mask

Styles

  • Training topicUsing styles to apply formatting
  • Training topicNumber format styles

Formatting numbers and dates

  • Training topicStandard number formats
  • Training topicHiding cell contents
  • Training topicDate formats

Conditional formatting

  • Training topicCreating cell rules
  • Training topicManaging cell rules
  • Training topicViewing conditional formats
  • Training topicData bars and icon sets

Data validation

  • Training topicSetting validation rules
  • Training topicInput and error messages
  • Training topicHighlighting validated cells
  • Training topicCircling invalid data

Protection

  • Training topicHow protection works
  • Training topicUnlocking cells
  • Training topicTurning protection on for a worksheet
  • Training topicProtecting the whole workbook

Grouping/outlining

  • Training topicCreating and removing groups
  • Training topicExpanding and collapsing

Multiple worksheets

  • Training topicGroup editing
  • Training topicFormulae across sheets
  • Training topic3D summing across sheets

Array formulae

  • Training topicBlock formulae
  • Training topicWhat the curly brackets mean
  • Training topicFunctions using arrays

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

Conditional formulae

  • Training topicCreating a single =IF formula
  • Training topicUsing =SUMIFS and =COUNTIFS
  • Training topicCombining conditions (AND, OR and NOT)

Lookup functions

  • Training topicUsing VLOOKUP for continuous values
  • Training topicUsing VLOOKUP for exact matches
  • Training topicList data validation for exact matches
  • Training topicDynamic range names
  • Training topicHandling errors in lookup tables

Advanced lookup functions

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

Scenarios

  • Training topicCreating what-if scenarios
  • Training topicThe scenario manager

Covered if time allows If time

Goal-seeking

  • Training topicTargeting a given value
  • Training topicSetting the 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

"Really enjoyed the two days. Have learned lots of things I can apply in my everyday job. I was referred to Wise Owl by a colleague."

Natalie Gatward (ThoughtWorks Ltd)

"Enjoyed the course and learnt a lot. We had a great tutor and he created a relaxed environment and made participation and questions easy. Also lunch was great. (Advised by a colleague who had previously attended a course.)"

Andrew Whaling (Muse Developments)

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

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

"Being a total Excel geek, it was great to see sleeker ways of working with a tool I have used for years. The trainer's pace of training was excellent, and all of the examples used in the content were extremely relatable. The value of the course will definitely be visibly reflected in my office work and personal use of Excel. Most of my Excel experience has been based on self-study, so I was keen to learn new tricks and tips to add some value to my base knowledge."

Debbie Oloruntoba (Plastipak)

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.  Note that this course is an alternative to our two-day Advanced Excel course, not a follow-on.

Scheduled Excel Business Modelling training dates

Here are the Excel Business Modelling courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 27-28 November 2018 2 £895 Book places
Thu/Fri 07-08 February 2019 2 £750 Book places
Thu/Fri 04-05 April 2019 2 £750 Book places
Date(s) Venue
27/11
07/02
04/04

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Excel training at your offices (we'll even provide and set up the computers).

Related Courses

Excel Advanced

Advanced

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, Excel VBA or PowerPivot 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 - Basics, Microsoft Excel, PowerPivot or Excel VBA - pivot tables/charts 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 Test your current Excel skills or Test your VBA knowledge 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