Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Excel New Features
About Lesson

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.

0% Complete