Excel Advanced Reporting Bible

Author: Zapaeva (USA)
Publisher:
Publish Date: 2006-01-01
Features: Comprehensive learning of techniques and strategies for Excel report development. Master the tools and methods for accessing data sources in Excel report development. Practical examples validate the core features of Excel report technology—data pivot tables, spreadsheet reports, parameter queries, and Web components, etc. The value of this book lies in treating advanced Excel report issues as a dedicated topic for concentrated discussion in one volume. The topics are naturally focused, and the content is certainly detailed and in-depth, offering readers who are confused about using Excel reports a sudden breakthrough in understanding. This book focuses on all aspects of Excel report development. It primarily introduces the features, application scenarios, and development processes of the most commonly used Excel report tools such as data pivot tables, spreadsheet reports, parameter queries, and Web components. It also provides detailed discussions on the tools used for Excel report development, including the use of SQL query language, how to use queries in the Microsoft Query program, and other Microsoft programs related to Excel report development. The book places significant emphasis on accessing external data sources, with particular attention to report development using OLTP data sources, exploring them in depth from all angles. For each topic, the book provides corresponding examples and explains the implementation process step by step, which not only enhances readers' skills but also boosts their confidence in using Excel report features. Additionally, the book's Web site offers video files for many examples, allowing readers to fully understand each step through video demonstrations.