Chapter 15
Using Excel tables and pivot tables
Creating outlines and subtotals
Connecting to other data sources
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.