買這商品的人也買了...
-
$1,500$1,425 -
$299Pro SharePoint Solution Development: Combining .NET, SharePoint and Office 2007 (Paperback)
-
$1,180$1,121 -
$1,180$1,121 -
$299Facebook Application Development
-
$790$672 -
$2,530$2,404 -
$450$351 -
$490$441 -
$1,840$1,748 -
$550$468 -
$1,940$1,843 -
$454Git 權威指南
-
$860$774 -
$760$684 -
$650$507 -
$580$458 -
$590$502 -
$520$406 -
$400$312 -
$520$442 -
$520$411 -
$520$468 -
$540$427 -
$680$612
相關主題
商品描述
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
Table of Contents
About the Author.Acknowledgements.
Introduction.
Part I Report Basics.
Chapter 1 Taking a First Look at Excel's Reporting Tools.
Chapter 2 Getting Started with PivotTable Reports.
Chapter 3 PivotTable Essentials and Components.
Part II External Data.
Chapter 4 Working with External Data Sources.
Chapter 5 Looking at the Get External Data Tab.
Chapter 6 Retrieving External Data Using Microsoft Query.
Chapter 7 Using the Query Wizard.
Chapter 8 Getting Started with Microsoft Query.
Chapter 9 Working with SQL in Microsoft Query.
Part III PivotTable Reporting.
Chapter 10 Designing PivotTable Reports.
Chapter 11 PivotTable Report Formatting.
Chapter 12 Managing PivotTable Data.
Chapter 13 Analyzing Data in a PivotChart.
Part IV Spreadsheet Reporting.
Chapter 14 Creating and Using Spreadsheet Reports.
Chapter 15 Building Report Solutions.
Chapter 16 Spreadsheet ReportFormatting.
Part V Appendices.
Appendix A SQL Reference.
Appendix B Pop-Up Menus, Clicking Actions, and Toolbar Functions.
Index.