Pivot tables in Excel have not undergone many changes. However, now you have a brand new feature at your disposal called Slicer, and in this lesson I’ll show you how to use it.

As you can see, this example includes two worksheets. The first contains the original data, while the second contains the table itself. Since I have already selected the appropriate element, options will be displayed on the screen that allow me to work with Pivot tables. This means that I can immediately go to the Insert section and click on the Slicer button. This function serves to filter data according to any of the displayed criteria. I will select the first two – Region and Month and click on the OK button. At that moment, two new frames will appear on the screen, and I will immediately place them below the table. Now I can change their appearance by choosing one of the offered options, which means a new color and other characteristics.

Using these filters is very simple. It is enough to click on the corresponding criterion, and only those elements that correspond to the selected region will appear on the table. To display all data again, you can click on the Clear Filter button or use the shortcut Alt+C. In the same way, I can also display data related to a specific period, filter them by month.

You can use the Slicer Settings function to adjust the parameters. You can start it most easily from the menu that will appear if you press the right mouse button. Otherwise, it is located at the left end of this bar, so it will not be difficult for you to click on the appropriate button and open a new window. I will use the opportunity to add 2010 to this field and thus mark the year. In addition, there are additional options at my disposal, but I will not dwell on them. If I then click on the OK button, the title of this frame will be changed.