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?

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

Locations:Manchester, London
Next course:Tue 14 November 2017
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Building models

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

Range names and absolute references

Fixing cell references ($)
Fixing rows/columns only
Range names
Labelling ranges

Masking

Avoiding the IF function
Creating a mask

Styles

Using the default styles
Creating custom styles
Using styles with protection

Formatting numbers and dates

Standard number formats
Creating custom formats
Dates and times
Scaling, colours and underscores

Conditional formatting

Creating/using cell rules
Data bars and colour sets

Validation

Setting validation rules
Input messages (a bad idea)
Highlighting validated cells
Single-cell dropdown lists

Protection

Unlocking cells
Protecting worksheets
Protecting workbooks
Very hidden worksheets

Grouping and outlining

Grouping rows/columns
Moving the outline symbols

Multiple worksheets

Moving and copying sheets
Group editing
Consolidation across sheets

Array formulae

Creating array formulae
Editing and deleting array formulae
Strengths and weaknesses

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

IF family of functions

The IF function
Nesting Ifs (and why not to)
IFS and SWITCH functions

Lookup functions

Exact-match lookup formulae
Continuous value lookups
Intercepting and handling errors

Advanced lookup functions

Using MATCH to find values
Combining MATCH and INDEX
Using OFFSET
The feared INDIRECT function

Scenarios

The scenario drop-down tool
What-if analysis
Creating a scenario report

Covered if time allows If time

Goal-seeking

Targeting a given value
Setting number of iterations

Data tables

One-way data tables
Two-way data tables

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
492 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

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

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

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

Rik Potter (Ombudsman Services 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.

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 2010, Excel VBA or Power BI exercises

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

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

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