1 Table of Contents: “...Pivot table fundamentals -- Creating a basic pivot table -- Customizing a pivot table -- Grouping...”

2 Table of Contents: “...Introduction -- Pivot table fundamentals -- Creating a basic pivot table -- Customizing a pivot...”

3 Table of Contents: “... -- Acknowledgments -- About the Authors -- Introduction -- Chapter 1 Pivot table fundamentals -- Why you should use a...”

4 “..., or year Introduction ... ... ... ... ... ... ... ... . 1 1 Pivot Table Fundamentals ... ... ... ... ... 11...”

5 Table of Contents: “...At a Glance; About the Authors; Table of Contents; Introduction; Part I: Leveraging Excel...”

6 Table of Contents: “...pt. 1. Moving from spreadsheets to dashboards -- pt. 2. Excel chart basics -- pt. 3. Going beyond...”

7 Table of Contents: “... Glance -- Table of Contents -- Introduction -- Part I: Understanding Formula Basics -- Chapter 1...”

8 Table of Contents: “..., Avg, Count, StDev, Var -- Min, Max, First, Last -- Expression, Where -- Action Queries -- Make-table...”

9 Table of Contents: “...pt. 1. Getting started with Excel macros -- pt. 2. Working with workbooks -- pt. 3. Automating...”

10 Table of Contents: “... -- Introduction -- Part I: Fundamentals of Data Analysis in Access -- Chapter 1: The Case for Data Analysis...”

11 Table of Contents: “...Introducing dashboards -- Table design best practices -- Using Excel sparklines -- Chartless...”

12 Table of Contents: “...pt. I. Makin the Move to Dashboards -- Ch. 1. Getting in the Dashboard State of Mind -- Ch. 2...”

13 Table of Contents: “...; Dynamically rearranging pivot table data; Offering one-touch reporting options; Chapter 2 Getting Cozy...”

14 Table of Contents: “... VBA Techniques. Working with Pivot Tables -- Working with Charts -- Interacting with Other...”

15 Table of Contents: “... VBA Techniques. Working with Pivot Tables -- Working with Charts -- Interacting with Other...”

16 Table of Contents: “...Part I. Getting Started with Excel -- Part II. Working with Formulas and Functions -- Part III...”

17 “... view or edit them; Use improved PivotTables to analyze huge amounts of data; Store and share workbooks...”