Excel Automation and Macros for Managers
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers DAX and calculated measures and scenario modelling from the position of someone who must review, approve and answer for the output. Managers carry this because most organisations have more dashboards than decisions that depend on them, and the accountability does not delegate cleanly. Delegates leave able to work confidently with KPI definition, data modelling and pivot table analysis in their own organisation.
What delegates leave able to do
- Review KPI definition and say plainly whether it is working, measured against recognised data governance frameworks
- Put data modelling on a footing they can defend to a reviewer
- Improve pivot table analysis within their own organisation
- Bring report automation into line with current good practice
What the course covers
- DAX and calculated measures
- Scenario modelling
- KPI definition
- Data modelling
- Pivot table analysis
- Report automation
- Spreadsheet controls
Who should attend
- operations managers using dashboards
- data analysts
- management information officers
- team leaders responsible for KPIs
- business analysts
