Check out these seven Slicer tips that you wish you knew earlier.
Slicers are the best filtering tools in Excel. Most commonly used with PivotTables but capable of much more.
This Excel tutorial will show some neat Excel Slicer tips and some advanced tips that will use formulas.
📚 Resources
Download the practise file
https://computergaga.com/_excel/files/basic/slicer-tips.xlsx
⌚ Timestamps
00:00 - Seven Excel Slicer Tips
00:24 - Use icons in Slicers
02:10 - Switch to horizontal layout
03:01 - Use Slicers with formulas
06:31 - Display selected values from Slicers
08:38 - Hide Slicer items with no data
10:01 - Filter multiple PivotTables with Slicers
12:26 - Stop Slicers moving
📺 Related Videos
https://youtu.be/aFHEVQp6Hec - PERCENTOF function
https://youtu.be/333IMGoNAqo - 11 PivotTable tips in 11 minutes
https://youtu.be/Aef5--iix8w - Excel GETPIVOTDATA function
Find more great free tutorials at; https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
TikTok ► https://www.tiktok.com/@computergaga
#excel #excelslicers #exceltutorial