3 Review(s)

This book instructs readers on how to develop reporting solutions using Microsoft Excel 2003. Each chapter includes comprehensive information and real-world examples describing how the reporting technology is used in an array of prestigious organizations. The main sections of the book are as follows: PivotTable Reports, Spreadsheet Reports, Parameter Queries and Web Components. While there are a few sections on Offline Analytical Processing (OLAP) reports and beginning Visual Basic for Applications (VBA), this book primarily focuses on report development using OLTP databases, a subject with almost no coverage in the marketplace. Each chapter includes comprehensive information and real-world examples describing how reporting technology can be used in various business settings. Special Feature Fills an unmet need in the market for comprehensive coverage on the technical and strategic features vital to Excel 2003 report development. Provides information on developing effective reports and offers coverage on how this technology is used in various organizations. Gives readers extensive and in-depth information on PivotTable and Spreadsheet report features and capabilities, offers comprehensive coverage of web components, report automation, and data source access methods, and provides detailed documentation of the Microsoft Query Program. Sophisticated Microsoft Excel users, SQL Programmers, IT Professionals, and report developers will use this book to develop and analyze consistent custom reports. About the Author Timothy Zapawa obtained a baccalaureate in Accounting & Arabic from the University of Michigan in Ann Arbor in 1997. Prior to that, he served four years in the United States Navy in electronic communications. He has attained various certifications, including the Certified Publication Accountant (CPA), Certified Management Accountant (CMA), Certified in Financial Management (CFM), Project Manager Professional (PMP), Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Database Administrator (MCDBA). He is a project director at Advantage Computing Systems, Inc., www.advantagecs.com, a company that produces enterprise software for publishing companies and service bureaus. He leads teams of 12-24 engineers, developers and managers through 9-24 month software implementations. He has also developed several technical training courses on Crystal Reports, SQL query development for Oracle and SQL Server, and Excel PivotTable Reporting for his company’s clients. Table of Contents Acknowledgments Introduction Part I: Report Initiation and Source Data           o Taking a First Look at Excel’s Reporting Tools           o Getting Started with PivotTables           o Understanding and Accessing Source Data           o Using the Query Wizard           o Getting Started with Microsoft Query           o Working with SQL in Microsoft Query Part II: Advanced Reporting Features.           o Designing PivotTable Reports           o Managing PivotTable Data           o Exploring PivotChart Functionality           o Working with OLAP Cubes           o Creating and Using Spreadsheet Reports           o Using Excel Reports on the Web Part III: Appendixes           o Appendix A: Configuring Your System           o Appendix B: SQL Reference           o Index