Home

How to Use and work with tables in Microsoft Excel 2007

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

Apple's iOS 26 and iPadOS 26 updates are packed with new features, and you can try them before almost everyone else. First, check Gadget Hacks' list of supported iPhone and iPad models, then follow the step-by-step guide to install the iOS/iPadOS 26 beta — no paid developer account required.