Sinopsis
PivotTables enable you to extract meaning from large amounts of data. This description is deceptively simple because in fact PivotTables are powerful and sophisticated tools that enable you to do things that would be impossible or difficult to do any other way. A PivotTable enables you to take what seems to be an indecipherable mass of facts and extract any trends and patterns buried in the data. You can organize and summarize your data, perform comparisons, and extract meaningful information that can be invaluable to you and your organization.
Why the term pivot? It comes from an analogy between the way PivotTables work and the way you investigate a physical object. Imagine that you have been handed a complex device and asked to figure out what it does. You don’t just look at it from one angle; rather you turn it in your hands, examining it from all possible perspectives to be sure you do not miss any important clues. PivotTables work the same way, enabling you to turn or pivot the raw data and examine it from various perspectives to extract the information you need. Then you also have the option of creating a PivotChart, a graphical representation of the information in a PivotTable.
Content
- Part I: Understanding PivotTables and Charts
- Part II: Understanding Data Sources for PivotTables
- Part III: Using PivotTable Tools and Formatting
- Part: IV: Working with PivotTable Components
- Part V: More About PivotTable Components
- Part VI: Understanding and Using PivotCharts
- Part VII: Using PivotTables with Multidimensional Data
- Part VIII: Getting Hard Data from a PivotTable
- Part IX: PivotTable Alternatives
- Part X: Programming PivotTables with VBA
.jpg)
0 komentar:
Posting Komentar