Advanced Excel in the Public Sector
5 days|Delivered on request
Advanced Excel in the Public Sector takes the discipline and works it through the constraints of this operating context, including spreadsheet controls, visual encoding choices and the compliance obligations that come with it. The sector framing is necessary because analysts are frequently self taught in the tool and untrained in the reasoning, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with self service analytics, pivot table analysis and data quality management in their own organisation.
What delegates leave able to do
- Take ownership of self service analytics rather than escalating it, measured against established visualisation principles
- Review pivot table analysis and say plainly whether it is working
- Spot where data quality management is failing before it becomes a finding
- Explain forecasting techniques to someone who does not do the work
What the course covers
- Spreadsheet controls
- Visual encoding choices
- Self service analytics
- Pivot table analysis
- Data quality management
- Forecasting techniques
- Data cleaning and preparation
Who should attend
- reporting specialists
- management information officers
- operations managers using dashboards
- team leaders responsible for KPIs
