Loading…
Loading…
What you will build: Clean item names, stock value, a reorder status, supplier names pulled from another sheet, a summary and category table, highlighted and filtered reorder items, and a pie chart of stock value.
Operations
You manage stock for an electronics accessories shop with 80 SKUs. The item names came from an old system full of stray spaces, suppliers live on a separate sheet, and the owner wants to know what to reorder today and where the money is tied up.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
Clean item names, stock value, a reorder status, supplier names pulled from another sheet, a summary and category table, highlighted and filtered reorder items, and a pie chart of stock value. Every step is checked automatically, with hints when you get stuck.
Type Item (clean) in H1 and fill H2:H81 with each item name without the extra spaces.
10 points
Type Stock value in I1 and fill I2:I81 with On hand × Unit cost.
10 points
Type Status in J1. Fill J2:J81 with Reorder when On hand is at or below the Reorder point, otherwise OK.
15 points
Type Supplier name in K1. Fill K2:K81 by looking up each Supplier code on the Suppliers sheet (A2:B6).
15 points
N2: total stock value. N3: how many items need reordering.
10 points
Q2:Q6: total stock value for each category in P2:P6.
15 points
Highlight every cell in J2:J81 that contains Reorder.
10 points
Turn on the filter for A1:K81 and show only the Reorder rows.
10 points
Insert a pie chart of P1:Q6.
5 points
New to any of these? Each one is a free or Premium lesson you can do first.
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
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