Loading…
Loading…
What you will build: A listings sheet with price per square foot, a summary block, slow listings highlighted, a PivotTable of average price by neighborhood with a chart, and the table sorted by price.
Real estate
You are an analyst at a small real-estate agency. The sales director wants a quick read on the current 60 listings: what the portfolio is worth, where prices are highest, and which homes are sitting on the market too long. Work through the steps in order; every step builds on the same workbook.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
A listings sheet with price per square foot, a summary block, slow listings highlighted, a PivotTable of average price by neighborhood with a chart, and the table sorted by price. Every step is checked automatically, with hints when you get stuck.
Type Price/SqFt in H1, then fill H2:H61 with each listing's price divided by its square footage.
30 points
K2: total value of all listings.
15 points
K3: average listing price.
15 points
K4: count the listings whose Type is Condo.
15 points
K5: average price of listings in Riverside.
15 points
K6: the highest price. K7: the neighborhood of that listing (use XLOOKUP or INDEX/MATCH, pointing at K6).
20 points
Highlight the Days on market values in G2:G61 that are greater than 90.
20 points
Insert a PivotTable of the Average of Price by Neighborhood. Place it at J10.
25 points
Insert a bar chart of the PivotTable output so the director can compare neighborhoods.
15 points
Finally, sort the listings table by Price, highest first.
15 points
New to any of these? Each one is a free or Premium lesson you can do first.
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
FluentExcel project · Operations
Inventory Management
9 steps · 80 rows of data · 327 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SKU | Item | Category | On hand | Reorder point | Unit cost | Supplier | Item (clean) | Stock value | Status |
| 2 | INV-1001 | USB-C cable Lite | Cables | 25 | 19 | $32.72 | S05 | USB-C cable Lite | 818 | OK |
| 3 | INV-1002 | USB stick Lite | Storage | 119 | 16 | $52.37 | S03 | USB stick Lite | 6232.03 | OK |
| 4 | INV-1003 | Earbuds Max | Audio | 25 | 30 | $52.76 | S02 | Earbuds Max | 1319 | Reorder |
| 5 | INV-1004 | Ethernet cable Mini | Cables | 61 | 32 | $58.76 | S04 | Ethernet cable Mini | 3584.36 | OK |
| 6 | INV-1005 | Hard drive Lite | Storage | 26 | 35 | $20.65 | S03 | Hard drive Lite | 536.9 | Reorder |
| 7 | INV-1006 | Hard drive Plus | Storage | 109 | 30 | $14.22 | S02 | Hard drive Plus | 1549.98 | OK |
| 8 | INV-1007 | USB stick Lite | Storage | 0 | 37 | $36.93 | S03 | USB stick Lite | 0 | Reorder |
| 9 | INV-1008 | Headphones Pro | Audio | 24 | 11 | $40.87 | S01 | Headphones Pro | 980.88 | OK |
| 10 | INV-1009 | Camera bag Lite | Cases | 88 | 15 | $35.09 | S02 | Camera bag Lite | 3087.92 | OK |
| 11 | INV-1010 | Ethernet cable Lite | Cables | 2 | 36 | $11.98 | S04 | Ethernet cable Lite | 23.96 | Reorder |
Stock value
Operations
Inventory Management
9 steps · 2.5 h
FluentExcel project · Human resources
HR and Payroll
8 steps · 60 rows of data · 423 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Emp ID | Name | Department | Start date | Annual salary | Overtime hrs | Rating | Years | Monthly base | Overtime pay |
| 2 | E1001 | Ana Nair | Sales | 12/23/2018 | $82,000 | 4 | 1 | 7 | 6833.333333 | 236.5384615 |
| 3 | E1002 | Ben Novak | Engineering | 8/20/2022 | $100,010 | 20 | 4 | 3 | 8334.166667 | 1442.451923 |
| 4 | E1003 | Cara Haddad | Operations | 4/1/2016 | $61,020 | 20 | 3 | 10 | 5085 | 880.0961538 |
| 5 | E1004 | Dev Haddad | Sales | 6/27/2017 | $50,030 | 8 | 4 | 9 | 4169.166667 | 288.6346154 |
| 6 | E1005 | Eli Lopez | Engineering | 10/21/2022 | $118,040 | 0 | 5 | 3 | 9836.666667 | 0 |
| 7 | E1006 | Fay Kim | Engineering | 4/22/2024 | $87,050 | 4 | 2 | 2 | 7254.166667 | 251.1057692 |
| 8 | E1007 | Gus Okafor | Operations | 7/22/2020 | $64,060 | 0 | 5 | 5 | 5338.333333 | 0 |
| 9 | E1008 | Hana Kim | Support | 12/25/2016 | $47,070 | 0 | 5 | 9 | 3922.5 | 0 |
| 10 | E1009 | Ivan Okafor | Operations | 6/9/2019 | $48,080 | 0 | 4 | 7 | 4006.666667 | 0 |
| 11 | E1010 | Jade Smith | Support | 10/9/2023 | $40,090 | 0 | 4 | 2 | 3340.833333 | 0 |
Human resources
HR and Payroll
8 steps · 3 h