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 Understand PowerPivot Lesson content is empty. Prev Activate PowerPivot Next Import a text file into PowerPivot 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.