did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780470046449

Excel 2007 Advanced Report Development

by
  • ISBN13:

    9780470046449

  • ISBN10:

    0470046449

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2007-03-26
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $50.00 Save up to $7.13
  • Rent Book $42.87
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    USUALLY SHIPS IN 2-3 BUSINESS DAYS
    *This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.

Supplemental Materials

What is included with this book?

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!

Author Biography

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.

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 ReportFormatting
Appendices
Appendix A
Appendix B
Index
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program