Excel Financial Modelling
-
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
Description
-
Type
Course
-
Location
-
Start date
Different dates available
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
Start date
Start date
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
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 rating
Recommended
Centre rating
Mari Tamashiro
Sinead
Soman S.
William
Jacob
This centre's achievements
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
Excel Financial Modelling