Excel 2007 Advanced Report Development

Timothy Zapawa

542 pages, parution le 20/04/2007

Ajouter à une liste

Indisponible

Résumé

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

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

Report Basics.
- Taking a First Look at Excel's Reporting Tools.
- Getting Started with PivotTable Reports.
- PivotTable Essentials and Components.
External Data.
- Working with External Data Sources.
- Looking at the Get External Data Tab.
- Retrieving External Data Using Microsoft Query.
- Using the Query Wizard.
- Getting Started with Microsoft Query.
- Working with SQL in Microsoft Query.
PivotTable Reporting.
- Designing PivotTable Reports.
- PivotTable Report Formatting.
- Managing PivotTable Data.
- Analyzing Data in a PivotChart.
Spreadsheet Reporting.
- Creating and Using Spreadsheet Reports.
- Building Report Solutions.
- Spreadsheet ReportFormatting.
Appendices.
- Appendix A SQL Reference.
- Appendix B Pop-Up Menus, Clicking Actions, and Toolbar Functions.

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Timothy Zapawa
Parution	20/04/2007
Nb. de pages	542
Format	19 x 23,5
Couverture	Broché
Poids	837g
Intérieur	Noir et Blanc
EAN13	9780470046449
ISBN13	978-0-470-04644-9