Excel 2007 Advanced Report Development

Acknowledgements.

Introduction.

Part I Report Basics.

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

Chapter 2 Getting Started with PivotTable Reports.

Chapter 3 PivotTable Essentials and Components.

Part II External Data.

Chapter 4 Working with External Data Sources.

Chapter 5 Looking at the Get External Data Tab.

Chapter 6 Retrieving External Data Using Microsoft Query.

Chapter 7 Using the Query Wizard.

Chapter 8 Getting Started with Microsoft Query.

Chapter 9 Working with SQL in Microsoft Query.

Part III PivotTable Reporting.

Chapter 10 Designing PivotTable Reports.

Chapter 11 PivotTable Report Formatting.

Chapter 12 Managing PivotTable Data.

Chapter 13 Analyzing Data in a PivotChart.

Part IV Spreadsheet Reporting.

Chapter 14 Creating and Using Spreadsheet Reports.

Chapter 15 Building Report Solutions.

Chapter 16 Spreadsheet ReportFormatting.

Part V Appendices.

Appendix A SQL Reference.

Appendix B Pop-Up Menus, Clicking Actions, and Toolbar Functions.

Index.