Excel projects: build a real workbook from start to finish

Guided multi-step projects that combine lookups, conditional sums, formatting and charts into one finished dashboard or workbook.

Single exercises teach one function at a time. Projects are where they come together: each one walks you through building a complete workbook in stages, the way you would on the job, and checks every step before you move on. Finishing a project earns a completion certificate you can share.

• 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.

• Regional Sales Dashboard

  A raw sales export, from row one to a working dashboard: pivot it, chart it, then flag the region that needs attention.

• Team Budget Dashboard

  Turn a raw departmental expense export into a dashboard: break it down, show each department's share, then flag whoever's over their cap.

• Vendor Contract Workbook

  A workbook spread across sheets and names, the way real contract files actually get built: look up a rate, pull a figure from another sheet, then apply a named discount.

• World Cup Shirt Orders: Advanced

  The same order sheet, but with the messier real-world data the basic project glossed over: a courier code that only makes sense from its first letter, a country code that might be 2 or 3 letters, a fee stored as text, a real two-axis distance table, and a tiered highlight rule.

• World Cup Shirt Orders

  A real exam scenario, start to finish: look up each order's country, pull the shared price and transport rate off other sheets, work out the profit, then flag every order that lost money.