Advanced Excel for Non-Specialists
5 days|Delivered on request
Advanced Excel for Non-Specialists is built for delegates who need to be useful in this area quickly. It starts at first principles and works through pivot table analysis and data governance without assuming prior specialist training. The programme exists because analysts are frequently self taught in the tool and untrained in the reasoning, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with data quality management, storytelling with data and visual encoding choices in their own organisation.
What delegates leave able to do
- Spot where data quality management is failing before it becomes a finding, measured against recognised data governance frameworks
- Improve storytelling with data within their own organisation
- Take ownership of visual encoding choices rather than escalating it
- Bring data modelling into line with current good practice
What the course covers
- Pivot table analysis
- Data governance
- Data quality management
- Storytelling with data
- Visual encoding choices
- Data modelling
- Data warehouse concepts
Who should attend
- reporting specialists
- data analysts
- management information officers
- operations managers using dashboards
