Skip to main content

Excel 2007 Advanced Report Development

Excel 2007 Advanced Report Development

Timothy Zapawa

ISBN: 978-0-470-14801-3

Jun 2007

648 pages

$32.99

Description

Create powerful, innovative reporting solutions with Excel 2007! With this new book, which is significantly updated from the bestselling Excel 2003 version, author Timothy Zapawa provides you with in-depth coverage of Excel 2007’s enhanced reporting capabilities. Discover what you can do with PivotTable and Spreadsheet reports, enhanced conditional formatting and filtering functions, improved data access and management tools, and expanded OLAP features. With notes, tips, warnings, real-world examples, and how-to videos in every chapter, you'll soon be an expert on Excel report development!
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.

Chapter 1 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 2 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 3 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 4 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 5 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 6 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 7 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 8 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 9 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 10 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 11 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 12 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 13 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 14 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 15 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 16 sample files
To view the video files you may need to download the Windows Media Player plug-ins at http://www.techsmith.com/download.html.
Download
Chapter 17: Working with OLAP Cubes
Download
All Code Project Files
Download