Microsoft Excel For Educators: Segment 7

Welcome all to a new week of Excel for Educators where I’ve tried to take some of the things that I do in my work with the Analytics, Research and Evaluation team here at Discovery Education and frame them in the perspective of the classroom teacher, and then divide them into 10 minute segments. This is the seventh post of the series, and this instructional video runs less than 9 minutes. It will be beneficial as you view the videos to also have the companion worksheet open so that you can try things in a hands-on environment as you see them (

In this video we will explore Excel’s ability to help us create a dynamic display of our student assignment and test data. And we’ll use the Pivot Table tool to get there.

Segment 1 can be accessed at:

Segment 2 can be accessed at:

Segment 3 can be accessed at:

Segment 4 can be accessed at:

Segment 5 can be accessed at:

Segment 6 can be accessed at:

Please be on the lookout for Segment 8 of this series where we will explore more….

Please do leave comments, suggestions, questions as you see fit. Please enjoy.


Related posts

One Comment;

  1. Annette McKee said:

    Working in Windows, I had some trouble finding the Excel Pivot Table feature – finally found it under the Insert tab.

Comments are closed.