TPT
Total:
$0.00
Excel Intermediate Formulas Bundle — Full Week Unit Plan | Tutorial + Activity
Share

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.

Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.

Excel Intermediate Formulas Bundle — Full Week Unit Plan | Tutorial + Activity

Bits and Bytes 6-12
101 Followers
$6.00
$7.00
SAVE
$1.00

Highlights

Grades icon
Grades
7th - 10th
Teaching Duration
1 Week

Save even more with bundles

Complete Microsoft Excel curriculum and lesson plans for high school CTE, business, and computer applications classes. This no-prep, 8-week unit takes students from beginner to advanced data analysis with step-by-step tutorials, hands-on activities, real-world projects, a personal finance capstone,
Price $35.00Original Price $47.25Save $12.25
15

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.

Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.

Reviews

This product has not yet been rated.
Rated 0 out of 5

Questions & Answers

Loading
Loading