Teach Yourself VISUALLY Excel 2016

CHAPTER 10

Working with Tables

The forte of Excel is spreadsheet work, of course, but its row-and-column layout also makes it a natural flat-file database manager. That is, instead of entering data and then using the Excel tools to build formulas and analyze that data, you can also use Excel simply to store data in a special structure called a table.

Understanding Tables

Get to Know Table Features

Convert a Range to a Table

Select Table Data

Insert a Table Row

Insert a Table Column

Delete a Table Row

Delete a Table Column

Add a Column Subtotal

Convert a Table to a Range

Apply a Table Style

Build a Custom Table Style

Create a PivotTable