Home

How to Use and work with tables in Microsoft Excel 2007

May 6, 2010 09:44 PM

Spreadsheet displaying sales data including date, car type, customer city, sales, and cost of goods sold.

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

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.