Digital Transformation in Advanced Excel
3 days|Delivered on request
This programme examines how the practice is shifting, and what delegates should adopt, adapt or ignore. It works through forecasting techniques and data governance as they stand today and where they are heading. The shift is worth understanding because analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with spreadsheet controls, pivot table analysis and scenario modelling in their own organisation.
What delegates leave able to do
- Make a decision about spreadsheet controls without waiting for a specialist, measured against dimensional modelling practice
- Explain pivot table analysis to someone who does not do the work
- Put scenario modelling on a footing they can defend to a reviewer
- Improve visual encoding choices within their own organisation
What the course covers
- Forecasting techniques
- Data governance
- Spreadsheet controls
- Pivot table analysis
- Scenario modelling
- Visual encoding choices
- Statistical fundamentals
Who should attend
- finance professionals building reports
- reporting specialists
- business analysts
- team leaders responsible for KPIs
