Select Page

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

Excel Video 34 Filtering Text in Tables

Excel Video 34 covers filtering text in tables. Filtering text is more straight-forward with fewer options than filtering dates or numbers, so I’m including a couple of other tricks in this video as well. Watch the demonstration of using custom filters to see how to...

Excel Video 33 Filtering Dates in Tables

Excel Video 33 demonstrates some of many methods Excel offers to filter date fields in tables. When you filter a field containing dates, Excel recognizes the dates and customizes your filter options accordingly. The date filtering options you’re used to seeing in...

Excel Video 32 Totals in Tables

Welcome back for more Excel videos! Excel Video 32 shows you how clicking the Total Row the Table Tools Design Tab puts a total row at the bottom of your table. The cool thing is that next to each cell in the total row is a drop-down arrow with a variety of choices...