Excel’s Table feature adds some nice functionality to your Excel workbook.

Download exercise file here: ExcelTable

Create Table

To create a table, highlight the cells you want and hit Ctrl-T. Leave My table has headers checked as our first row is header values.

Your table will now look like this:

The drop down menu in each header provides sorting and filtering.

Tables provide a new set of menu items in the Ribbon Bar

Let’s click the Total Row check box in the Ribbon Bar

A Total Row will appear at the bottom of your table. You can select which kind of aggregate you want to perform.

Slicer

Let’s add a slicer now.

Select Name

Now you have a slicer for your table.

Now, select Charles and see how it filters your table