by Nate Moore | Feb 24, 2010 | 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...
by Nate Moore | Feb 22, 2010 | 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....
by Nate Moore | Feb 17, 2010 | 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...
by Nate Moore | Feb 15, 2010 | 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...
by Nate Moore | Feb 10, 2010 | 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...
