Excel Financial Modelling

STL
4.2
13 reviews
  • On the off chance that you need to enhance your Excel abilities, this is the best place to go. Extraordinary client benefit as well.
    ← | →
  • Such an extraordinary course for initial level learnrs in excel, Learnt to such an extent. Educator was extraordinary as well
    ← | →
  • I addressed Excel Advanced part course on different points and the coach Marius was extremely educated and kept all of us connected with all through. This day course covers a considerable measure of subjects and accordingly it is dependent upon me to hone these new abilities and apply them at each open door at work with a specific end goal to make full utilization of this course.
    ← | →

Course

In London

£ 2001-3000

The best Excel courses

See all

See all

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

Anyone looking to learn or extend their knowledge of using Excel to assist with financial decision making in a business context.

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

This course will show you why Excel is an essential tool for financial modelling, guide you through some key models and also introduce the practice of rolling forecasting. There will also be the opportunity to explore tying up actual models with reporting.

Attendance or equivalent knowledge of Excel Advanced Part 1 and Introduction to Finance for Non-financial managers

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.2
fantastic
  • On the off chance that you need to enhance your Excel abilities, this is the best place to go. Extraordinary client benefit as well.
    ← | →
  • Such an extraordinary course for initial level learnrs in excel, Learnt to such an extent. Educator was extraordinary as well
    ← | →
  • I addressed Excel Advanced part course on different points and the coach Marius was extremely educated and kept all of us connected with all through. This day course covers a considerable measure of subjects and accordingly it is dependent upon me to hone these new abilities and apply them at each open door at work with a specific end goal to make full utilization of this course.
    ← | →
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Mari Tamashiro

4.0
22/03/2015
What I would highlight: On the off chance that you need to enhance your Excel abilities, this is the best place to go. Extraordinary client benefit as well.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Sinead

3.0
21/02/2015
What I would highlight: Such an extraordinary course for initial level learnrs in excel, Learnt to such an extent. Educator was extraordinary as well
What could be improved: An excessive number of subjects canvassed in one day, insufficient time to rehearse all alone to get an appropriate comprehension of the usefulness disclosed.
Would you recommend this course?: Yes

Soman S.

5.0
10/02/2015
What I would highlight: I addressed Excel Advanced part course on different points and the coach Marius was extremely educated and kept all of us connected with all through. This day course covers a considerable measure of subjects and accordingly it is dependent upon me to hone these new abilities and apply them at each open door at work with a specific end goal to make full utilization of this course.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

William

4.5
10/02/2015
What I would highlight: This Excel instructional class was truly great. The instructor was one of the best teachers (in any subject) I have ever met. He made excel expectations appear like the most intriguing programming ever. We were all holding tight his each word and did not get exhaust throughout the day. This is on account of he was knowledgable, all around paced, empathic, amusing, and a truly clear explainer. I took in a great deal and am extremely appreciative.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Jacob

5.0
09/02/2015
What I would highlight: Our educator for the day was super useful and neighborly. He is extremely learned and was exceptionally useful with every one of our issues. The course it self was extremely wide and presented a great deal of new aspects of excel preparation to me.
What could be improved: Everything OK.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • Financial Training
  • Financial
  • Using excel
  • Sales Training
  • Forecasts
  • Financial Modelling
  • Excel
  • Data analysis
  • Financial models
  • Pivot tables
  • Analysing sales
  • Sales
  • Cost budget models
  • Capital investment models
  • Business valuation models
  • Rolling forecasts
  • Dynamic reporting models

Course programme

Excel modelling fundamentals

Best practice tips
Common mistakes to avoid
Making the most of Excel functionality

Analysing data for financial models

Using Pivot Tables to analyse and prepare raw data
Analysing sales and cost data
Identifying fixed and variable costs using linear regression functions
Testing cause and effect using correlation functions
Using moving averages to model seasonality

Sales and cost budget models

Interpolation and extrapolation methods
Using Excel for 'what if' analysis on sales and costs

Capital investment models

Understanding discounted cashflow and net present value (NPV)
identifying relevant incremental cashflows
Using Excel functions to calculate NPV
Understanding internal rate of return (IRR)
Using Excel to calculate IRR

Business valuation models

Understanding and using different business valuation methods
Using cashflow projections for business valuations
Building a business valuation model using Excel

Rolling forecasts

Budgets versus rolling forecasts
Identifying key business drivers
How American Express use rolling forecasts
'What if' analysis with rolling forecasts
Using Excel for rolling forecasts

Dynamic reporting models

Building simple reporting models for divisional reporting
Best practice in designing user-friendly workbooks
Using VLOOKUP and HLOOKUP as dynamic functions



Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

See related categories

Excel Financial Modelling

£ 2001-3000

The best Excel courses

See all

See all