Search Results for: slicers

Who doesn’t love slicers? What an awesome way to sort and filter data. We have talked about how, in addition to being a time saver, slicers can make it easier to share your data with others who are not as comfortable working in Excel. Not everyone understands, “filter the data,” but we all can understand … Continue reading “Excel: Using Slicers With Password Protected Sheets”

A fantastic question came up during last week’s open lab. Is it possible to create a PivotChart pie chart that can be filtered to show only the percent of the item selected?  Here is one solution for that question (and spoiler alert, it is technically not a PivotChart). A few things before we get started… … Continue reading “Excel: Filter a Pie PivotChart and Maintain Percent of Whole (A Different Take on Progress Charts)”

Utilizing links in an Office document can do so much more than simply take your end users to a website. Links are also a great way to help people navigate around a document. Below is a great example… let’s check it out. Exercise File Feel free to follow along with today’s Exercise File: This is … Continue reading “Excel: Navigating Inside a Document with Links”

Slicers are hugely popular in both Excel Essentials and Excel Pivot Tables training. We go for standard slicers in both of those sessions, but there is another type that is particularly fun to play with if you are working with dates; the Timeline Slicer. Exercise File Download today’s Exercise File to follow along: This is… … Continue reading “Excel: Timeline Slicer”