Financial Modelling in ExcelCity University London
Preço a consultar
- Short course
- Islington (Reino Unido)
O que se aprende nesse curso?
Skills and Training
- Excel hints, techniques and tips in a financial context
- Keyboard shortcuts
- Best Practice techniques for financial modelling
- How to establish suitable driver based models for forecasting
- Modelling Income Statements, Balance Sheets and Statements of Cash flow
- Sensitivity Analysis
- Ways to minimize errors
- Advanced modelling techniques
By the end of the Financial Modelling in Excel course, you will be able to:
Use best practice modelling principles to design and build robust financial modelsCourse Outline
The first four weeks of the course cover the necessary groundwork, design principles and functions required to build robust models.
In weeks 5 - 9 these design techniques are put into practice by building a detailed financial model from scratch based on a fictitious retail based case study.
The course concludes with a review of further advanced excel techniques including sensitivity analysis.Scheme of WorkWeek 1Keyboard shortcuts, styles and custom formattingWeek 2Financial modelling best practiceWeek 3Modelling techniques including summing across sheets, "IF" statements, VLOOKUPs, INDEX & MATCH and conditional formattingWeek 4Drivers; key items which drive financial modelsWeek 5Start case study: Income Statement – annual projectionsWeek 6Case study continued: Income Statement – monthly projectionsWeek 7Case study continued: Income Statement – finalise and completeWeek 8Case study continued: Balance SheetWeek 9Case study continued: Cash Flow Statement and complete the model plus a brief look at MacrosWeek 10Advanced Techniques and course round up