© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_12

12. Working with Tables

David Slager

(1)Fort Wayne, Indiana, USA

A table is a structured collection of data consisting of a header row and multiple data rows. A table is used to contain data of a single type such as orders, sales, inventory, and so on. A table makes it easier to filter, sort, analyze, summarize, and format your data.

After reading and working through this chapter you should be able to:

  • Create and format a table

  • Sort and filter a table

  • Add to a table

  • Resize a table

  • Add calculated fields to a table

  • Create slicers

  • Apply themes

  • Apply styles

  • Create conditional formatting

You can pull data from multiple tables to create another table. Data in a table can be kept ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.