Helper Slicer Visual Analysis Trick for Excel

Add to Favorites
Author: | Edits: don

How to make buttons to visually analyze any data set in Excel.

This allows you to click a button to view things like: top performers, above average sales, inventory reorders, or whatever else you need to track and analyze.

The setup for this visual data analysis is very easy to do and I show you how to adjust it for your needs in Excel.

Resources

Slicers in Excel (Microsoft)

Excel Online Courses


Excel Version: Excel 2016, Excel 2019, Excel 365
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Data Visualization and Summary Trick for Excel - Outlining Data
Tutorial: How to group and outline data in Excel. Simple trick for collapsing large data sets so th...
5 Bite-Size Vlookup Tricks for Excel
Tutorial: 5 tricks for using Vlookup on data that might not always be 'friendly.' This includes: Re...
Pivot Chart Formatting Copy Trick in Excel - Excel Quickie
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
Enable the Analysis ToolPak in Excel
Tutorial: How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Exc...
Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel
Tutorial: How to combine a list of data into one cell while putting a delimiter between each piece ...
Excel Tips - Quickly Fill Formulas and Text Series in a Few Seconds
Tutorial: How to quickly fill a series of formulas, numbers, or text in Excel instantly. I'll show ...
Tutorial Details
Excel Version: Excel 2016, Excel 2019, Excel 365
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course