Fundamentals of Excel Automation and Macros
2 days|Delivered on request
Fundamentals of Excel Automation and Macros is built for delegates who need to be useful in this area quickly. It starts at first principles and works through KPI definition and data quality management without assuming prior specialist training. The programme exists because most organisations have more dashboards than decisions that depend on them, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with statistical fundamentals, DAX and calculated measures and spreadsheet controls in their own organisation.
What delegates leave able to do
- Explain statistical fundamentals to someone who does not do the work, measured against established visualisation principles
- Make a decision about DAX and calculated measures without waiting for a specialist
- Take ownership of spreadsheet controls rather than escalating it
- Spot where SQL querying is failing before it becomes a finding
What the course covers
- KPI definition
- Data quality management
- Statistical fundamentals
- DAX and calculated measures
- Spreadsheet controls
- SQL querying
- Storytelling with data
Who should attend
- operations managers using dashboards
- professionals moving into analytics
- team leaders responsible for KPIs
- business analysts
