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

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

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

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

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

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

7 Table of Contents: “... Databases Help; Database Terminology; How Databases Are Designed; Chapter 2: PivotTable Fundamentals...”

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

9 Table of Contents: “...Step 1: Design the Ribbon and build the XML -- Step 2: Write the callback routines -- Step 3...”

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

11 Table of Contents: “... -- An Excel User's Guide to Access: Don't Panic! -- Summary -- Chapter 2: Access Basics -- Access Tables...”

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

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

14 Table of Contents: “... ; Building a super model -- Building basic dashboard components. Dressing up your data tables ; Sparking...”

15 Table of Contents: “...Part I: Access building blocks -- Part II: Understanding Access tables -- Part III: Working...”

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

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

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

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