Excel Automation and Macros for Non-Specialists
2 days|Delivered on request
Excel Automation and Macros for Non-Specialists is built for delegates who need to be useful in this area quickly. It starts at first principles and works through SQL querying and self service analytics 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 governance, spreadsheet controls and pivot table analysis in their own organisation.
What delegates leave able to do
- Spot where data governance is failing before it becomes a finding, measured against established visualisation principles
- Take ownership of spreadsheet controls rather than escalating it
- Improve pivot table analysis within their own organisation
- Review data modelling and say plainly whether it is working
What the course covers
- SQL querying
- Self service analytics
- Data governance
- Spreadsheet controls
- Pivot table analysis
- Data modelling
- Forecasting techniques
Who should attend
- operations managers using dashboards
- data analysts
- finance professionals building reports
- team leaders responsible for KPIs
