Instructional Video

Excel 2016: Doing More with PivotTables

Curated and Reviewed by Lesson Planet

How does pivoting add excitement? Learners discover how to make even the most mundane data more exciting with the 26th video from the 27-part Microsoft Excel 2016 series. In addition, they learn how to add filters and slicers to their PivotTables and explore how to create a PivotChart. 

3 Views 1 Download
CCSS: Adaptable
Instructional Ideas
  • Gauge comprehension by having learners explain the differences between PivotTables and PivotCharts
Classroom Considerations
  • Builds on information from a previous video 
  • Requires a projector and speakers, or a computer and headphones for each pupil
  • This video is hosted on YouTube
Pros
  • Narrator presents information in a detailed, straightforward manner
  • Includes a supportive text-based lesson 
Cons
  • None
Common Core