Dear customers, please be informed that our shopping cart will be unavailable between August 21 and September 1, 2014, as we will be making some changes to serve you better. To minimise any possible delivery disruption, we encourage you to make your purchases before August 21. We appreciate your understanding and apologise for any inconvenience.

Wiley
Wiley.com
Print this page Share

Excel Advanced Report Development

ISBN: 978-0-7645-8811-2
504 pages
July 2005
Excel Advanced Report Development (0764588117) cover image
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
See More
Acknowledgments.

Introduction.

Part I: Report Initiation and Source Data.

Chapter 1: Taking a First Look at Excel’s Reporting Tools.

Chapter 2: Getting Started with PivotTables.

Chapter 3: Understanding and Accessing Source Data.

Chapter 4: Using the Query Wizard.

Chapter 5: Getting Started with Microsoft Query.

Chapter 6: Working with SQL in Microsoft Query.

Part II: Advanced Reporting Features.

Chapter 7: Designing PivotTable Reports.

Chapter 8: Managing PivotTable Data.

Chapter 9: Exploring PivotChart Functionality.

Chapter 10: Working with OLAP Cubes.

Chapter 11: Creating and Using Spreadsheet Reports.

Chapter 12” Using Excel Reports on the Web.

Part III: Appendixes.

Appendix A: Configuring Your System.

Appendix B: SQL Reference.

Index.

See More
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).
See More
Download TitleSizeDownload
Download the prices.mht file 26.60 KB Click to Download
Download files for Chapter 2 4.93 KB Click to Download
Download files for Chapter 3 1.08 KB Click to Download
Download files for Chapter 5 644 bytes Click to Download
Download files for Chapter 6 652 bytes Click to Download
Download files for Chapter 7 962 bytes Click to Download
Download files for Chapter 8 748 bytes Click to Download
Download files for Chapter 9 921 bytes Click to Download
Download files for Chapter 10 1013 bytes Click to Download
Download files for Chapter 11 14.77 KB Click to Download
Download files for Chapter 12 79.21 KB Click to Download
Download files for Excel Reporting 105.82 KB Click to Download
Download files for Prices 2.88 KB Click to Download
Download all Video files in one zip file
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
32.65 MB Click to Download
Download the Chapter 02-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
1.78 MB Click to Download
Download the Chapter 02-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
3.09 MB Click to Download
Download the Chapter 03-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
2.23 MB Click to Download
Download the Chapter 03-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
4.85 MB Click to Download
Download the Chapter 03-03 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
3.01 MB Click to Download
Download the Chapter 03-04 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
5.37 MB Click to Download
Download the Chapter 04-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
5.48 MB Click to Download
Download the Chapter 05-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
5.20 MB Click to Download
Download the Chapter 06-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
4.28 MB Click to Download
Download the Chapter 07-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
1.87 MB Click to Download
Download the Chapter 07-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
2.94 MB Click to Download
Download the Chapter 07-03 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
7.45 MB Click to Download
Download the Chapter 08-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
3.49 MB Click to Download
Download the Chapter 08-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
4.97 MB Click to Download
Download the Chapter 09-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
4.60 MB Click to Download
Download the Chapter 10-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
4.24 MB Click to Download
Download the Chapter 10-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
5.81 MB Click to Download
Download the Chapter 11-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
2.32 MB Click to Download
Download the Chapter 11-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
2.85 MB Click to Download
Download the Chapter 12-01 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
3.86 MB Click to Download
Download the Chapter 12-02 video
To view the video files you may need to download the Windows Media Player plug-ins at http://www.wmplugins.com/ItemDetail.aspx?codec=tscc.
2.29 MB Click to Download
See More
Buy Both and Save 25%!
+

Excel Advanced Report Development (US $39.99)

-and- Excel 2010 For Dummies Quick Reference (US $18.99)

Total List Price: US $58.98
Discounted Price: US $44.23 (Save: US $14.75)

Buy Both
Cannot be combined with any other offers. Learn more.

Related Titles

Back to Top