Excel has many different tools that can be made more efficient or optimized simply by combining different concepts, tools or functions. Of course, there is no exception when it comes to Excel slicers. By default and out of the box, Excel slicers are made to provide you with the option to filter any field within a pivot table or a standard table using a visual selection tool. This tool allows the user to select any value and will then filter your entire pivot table or table by the value selected (note: you can also select multiple records for any given slicer as well). I will mention that unfortunately, out of the box, Excel slicers are available only in Excel 2010/2013. Let’s have a deeper look at what you are going to learn in this premium Excel slicer tutorial.
The Excel Slicer Tutorial that Will Show you the Secret to Sorting and Filtering Your Top/Bottom 5 Records
If you haven’t already been exposed to this functionality, often times in more advanced Excel dashboard applications, the dashboard will make use of slicers to sort, filter and display only the top 10 or the bottom 10 records of a data set (you can really choose top X/bottom X amount – where X can be any value). In fact, Chandoo happened to do this in his most recent Excel Dashboard Template product (see image below).
The concept is great because it provides the dashboard user with a very simple means of being able to change the display at the drop of a hat by simply clicking a button. For the past several weeks I have been working on creating an Excel slicer tutorial that shows you how you can achieve this exact same functionality in your dashboards. I’ve put together a detailed tutorial package to show you how you can make this happen. Here is a quick video of the final product:
What’s Included in the Excel Slicer Tutorial?
With the tutorial you will get the following 3 items all for just $10 USD.
NOTE:
If you are not using Excel 2010 or 2013, this tutorial is not for you as Excel slicers are not available out of the box in earlier versions.
The Premium Excel Slicer Tutorial For your Dashboard Includes:
- The interactive PowerPoint Tutorial that includes:
1) A visual guide and outline that allows you to easily navigate through the 7 different sections of the tutorial (here is a snippet – sorry I can’t give it all away because this will be an integral part of the learning process)!
2) Detailed written steps for each of the 7 sections of the tutorial that explain how and what you’ll need to do.
3) Videos for each of the 7 sections within the PowerPoint that will show you exactly how to achieve the final result.
- The PDF version of the PowerPoint presentation for the students who do not have access to PowerPoint. Unfortunately the videos do not work in the PDF version so I’ve included the videos separately.
- As mentioned above, all of the videos that were included in the PowerPoint will be available to stream from the link that will be provided once you purchase the course.
BUY NOW
If you have any questions at all of course, you will be able to contact me directly via email by responding to the email that you’ll receive once you’ve made the purchase. I truly hope you enjoy the course!
Trackbacks/Pingbacks