Microsoft Excel For Educators: Segment 2

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 15-20 minute segments. This is the second post of the series. It will be beneficial as you view the 15-20 minute videos to also have the companion worksheet open so that you can try things in a hands-on environment as you see them (

This second video focuses on Excel’s formatting and conditional formatting features. The ability to use these tools can help us build a set of student data that we can wrap our head around, and also allows us to get some factual information from the data very quickly.

Segment 1 can be accessed at:

Please be on the lookout for Segments 3 and 4 of this series where we will explore the following:

The “IF” functions (Sumif, Averageif, Countif)
The “IFS” functions (Averageifs, Countifs)
…and More

And we’ll keep it going from there. Please do leave comments, suggestions, questions as you see fit. Please enjoy.


Related posts