Instructional Video

Excel 2016: Groups and Subtotals

Curated and Reviewed by Lesson Planet

How do Excel users make their data more manageable? Video 19 of 27 from the Microsoft Excel 2016 set has the answer. Scholars learn how to use groups and subtotals to summarize and outline data. Users also discover how to manage a spreadsheet's headers, footers, and page numbers.

3 Views 2 Downloads
CCSS: Adaptable
Instructional Ideas
  • Have individuals teach a partner how to restart page numbering in an Excel document 
  • Ask small groups to discuss the differences between headers and footers
Classroom Considerations
  • Requires speakers and projection or a computer and headphones for each individual
  • This video is hosted on YouTube
Pros
  • Slow-paced narration makes it easy to follow along
  • Includes a link to a handy text-based lesson 
Cons
  • None
Common Core