Excel Advanced Report Development

Timothy Zapawa

468 pages, parution le 18/08/2005

Ajouter à une liste

Indisponible

Résumé

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

L'auteur - 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).

Sommaire

Acknowledgments
Introduction
Report Initiation and Source Data
- Taking a First Look at Excel's Reporting Tools
- Getting Started with PivotTables
- Understanding and Accessing Source Data
- Using the Query Wizard
- Getting Started with Microsoft Query
- Working with SQL in Microsoft Query
Advanced Reporting Features
- Designing PivotTable Reports
- Managing PivotTable Data
- Exploring PivotChart Functionality
- Working with OLAP Cubes
- Creating and Using Spreadsheet Reports
- Using Excel Reports on the Web
Appendixes
- Appendix A: Configuring Your System
- Appendix B: SQL Reference
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Timothy Zapawa
Parution	18/08/2005
Nb. de pages	468
Format	18,5 x 23,5
Couverture	Broché
Poids	759g
Intérieur	Noir et Blanc
EAN13	9780764588112
ISBN13	978-0-7645-8811-2