Excel 2007 Advanced Report Development (eBook)

Timothy Zapawa is a Project Director at AdvantageComputing Systems in Ann Arbor, Michigan, where he manages implementation projects of enterprise software systems for book and magazine publishers around the world. He holds several professional and technical certifications and has developed training courses on delivering business intelligence, building report solutions, and developing SQL queries and programs in SQL and Oracle databases.

About the Author.

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.