Excel PivotTables and PivotCharts,

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed
on two of Excel's most useful features. PivotTable and PivotChart
turn long lists of unreadable data into dynamic, easy-to-read
tables and charts that highlight the information you need most; you
can tweak results with a click or easily fuse data from several
sources into one document. Now you can learn how to tap these
powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow
screenshots, this book shows you in a visual way how to
create and customize PivotTables and PivotCharts, use them to
analyze business data, and ultimately achieve more with less
work.

• Explains the benefits PivotTables and PivotCharts, two powerful
  features of Excel that allow users to create dynamic
  spreadsheets

• Covers creating and customizing, analyzing business data,
  building custom calculations, linking to external data sources
  (including Access databases, Word tables, Web pages, XML data, SQL
  Server databases, and OLAP cubes), creating macros to automate
  tasks, and more

• Uses step-by-step tutorials and easy-to-follow screenshots, a
  "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you
need to ramp up your Excel skills with PivotTables and
PivotCharts.

Autorentext
Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991 and he has more than 70 books to his credit. Paul's books have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Excel 2010; Excel 2010 Visual Quick Tips; Teach Yourself VISUALLY Windows 7; and Teach Yourself VISUALLY Office 2008 for Mac. Paul is also the proprietor of Word Spy (www.wordspy.com and twitter.com/wordspy), a Web site that tracks new words and phrases as they enter the language. Paul invites you to drop by his personal Web site at www.mcfedries.com or to follow him on Twitter at twitter.com/paulmcf.

Zusammenfassung
Master two of the most powerful features of Excel Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

• Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets
• Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more
• Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners
  Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

Inhalt

How to Use This Book v

1 Understanding Pivottables and Pivotcharts 2

Understanding Data Analysis 2

Introducing the PivotTable 4

Learn PivotTable Benefits 6

Learn When to Use PivotTables 8

Explore PivotTable Features 10

Introducing the PivotChart 12

2 Building a Pivottable 14

Prepare Your Worksheet Data 14

Create a Table for a PivotTable Report 16

Build a PivotTable from an Excel Table 18

Build a PivotTable from an Excel Range 20

Recreate an Existing PivotTable 22

3 Manipulating Your Pivottable 24

Turn the PivotTable Field List On and Off 24

Customize the PivotTable Field List 25

Select PivotTable Items 26

Remove a PivotTable Field 28

Refresh PivotTable Data 30

Display the Details Behind PivotTable Data 32

Create a Chart from PivotTable Data 34

Enable the Classic PivotTable Layout 38

Add Multiple Fields to the Row or Column Area 40

Add Multiple Fields to the Data Area 42

Add Multiple Fields to the Report Filter 44

Publish a PivotTable to a Web Page 46

Convert a PivotTable to Regular Data 50

Delete a PivotTable 52

4 Changing the Pivottable View 54

Move a Field to a Different Area 54

Change the Order of Fields within an Area 56

Change the Report Layout 58

Sort PivotTable Data with AutoSort 60

Move Row and Column Items 62

Group Numeric Values 64

Group Date and Time Values 66

Group Text Values 68

Hide Group Details 70

Show Group Details 71

Ungroup Values 72

5 Filtering a Pivottable 74

Apply a Report Filter 74

Change the Report Filter Layout 76

Filter Row or Column Items 78

Filter PivotTable Values 80

Hide Items in a Row or Column Field 82

Use Search to Display Multiple Items 84

Show Hidden Items in a Row or Column Field 86

Filter a PivotTable with a Slicer 88

Connect a PivotTable to an Existing Slicer 90

Connect a Slicer to Multiple PivotTables 92

6 Customizing Pivottable Fields 94

Rename a PivotTable Field 94

Rename a PivotTable Item 96

Format a PivotTable Cell 98

Apply a Numeric Format to PivotTable Data 100

Apply a Date Format to PivotTable Data 102

Apply a Conditional Format to PivotTable Data 104

Show Items with No Data 106

Exclude Items from a Report Filter 108

Repeat Item Labels in Fields 110

7 Creating a Pivotchart 112

Understanding PivotChart Limitations 112

Create a PivotChart from a PivotTable 113

Create a PivotChart beside a PivotTable 114

Create a PivotChart from an Excel Table 116

Move a PivotChart to another Sheet 118

Filter a PivotChart 120

Change the PivotChart Type 122

Sort the PivotChart 124

Add PivotChart Titles 126

Move the PivotChart Legend 128

Display a Data Table with the PivotChart 130

8 Setting Pivottable Options 132

Apply a PivotTable Quick Style 132

Create a Custom PivotTable Quick Style 134

Preserve PivotTable Formatting 136

Rename the PivotTable 138

Turn Off Grand Totals 140

Merge Item Labels 142

Specify Characters for Errors and Empty Cells 144

Protect a PivotTable 146

9 Performing Pivottable Calculations 148

Change the PivotTable Summary Calculation 148

Create a Difference Summary Calculation 150

Create a Percentage Summary Calculation 152

Create a Running Total Summary Calculation 154

Create an Index Summary Calculation 156 Turn Off Subtotals...