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

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 ...

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done. Filtering is a huge part of many Microsoft Excel sheets, and ...

For many of us, sorting an Excel spreadsheet alphabetically means clicking the A→Z or Z→A buttons in the Sort & Filter group and moving on with our day. I used to think that was the extent of what ...