{"product_id":"excel-365-pivot-tables-charts-a-quickstudy-laminated-reference-guide-9781423246169","title":"Excel 365 - Pivot Tables \u0026 Charts: A Quickstudy Laminated Reference Guide","description":"Quick and easy 6-page laminated guide focuses on creating and using pivot tables efficiently and effectively in Excel. Whether you are a beginner or experienced user, pivot tables offer flexibility while doubling down on Excel's power. Curtis Frye, author of multiple books on Excel, creator of many LinkedIn Learning videos and an experienced corporate trainer uses his experience and knowledge to cover the most relevant use of pivot tables at different levels of complexity. As a corporate trainer, seeing what beginners need to start using pivot tables and what those with some pivot table skills can do to harness more power brings value to this targeted reference at an unbeatable price. Look for Excel 365 and Excel 365 Tips and Tricks QuickStudy guides to have a solid power-user reference set. \u003cbr\u003e Introducing PivotTables \u003cul\u003e\n\u003cli\u003eGlossary\u003c\/li\u003e\n\u003cli\u003eCreating \u0026amp; Pivoting PivotTables \u003cul\u003e\n\u003cli\u003eArrange Data for Use in a PivotTable\u003c\/li\u003e\n\u003cli\u003eCreate a PivotTable from an Excel Table, Data List or from External Data\u003c\/li\u003e\n\u003cli\u003eCreate a Recommended PivotTable\u003c\/li\u003e\n\u003cli\u003eRefresh PivotTable Data, Update Cell References that Provide Data to a PivotTable\u003c\/li\u003e\n\u003cli\u003ePivot a PivotTable, Defer PivotTable Updates\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eManaging PivotTables \u003cul\u003e\n\u003cli\u003eShow or Hide the Field List, Expand \u0026amp; Contract Buttons, Field Headers\u003c\/li\u003e\n\u003cli\u003eSelect an Entire PivotTable, Move it, Copy a Configuration, Delete a PivotTable\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eSummarizing PivotTable Data \u003cul\u003e\n\u003cli\u003eShow or Hide Subtotals, Grand Totals\u003c\/li\u003e\n\u003cli\u003eChange the Data Field Summary Operation\u003c\/li\u003e\n\u003cli\u003eChange How PivotTable Data Values Are Displayed\u003c\/li\u003e\n\u003cli\u003eSummarize More than One Data Field\u003c\/li\u003e\n\u003cli\u003eCreate, Edit, Delete a Calculated Field\u003c\/li\u003e\n\u003cli\u003eUse PivotTable Data in a Formula\u003c\/li\u003e\n\u003cli\u003eDisplay Data Source Rows\u003c\/li\u003e\n\u003cli\u003eCreate an Excel table from a PivotTable\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eSorting \u0026amp; Filtering PivotTable Data \u003cul\u003e\n\u003cli\u003eSort a Column of PivotTable Data into Ascending or Descending Order\u003c\/li\u003e\n\u003cli\u003eCustom Lists\u003c\/li\u003e\n\u003cli\u003eFilter a PivotTable Field by Selection, Rule, Using a Search Filter\u003c\/li\u003e\n\u003cli\u003eSlicers\u003c\/li\u003e\n\u003cli\u003eFilter a PivotTable Using Report Filter Fields\u003c\/li\u003e\n\u003cli\u003eCreate Individual PivotTables Using Report Filter Values\u003c\/li\u003e\n\u003cli\u003eClear a PivotTable Filter Using the Field List Pane\u003c\/li\u003e\n\u003cli\u003eClear a Filter Using the Row or Column Labels, Clear All Filters\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eDefining Sets of Values \u003cul\u003e\n\u003cli\u003eDefine a Set Based on Row Items, on Column Items\u003c\/li\u003e\n\u003cli\u003eDisplay a Set in the Rows or Columns Area\u003c\/li\u003e\n\u003cli\u003eEdit a Set, Delete a Set\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eFormatting PivotTables \u003cul\u003e\n\u003cli\u003eApply a PivotTable Style\u003c\/li\u003e\n\u003cli\u003eApply a PivotTable Style \u0026amp; Remove Existing Formatting\u003c\/li\u003e\n\u003cli\u003eApply or Remove Headers \u0026amp; Banding\u003c\/li\u003e\n\u003cli\u003eCreate a PivotTable Style\u003c\/li\u003e\n\u003cli\u003eApply a Custom PivotTable Style\u003c\/li\u003e\n\u003cli\u003eChange the Data Field Number Format\u003c\/li\u003e\n\u003cli\u003eChange the PivotTable Layout\u003c\/li\u003e\n\u003cli\u003eControl Whether PivotTable Lables Are Repeated at the Top of Each Printed Page\u003c\/li\u003e\n\u003cli\u003eDetermine How to Handle Blank Rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eCreating \u0026amp; Manipulating PivotCharts \u003cul\u003e\n\u003cli\u003eCreate a New PivotChart\/from an Existing PivotTable\u003c\/li\u003e\n\u003cli\u003ePivot a PivotChart\u003c\/li\u003e\n\u003cli\u003eFilter a PivotChart by Selection\/by Rule\u003c\/li\u003e\n\u003cli\u003eApply a Style to a PivotChart\u003c\/li\u003e\n\u003cli\u003eChange a PivotChart's Layout\/Chart Type\u003c\/li\u003e\n\u003cli\u003eAdd a Trendline to a PivotChart\u003c\/li\u003e\n\u003cli\u003eMove a PivotChart to Another Worksheet\/to a Chart Sheet\u003c\/li\u003e\n\u003cli\u003eApply a Quick Layout to a PivotChart\u003c\/li\u003e\n\u003cli\u003eAdd or Remove a PivotChart Element\u003c\/li\u003e\n\u003cli\u003eApply a PivotChart Style, Change the Color Scheme\u003c\/li\u003e\n\u003cli\u003eFormat a PivotChart Data Series, Format One Value in a PivotChart Data Series\u003c\/li\u003e\n\u003cli\u003eAdd an Annotation to a PivotChart, Format a PivotChart Annotation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003ePrinting PivotTables \u003cul\u003e\n\u003cli\u003ePrint a PivotTable, Print Headers at the Top of Each Printed Page\u003c\/li\u003e\n\u003cli\u003ePrint Each Item on Its Own Page, Print a PivotChart\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eEnabling \u0026amp; Adding Tables to the Data Model \u003cul\u003e\n\u003cli\u003eCreate a Relationship between Two Tables\u003c\/li\u003e\n\u003cli\u003eCreate a PivotTable Using the Data Model\u003c\/li\u003e\n\u003cli\u003eWork with a PivotTable Created Using the Data Model\u003c\/li\u003e\n\u003cli\u003eEdit a Table Relationship, Deactivate, Activate, Delete a Relationship\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eFiltering PivotTables Using Timelines \u003cul\u003e\n\u003cli\u003eCreate a Timeline\u003c\/li\u003e\n\u003cli\u003eFilter a PivotTable Using a Timeline\u003c\/li\u003e\n\u003cli\u003eFormat a Timeline\u003c\/li\u003e\n\u003cli\u003eClear a Timeline Filter\u003c\/li\u003e\n\u003cli\u003eRemove a Timeline\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e","brand":"Quickstudy Reference Guides","offers":[{"title":"Default Title","offer_id":50621106585874,"sku":"9781423246169","price":5.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_30631582-72d5-42c7-8900-ddc5d7ebc836.jpg?v=1732581449","url":"https:\/\/surprise-castle.myshopify.com\/products\/excel-365-pivot-tables-charts-a-quickstudy-laminated-reference-guide-9781423246169","provider":"Surprise Castle","version":"1.0","type":"link"}