Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Training
Customized training to master new skills and grow your business.
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Private Training
Cheat Sheets
Quick references for when you need a little guidance.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Affiliate Program
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
Reseller Partner
It's time to address your client's training needs.
Foundation
Learn how to get into IT with free training and mentorship.
Management Team
Discover the faces behind our success: Meet our dedicated team
Contact Us
How can we help? Connect with Our Team Today!
FAQs
Find all the information you’re looking for. We’re happy to help.
Welcome back to our blog series Excel at Excel with Steve Hughes! In his previous posts, he's discussed using the Quick Explore, Show Details and Flash Fill features. In this entry, Steve will show you how to add a Slicer feature in Excel.
Slicers are not new functionality in Excel as they were in Excel 2010 as well. However, they are even more highlighted in Excel 2013. You can add a Slicer from the INSERT tab on the ribbon in Excel as shown in the image below:
When you click this button, you get a data source dialog. It will show you the available connections in your workbook as well as other connections you have used or are available. Now in my case, I am using a PowerPivot data source. In order to use that, you need to create your slicer from the PivotTable tools as shown below by right-clicking the field to use as a Slicer.
Once you click this, it will create a Slicer on the sheet you are working in with all of the available, unique values from the field.
Now you have created your first Slicer. However, I would be cruel not to wrap this up by showing you how to connect your Slicer to related data objects in Excel.
There are two ways to get to the Report Connections option. First, in the shortcut menu (right-click) on the Slicer you will get the option in that menu as noted below.
The second way is to bring focus to the Slicer and you will get a new menu option on the ribbon called Slicer Tools – Options. The Report Connections button there will lead you to the same dialog to relate object.
You can also get to the shortcut menu from the target data object such as a PivotTable.
The Report Connections dialog allows you to relate the slicer to data objects from the same data source. It will display objects from all of the objects within your workbook. This means that you can have Slicers filter data across multiple sheets. How cool!
In the next edition, I will talk about a new setting which I believe makes slicers even more user-friendly and usable to create a dashboard in Excel.
ABOUT THE AUTHOR
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment