Excel Pivot Tables: Crunch Large Amounts Of Data (Data Analysis With Excel Book 5)

If you don’t have specialized software to interrogate your data, Excel is a great tool to use simply because it is so flexible. Pivot tables are one of the most powerful features in Excel, and using them allows you to manipulate and understand large quantities of data much faster than trying to code a bunch of functions into cells in Excel. The power of pivot tables to show you summations, counts, percentages and other quantities is very useful in a number of business or scientific settings.

This book goes over how to get started with Pivot tables in Excel, and many of the most important options that pivot tables have. This book is focused on the most important features of Pivot Tables, but it doesn’t deep dive into the details of every single different thing that can be done with them. This book goes over how to create pivot tables, different ways that they can be set up in rows, columns or tables, how to show the values in the pivot tables as counts, summations, products, percentages or other useful values, how to filter and sort pivot tables, how to format them and a few other tips and tricks.