What are Excel Tables and why are they Awesome?

April 14, 2020

BY BOHDANNA, DIRECTOR OF EVALUATION

 

If you use Excel to store data, you know about worksheets and how you can organize information with columns and rows.

 

Did you know Excel has a feature that makes your information easier to navigate with a few clicks?

 

 

The awesomeness (aka benefits) of Excel Tables:

What it does

So you can…

Creates filters for each column Quickly sort or filter information

 

Recognizes data as a set range Automatically expand your data range and formulas when you add new columns and rows
Provides an option to show a total row Make quick calculations in a toggle (e.g., Sum, Average)
Names your Excel table Easily reference data in other worksheets and workbooks

 

Are you sold?

 

Here’s the steps to create an Excel table:

  1. Select a cell somewhere in your table
  2. Click Insert > Table (keyboard shortcuts: Ctr+T (Windows) or Cmd + T (Mac))
  3. Confirm the table range (i.e., the cell range to include in the table)
  4. Confirm if your data range includes a header row (i.e., column labels)
  5. Click “ok”
  6. With your table active (i.e., select a cell in the table) use the ‘table’ ribbon to format your table design

 

To convert back to a data range:

  1. Select a cell somewhere in your table
  2. Click Table > Convert to range

Written By

Bohdanna

Director of Evaluation