Did you know that Excel can filter lists for you? The feature is called "Data Autofilter." I use this tool all the time to (try to) make sense of data quickly without having to do any real programming. To try it, set up a list with each row containing one data point, plus a header row. You'll need to record the data and other information about it in separate columns. For example, for my students' grades, I have  the name in one column, the major in another, the year in a third, and so on. Set up at least a couple of rows and select a cell in the list. Then, when you turn Autofilter on (it's a toggle; go to the "Data" menu item and select "Filter/Autofilter"), you'll see little buttons with arrows appearing next to the column headings. Hit the button, and you get a drop-down list where you can select the filtering criteria. The criteria include blanks, nonblanks, specific values already in the list, top 10, custom, and so on. Select one of the filtering choices, and the rows not  conforming will magically disappear!

The key to making really productive use of this tool is to use a built-in feature of Excel whose name I haven't been able to determine. First select a  column of interest, or at least two cells. Then look at the bar across the very bottom of the screen (on the left-hand side it will probably say "Ready"; look to the right). On my screen, this is usually under the horizontal slider bar. You'll see some text there; I think the default is "Count". By right-clicking on that text, you'll get a list of other choices. In my grades example, you could choose "count" if the column contains letter grades, or "average" if the column contains numerical information.  Filter the list different ways, and track how the number changes to get  an idea of how the aggregate data looks.

Of course, this is just a quick and dirty way to get an impression of the variations. To do the job right, you'll want to use Database functions -- another topic...