Booking options
£1,718 - £3,626
£1,718 - £3,626
Delivered Online or In-Person
Delivered at your location
UK & International Requests Considered
5 days
All levels
Overview
In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models.
Objectives
Harness Excel's tools within a best practice framework
Add flexibility to their models through the use of switches and flexible lookups
Work efficiently with large data volumes
Model debt effectively
Approach modelling for tax, debt, pensions and disposals with confidence
Build flexible charts and sensitivity analysis to aid the presentation of results
Learn and apply Excel tools useful in financial forecasting
Understand and design the layout of a flexible model
Forecast financial statements of a public or private company
Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation