CHF20.00
Download est disponible immédiatement
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.
Auteur
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.
Résumé
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.
Contenu
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...