by Nate Moore | Mar 17, 2010 | Tables
Excel Video 41 is another short, straight-forward video, this time on table style options. Table style options is a section of six check boxes in the Table Tools Design tab that let you control how your table is formatted. Even better, the options carry over to the...
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...
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...
