Timothy Zapawa

Excel 2007 Advanced Report Development (eBook, PDF)

• Format: PDF

Produktbeschreibung

Create powerful, innovative reporting solutions with Excel 2007! With this new book, which is significantly updated from the bestselling Excel 2003 version, author Timothy Zapawa provides 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!

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 576
• Erscheinungstermin: 10. Juli 2007
• Englisch
• ISBN-13: 9780470148013
• Artikelnr.: 37290588

Autorenporträt

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.

Inhaltsangabe

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.