Managing Excel Automation and Macros
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers KPI definition and data quality management 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 scenario modelling, spreadsheet controls and data cleaning and preparation in their own organisation.
What delegates leave able to do
- Explain scenario modelling to someone who does not do the work, measured against recognised data governance frameworks
- Bring spreadsheet controls into line with current good practice
- Spot where data cleaning and preparation is failing before it becomes a finding
- Put DAX and calculated measures on a footing they can defend to a reviewer
What the course covers
- KPI definition
- Data quality management
- Scenario modelling
- Spreadsheet controls
- Data cleaning and preparation
- DAX and calculated measures
- Statistical fundamentals
Who should attend
- reporting specialists
- finance professionals building reports
- data analysts
- business analysts
- professionals moving into analytics
