Excel Advanced Report Development

Excel Advanced Report Development

3.72 (22 ratings by Goodreads)
By (author) 

List price: US$39.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

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; and, detailed information on creating and working with web-enabled Excel reports.
show more

Product details

  • Paperback | 504 pages
  • 185.42 x 231.14 x 27.94mm | 748.42g
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 1. Auflage
  • 0764588117
  • 9780764588112
  • 774,775

Back cover copy

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. Single-source coverage of Excel's report development features Extensive and in-depth information on PivotTable(R) and Spreadsheet report features, functions, and capabilities Thorough documentation of the Microsoft(R) 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 Companion web site Example files for all the exercises in the book are available for download at www.wiley.com/go/excelreporting, where you can also watch videos illustrating various lessons.
show more

Table of contents

Acknowledgments. Introduction. Part I: Report Initiation and Source Data. Chapter 1: Taking a First Look at Excel's Reporting Tools. Chapter 2: Getting Started with PivotTables. Chapter 3: Understanding and Accessing Source Data. Chapter 4: Using the Query Wizard. Chapter 5: Getting Started with Microsoft Query. Chapter 6: Working with SQL in Microsoft Query. Part II: Advanced Reporting Features. Chapter 7: Designing PivotTable Reports. Chapter 8: Managing PivotTable Data. Chapter 9: Exploring PivotChart Functionality. Chapter 10: Working with OLAP Cubes. Chapter 11: Creating and Using Spreadsheet Reports. Chapter 12" Using Excel Reports on the Web. Part III: Appendixes. Appendix A: Configuring Your System. Appendix B: SQL Reference. Index.
show more

About Timothy Zapawa

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).
show more

Rating details

22 ratings
3.72 out of 5 stars
5 23% (5)
4 32% (7)
3 41% (9)
2 5% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X