Classroom Training

Excel Business Modelling

Classroom training course - online version also available

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

2 days

How many of the following boxes can you tick?

You know Excel well, and use it every day?
You work with financial models?
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

Possible locations:London, Manchester, Online
Next classroom course:Tue 27 April 2021
Time:10.00-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The contents of this course are as follows:

Building models

What makes a good formula
Separating inputs and calculations
Maintaining constant periodicity

Range names

Creating range names
Editing/deleting range names

Masking

Avoiding the IF function
Creating a mask

Styles

Using styles to apply formatting
Number format styles

Formatting numbers and dates

Standard number formats
Hiding cell contents
Date formats

Conditional formatting

Creating cell rules
Managing cell rules
Viewing conditional formats
Data bars and icon sets

Data validation

Setting validation rules
Input and error messages
Highlighting validated cells
Circling invalid data

Protection

How protection works
Unlocking cells
Turning protection on for a worksheet
Protecting the whole workbook

Grouping/outlining

Creating and removing groups
Expanding and collapsing

Multiple worksheets

Group editing
Formulae across sheets
3D summing across sheets

Array formulae

Block formulae
What the curly brackets mean
Functions using arrays

Cashflow calculations

Avoiding circularity
Separating interest paid and received
Dealing with compound interest rates

Investment appraisal

Net present value
Internal rate of return
Non-periodic cashflows

Conditional formulae

Creating a single =IF formula
Using =SUMIFS and =COUNTIFS
Combining conditions

Lookup functions

The XLOOKUP function
VLOOKUP for continuous values
VLOOKUP for exact matches
Data validation for exact matches

Advanced lookup functions

The XMATCH function
Combining =INDEX and =MATCH
The OFFSET function

Scenarios

Creating what-if scenarios
The scenario manager

Covered if time allows If time

Goal-seeking

Targeting a given value
Setting the number of iterations

Data tables

One-way data tables
Two-way data tables

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.

Why Choose Us?

No more than 5 people per class
Proper restaurant lunch included
535 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Great trainer, good location, good content."

Jonathan Fletcher (ReAssure UK Services Limited)

"Exceptional training, very well thought through and examples made things very understandable. The trainer was great in terms of expanding into different topics that were of particular interest and use to us. Your course content (compared to others) seemed to offer the best value in terms of learning a lot."

Robert Kingston (Xpedite GoC)

"Experienced, friendly & approachable trainer, constantly checking if every one okay and good. Content appropriate. Small class, everyone got enough attention. Delivery; right speed, not too fast/slow. Unlimited supply of tea/coffee/biscuits. Colleagues recommendation."

Kin Chung Ow (Ministry of Housing, Communities and Local Government (MHCLG))

"(Intro Power BI) The trainer's pace was perfect for course. He understood the level at which candidates were at and paced the course accordingly. (Adv Power BI) Excellent course! A lot to take in but the supporting info is superb."

Leo Skelly (Prima Group)

"We had a great trainer who made the content easy to digest."

Samantha Turpin (Crown Commercial Service)

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

Scheduled Excel Business Modelling training dates

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

Dates	Days	Venue	Price	Booking
Tue/Wed 27-28 April 2021	2	Manchester	£750	Book places
Tue/Wed 03-04 August 2021	2	Manchester	£750	Book places

Date(s)	Venue
27/04	Manchester
03/08	Manchester

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

Other Microsoft Excel training resources

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

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

View Excel tips, Excel VBA - Basics, Microsoft Excel or PowerPivot videos

Excel skills assessment

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

View Test your VBA knowledge or Test your Excel 365 skills skills assessment tests

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