Adding color creates a great visual effect, but did you know that you can evaluate values by color? Use this technique to turn color into valuable information. Color is a great visual tool in most any ...

Microsoft Excel has a great sorting feature that works quite well. However, it is possible to use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, ...

Let’s say you have a student gradebook file open in Excel and it contains information for the students in your class. As you look through the students’ grades, you highlight the names of students to ...

Microsoft Excel’s Subtotal feature is a great tool, but you can make the results even better by customizing the format. Microsoft Excel’s Subtotal feature calculates subtotals and a grand total for ...

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by themselves, ...