Excel 2007 Advanced Report Development / Microsoft Access 2007 Data Analysis - Couverture souple

Zapawa, Timothy

Couverture souple

ISBN 10 : 0470190922 ISBN 13 : 9780470190920

Editeur : John Wiley & Sons, 2007

Synopsis

* Filling the void in the market for comprehensive coverage on all things Microsoft Excel 2007 report development-related, this book addresses the technical and strategic angles of developing reporting solutions using Microsoft Excel 2007 * Each chapter includes real-world examples of effective reports and demonstrates how this technology is used in various organizations * Offers readers useful information on PivotTable and spreadsheet report features and capabilities, parameter queries, Web components, report automation, and data source access methods --This text refers to the Paperback edition.

A propos du livre

Quatrième de couverture

Create powerful, innovative reporting solutions with Excel 2007

In this new book, significantly updated from his bestselling Excel 2003 version, Timothy Zapawa has provided you with in–depth coverage of Excel 2007′s enhanced reporting capabilities. Discover what you can do with PivotTable and Spreadsheet reports, enhanced conditional formatting and filtering functions, improved data access and management tools, and expanded OLAP features. With notes, tips, warnings, real–world examples, and how–to videos in every chapter, you′ll soon be an expert on Excel report development!

• Understand and use key features of PivotTable® and Spreadsheet reports

• Access data from SQL and Oracle databases, Web sites, OLAP cubes, and text files

• Build sophisticated SQL queries using the Microsoft Query program

• Link several Excel reports together to develop a larger, automated report solution

• Discover the enhanced Excel 2007 tools for filtering, sorting, and grouping data

Companion Web site
At www.wiley.com/go/excelreporting/2007, you′ll find sample query files and report examples you can download, up–to–the–minute materials on Online Data Processing, and video walkthroughs of steps explained in the book.

Biographie de l'auteur

Timothy Zapawa is a Project Director at AdvantageComputing Systems in Ann Arbor, Michigan, where he manages implementation projects of enterprise software systems for book and magazine publishers around the world. He holds several professional and technical certifications and has developed training courses on delivering business intelligence, building report solutions, and developing SQL queries and programs in SQL and Oracle databases.

Détails de l'édition

• Éditeur: John Wiley & Sons
• Date d'édition: 2007
• ISBN 10: 0470190922
• ISBN 13: 9780470190920
• Reliure: Broché
• Langue: anglais
• Nombre de pages: 2
• Coordonnées du fabricant: non disponible