Excel: 5 Essential Must-Know Slicer Tricks
In this video I'm going to guide you through five cool tricks to take your Excel Slicers to the next level. I'll show you how to...
Connect a Slicer to Multiple Pivot Tables: Learn how to use a single Slicer for simultaneous filtering across multiple Pivot Tables, saving you valuable time and effort.
Change the Shape of a Slicer: I'll show you how to switch a Slicer's layout from vertical to horizontal, enhancing its fit and functionality within your spreadsheet.
Customise the Slicer Heading Text: Discover how to modify the Slicer's heading text to make it more user-friendly and relevant to your specific data context.
Change the Button Size and Slicer Background Colour: Resize Slicer buttons and change the Slicer's background colour to improve visual impact and readability.
Add a Slicer to a Table: Slicers aren't just for Pivot Tables and Charts
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:39 Link a Slicer to Multiple Pivot Tables
00:02:38 Change the Shape of a Slicer
00:03:35 Customise the Slicer Heading Text
00:04:34 Change the Button Size and Slicer Background Colour
00:06:54 Add a Slicer to a Table
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/nhl5up3angxe09w...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #slicers #dashboards