Microsoft Office 2019 Inside Out, First Edition

Chapter 15Using Excel tables and pivot tables

Excel and databases

Defining a table range

Creating a table using styles

Using the table tools

Sorting table data

Filtering table data

Using the data form

Creating outlines and subtotals

Working with external data

Connecting to other data sources

Working with pivot tables

Although we primarily think of Excel as a number cruncher, it also provides several tools and features for working with collections of information, which we refer to as databases. Excel enables you to view and manipulate data records and field information in a database table. You can also sort records in your table, filter the records, and import or connect to external data sources.

In this chapter, we look at Excel’s database capabilities, ...