Advanced Excel for Managers
5 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers storytelling with data and data cleaning and preparation from the position of someone who must review, approve and answer for the output. Managers carry this because reporting effort scales badly when the underlying model is wrong, and the accountability does not delegate cleanly. Delegates leave able to work confidently with visual encoding choices, dashboard design and forecasting techniques in their own organisation.
What delegates leave able to do
- Explain visual encoding choices to someone who does not do the work, measured against recognised data governance frameworks
- Take ownership of dashboard design rather than escalating it
- Spot where forecasting techniques is failing before it becomes a finding
- Make a decision about data modelling without waiting for a specialist
What the course covers
- Storytelling with data
- Data cleaning and preparation
- Visual encoding choices
- Dashboard design
- Forecasting techniques
- Data modelling
- Pivot table analysis
Who should attend
- reporting specialists
- team leaders responsible for KPIs
- management information officers
- business analysts
- operations managers using dashboards
