Locked lesson.

## About this lesson

Learn about creating Excel tables and their advantages.

## Exercise files

Download this lesson’s related exercise files.

Excel Tables - Begin.xlsx28.3 KB Excel Tables - Complete.xlsx

30.4 KB

## Quick reference

### Excel Tables

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.