by Nate Moore | Mar 15, 2010 | Tables
Excel Video 40 is a short, simple presentation on table styles in Excel 2007. There are a variety of easy to use pre-formatted styles you can apply to your table to make it look much more professional and make it easier to read at the same time. Best of all, it...
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...