Excel and analytical thinking
- Excel essentials: formulas, cell references, formatting, data validation
- Lookup functions: XLOOKUP, INDEX-MATCH; logical and text functions
- Pivot tables, slicers and pivot charts
- Power Query for cleaning and combining data
- Statistics for analysts: averages, spread, correlation, sampling
- Framing business questions and choosing KPIs
Dubai practice: 5% UAE VAT in invoice and sales datasets.