×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Excel Advanced Report Development
     

Excel Advanced Report Development

5.0 3
by Timothy Zapawa
 

If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting

Overview

If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately. This book includes:

  • Single-source coverage of Excel's report development features
  • Extensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilities
  • Thorough documentation of the Microsoft Query program included with Excel
  • Comprehensive information on Excel's client-based OLAP cube tools for processing very large datasets from OLTP data sources
  • Detailed information on creating and working with web-enabled Excel reports

Product Details

ISBN-13:
9780764588112
Publisher:
Wiley
Publication date:
07/28/2005
Pages:
504
Product dimensions:
7.32(w) x 9.24(h) x 1.06(d)

Meet the Author

Timothy Zapawa is a project director atAdvantage Computing Systems, Inc., where he leads teams of engineers, developers, and managers through long-term software implementations. He has developed software training programs and has obtained several professional and technical certifications, including Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Database Administrator (MCDBA).

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

Excel Advanced Report Development 5 out of 5 based on 0 ratings. 3 reviews.
Anonymous More than 1 year ago
Guest More than 1 year ago
I went to the book store looking for another title concerning Excel reporting. The book was not available so I started looking at other books on the subject. This book caught my eye because of the title and subject matter. I was not disappointed. I have found this book to be on point. I really appreciated the examples since I am a strong visual learner and the SQL queries. I had problems with the video examples that was okay because I did not need them. This book is a winner.
Guest More than 1 year ago
Excellent book! This is by far the best book I've read on PivotTable reporting. It's jam-packed with SQL query examples and it is the first book I've seen that shows how client OLAP and web-enabled reporting really work. The author really shows his expertise on how reports really work in the enterprise.