Skip to Main Content
Microsoft Excel 365 Bible
book

Microsoft Excel 365 Bible

by Michael Alexander, Dick Kusleika
March 2022
Beginner to intermediate content levelBeginner to intermediate
1072 pages
28h 16m
English
Wiley
Content preview from Microsoft Excel 365 Bible

CHAPTER 27Analyzing Data with PivotTables

The previous chapter introduced PivotTables. There we presented several examples to demonstrate the types of PivotTable summaries that you can generate from a set of data.

This chapter continues the discussion and explores the details of creating effective PivotTables. Creating a basic PivotTable is easy, and the examples in this chapter demonstrate additional PivotTable features that you may find helpful. We urge you to try these techniques with your own data. If you don't have suitable data, use the files available on this book's website.

Working with Non-Numeric Data

Most PivotTables are created to aggregate numeric data, but PivotTables are also useful with some types of non-numeric data. With non-numbers, you can count instead of summing or averaging.

Figure 27.1 shows a table and a PivotTable generated from the table. The table consists of a list of 400 employees, along with their location and gender. As you can see, the table has no numeric values, but you can create a useful PivotTable that counts the items rather than sums them. The PivotTable (in range E2:H10) cross-tabulates the Location field by the Gender field for the 400 employees, and it shows the count for each combination of location and gender.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119835103Purchase Link