![Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers) 12-copy-paste-pivot-table-slicer](https://i0.wp.com/www.thekeycuts.com/wp-content/uploads/2022/08/12-copy-paste-pivot-table-slicer-787x300.png)
Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers)
I used to create a monthly 30-slide report and each slide had a different table or chart that I copied and pasted from Excel. As a naive analyst, I literally filtered my list of data using regular dropdown filters on each column to get the numbers I needed. I would filter, sum or average the […]