by Nate Moore | Mar 10, 2010 | 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...
by Nate Moore | Mar 8, 2010 | 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....
by Nate Moore | Mar 1, 2010 | Tables
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...
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....
