https://www.youtube.com/watch?v=opJgMj1IUrc

Transcript by minute

00:00 — Project overview and goal

01:00 — Setup: sheets for raw, working, pivot, dashboard

02:00 — Data overview and target variable

03:00 — Remove duplicates and plan label cleanup

04:00 — Find and Replace: expand coded fields

05:00 — Income formatting approach

06:00 — Review other fields and commute distance

07:00 — Why create age brackets

08:00 — Build initial IF for age bracket

09:00 — Nested IFs for age brackets

10:00 — Add 31+ bracket

11:00 — Assign ‘middle age’ 31+ and plan false branch

12:00 — Add ‘old’ 55+ bracket

13:00 — Create first pivot table

14:00 — Average income by gender and purchase