Microsoft Office Tutorials and References
In Depth Information
The AutoFilter: Picking and Choosing Your Data
Figure 6–20. Group shot: Filtering for two students
Or for an alternative but related example, if we had a database of students and their majors, for
instance (Figure 6–20):
Figure 6–21. Ringo a Lit major? What a concept.
We could filter by major, and say, click on Soc. We’d get (Figure 6–21):
Figure 6–22. Singling out Soc
And just as we could filter for both Dorothy and George, we could filter for both Soc and Poli Sci.
Again, transpose all this to a university of 10,000, and you get a pretty swift and effective way to learn
about large numbers of students.