Using Excel tables for database data


show more Using Excel tables for database data provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Setting Up a Database in Excel 2010 show less
please wait ...

Using Excel tables for database data

If you want to work with a database type of list efficiently or if you want to set up a new list with a minimum amount of difficulty, you might want to consider using Excel's Table feature. It was new in Excel 2007; it's actually the successor to the older feature called List, which was not so well implemented. This data here could look better; it could be easier to work with if we convert it into a Table. The next sheet over actually is the same data, but it has been converted into a Table. The first obvious difference is every other row is highlighted that makes it easier to read.

As I'm scrolling here notice what's happening to the titles, now do you really care what the column letters are? Now you might, but on the other hand the Table emphasizes the idea that we've got field names that third column, whether it's column C or not it contains Department information that's the pertinent fact about that data. If it somehow bothers you and you do want to see the ...

Using Excel tables for database data
Video duration: 3m 40s 43m 27s Appropriate for all

Viewers:

Using Excel tables for database data provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Setting Up a Database in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...