Filter data in a PivotTable

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac. Filter your data to hone in on a smaller segment of your PivotTable data for granular analysis. Initially, add one or multiple slicers for a fast and productive way toContinue reading “Filter data in a PivotTable”

Group or ungroup data in a PivotTable

Grouping data in a PivotTable can assist you with displaying a subset of data to analyse. For instance, you might want to group a monumental list of dates or times (date and time fields in the PivotTable) into quarters and months, similar to this image. Note:┬áThe time grouping feature is new in Excel 2016. WithContinue reading “Group or ungroup data in a PivotTable”