Excel Sorting & Subtotaling - Lecture Notes - CIS 211 - Management Information Systems
Resources
For today's follow-along lab, you will need to use a Windows or Mac computer that has Microsoft Excel 2007 installed. You should download and use the excel file lec-02-more-pop.xlsx. This file contains population data published by the United States Census Bureau.
Lab
In class, we will undertake a follow-along lab to learn the basics of sorting, subtotaling, and conditional formatting in Microsoft Excel. Below is a list of key topics covered in the follow-along lab. Items appearing in bold are accompanied by videos in the next section on this Web page.
- Using conditional formatting to change the background color of a cell
- Sorting using the AZ and ZA buttons
- Sorting using the Custom Sort button
- Sorting on multiple values
- Sorting on criteria other than values
- Avoiding sorting a subset of data
- Basic subtotaling and its interaction with sorting
- Advanced subtotaling: using formulas to guide subtotals
- INT formula
Video
Sorting, Conditional Formatting, and Subtotaling in Excel:
