Excel 2007 Advanced Report Development

Author:: Timothy Zapawa
Format:: Softcover

Now:	R357.95
eBucks:	eB3580

United Kingdom

Delivery time:: Usually within 15 working days.
Seller:: kalahari.com

E-mail

Email this product to a friend

Friend's email address

Your email address

Your name

Message (optional)

Cancel

Short description

* 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

Long description

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. This title offers readers useful information on PivotTable and spreadsheet report features and capabilities, parameter queries, Web components, report automation, and data source access methods.

Product details

Publisher:: John Wiley & Sons
ISBN:: 9780470046449
Publication date:: March 2007
Length:: 236mm
Width:: 190mm
Thickness:: 28mm
Weight:: 1002g
Pages:: 542
Illustrations:: Illustrated
Readership:: Research & professional

Acknowledgements.
Introduction.
1. Taking a First Look at Excel's Reporting Capabilities.
2. Getting Started with PivotTable Reports.
3. PivotTable Essentials and Components.
4. Working with External Data Sources.
5. Looking at the Get External Data Toolbar.
6. Retrieving External Data Using Microsoft Query.
7. Using the Query Wizard.
8. Getting Started with Microsoft Query.
9. Working with SQL in Microsoft Query.
10. Designing PivotTable Reports.
11. PivotTable Report Formatting.
12. Managing PivotTable Report Data.
13. Analyzing Data in a PivotChart.
14. Creating and Using Spreadsheet Reports.
15. Building Report Solutions.
16. Spreadsheet Report Formatting.
Appendix A. SQL Reference.
Appendix B. Popup Menus, Clicking Actions, and Toolbar Functions.
Index.