From a raw Dubai sales export to answers for the VP — the whole workflow, in about 5 hours.
A hands-on Excel course for sales professionals who receive sales data and need to analyse it themselves. It follows one FMCG sales export — Food & HPC brands sold to Dubai supermarkets, with Sales and Returns — through the real analysis workflow: clean it, enrich it with VLOOKUP, summarise it with SUMIFS, pivot and rank it, and present a one-pager — then you run the whole thing yourself in a capstone. The 80% of Excel a sales team actually uses; no macros, Power Query, or dynamic-array gymnastics.
Five stages of one sales-analysis workflow — about 5 hours end-to-end, following a single dataset from raw export to finished one-pager. Each ends with a quiz and a downloadable practice file, capped by a hands-on capstone.
A supermarket sales export just landed. Turn it into a clean, trustworthy Excel Table before anything else.
Add the context the export is missing — sales managers, quotas and brand managers — with VLOOKUP.
Quick looks with filters and subtotals, then the SUMIFS trio and the sales KPIs.
Reshape and slice the whole dataset in seconds with PivotTables — and rank reps and brand managers.
Make the numbers land on a one-page summary, then run the whole workflow yourself on a fresh file.
Works in Excel 2016 and up (VLOOKUP-first; XLOOKUP shown as a modern note). No macros, no Power Query, no dynamic-array gymnastics — just the 80% of Excel a sales team actually uses.
Begin Module 1