Microsoft Excel For Educators: Segment 5

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 fifth post of the series, and this instructional video runs less than 10 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 the “Grouping” tool as well as investigate some great formulas that will help you instantly locate the largest and smallest values in your student data, as well as the median, and any other percentile.

Segment 1 can be accessed at:

Segment 2 can be accessed at:

Segment 3 can be accessed at:

Segment 4 can be accessed at:

Please be on the lookout for Segment 6 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. KeyCuts said:

    Great use of the grouping tool! To quickly create a group using keyboard shortcuts on the PC for Excel, hit SHIFT+ALT+RIGHT ARROW.

    We love Excel keyboard shortcuts, so much so that we created an Excel keyboard cover that shows the 20 most commonly used keyboard shortcuts for the Mac. Learn more at

Comments are closed.