Excel Advanced Report Development

Introduction.

Part I: Report Initiation and Source Data.

Chapter 1: Taking a First Look at Excel’s Reporting Tools.

Chapter 2: Getting Started with PivotTables.

Chapter 3: Understanding and Accessing Source Data.

Chapter 4: Using the Query Wizard.

Chapter 5: Getting Started with Microsoft Query.

Chapter 6: Working with SQL in Microsoft Query.

Part II: Advanced Reporting Features.

Chapter 7: Designing PivotTable Reports.

Chapter 8: Managing PivotTable Data.

Chapter 9: Exploring PivotChart Functionality.

Chapter 10: Working with OLAP Cubes.

Chapter 11: Creating and Using Spreadsheet Reports.

Chapter 12” Using Excel Reports on the Web.

Part III: Appendixes.

Appendix A: Configuring Your System.

Appendix B: SQL Reference.

Index.