Aitken P.G. - Excel 2007 PivotTables and PivotCharts [2007, PDF, ENG] torrent

Книги и журналы » Компьютерная литература » Программы от Microsoft

Excel 2007 PivotTables and PivotCharts

Год: 2007
Автор: Peter G. Aitken
Язык: Английский
Издательство: Wiley
ISBN: 978-0-470-10487-3
Формат: PDF
Качество: eBook (изначально компьютерное)
Количество страниц: 300
Описание: 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.

С примерами. These are the workbook files you will need to complete many of the book's exercises.
[spoiler="Оглавление"]
Table of Contents
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.
[/spoiler]
[spoiler="Примеры страниц"]

[/spoiler]