Online Corporate Financial Modelling Course

Financial Modelling with Excel

This is a preview lesson

Purchase this course, or sign in if you’re already enrolled, to take this lesson.

The Financial Modelling, Budgeting and Forecasting MS Excel course covers the various tools and formula you should know if you work with any forward looking data whether it is a simple budget, longer term forecast or a financial model.

Financial Modelling Excel Course Details

  • 115 lessons
  • 200+ video clips
  • 45 example exercises with detailed video solutions explaining exactly how you should have go to the answer.
  • Aimed at Intermediate to Advanced Excel users, based on our free Excel skills assessments
  • Equivalent of attending a 2 day live course
  • Lifetime access
  • Start/ stop as required and repeat when necessary

Examples of what you will be able to do

After the lessons and exercises you will be able to:

Let Excel take your historical data and forecast forward, either simply, or including seasonality.


Use Excel’s capabilities to work backwards. No more making small changes to a cell to see when the spreadsheet gives you the answer you want


See what numbers make up a formula without jumping all around the spreadsheet


Learn how to (easily) build nested IF formulas. Technique can be used for any nested formulas


Control the formatting of cells and include the key metric within the cell without upsetting formulas


See 2 sheets FROM THE SAME SPREADSHEET side by side for comparisons or for (easily) building your formula.


Learn how to model for changes in ‘fixed’ costs when growth changes


Build automated What If matrices so that you can see the impact of changes on the outcome without having to re run the spreadsheet


Protect various aspects of your spreadsheet models from unwanted changes by users


Add Waterfall charts to your spreadsheet models to better explain what is happening in the budget or forecast


Let Excel find the correct sheet to use based on the sheet name. You can add sheets and the formulas will adapt


Create comprehensive lookups that run across and down


Create consolidation spreadsheets that include sheets depending on where they are placed. Easily move branches from one division to another without changing formula


Find errors in your formulas


Remove errors from Formulas


How many working days between 2 dates (taking holidays into account)


Insert mini charts to show the trend of data


Learn how to allow for time dependencies and critical paths in your spreadsheet models


Make sure any formula you build can be easily (and safely) copied and reused


Build your spreadsheets in such a way that the formulas you create are the easiest possible


Learn how to (easily) summarise monthly information into annual, semi annual, quarterly or any period you want.


Use safe, efficient formula rather than building your own
See how Excel can mimic your Financial Calculator for debt and time value of money calculations and do more
Build detailed debt calculators with options like interest and capital repayment holidays
Learn how Time Value of Money can be used for PE Ratios

and much, much more!

For the full list of contents go back to the Financial Modelling, Budgeting and Forecasting with Excel Course contents main page.

Buy the course now to get immediate access!

    Your Cart
    Your cart is emptyReturn to Shop