Quick notes on how to use pivot tables in excel

You know by now that Excel is a powerhouse when it comes to making calculations, and the ability to create a calculated field is something youРІР‚в„ўll definitely want to have in your toolbox when working with pivot tables.Р”Р„ calculated field allows you to keep a calculation running throughout a pivot table-similarly to how youРІР‚в„ўd have a formula plugged in a standard spreadsheet.

While getting the slicer established involves a little bit of work, it can save you tons of elbow grease down the road-particularly if youРІР‚в„ўre using a lot of different pivot tables. With that slicer setup, Jason can simply hit the button for 2016 to only see his data for that year in his pivot tables. To do so, right click on the slicer, select РІР‚СљReport Connections,РІР‚Сњ and then choose the pivot tables that should be connected to that slicer. Now, Jason needs to link his existing pivot tables to that slicer so that all the data is associated with that particular slicer.

I recommend positioning it on top of your pivot tables, so that you can look at everything in one glance.Р”В¤. Resize and move your slicer to where you want it to appear. Select the variable you want to sort your data by (in this case, itРІР‚в„ўs the year) and click РІР‚СљOK.РІР‚СњР”Р€. Head to РІР‚СљInsertРІР‚в„ў and then click the РІР‚СљSlicerРІР‚Сњ button. Instead of needing to change the year filter on both of those pivot tables, he could create a slicer for the year. He really wants to drill down and view beer sales by quarter and by size for only 2016. Right now, heРІР‚в„ўs looking at his data for both 20. LetРІР‚в„ўs say that Jason is looking at two different pivot tables: One that displays beer sales by quarter and one that displays beer sales by size. What exactly is a slicer? Put simply, itРІР‚в„ўs a way to link multiple pivot tables together so that you can filter your data for all of your pivot tables at once-rather than needing to change the filter on each of your individual pivot tables. While a slicer might sound synonymous with a rare form of torture, itРІР‚в„ўs actually an incredibly useful tool-and definitely something youРІР‚в„ўll want to be familiar with when youРІР‚в„ўre analyzing a lot of data.

Quick notes on how to use pivot tables in excel