Advertisements
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
