Practical Advanced Excel
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through data cleaning and preparation and forecasting techniques on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: most organisations have more dashboards than decisions that depend on them, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with spreadsheet controls, statistical fundamentals and data governance in their own organisation.
What delegates leave able to do
- Put spreadsheet controls on a footing they can defend to a reviewer, measured against dimensional modelling practice
- Improve statistical fundamentals within their own organisation
- Bring data governance into line with current good practice
- Take ownership of scenario modelling rather than escalating it
What the course covers
- Data cleaning and preparation
- Forecasting techniques
- Spreadsheet controls
- Statistical fundamentals
- Data governance
- Scenario modelling
- Data modelling
Who should attend
- management information officers
- data analysts
- reporting specialists
