Excel Magic: Create Title with Excel Slicer Selections! - Episode 2263

Microsoft Excel Tutorial: Create a Title using a Pivot Table Slicer

Welcome to another episode of the MrExcel podcast, where we dive into all things Excel. In this episode, we will be discussing how to create a title with Excel slicer selections. This is a handy trick that will make your pivot tables more visually appealing and easier to understand.

Since Excel 2007, we have had the ability to select multiple items in a pivot table. However, this can often lead to confusion as it is not clear which items have been selected. But fear not, in Excel 2010, the slicer feature was introduced, allowing us to see which items are selected. The only downside is that the entire slicer needs to be printed out, which can be a hassle.

But don't worry, I have a solution for you. We will remove the filter from the pivot table and copy it to a separate location. This will share the cache and allow us to only display the sector column. We will also remove the grand total and use the new text join function, introduced in Excel 2017, to create a list of selected sectors. This will give us a clear and concise report of the selected items.

To make it even more visually appealing, we can use cell styles to format the title. And the best part? This trick works for any number of selected sectors, making it a versatile solution for your pivot tables. So next time you need to report on multiple slicer selections, give this trick a try and see the difference it makes.

Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe and hit the notification bell to stay updated on all our Excel tips and tricks. And if you enjoyed this video, give it a thumbs up and leave a comment below. See you in the next one!

#excel
#microsoft
#microsoftexcel
#exceltricks
#excelhacks
#walkthrough
#evergreen
#pivot_table
#excelpivot
#excelpivottablestutorial

This video answers these common search terms:
how to make a title slicer in excel
how to use slicers in excel pivot chart
how to use pivot slicers in excel
how to use slicer in excel pivot table
how to use slicers in excel pivot table
how to use slicers to filter data in excel
how to use a slicer in excel
how to use excel slicer
how to use excel slicer function
how to use excel slicers
how to use slicer excel
how to use slicer in excel
how to use slicers in excel
how to use the slicer in excel
when to use slicer in excel
how to create slicer in excel
how to insert slicers in excel
what is a slicer in excel?

Table of Contents:
(00:00) Show Pivot Table Slicer Selections in Title
(00:15) Pivot Table Filter (Multiple Items)
(00:25) Print Whole Slicer?
(00:40) Copying pivot table to share cache.
(00:55) Removing grand total.
(01:05) Using text join function.
(01:26) Updating report for sectors.
(01:36) Using cell styles for titles.
(01:48) Improved selection display.
(01:58) Clicking Like really helps the algorithm

When you filter a pivot table to many items, the title of (Multiple Items) is nearly useless. Which items? Printing the whole slicer can take up a lot of space. Today, I combine a Mike Alexander trick with TEXTJOIN to create a title that shows which items are selected in the slicer.

[AweshBhornya-ExcelforNewbies]

One of my favourite channels for learning Excel Bill you are just good

[excelisfun]

15 minutes, again!?!?!?! You are too rad with all these Excel Videos : )

[Ebiru]

And what if our company still has 2016? Is there an alternative?

[ricos]

Instead of creating a new pivot table, you could use excel CUBE formulas to do the same thing. It's a liitle long winded as a formula, but saves on the additional pivot.



This will create a CUBESET of the selected items in the Sector slicer and then join those together using the CUBERANKEDMEMBER formula to return "rank" 1 up until the last item in the CUBESET (using CUBESETCOUNT).

Hope that makes sense!