HOME
 

Excel Financial Modelling

STL
Course summary
Length: 2 days
Price: 2,708 - 2,835 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 04/03/2019 09:30 - London
Rating: (8 Reviews)
Course Dates
London
04/03/2019 09:30  (English)
2,708 GBP
03/06/2019 09:30  (English)
2,835 GBP
02/09/2019 09:30  (English)
2,835 GBP
02/12/2019 09:30  (English)
2,835 GBP
02/03/2020 09:30  (English)
2,835 GBP

Excel Financial Modelling



Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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.

Suitability - Who should attend?



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

Training Course Content



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

Expenses



List price £2995 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video

   

Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.


Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel Financial Modelling.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net


Reviews by course attendees

Emmanuel Asamoah; Head Of Finance   |   23/03/2016
I said no because the training centre wasnt as I expected. It was strange to get there and there was no refreshments. I had to request including the management of my lunch.
          (5)
Rola Akande   |   21/11/2014
A follow on course to this
          (5)
Irene Johnson   |   17/07/2013
          (4)
Request information

Find out more about this Excel Financial Modelling course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here