Loading…
Loading…
What you will build: A summary of income, expenses and savings rate, spend by category with the top three highlighted, a validated entry area, a filtered view of groceries and a pie chart of spending.
Personal finance
Maya tracked every transaction for January in one sheet. She wants to know how much she saved, where the money went, and wants a tidy way to log new transactions. Build her budget dashboard step by step.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
A summary of income, expenses and savings rate, spend by category with the top three highlighted, a validated entry area, a filtered view of groceries and a pie chart of spending. Every step is checked automatically, with hints when you get stuck.
H2: total of all transactions whose Type is Income.
15 points
H3: total of all Expense transactions.
15 points
H4: income minus expenses, using your cells H2 and H3.
10 points
H5: net savings as a share of income, formatted as a percentage.
15 points
Fill K2:K7 with the total spent in each category listed in column J. Write one formula that points at the category in J and fill it down.
30 points
Highlight the top 3 categories by spend in K2:K7.
15 points
New transactions go in rows 42 to 46. Add a dropdown to B42:B46 that only allows the six expense categories in J2:J7.
15 points
Turn on the filter for A1:E41 and show only Groceries in the Category column.
15 points
Insert a pie chart of J1:K7.
15 points
New to any of these? Each one is a free or Premium lesson you can do first.
FluentExcel project · Education
Student Gradebook
8 steps · 32 rows of data · 99 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Student | HW1 | HW2 | Project | Exam | Final | Grade | Rank | ||
| 2 | Hana Silva | 99 | 98 | 100 | 99 | 99.15 | A | 1 | ||
| 3 | Xena Ali | 100 | 82 | 100 | 100 | 97.3 | A | 2 | ||
| 4 | Vera Chen | 83 | 99 | 98 | 85 | 90.7 | A | 3 | ||
| 5 | Jade Chen | 89 | 96 | 89 | 90 | 90.45 | A | 4 | ||
| 6 | Tara Silva | 85 | 90 | 79 | 99 | 89.55 | A | 5 | ||
| 7 | Zoe Nair | 77 | 90 | 77 | 100 | 88.15 | A | 6 | ||
| 8 | Sam Haddad | 84 | 91 | 80 | 85 | 84.25 | A | 7 | ||
| 9 | Ana Lopez | 80 | 81 | 87 | 70 | 78.25 | B | 8 | ||
| 10 | Nia Nair | 80 | 80 | 80 | 73 | 77.2 | B | 9 | ||
| 11 | Fay Rossi | 74 | 64 | 69 | 88 | 76.6 | B | 10 |
Grade distribution
Education
Student Gradebook
8 steps · 2 h
FluentExcel project · Project management
Project Tracker
8 steps · 40 rows of data · 125 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Task | Owner | Start | Due | Status | Priority | Work days | Days left | Flag | |
| 2 | Design dashboard | Tom | 4/4/2026 | 4/7/2026 | In progress | Low | 2 | -8 | Overdue | |
| 3 | Build API endpoint | Sara | 3/25/2026 | 3/31/2026 | Done | High | 5 | -15 | ||
| 4 | Test reports | Priya | 3/26/2026 | 3/30/2026 | Done | Medium | 3 | -16 | ||
| 5 | Review login page | Lena | 4/15/2026 | 5/6/2026 | In progress | High | 16 | 21 | ||
| 6 | Document settings | Sara | 3/28/2026 | 4/18/2026 | Not started | Low | 15 | 3 | ||
| 7 | Deploy settings | Marco | 3/8/2026 | 3/26/2026 | Done | Low | 14 | -20 | ||
| 8 | Plan settings | Sara | 4/5/2026 | 4/13/2026 | Not started | Medium | 6 | -2 | Overdue | |
| 9 | Migrate onboarding | Tom | 4/2/2026 | 4/7/2026 | In progress | Low | 4 | -8 | Overdue | |
| 10 | Design reports | Lena | 4/1/2026 | 4/26/2026 | Done | Low | 18 | 11 | ||
| 11 | Build reports | Priya | 4/2/2026 | 4/12/2026 | Not started | Medium | 7 | -3 | Overdue |
Tasks
Project management
Project Tracker
8 steps · 2 h
FluentExcel project · Real estate
Real Estate Analysis
10 steps · 60 rows of data · 66 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Listing | Neighborhood | Type | Beds | SqFt | Price | Days on market | Price/SqFt | Summary | |
| 2 | RE-1029 | Downtown | House | 4 | 2540 | $1,235,000 | 108 | 486.2204724 | Total value | |
| 3 | RE-1001 | Downtown | Condo | 5 | 2900 | $1,185,000 | 9 | 408.6206897 | Average price | |
| 4 | RE-1054 | Downtown | Townhouse | 4 | 2740 | $1,137,000 | 90 | 414.9635037 | Condos listed | |
| 5 | RE-1019 | Downtown | Condo | 5 | 2740 | $1,135,000 | 140 | 414.2335766 | Avg price Riverside | |
| 6 | RE-1002 | Downtown | House | 4 | 2380 | $1,131,000 | 143 | 475.210084 | Highest price | |
| 7 | RE-1049 | Hillcrest | House | 5 | 3000 | $1,130,000 | 133 | 376.6666667 | Neighborhood of highest | |
| 8 | RE-1025 | Lakeside | Townhouse | 5 | 2710 | $1,111,000 | 24 | 409.9630996 | ||
| 9 | RE-1022 | Hillcrest | Condo | 5 | 3130 | $1,080,000 | 123 | 345.0479233 | ||
| 10 | RE-1007 | Downtown | Condo | 5 | 2850 | $1,072,000 | 148 | 376.1403509 | ||
| 11 | RE-1009 | Downtown | Townhouse | 5 | 2580 | $1,030,000 | 7 | 399.2248062 |
Real estate
Real Estate Analysis
10 steps · 3 h