Excel Advanced Report Development - Brossura

Zapawa, Timothy

 
9780764588112: Excel Advanced Report Development

Sinossi

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

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull?autore

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

Dalla quarta di copertina

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® 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

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.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Altre edizioni note dello stesso titolo

9788126506187: EXCEL ADVANCED REPORT DEVELOPMENT

Edizione in evidenza

ISBN 10:  8126506180 ISBN 13:  9788126506187
Casa editrice: Wiley India Pvt Ltd
Brossura