Spreadsheet Controls Auditing and Assurance
3 days|Delivered on request
This programme is written from the assurance side. Delegates learn to test whether pivot table analysis and report automation are working as claimed, and how to evidence the conclusion. Assurance work is under scrutiny because analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with forecasting techniques, scenario modelling and data modelling in their own organisation.
What delegates leave able to do
- Improve forecasting techniques within their own organisation, measured against recognised data governance frameworks
- Spot where scenario modelling is failing before it becomes a finding
- Review data modelling and say plainly whether it is working
- Explain visual encoding choices to someone who does not do the work
What the course covers
- Pivot table analysis
- Report automation
- Forecasting techniques
- Scenario modelling
- Data modelling
- Visual encoding choices
- Data quality management
Who should attend
- operations managers using dashboards
- finance professionals building reports
- professionals moving into analytics
- team leaders responsible for KPIs
- data analysts
