Excel^® 2007 Advanced Report Development

by Timothy Zapawa

• ISBN13: 9780470148013
• ISBN10: 0470148012
• Format: eBook
• Copyright: 2007-06-01
• Publisher: Wiley

Summary

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!

Table of Contents

About the Author

Acknowledgements

Introduction

Report Basics

Taking a First Look at Excel's Reporting Tools

Getting Started with PivotTable Reports

PivotTable Essentials and Components

External Data

Working with External Data Sources

Looking at the Get External Data Tab

Retrieving External Data Using Microsoft Query

Using the Query Wizard

Getting Started with Microsoft Query

Working with SQL in Microsoft Query

PivotTable Reporting

Designing PivotTable Reports

PivotTable Report Formatting

Managing PivotTable Data

Analyzing Data in a PivotChart

Spreadsheet Reporting

Creating and Using Spreadsheet Reports

Building Report Solutions

Spreadsheet Report Formatting

Appendices

SQL Reference

Pop-Up Menus, Clicking Actions, and Toolbar Functions

Index

Table of Contents provided by Publisher. All Rights Reserved.