A Collection of Web Pages About Excel Pivot Tables
How Do Pivot Tables Work? – Excel Campus
This post explains how pivot tables work, and why the structure of your source data is so important. Download example file to follow along.
Bottom line: This post explains how pivot tables work.
You will learn what actually happens when you drag a field into each area of the pivot table, and why the structure of your source data is so important…More at http://excelcampus.com
Understand Pivot Tables for Excel Dashboards and Reports – dummies
By Michael Alexander
Pivot tables in Excel are extremely useful for dashboarding and reporting. A pivot table is composed of four areas.
The data you place in these areas defines both the utility and appearance of the pivot table. Take a moment to understand the function of each of these four areas…More at http://dummies.com