Select Page

Excel Video 40 Table Styles

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

Excel Video 39 More Sorting Tricks in 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...

Excel Video 38 Sorting 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....

Excel Video 37 Advanced Table Filtering

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