Y

Library · tool

Excel

Pivot tables, lookups and Power Query. Named in more than half of junior analyst postings, and still the fastest way to answer a one-off question.

Excel is where most business data ends up, even in companies with modern warehouses. Finance, operations and sales teams send you spreadsheets and expect spreadsheets back.

The lessons use the real UCI Online Retail II workbook (CC BY 4.0), which opens directly in Excel or Google Sheets.

  1. 1Pivot tables and lookupsPivot tables on half a million sales lines3 min read
  2. 2Pivot tables and lookupsExcel formulas: relative vs absolute cell references12 min read
  3. 3Pivot tables and lookupsXLOOKUP and the cleaning formulas you use every week3 min read
  4. 4Pivot tables and lookupsExcel Tables, sort and filter for clean data11 min read

Excel lessons

Loading lessons…

    Further reading

    • UCI Online Retail II ↗dataset · free · CC BY 4.0

      Two years of order lines from a UK online gift wholesaler, used across the data shelves.