Select Page

Excel Video 39 More Sorting Tricks in Tables

Excel Video 39 shows a new feature in Excel 2007, the ability to sort by color. You can sort by cell color, by font color, or by cell icon. Watch this video and learn how to teach Excel the specific sort order you prefer for the colors or icons you’re using. Excel...

Excel Video 38 Sorting Tables

Excel Video 38 demonstrates the way sorting works in tables. Excel recognizes whether the data you’re trying to sort are dates, text, or numbers, and changes the wording of the sorting options accordingly. It’s straightforward to sort from A-Z or from Z-A in tables....

Excel Video 37 Advanced Table Filtering

We’ve covered a variety of different ways to filter tables in the last 4 lectures. Excel Video 37 introduces advanced filters in Excel 2007, where the basic drop-down filters are not enough. The filters we’ve looked at so far allow you select multiple choices in the...

Excel Video 36 Filtering by Color in Tables

Now that we’ve been through filtering dates, text, and numbers in tables, Excel Video 36 demonstrates how to filter by color. Filtering by color is new in Excel 2007 and allows you to filter data by either the font color or the cell color. Video 36 uses three separate...

Excel Video 35 Filtering Numbers in Tables

Excel Video 35 reviews the options for filtering numbers in tables. After watching the last two videos on filtering dates and text, this will be second nature to you. We’ll review an example or two of filtering numbers, like getting all patients in their thirties....