Advanced Excel and Financial Modeling 2016

Topics

• 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

Who should Attend

Anyone looking to improve their skills in Excel.