Excel 365 - Pivot Tables & Charts (eBook)

Quick and easy 6-page digital 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 Excels 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. 6 page digital guide includes: Introducing PivotTables GlossaryCreating & Pivoting PivotTables Arrange Data for Use in a PivotTableCreate a PivotTable from an Excel Table, Data List or from External DataCreate a Recommended PivotTableRefresh PivotTable Data, Update Cell References that Provide Data to a PivotTablePivot a PivotTable, Defer PivotTable UpdatesManaging PivotTables Show or Hide the Field List, Expand & Contract Buttons, Field HeadersSelect an Entire PivotTable, Move it, Copy a Configuration, Delete a PivotTableSummarizing PivotTable Data Show or Hide Subtotals, Grand TotalsChange the Data Field Summary OperationChange How PivotTable Data Values Are DisplayedSummarize More than One Data FieldCreate, Edit, Delete a Calculated FieldUse PivotTable Data in a FormulaDisplay Data Source RowsCreate an Excel table from a PivotTableSorting & Filtering PivotTable Data Sort a Column of PivotTable Data into Ascending or Descending OrderCustom ListsFilter a PivotTable Field by Selection, Rule, Using a Search FilterSlicersFilter a PivotTable Using Report Filter FieldsCreate Individual PivotTables Using Report Filter ValuesClear a PivotTable Filter Using the Field List PaneClear a Filter Using the Row or Column Labels, Clear All FiltersDefining Sets of Values Define a Set Based on Row Items, on Column ItemsDisplay a Set in the Rows or Columns AreaEdit a Set, Delete a SetFormatting PivotTables Apply a PivotTable StyleApply a PivotTable Style & Remove Existing FormattingApply or Remove Headers & BandingCreate a PivotTable StyleApply a Custom PivotTable StyleChange the Data Field Number FormatChange the PivotTable LayoutControl Whether PivotTable Lables Are Repeated at the Top of Each Printed PageDetermine How to Handle Blank RowsCreating & Manipulating PivotCharts Create a New PivotChart/from an Existing PivotTablePivot a PivotChartFilter a PivotChart by Selection/by RuleApply a Style to a PivotChartChange a PivotChart's Layout/Chart TypeAdd a Trendline to a PivotChartMove a PivotChart to Another Worksheet/to a Chart SheetApply a Quick Layout to a PivotChartAdd or Remove a PivotChart ElementApply a PivotChart Style, Change the Color SchemeFormat a PivotChart Data Series, Format One Value in a PivotChart Data SeriesAdd an Annotation to a PivotChart, Format a PivotChart AnnotationPrinting PivotTables Print a PivotTable, Print Headers at the Top of Each Printed PagePrint Each Item on Its Own Page, Print a PivotChartEnabling & Adding Tables to the Data Model Create a Relationship between Two TablesCreate a PivotTable Using the Data ModelWork with a PivotTable Created Using the Data ModelEdit a Table Relationship, Deactivate, Activate, Delete a RelationshipFiltering PivotTables Using Timelines Create a TimelineFilter a PivotTable Using a TimelineFormat a TimelineClear a Timeline FilterRemove a Timeline