Select Page

Tables

Tables are ideal for analyzing, sorting, and filtering detailed data, like accounts receivable balances and pre-authorizations. Watch this playlist of videos, read the three articles and try out the sample spreadsheet that accompanies the articles. Tables can make your staff much more efficient as they focus on what’s most important to work on next. There are also links to two other playlists, an advanced Tables playlist in Excel 2013 and a basic Excel 2007 Tables that you may also find helpful.  Master Tables and you’re well on your way to leveraging the power of Excel.

Tables Part 1 article

Tables were one of the best reasons to upgrade from older versions of Excel to Excel 2007 or Excel 2010. Here’s how to get started with Tables.

Tables Part 2 article

Now that you are familiar with the basics of tables, the Table Tools Design Tab can give you some great formatting options. If you’re still manually shading every other row of your data, you need to read this.

Tables Part 3 article

Now that you’re familiar with Tables, add power and flexibility with tips in this article.

Tables Spreadsheet

 

Use this spreadsheet to follow along with the Tables articles.