Chapter 15

Using Excel tables and pivot tables

Excel and databases

Defining a table range

Creating a table using styles

Using the table design 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 ...

Get Microsoft Office Inside Out (Office 2021 and Microsoft 365) 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.