Managing Advanced Excel
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers scenario modelling and report automation from the position of someone who must review, approve and answer for the output. Managers carry this because analysts are frequently self taught in the tool and untrained in the reasoning, and the accountability does not delegate cleanly. Delegates leave able to work confidently with KPI definition, data warehouse concepts and dashboard design in their own organisation.
What delegates leave able to do
- Bring KPI definition into line with current good practice, measured against established visualisation principles
- Make a decision about data warehouse concepts without waiting for a specialist
- Review dashboard design and say plainly whether it is working
- Take ownership of spreadsheet controls rather than escalating it
What the course covers
- Scenario modelling
- Report automation
- KPI definition
- Data warehouse concepts
- Dashboard design
- Spreadsheet controls
- Storytelling with data
Who should attend
- reporting specialists
- business analysts
- management information officers
- professionals moving into analytics
- data analysts
