About this lesson
If you often work with data sets that are quite large, then you might consider using an Excel table. Tables have a lot of functionality automated and make life easier.
Download this lesson’s exercise file.Tables
What do you use tables for?
If you work with large datasets, the benefits that tables offer is well worth considering
Requirements for tables
- One row headings
- No column or row breaks
- Consistent data types
Convert to table
Click anywhere in the data range
HOME > STYLES > FORMAT AS TABLE
- Windows: Control + T
- Mac: Command + T
Advantages of using tables
- Column headings are always visible, if you are in the table
- Sort and filter buttons are automatically added
- Totals added easily to the bottom of the range by the click of an option
- Totals added shows you the total of the visible fields
- Structured referencing in formulas makes formulas easier
- If you add a formula in a column, it is automatically copied to the rest of the column
- Adjustments to formulas are also copied to the rest of the column (both upward and downward)
Lesson notes are only available for subscribers.