Advanced Excel: Tools and Techniques
5 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through data warehouse concepts and spreadsheet controls on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: reporting effort scales badly when the underlying model is wrong, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with data modelling, pivot table analysis and data cleaning and preparation in their own organisation.
What delegates leave able to do
- Bring data modelling into line with current good practice, measured against dimensional modelling practice
- Take ownership of pivot table analysis rather than escalating it
- Spot where data cleaning and preparation is failing before it becomes a finding
- Review data governance and say plainly whether it is working
What the course covers
- Data warehouse concepts
- Spreadsheet controls
- Data modelling
- Pivot table analysis
- Data cleaning and preparation
- Data governance
- Data quality management
Who should attend
- data analysts
- reporting specialists
- management information officers
