Locked lesson.

## About this lesson

Learn about creating Excel tables, and their advantages.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Excel Tables.xlsx12.2 KB Excel Tables - Completed.xlsx

13.9 KB Excel Tables - Extra Practice.xlsx

19.4 KB

## Quick reference

### Topic

Creating Excel tables, and their benefits.

### When to use

Excel tables are the standard and best way to organize tabular data in Excel today.

### Instructions

#### Benefits of creating Excel tables

- Instant access to alternate row shading
- Auto-expansion when new rows or columns are added
- Auto-complete of identical formulas down the entire column
- Access to structured table reference formula creation
- Automatic application of filters
- Automatic naming of the table

#### Preparing your data to turn it into an Excel table

- Make certain that your data is in tabular format
- It is essential that there be no blank rows or columns interrupting the data
- Provide a clear header row for your data

#### Creating Excel tables

- Select any cell in the data range
- Go to the Home tab, choose Format as table, and pick your favorite color scheme
- You may want to then go to the Table Tools > Design tab, and rename the table to something more descriptive than Table1

Lesson notes are only available for subscribers.