Excel project

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.

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

Step 1 of 4: Break down spend by department and category

Expenses are logged per department per category. Build a pivot table showing total spend by department and category.

Step 2 of 4: Chart each department's share of the budget

Combine both categories and chart each department's share of the total budget.

Step 3 of 4: Flag whoever's over budget

Every department has a $1,000 cap this quarter. Highlight whichever department went over it.

Step 4 of 4: Price out financing new equipment

Engineering wants to finance $12,000 of new equipment over 24 months at a 6% annual interest rate. Calculate the monthly payment.

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 →