Loading…
Loading…
What you will build: Length of stay, age group and admission-day columns, a department table, a KPI block, highlighted long stays, a PivotTable of average cost and a titled chart.
Healthcare
You work in the operations office of a mid-size hospital. The board meets on Friday and wants a Q1 picture of 120 admissions: how long patients stay, which departments are busiest and most expensive, how much is insured, and whether weekend admissions are a staffing problem.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
Length of stay, age group and admission-day columns, a department table, a KPI block, highlighted long stays, a PivotTable of average cost and a titled chart. Every step is checked automatically, with hints when you get stuck.
Type Stay (days) in H1 and fill H2:H121 with Discharged − Admitted.
10 points
Type Age group in I1 and fill I2:I121: under 18 = Child, under 65 = Adult, otherwise Senior.
10 points
Type Admit day in J1 and fill J2:J121 with Weekend if the admission date is a Saturday or Sunday, otherwise Weekday.
10 points
M2:M6: patients per department. N2:N6: average stay. O2:O6: total cost.
20 points
M9: total cost of insured patients. M10: number of Senior patients in Cardiology. M11: the longest stay. M12: the patient ID with that stay (look it up from M11). M13:…
20 points
Highlight stays in H2:H121 longer than 7 days.
10 points
Insert a PivotTable from A1:J121 at L16 showing the Average of Cost by Department.
10 points
Insert a bar chart of L1:M6 titled Patients by department.
10 points
New to any of these? Each one is a free or Premium lesson you can do first.
FluentExcel project · Finance
Loan and Mortgage Calculator
8 steps · 17 rows of data · 56 formulas
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Input | Value | Month | Opening | Interest | Principal | Closing | |
| 2 | Home price | $350,000.00 | 1 | $297,500.00 | $1,363.54 | $463.37 | $297,036.63 | |
| 3 | Deposit % | 15% | 2 | $297,036.63 | $1,361.42 | $465.49 | $296,571.14 | |
| 4 | Annual rate | 5.50% | 3 | $296,571.14 | $1,359.28 | $467.63 | $296,103.51 | |
| 5 | Years | 25 | 4 | $296,103.51 | $1,357.14 | $469.77 | $295,633.74 | |
| 6 | Extra monthly payment | $200.00 | 5 | $295,633.74 | $1,354.99 | $471.92 | $295,161.82 | |
| 7 | 6 | $295,161.82 | $1,352.83 | $474.09 | $294,687.74 | |||
| 8 | Loan amount | $297,500.00 | 7 | $294,687.74 | $1,350.65 | $476.26 | $294,211.48 | |
| 9 | Monthly payment | $1,826.91 | 8 | $294,211.48 | $1,348.47 | $478.44 | $293,733.04 | |
| 10 | Total paid | $548,073.09 | 9 | $293,733.04 | $1,346.28 | $480.63 | $293,252.40 | |
| 11 | Total interest | $250,573.09 | 10 | $293,252.40 | $1,344.07 | $482.84 | $292,769.57 |
Finance
Loan and Mortgage Calculator
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
FluentExcel project · Sales
Sales Dashboard
9 steps · 150 rows of data · 172 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Rep | Region | Product | Units | Unit price | Revenue | Summary | |
| 2 | SO-2001 | 1/2/2026 | Ben | North | Phone | 5 | $599 | 2995 | Total revenue | |
| 3 | SO-2002 | 1/2/2026 | Ana | North | Tablet | 3 | $399 | 1197 | Orders | |
| 4 | SO-2003 | 1/3/2026 | Cara | South | Phone | 5 | $599 | 2995 | Average order | |
| 5 | SO-2004 | 1/4/2026 | Dev | South | Tablet | 2 | $399 | 798 | Top rep | |
| 6 | SO-2005 | 1/4/2026 | Ben | North | Laptop | 3 | $899 | 2697 | ||
| 7 | SO-2006 | 1/8/2026 | Cara | South | Laptop | 1 | $899 | 899 | ||
| 8 | SO-2007 | 1/9/2026 | Cara | South | Monitor | 4 | $229 | 916 | ||
| 9 | SO-2008 | 1/10/2026 | Cara | South | Phone | 1 | $599 | 599 | ||
| 10 | SO-2009 | 1/11/2026 | Eli | East | Headset | 5 | $79 | 395 | ||
| 11 | SO-2010 | 1/13/2026 | Eli | East | Tablet | 2 | $399 | 798 |
Monthly revenue
Sales
Sales Dashboard
9 steps · 3 h