Excel 2007 PivotTables and PivotCharts

Peter G. Aitken (Autor)

Buch | Softcover

312 Seiten

2007
John Wiley & Sons Ltd (Verlag)
978-0-470-10487-3 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You'll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and-most importantly-you'll discover what these tools can do for you.

Peter G. Aitken has written some 45 books and hundreds of articles on computer topics. His consulting firm, PGA Consulting, focuses on services involving Excel, including programming, custom templates, and troubleshooting. Peter is the coauthor of Excel 2007 Formulas and Functions For Dummies (Wiley). John Walkenbach, Series Editor, has written more than 30 Excel books, including Excel 2007 VBA Programming For Dummies and Excel 2007 Bible, also from Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.

Introduction. Part I: PivotTable Fundamentals. Chapter 1: Understanding PivotTables and Charts. Chapter 2: Understanding Data Sources for PivotTables. Chapter 3: Using PivotTable Tools and Formatting. Part II: PivotTables and Charts: Going Beyond the Basics. Chapter 4: Working with PivotTable Components. Chapter 5: More About PivotTable Components. Chapter 6: Understanding and Using PivotCharts. Part III: Getting the Most out of PivotTables and Charts. Chapter 7: Using PivotTables with Multidimensional Data. Chapter 8: Getting Hard Data from a PivotTable. Chapter 9: PivotTable Alternatives. Chapter 10: Programming PivotTables with VBA. Appendix A: Troubleshooting PivotTables and PivotCharts. Appendix B: Excel Version Differences for PivotTables. Appendix C: An Excel Chart Primer. Index.

Erscheint lt. Verlag	10.4.2007
Reihe/Serie	Mr. Spreadsheet's Bookshelf ; Vol.1
Zusatzinfo	Illustrations
Verlagsort	Chichester
Sprache	englisch
Maße	187 x 232 mm
Gewicht	476 g
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	0-470-10487-2 / 0470104872
ISBN-13	978-0-470-10487-3 / 9780470104873
Zustand	Neuware