Chapter 9. WORKING WITH PIVOTTABLES
Create a PivotTable
Excel offers you much more than just a way of keeping track of your data and doing calculations. It also provides tools to analyze your data so that you can understand it and use it to make more effective decisions.
One of the most useful tools, the PivotTable, is also one of the least understood. PivotTables help you answer questions about your data. Similar to a cross-tabulation in statistics, a PivotTable shows how data is distributed across categories. For example, you can use a PivotTable to see how different products sell by region and by quarter.
You base PivotTables on lists. Lists are made up of rows and columns. You can use a worksheet list or you can connect to a list from another ...
Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition 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.
