{"product_id":"excel-pivottables-and-pivotcharts-isbn-9780470591611","title":"Excel PivotTables and PivotCharts","description":"\u003cb\u003eMaster two of the most powerful features of Excel\u003c\/b\u003e  \u003cp\u003eEven 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.\u003c\/p\u003e \u003cp\u003eUsing a series of step-by-step tutorials and easy-to-follow screenshots, this book \u003ci\u003eshows\u003c\/i\u003e 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eExplains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets\u003c\/li\u003e \u003cli\u003eCovers 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\u003c\/li\u003e \u003cli\u003eUses step-by-step tutorials and easy-to-follow screenshots, a \"learn by seeing\" approach for visual learners\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003ePractical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.\u003c\/p\u003e \u003cp\u003eHow to Use This Book v\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Understanding Pivottables and Pivotcharts 2\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Data Analysis 2\u003c\/p\u003e \u003cp\u003eIntroducing the PivotTable 4\u003c\/p\u003e \u003cp\u003eLearn PivotTable Benefits 6\u003c\/p\u003e \u003cp\u003eLearn When to Use PivotTables 8\u003c\/p\u003e \u003cp\u003eExplore PivotTable Features 10\u003c\/p\u003e \u003cp\u003eIntroducing the PivotChart 12\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Building a Pivottable 14\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePrepare Your Worksheet Data 14\u003c\/p\u003e \u003cp\u003eCreate a Table for a PivotTable Report 16\u003c\/p\u003e \u003cp\u003eBuild a PivotTable from an Excel Table 18\u003c\/p\u003e \u003cp\u003eBuild a PivotTable from an Excel Range 20\u003c\/p\u003e \u003cp\u003eRecreate an Existing PivotTable 22\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Manipulating Your Pivottable 24\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTurn the PivotTable Field List On and Off 24\u003c\/p\u003e \u003cp\u003eCustomize the PivotTable Field List 25\u003c\/p\u003e \u003cp\u003eSelect PivotTable Items 26\u003c\/p\u003e \u003cp\u003eRemove a PivotTable Field 28\u003c\/p\u003e \u003cp\u003eRefresh PivotTable Data 30\u003c\/p\u003e \u003cp\u003eDisplay the Details Behind PivotTable Data 32\u003c\/p\u003e \u003cp\u003eCreate a Chart from PivotTable Data 34\u003c\/p\u003e \u003cp\u003eEnable the Classic PivotTable Layout 38\u003c\/p\u003e \u003cp\u003eAdd Multiple Fields to the Row or Column Area 40\u003c\/p\u003e \u003cp\u003eAdd Multiple Fields to the Data Area 42\u003c\/p\u003e \u003cp\u003eAdd Multiple Fields to the Report Filter 44\u003c\/p\u003e \u003cp\u003ePublish a PivotTable to a Web Page 46\u003c\/p\u003e \u003cp\u003eConvert a PivotTable to Regular Data 50\u003c\/p\u003e \u003cp\u003eDelete a PivotTable 52\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Changing the Pivottable View 54\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMove a Field to a Different Area 54\u003c\/p\u003e \u003cp\u003eChange the Order of Fields within an Area 56\u003c\/p\u003e \u003cp\u003eChange the Report Layout 58\u003c\/p\u003e \u003cp\u003eSort PivotTable Data with AutoSort 60\u003c\/p\u003e \u003cp\u003eMove Row and Column Items 62\u003c\/p\u003e \u003cp\u003eGroup Numeric Values 64\u003c\/p\u003e \u003cp\u003eGroup Date and Time Values 66\u003c\/p\u003e \u003cp\u003eGroup Text Values 68\u003c\/p\u003e \u003cp\u003eHide Group Details 70\u003c\/p\u003e \u003cp\u003eShow Group Details 71\u003c\/p\u003e \u003cp\u003eUngroup Values 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Filtering a Pivottable 74\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eApply a Report Filter 74\u003c\/p\u003e \u003cp\u003eChange the Report Filter Layout 76\u003c\/p\u003e \u003cp\u003eFilter Row or Column Items 78\u003c\/p\u003e \u003cp\u003eFilter PivotTable Values 80\u003c\/p\u003e \u003cp\u003eHide Items in a Row or Column Field 82\u003c\/p\u003e \u003cp\u003eUse Search to Display Multiple Items 84\u003c\/p\u003e \u003cp\u003eShow Hidden Items in a Row or Column Field 86\u003c\/p\u003e \u003cp\u003eFilter a PivotTable with a Slicer 88\u003c\/p\u003e \u003cp\u003eConnect a PivotTable to an Existing Slicer 90\u003c\/p\u003e \u003cp\u003eConnect a Slicer to Multiple PivotTables 92\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Customizing Pivottable Fields 94\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRename a PivotTable Field 94\u003c\/p\u003e \u003cp\u003eRename a PivotTable Item 96\u003c\/p\u003e \u003cp\u003eFormat a PivotTable Cell 98\u003c\/p\u003e \u003cp\u003eApply a Numeric Format to PivotTable Data 100\u003c\/p\u003e \u003cp\u003eApply a Date Format to PivotTable Data 102\u003c\/p\u003e \u003cp\u003eApply a Conditional Format to PivotTable Data 104\u003c\/p\u003e \u003cp\u003eShow Items with No Data 106\u003c\/p\u003e \u003cp\u003eExclude Items from a Report Filter 108\u003c\/p\u003e \u003cp\u003eRepeat Item Labels in Fields 110\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Creating a Pivotchart 112\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding PivotChart Limitations 112\u003c\/p\u003e \u003cp\u003eCreate a PivotChart from a PivotTable 113\u003c\/p\u003e \u003cp\u003eCreate a PivotChart beside a PivotTable 114\u003c\/p\u003e \u003cp\u003eCreate a PivotChart from an Excel Table 116\u003c\/p\u003e \u003cp\u003eMove a PivotChart to another Sheet 118\u003c\/p\u003e \u003cp\u003eFilter a PivotChart 120\u003c\/p\u003e \u003cp\u003eChange the PivotChart Type 122\u003c\/p\u003e \u003cp\u003eSort the PivotChart 124\u003c\/p\u003e \u003cp\u003eAdd PivotChart Titles 126\u003c\/p\u003e \u003cp\u003eMove the PivotChart Legend 128\u003c\/p\u003e \u003cp\u003eDisplay a Data Table with the PivotChart 130\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Setting Pivottable Options 132\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eApply a PivotTable Quick Style 132\u003c\/p\u003e \u003cp\u003eCreate a Custom PivotTable Quick Style 134\u003c\/p\u003e \u003cp\u003ePreserve PivotTable Formatting 136\u003c\/p\u003e \u003cp\u003eRename the PivotTable 138\u003c\/p\u003e \u003cp\u003eTurn Off Grand Totals 140\u003c\/p\u003e \u003cp\u003eMerge Item Labels 142\u003c\/p\u003e \u003cp\u003eSpecify Characters for Errors and Empty Cells 144\u003c\/p\u003e \u003cp\u003eProtect a PivotTable 146\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Performing Pivottable Calculations 148\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChange the PivotTable Summary Calculation 148\u003c\/p\u003e \u003cp\u003eCreate a Difference Summary Calculation 150\u003c\/p\u003e \u003cp\u003eCreate a Percentage Summary Calculation 152\u003c\/p\u003e \u003cp\u003eCreate a Running Total Summary Calculation 154\u003c\/p\u003e \u003cp\u003eCreate an Index Summary Calculation 156\u003c\/p\u003e \u003cp\u003eTurn Off Subtotals for a Field 158\u003c\/p\u003e \u003cp\u003eDisplay Multiple Subtotals for a Field 160\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Creating Custom Pivottable Calculations 162\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Custom Calculations 162\u003c\/p\u003e \u003cp\u003eUnderstanding Custom Calculation Limitations 163\u003c\/p\u003e \u003cp\u003eInsert a Custom Calculated Field 164\u003c\/p\u003e \u003cp\u003eInsert a Custom Calculated Item 166\u003c\/p\u003e \u003cp\u003eEdit a Custom Calculation 168\u003c\/p\u003e \u003cp\u003eChange the Solve Order of Calculated Items 170\u003c\/p\u003e \u003cp\u003eList Your Custom Calculations 172\u003c\/p\u003e \u003cp\u003eDelete a Custom Calculation 173\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Building Formulas for Pivottables 174\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Formulas 174\u003c\/p\u003e \u003cp\u003eUnderstanding Formula Types 176\u003c\/p\u003e \u003cp\u003eIntroducing Worksheet Functions 178\u003c\/p\u003e \u003cp\u003eUnderstanding Function Types 180\u003c\/p\u003e \u003cp\u003eBuild a Function 182\u003c\/p\u003e \u003cp\u003eBuild a Formula 184\u003c\/p\u003e \u003cp\u003eWork with Custom Numeric and Date Formats 186\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Using Microsoft Query with Pivottables 188\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Microsoft Query 188\u003c\/p\u003e \u003cp\u003eDefine a Data Source 190\u003c\/p\u003e \u003cp\u003eStart Microsoft Query 194\u003c\/p\u003e \u003cp\u003eTour the Microsoft Query Window 195\u003c\/p\u003e \u003cp\u003eAdd a Table to the Query 196\u003c\/p\u003e \u003cp\u003eAdd Fields to the Query 198\u003c\/p\u003e \u003cp\u003eFilter the Records with Query Criteria 200\u003c\/p\u003e \u003cp\u003eSort the Query Records 202\u003c\/p\u003e \u003cp\u003eReturn the Query Results 204\u003c\/p\u003e \u003cp\u003e\u003cb\u003e13 Importing Data for Pivottables 206\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding External Data 206\u003c\/p\u003e \u003cp\u003eImport Data from a Data Source 208\u003c\/p\u003e \u003cp\u003eImport Data from an Access Table 210\u003c\/p\u003e \u003cp\u003eImport Data from a Word Table 212\u003c\/p\u003e \u003cp\u003eImport Data from a Text File 214\u003c\/p\u003e \u003cp\u003eImport Data from a Web Page 218\u003c\/p\u003e \u003cp\u003eImport Data from an XML File 220\u003c\/p\u003e \u003cp\u003eCreate a PowerPivot Data Connection 222\u003c\/p\u003e \u003cp\u003eRefresh Imported Data 224\u003c\/p\u003e \u003cp\u003e\u003cb\u003e14 Building More Advanced Pivottables 226\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreate a PivotTable from Multiple Consolidation Ranges 226\u003c\/p\u003e \u003cp\u003eCreate a PivotTable from an Existing PivotTable 230\u003c\/p\u003e \u003cp\u003eCreate a PivotTable from External Data 232\u003c\/p\u003e \u003cp\u003eCreate a PivotTable Using PowerPivot 236\u003c\/p\u003e \u003cp\u003eAutomatically Refresh a PivotTable that Uses External Data 238\u003c\/p\u003e \u003cp\u003eSave Your Password with an External Data Connection 240\u003c\/p\u003e \u003cp\u003eExport an Access PivotTable Form to Excel 242\u003c\/p\u003e \u003cp\u003eReduce the Size of PivotTable Workbooks 244\u003c\/p\u003e \u003cp\u003eUse a PivotTable Value in a Formula 245\u003c\/p\u003e \u003cp\u003e\u003cb\u003e15 Building a Pivottable From An Olap Cube 246\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding OLAP 246\u003c\/p\u003e \u003cp\u003eCreate an OLAP Cube Data Source 248\u003c\/p\u003e \u003cp\u003eCreate a PivotTable from an OLAP Cube 252\u003c\/p\u003e \u003cp\u003eShow and Hide Details for Dimensions and Levels 254\u003c\/p\u003e \u003cp\u003eHide Levels 256\u003c\/p\u003e \u003cp\u003eDisplay Selected Levels and Members 257\u003c\/p\u003e \u003cp\u003eDisplay Multiple Report Filter Items 258\u003c\/p\u003e \u003cp\u003eInclude Hidden Items in PivotTable Totals 260\u003c\/p\u003e \u003cp\u003ePerforming What-if Analysis on the PivotTable 262\u003c\/p\u003e \u003cp\u003eCreate an Offline OLAP Cube 264\u003c\/p\u003e \u003cp\u003e\u003cb\u003e16 Learning Vba Basics for Pivottables 268\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOpen the VBA Editor 268\u003c\/p\u003e \u003cp\u003eAdd a Macro to a Module 270\u003c\/p\u003e \u003cp\u003eRun a Macro 272\u003c\/p\u003e \u003cp\u003eSet Macro Security 274\u003c\/p\u003e \u003cp\u003eAssign a Shortcut Key to a Macro 278\u003c\/p\u003e \u003cp\u003eAppendix: Glossary of Pivottable Terms 280\u003c\/p\u003e \u003cb\u003ePaul McFedries\u003c\/b\u003e 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 \u003ci\u003eTeach Yourself VISUALLY Excel 2010; Excel 2010 Visual Quick Tips; Teach Yourself VISUALLY Windows 7;\u003c\/i\u003e and \u003ci\u003eTeach Yourself VISUALLY Office 2008 for Mac\u003c\/i\u003e. 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.  \u003cp\u003eWelcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 135 key techniques with Excel PivotTables and PivotCharts, including:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eCreating a table for a PivotTable report\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eConverting a PivotTable to regular data\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eChanging the Report Filter layout\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eFormatting PivotTable cells\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eDisplaying a data table with a PivotChart\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003ePerforming PivotTable calculations\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eBuilding formulas for PivotTables\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eFiltering records with Query criteria\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eCreating an OLAP cube data source\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eLearning VBA basics for PivotTables\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eHigh-resolution screen shots demonstrate each task\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eSuccinct explanations walk you through step by step\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTwo-page lessons break big topics into bite-sized modules\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003e\"Apply It\" and \"Extra\" sidebars highlight useful tips\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e","brand":"Visual","offers":[{"title":"Default Title","offer_id":47989182169317,"sku":"NP9780470591611","price":29.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470591611.jpg?v=1761783118","url":"https:\/\/k12savings.com\/products\/excel-pivottables-and-pivotcharts-isbn-9780470591611","provider":"K12savings","version":"1.0","type":"link"}