Excel VBA/Macro Course [80% Discount]: https://www.teachexcel.com/vbacourse...

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:
Download the File: https://www.teachexcel.com/exceltuto...
Slicers in Excel (Microsoft): https://support.microsoft.com/enus/o...
TeachExcel Online Courses: https://www.teachexcel.com/premiumco...

00:00 How it Works
00:49 Setup Your Data for Analysis
03:07 Add Tables & Slicers for Analysis
04:25 Custom Format Slicers

#msexcel #tutorial #exceltips #freetutorial #excel