Advanced Excel and Financial Modeling 2016 is a course that covers topics such as:
- Refresher of Excel fundamentals
- Basic Excel tools including shortcuts to improve your efficiency
- Key analysis tools
- Customising Excel
- Complex (nested) formulae
- Formatting
- Sensitivity anaylsis
- The camera function
- Creating impressive output
- Charting the results
- Basic structure of a model
- An overview of VBA
- Model design and consideration of inputs
- Understanding/refresher of financial statements
- Including checks and balances
- Forecasting EBITDA
- Forecasting capex and depreciation
- Forecasting working capital
- Reviewing the results
- Forecasting financing flows
Advanced Excel and Financial Modeling 2016 brings together anyone looking to improve their skills in Excel.