Originally published: 10/08/2018 07:48
Last version published: 27/07/2019 22:55
Publication number: ELQ-11041-6
View all versions & Certificate

Excel Financial Modelling Course

Financial modelling using different scenarios to create robust structure, report setup, to create Excel magic.

This online course focuses on the skills and techniques required to construct financial models. Spreadsheet models are used in budgeting, forecasting, business analysis and capital budgeting and being able to construct financial models in a robust a repeatable way. This subject will cover model construction, assumptions, advanced excel functionality, error trapping, sensitivity analysis, presentation of model output and tips and tricks. Videos include:

Excel Short Cuts
Budgeting in Excel
Advanced Financial Modelling Techniques
Bottom Up Budgeting
Forecasting Development Using Excel
Charting for Trend Analysis
Activity Based Costing in Excel
DCF Modelling in Excel
FIFO Using Excel
What IF Analysis Using Excel
Essential Formulas in Excel
Project Costing Model in Excel

The course will show you how to build flexible, pliable models working through a range of real scenarios so you can apply your learning directly to your job. Excel financial modelling involves designing and building calculations to assist in decision making. Learning how to build models with complexity in an accurate, robust and transparent way is an essential skill in the modern workplace. The course will leave you with the skills to generate your own reports with a very clear idea of how to structure a financial report so it has maximum flexibility.

This Excel training course is suitable for those who work on Excel and who want to become familiar with and master the Excel tools, formulas and functions necessary for building effective robust flexible financial models.

This Best Practice includes
12 Videos (12 hours) + 11 Excel Files

Acquire business license for $300.00

Add to cart

Add to bookmarks



  • Rate this Online Course

    Write a review

  • Prempal Singh(last updated: 28/08/2019 21:03)
    Excel Financial Modelling Course
    A highly comprehensive and thorough Excel Course full of relevant tips to improve your productivity daily for finance professionals.


More Best Practices from Marcus Small

See all

Discussion feed for Excel Financial Modelling Course

The user community and author are here to help. Go ahead!

5.0 / 5 (1 votes)

please wait...