Fundamentals of Advanced Excel
2 days|Delivered on request
Fundamentals of Advanced Excel is built for delegates who need to be useful in this area quickly. It starts at first principles and works through data modelling and scenario modelling without assuming prior specialist training. The programme exists because reporting effort scales badly when the underlying model is wrong, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with SQL querying, pivot table analysis and KPI definition in their own organisation.
What delegates leave able to do
- Spot where SQL querying is failing before it becomes a finding, measured against established visualisation principles
- Put pivot table analysis on a footing they can defend to a reviewer
- Bring KPI definition into line with current good practice
- Make a decision about visual encoding choices without waiting for a specialist
What the course covers
- Data modelling
- Scenario modelling
- SQL querying
- Pivot table analysis
- KPI definition
- Visual encoding choices
- Data governance
Who should attend
- operations managers using dashboards
- business analysts
- reporting specialists
- data analysts
