Advanced Excel and Financial Modelling 2016 is a course that covers topics such as:
- Refresher of Excel fundamentals
- Basic Excel tools
- Basic structure of a model
- Customising Excel
- Model design and consideration of inputs
- Understanding/refresher of financial statements
- Making sure the model has integrity
- Forecasting EBITDA
- Forecasting working capital
- Including checks and balance
- Forecasting financial flows
- Forecasting capex and depreciation
- Forecasting tax
- Trouble shooting circulatory problems
- Sensitivity analysis
- The camera function
- Creating impressive output
- Charting the results
Advanced Excel and Financial Modelling 2016 is intended for financiers, finance managers, accountants and bankers looking to improve their skills in Excel.