Instructional Video

Excel 2016: Intro to PivotTables

Curated and Reviewed by Lesson Planet

Sometimes too much information can be overwhelming. PivotTables to the rescue!  Show scholars how to use PivotTables to summarize and manipulate content with a short, engaging video. Learners also discover how to use the feature to analyze and answer questions about their data. 

3 Views 4 Downloads
CCSS: Adaptable
Instructional Ideas
  • Have students practice creating PivotTables and adding rows and columns
  • Print and distribute the text tutorial as a student resource 
Classroom Considerations
  • Requires speakers and a projector or a computer and headphones for each individual 
  • Video 25 of 27 from the Microsoft Excel 2016 set
  • This video is hosted on YouTube
Pros
  • Presents information clearly and slowly with good graphics
  • Provides a convenient text-based lesson 
Cons
  • None
Common Core