Product Launch Dashboard
Track a two-product launch from a raw weekly export to a dashboard that shows the trend and flags the week that outran capacity.
Projects are multi-step builds, not single exercises: each one chains several real skills together on one dataset, the way an actual workbook gets built, not graded one isolated formula at a time. Steps unlock in order, so finishing one is what opens the next.
What this project covers
Units sold are logged per product per week. Build a pivot table showing units sold by product and week, in one grid.
Combine both products and chart total units sold across the four weeks, so the trend itself is the first thing you see.
Production can reliably handle 180 units a week. Highlight whichever week's total sold past that.
The dataset, the exact approach, and the answer for each step are part of the unlocked project itself, not shown here.
More projects
Projects are part of the full unlock
Projects are locked until you unlock the full site: multi-step builds chaining pivot tables, charts, conditional formatting, lookups, named ranges, and more on one real dataset. Open this one to see how to unlock the rest.
Open this project →