HomeCoursesExcelMicrosoft Excel Advanced Pivot Tables Basic PivotTable review 10 What is a PivotTable? Prepare your data Filtering data Formatting values PivotTable value field properties Produce multiple PivotTables PivotTable format and display Grouping date data Classic view Create PivotCharts PivotTable properties 7 Dynamic data ranges Use tables as data sources Dealing with zeros Data drill down Refresh PivotTable data Change the data source Move a PivotTable PivotTable views 5 Manually sort data Group fields Work with slicers Work with timelines Conditional Formatting Subtotals and summarising 2 Manipulate display of totals Advanced value field settings PivotTable calculations 4 Calculated fields Calculated field limitations Calculated items GETPIVOTDATA function PowerPivot 9 Install PowerPivot Activate PowerPivot Understand PowerPivot Import a text file into PowerPivot Copy data into PowerPivot Create a PivotTable from your data model Collect and link data Create relationships between data Create PivotCharts Create a dashboard with PowerPivot and Slicers 4 Collect and link data Create PivotCharts Create a slicer connected to multiple sources Link slicer values to cells Microsoft Excel Advanced Pivot Tables Back to Course Classic view Lesson content is empty. Prev Grouping date data Next Create PivotCharts Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website Save my name, email, and website in this browser for the next time I comment.