TPT
Total:
$0.00
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Share

Description

Step-by-step directions (78 slides) on how to how to make calculations using real estate data. The lesson includes:

  • Basic formulas such as calculating how much houses are selling per square foot,
  • IF Functions to determine if realtors earned a bonus,
  • SUMIF Functions to determine how much each realtor sold,
  • Creating Pivot Tables to analyze data, such as how many homes are selling in certain neighborhoods.
  • TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make (directions and grading rubric included).

Answer keys for everything are included. PowerPoint is fully editable. Screenshots from Microsoft 365.

Click here to purchase the video lesson or pay just $2 more to get both versions.

Microsoft Lessons (Word, Excel, PowerPoint)

Computer Coding Lessons

Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere Pro, After Effects

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.

Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)

Miss B's Shop
1.7k Followers
$10.00

Save even more with bundles

Three PowerPoint lessons with Excel sheets, Tests, Rubrics, and Answer Keys.Lesson 1: (Football Statistics)Basic formatting skills such as word wrapping text in a cell and drawing boxes around cells,How to sort data,writing formulas to determine net receiving yards, average number of carries per gam
Price $28.00Original Price $32.00Save $4.00
4
This is a bundle of 7 lessons from my Computer Applications class. They each include step-by-step directions for students and an assessment to evaluate their learning. Please note that many of the lessons have a version that is an instructional video and also a version that is the PowerPoints. There
Price $70.00Original Price $105.50Save $35.50
11
Pay just $2 more to get my PowerPoint lesson and my instructional video version of this lesson. Now you will have both options...teaching the lesson yourself, or assigning the video to your students. *Please note that the only difference between the two downloads is that one is a PowerPoint lesson a
Price $12.00Original Price $20.00Save $8.00
2

Description

Step-by-step directions (78 slides) on how to how to make calculations using real estate data. The lesson includes:

  • Basic formulas such as calculating how much houses are selling per square foot,
  • IF Functions to determine if realtors earned a bonus,
  • SUMIF Functions to determine how much each realtor sold,
  • Creating Pivot Tables to analyze data, such as how many homes are selling in certain neighborhoods.
  • TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make (directions and grading rubric included).

Answer keys for everything are included. PowerPoint is fully editable. Screenshots from Microsoft 365.

Click here to purchase the video lesson or pay just $2 more to get both versions.

Microsoft Lessons (Word, Excel, PowerPoint)

Computer Coding Lessons

Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere Pro, After Effects

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