Microsoft Office 2019 Step by Step, First Edition

Appendix

Define Excel tables

With Excel, you’ve always been able to manage lists of data effectively, so that you can sort your worksheet data based on the values in one or more columns, limit the data displayed by using criteria (for example, show only routes with fewer than 100 stops), and create formulas that summarize the values in visible (that is, unfiltered) cells. Excel 2019 provides those capabilities, and more, through Excel tables.

Manage data by using an Excel table

Tip

Sorting, filtering, and summarizing data are all covered elsewhere ...