O'Reilly logo

My Excel 2016 by Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15. Summarizing Data with PivotTables

Image

In this chapter, you’ll learn how to use a PivotTable to quickly summarize data. This chapter covers the following topics:

Creating a PivotTable

Sorting and filtering a PivotTable

Grouping dates in a PivotTable

Inserting slicers to help users filter a PivotTable

You can use a PivotTable to summarize a million rows with five clicks of the mouse button. For example, if you have sales data broken up by company and product, you can quickly summarize the sales by company, then product, or, with a few clicks, you can reverse the report and summarize by product, then company. Suppose you’re in charge of all ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required