Read more
Informationen zum Autor 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. Klappentext Master two of the most powerful features of ExcelEven 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 learnersPractical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts. 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. Inhaltsverzeichnis 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 ...
