Excel PivotTables and PivotCharts

Name: Excel PivotTables and PivotCharts | Your visual blueprint for creating dynamic spreadsheets
Brand: Visual
Price: 20.99 EUR
Availability: OnlineOnly

Your visual blueprint for creating dynamic spreadsheets

Paul McFedries(Autor*in)

Visual (Verlag)

2. Auflage

Erschienen am 24. Mai 2010

304 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-470-89255-8 (ISBN)

20,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Person

Inhalt

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 2nd Edition
Credits
About the Author
Author's Acknowledgments
How to Use This Visual Blueprint Book
TABLE OF CONTENTS
Chapter 1: UNDERSTANDING PIVOTTABLES AND PIVOTCHARTS
Understanding Data Analysis
Introducing the PivotTable
Learn PivotTable Benefits
Learn When to Use PivotTables
Explore PivotTable Features
Introducing the PivotChart
Chapter 2: BUILDING A PIVOTTABLE
Prepare Your Worksheet Data
Create a Table for a PivotTable Report
Build a PivotTable from an Excel Table
Build a PivotTable from an Excel Range
Recreate an Existing PivotTable
Chapter 3: MANIPULATING YOUR PIVOTTABLE
Turn the PivotTable Field List On and Off
Customize the PivotTable Field List
Select PivotTable Items
Remove a PivotTable Field
Refresh PivotTable Data
Display the Details Behind PivotTable Data
Create a Chart from PivotTable Data
Enable the Classic PivotTable Layout
Add Multiple Fields to the Row or Column Area
Add Multiple Fields to the Data Area
Add Multiple Fields to the Report Filter
Publish a PivotTable to a Web Page
Convert a PivotTable to Regular Data
Delete a PivotTable
Chapter 4: CHANGING THE PIVOTTABLE VIEW
Move a Field to a Different Area
Change the Order of Fields within an Area
Change the Report Layout
Sort PivotTable Data with AutoSort
Move Row and Column Items
Group Numeric Values
Group Date and Time Values
Group Text Values
Hide Group Details
Show Group Details
Ungroup Values
Chapter 5: FILTERING A PIVOTTABLE
Apply a Report Filter
Change the Report Filter Layout
Filter Row or Column Items
Filter PivotTable Values
Hide Items in a Row or Column Field
Use Search to Display Multiple Items
Show Hidden Items in a Row or Column Field
Filter a PivotTable with a Slicer
Connect a PivotTable to an Existing Slicer
Connect a Slicer to Multiple PivotTables
Chapter 6: CUSTOMIZING PIVOTTABLE FIELDS
Rename a PivotTable Field
Rename a PivotTable Item
Format a PivotTable Cell
Apply a Numeric Format to PivotTable Data
Apply a Date Format to PivotTable Data
Apply a Conditional Format to PivotTable Data
Show Items with No Data
Exclude Items from a Report Filter
Repeat Item Labels in Fields
Chapter 7: CREATING A PIVOTCHART
Understanding PivotChart Limitations
Create a PivotChart from a PivotTable
Create a PivotChart beside a PivotTable
Create a PivotChart from an Excel Table
Move a PivotChart to another Sheet
Filter a PivotChart
Change the PivotChart Type
Sort the PivotChart
Add PivotChart Titles
Move the PivotChart Legend
Display a Data Table with the PivotChart
Chapter 8: SETTING PIVOTTABLE OPTIONS
Apply a PivotTable Quick Style
Create a Custom PivotTable Quick Style
Preserve PivotTable Formatting
Rename the PivotTable
Turn Off Grand Totals
Merge Item Labels
Specify Characters for Errors and Empty Cells
Protect a PivotTable
Chapter 9: PERFORMING PIVOTTABLE CALCULATIONS
Change the PivotTable Summary Calculation
Create a Difference Summary Calculation
Create a Percentage Summary Calculation
Create a Running Total Summary Calculation
Create an Index Summary Calculation
Turn Off Subtotals for a Field
Display Multiple Subtotals for a Field
Chapter 10: CREATING CUSTOM PIVOTTABLE CALCULATIONS
Introducing Custom Calculations
Understanding Custom Calculation Limitations
Insert a Custom Calculated Field
Insert a Custom Calculated Item
Edit a Custom Calculation
Change the Solve Order of Calculated Items
List Your Custom Calculations
Delete a Custom Calculation
Chapter 11: BUILDING FORMULAS FOR PIVOTTABLES
Introducing Formulas
Understanding Formula Types
Introducing Worksheet Functions
Understanding Function Types
Build a Function
Build a Formula
Work with Custom Numeric and Date Formats
Chapter 12: USING MICROSOFT QUERY WITH PIVOTTABLES
Understanding Microsoft Query
Define a Data Source
Start Microsoft Query
Tour the Microsoft Query Window
Add a Table to the Query
Add Fields to the Query
Filter the Records with Query Criteria
Sort the Query Records
Return the Query Results
Chapter 13: IMPORTING DATA FOR PIVOTTABLES
Understanding External Data
Import Data from a Data Source
Import Data from an Access Table
Import Data from a Word Table
Import Data from a Text File
Import Data from a Web Page
Import Data from an XML File
Create a PowerPivot Data Connection
Refresh Imported Data
Chapter 14: BUILDING MORE ADVANCED PIVOTTABLES
Create a PivotTable from Multiple Consolidation Ranges
Create a PivotTable from an Existing PivotTable
Create a PivotTable from External Data
Create a PivotTable Using PowerPivot
Automatically Refresh a PivotTable that Uses External Data
Save Your Password with an External Data Connection
Export an Access PivotTable Form to Excel
Reduce the Size of PivotTable Workbooks
Use a PivotTable Value in a Formula
Chapter 15: BUILDING A PIVOTTABLE FROM AN OLAP CUBE
Understanding OLAP
Create an OLAP Cube Data Source
Create a PivotTable from an OLAP Cube
Show and Hide Details for Dimensions and Levels
Hide Levels
Display Selected Levels and Members
Display Multiple Report Filter Items
Include Hidden Items in PivotTable Totals
Performing What-if Analysis on the PivotTable
Create an Offline OLAP Cube
Chapter 16: LEARNING VBA BASICS FOR PIVOTTABLES
Open the VBA Editor
Add a Macro to a Module
Run a Macro
Set Macro Security
Assign a Shortcut Key to a Macro
APPENDIX: GLOSSARY OF PIVOTTABLE TERMS
INDEX

Inhalt (PDF)

Systemvoraussetzungen

Als PDF speichern Als Link merken