Excel 2016 Bible

Chapter 5Introducing Tables

IN THIS CHAPTER

1. Understanding how a table differs from a normal range
2. Working with tables
3. Using the Total Row
4. Removing duplicate rows from a table
5. Sorting and filtering a table

A common type of spreadsheet contains information in a structured list, also known as a table. A table is a rectangular range of data that usually has a row of text headings to describe the contents of each column. Excel's table feature makes common tasks much easier — and a lot better looking. More importantly, the table features may help eliminate some common errors.

This chapter is a basic introduction to Excel tables. As always, I urge you to just dig in and experiment with the various table-related commands. You may be surprised by what you can accomplish with just a few mouse clicks.

What Is a Table?

A table is a rectangular range of structured data. Each row in the table corresponds to a single entity. For example, a row can contain information about a customer, a bank transaction, an employee, a product, and so on. Each column contains a specific piece of information. For example, if each row contains information about an employee, the columns can contain data such as name, employee number, hire date, salary, department, and so on. Tables typically have a header row at the top that describes the information contained in each column.

Setting up data like this in a range of cells is straightforward. The magic happens when you tell Excel to convert a range of data into ...