How To: Use and work with tables in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:

1. Keyboard shortcut to create table
2. Automatic formatting (Including how to create table style and set as default)
3. Sorting & filtering from drop-down arrows
4. Dynamic ranges for formulas, charts and PivotTables
5. Change table name
6. Formula table nomenclature
7. Convert to range