# Financial Modelling with Excel

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
• 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 Let Excel find the correct sheet to use based on the sheet name. You can add sheets and the formulas will adapt Create consolidation spreadsheets that include sheets depending on where they are placed. Easily move branches from one division to another without changing formula How many working days between 2 dates (taking holidays into account) Insert mini charts to show the trend of data 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.