Chapter 1. Understanding PivotTables

Understanding Data Analysis

The PivotTables and PivotCharts that you learn about in this book are part of the larger category of data analysis. You can get the most out of these tools if you have a broader understanding of what data analysis is, what its benefits are, and what other tools are available to you.

Data analysis is the application of tools and techniques to organize, study, reach conclusions about, and sometimes also make predictions about, a specific collection of information. A sales manager might use data analysis to study the sales history of a product, determine the overall trend, and produce a forecast of future sales. A scientist might use data analysis to study experimental findings and determine ...

Get Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets 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.