1 Table of Contents: “... word about compatibility -- Next steps -- Chapter 2 Creating a basic pivot table -- Ensuring that data...”

2 “... 2 Creating a Basic Pivot Table ... ... ... ... . .21 3 Customizing a Pivot Table...”

3 Table of Contents: “.... Building a Super Moder -- pt. II. Building Basic Dashboard Components -- Ch. 3. The Pivotal Pivot Table...”

4 Table of Contents: “... -- Choosing among multiple lookup tables -- Determining letter grades for test scores -- Calculating a grade...”

5 Table of Contents: “...) -- Writing VBA Code to Update a Table -- Updating fields in a record using ADO -- Updating a calculated...”

6 Table of Contents: “...Connecting to a Database Service SQL Server Security; Working with Databases; Working with Tables...”

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

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

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

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

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