Description
Look at the descriptionDescription:
Give your students a full week of engaging, hands-on Microsoft Excel practice with this complete intermediate unit bundle. Students go beyond the basics with real datasets they actually care about — a sneaker resale shop and 2020 NBA player salaries — while reinforcing key vocabulary through a fun crossword. Everything is no-prep and ready to use.
This bundle is the perfect next step for students who already know basic formulas (SUM, AVERAGE, MIN, MAX, IF) and are ready to level up.
What's included in this bundle:
1. Intermediate Formulas Tutorial — Sneaker Shop Sales Project (14 slides) A self-paced step-by-step tutorial where students build a sneaker shop sales tracker from scratch. By the end, they have a finished workbook and have practiced every key intermediate formula. Topics covered:
- Absolute vs. relative cell references (the dollar sign)
- ROUND for clean calculations
- SUMIF, COUNTIF, and AVERAGEIF for category analysis
- XLOOKUP for pulling data across tables
- IFS for multi-condition logic
- Text formulas: LEFT, RIGHT, MID, CONCAT, and the & operator
2. NBA Salary Analysis Activity Students put their formula skills into real-world practice using 2020 NBA player salaries. They apply SUM, AVERAGE, MAX, and MIN, use filters to slice the data, and build charts to visualize their findings. A guaranteed hit with sports fans and future analysts.
3. Excel Formulas Crossword Puzzle Reinforce vocabulary and concepts with a print-and-go crossword covering formulas, functions, cell references, and key Excel terminology. Perfect as a warm-up, bell-ringer, sub day filler, or end-of-unit review.
Excel Intermediate Formulas Bundle — Full Week Unit Plan | Tutorial + Activity
Highlights
Save even more with bundles
Description
Look at the descriptionDescription:
Give your students a full week of engaging, hands-on Microsoft Excel practice with this complete intermediate unit bundle. Students go beyond the basics with real datasets they actually care about — a sneaker resale shop and 2020 NBA player salaries — while reinforcing key vocabulary through a fun crossword. Everything is no-prep and ready to use.
This bundle is the perfect next step for students who already know basic formulas (SUM, AVERAGE, MIN, MAX, IF) and are ready to level up.
What's included in this bundle:
1. Intermediate Formulas Tutorial — Sneaker Shop Sales Project (14 slides) A self-paced step-by-step tutorial where students build a sneaker shop sales tracker from scratch. By the end, they have a finished workbook and have practiced every key intermediate formula. Topics covered:
- Absolute vs. relative cell references (the dollar sign)
- ROUND for clean calculations
- SUMIF, COUNTIF, and AVERAGEIF for category analysis
- XLOOKUP for pulling data across tables
- IFS for multi-condition logic
- Text formulas: LEFT, RIGHT, MID, CONCAT, and the & operator
2. NBA Salary Analysis Activity Students put their formula skills into real-world practice using 2020 NBA player salaries. They apply SUM, AVERAGE, MAX, and MIN, use filters to slice the data, and build charts to visualize their findings. A guaranteed hit with sports fans and future analysts.
3. Excel Formulas Crossword Puzzle Reinforce vocabulary and concepts with a print-and-go crossword covering formulas, functions, cell references, and key Excel terminology. Perfect as a warm-up, bell-ringer, sub day filler, or end-of-unit review.


