© David Slager and Annette Slager 2020
D. Slager, A. SlagerEssential Excel 2019https://doi.org/10.1007/978-1-4842-6209-2_12

12. Working with Tables

David Slager1  and Annette Slager1
(1)
Fort Wayne, IN, 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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.