Loading…
Loading…
What you will build: Working-day durations, days left, an overdue flag, a status summary, a status dropdown, highlighted overdue tasks, one person’s filtered view and a pie chart.
Project management
You coordinate a product launch with 40 tasks across five people. The status meeting is on 15 April 2026 (cell L1). The team lead wants to know how long each task takes in working days, what is overdue, where the team stands overall, and a clean way to update statuses.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
Working-day durations, days left, an overdue flag, a status summary, a status dropdown, highlighted overdue tasks, one person’s filtered view and a pie chart. Every step is checked automatically, with hints when you get stuck.
Type Work days in G1 and fill G2:G41 with the working days from Start to Due.
10 points
Type Days left in H1 and fill H2:H41 with Due − the report date in L1 (negative means late).
10 points
Type Flag in I1. Fill I2:I41 with Overdue when the task is not Done AND its Due date is before L1; otherwise leave it empty with "".
15 points
L5:L7: number of tasks in each status. L9: number of overdue tasks. L10: the share of tasks that are Done (Done count ÷ all tasks).
15 points
Add a dropdown to E2:E41 that only allows the three statuses listed in K5:K7.
10 points
Highlight the cells in I2:I41 that contain Overdue.
10 points
Turn on the filter for A1:I41 and show only Lena’s tasks.
10 points
Insert a pie chart of K4:L7.
10 points
New to any of these? Each one is a free or Premium lesson you can do first.
FluentExcel project · Personal finance
Personal Budget
9 steps · 40 rows of data · 10 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Category | Description | Amount | Type | Summary | Category | |||
| 2 | 1/1/2026 | Salary | Salary | $2,100.00 | Income | Total income | 4730 | Rent | ||
| 3 | 1/1/2026 | Rent | Monthly rent | $1,250.00 | Expense | Total expenses | 3188.76 | Groceries | ||
| 4 | 1/1/2026 | Utilities | Electricity | $115.64 | Expense | Net savings | 1541.24 | Transport | ||
| 5 | 1/1/2026 | Entertainment | Streaming | $29.76 | Expense | Savings rate | 33% | Utilities | ||
| 6 | 1/1/2026 | Groceries | Corner shop | $105.00 | Expense | Dining | ||||
| 7 | 1/1/2026 | Dining | Coffee | $30.63 | Expense | Entertainment | ||||
| 8 | 1/1/2026 | Groceries | Supermarket | $32.17 | Expense | |||||
| 9 | 1/2/2026 | Groceries | Corner shop | $92.91 | Expense | |||||
| 10 | 1/2/2026 | Entertainment | Cinema | $31.06 | Expense | |||||
| 11 | 1/4/2026 | Groceries | Corner shop | $59.02 | Expense |
Spent
Personal finance
Personal Budget
9 steps · 1.5 h
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 · 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