Great video. I've spent way too much of my life messing with slicers. One thing to note, if you turn off the slicer display header (and hence lose the multi-select and the clear-filter buttons), you can still reset the slicer WITHOUT having to select each slicer button. With only 1 button selected (doesn't work if you have more than one button selected) just Ctrl+click the button that is already selected, and now they all will be selected (equivalent to having clicked the "clear filter" button in the header that you have hidden)
@MyOnlineTrainingHub
11 ай бұрын
Awesome tip, Quidisi! I'll try it out. 🙏
@ricos1497
11 ай бұрын
Yes! Good tip. I usually just do a quick macro and assign to a filter shape from the icons menu (or look up icons in iconfinder for different ones). That way the user still has the familiarity of the button.
@ivanbork4175
11 ай бұрын
Another option is to add ”clear all” to your QAT tollbar
@TheJoshtheboss
11 ай бұрын
Your ingenuity never ceases to amaze me. Always love coming back to your Excel content, especially dashboards, power query and pivot tables and charts 😊
@MyOnlineTrainingHub
11 ай бұрын
Wow, thank you!
@ExcelUpNorth
11 ай бұрын
No way! I’ve been looking for a way to reduce the font size for a while and it’s been there the whole time? Thanks Mynda!
@MyOnlineTrainingHub
11 ай бұрын
😁glad you can make use of it, Darryl!
@ivanbork4175
11 ай бұрын
Hi Mynda Very good and useful tricks, thanks. And please, allow me to comment that I’m glad to see a video that is just about the subject without any noise.
@MyOnlineTrainingHub
11 ай бұрын
Thanks, Ivan!
@aiasaiascon3894
10 ай бұрын
Within All, you are a tremendous BI Designer!!!
@MyOnlineTrainingHub
10 ай бұрын
Thanks for your kind words 🥰
@tristangeoffroy9286
10 ай бұрын
Thank you for this thorough review of slicer design that can improve so much user experience. I like your idea of make it like a menu, or inserting it into a graph. … and also to your comment. Thank you
@MyOnlineTrainingHub
10 ай бұрын
Thanks so much! Great to hear 😊
@robertcooper3759
11 ай бұрын
Oh Mindy, you're lovely - you really know your stuff.
@MyOnlineTrainingHub
11 ай бұрын
Thank you!
@erdal4687
11 ай бұрын
That's exactly what I was looking for. Thanks Mynda.
@MyOnlineTrainingHub
11 ай бұрын
Glad it was helpful!
@h4niali
11 ай бұрын
Thank you so much , very very important slicer customization
@MyOnlineTrainingHub
11 ай бұрын
My pleasure 😊
@learnspreadsheets
10 ай бұрын
This is brilliant! Wish you had more resizing capabilities but oh well
@MyOnlineTrainingHub
10 ай бұрын
Cheers, David! Yeah, it's also a shame we can't do simple things like left or right align text in the buttons etc.
@HenricAndersen
11 ай бұрын
Another great video. Thanks Mynda 🙏🙏
@MyOnlineTrainingHub
11 ай бұрын
Thanks for watching! 🙏😊
@joannablack
11 ай бұрын
I would love to see something similar for Power BI! for an application designed for data visualization, I find the lack of formatting options for slicers (or obvious options anyway...) very frustrating
@MyOnlineTrainingHub
11 ай бұрын
Yes, Power Bi formatting for Slicers isn't great.
@debasishsamal4646
3 ай бұрын
Much Appreciated.
@MyOnlineTrainingHub
3 ай бұрын
Glad it was helpful 😊
@martyc5674
11 ай бұрын
Great Video Mynda- Slicers settings are not at all intuitive, some brilliant workarounds in there that i have just been able to put into good use 👌👌
@MyOnlineTrainingHub
11 ай бұрын
Awesome to hear! 🙏
@itachiUchiha-u4e
11 ай бұрын
Thank you Mam the Tutorial was Great. Please Make more tutorials on None productive time report and production loss analysis report 😊
@MyOnlineTrainingHub
11 ай бұрын
Thank you. Will keep those topics in mind.
@chrism9037
11 ай бұрын
Very nice Mynda!!!
@MyOnlineTrainingHub
11 ай бұрын
Cheers, Chris!
@tmb8807
11 ай бұрын
This is cool. I really wish we had more built-in options for the format of slicers (combo box, radio buttons, etc). Know it can be done in other ways but it's a hassle.
@MyOnlineTrainingHub
11 ай бұрын
Yes, great idea. More like what Power BI has for Slicers would be awesome 😊
@shoppersdream
7 ай бұрын
This was nice, thanks! Excel works best on Windows and I have a Mac, so many things do not work on Mac.
@MyOnlineTrainingHub
7 ай бұрын
Yes, Excel for Mac is behind but Microsoft are working hard to bring it to parity.
@dannypuype6104
9 ай бұрын
When hiding the header, right clicking the slicer gives you the option to clear the filters
@MyOnlineTrainingHub
9 ай бұрын
Ah, nice tip. Thanks for sharing.
@dannypuype6104
9 ай бұрын
:-) @@MyOnlineTrainingHub I also use some VBA sometimes; beware the difference between the slicer name and the slicer code name, which both can be found in the properties of the slicer: Sub ClearFilters() Application.ScreenUpdating = False Application.EnableEvents = False With ActiveWorkbook.SlicerCaches("Slicer_Sales_year1") ActiveSheet.Shapes.Range(Array("Sales year")).Select 'refers to name of slicer ActiveWorkbook.SlicerCaches("Slicer_Sales_year1").ClearManualFilter 'refers to code name of slicer ActiveSheet.Shapes.Range(Array("CategoryName 2")).Select ActiveWorkbook.SlicerCaches("Slicer_CategoryName2").ClearManualFilter ActiveSheet.Shapes.Range(Array("Country 2")).Select ActiveWorkbook.SlicerCaches("Slicer_Country2").ClearManualFilter End With Application.EnableEvents = True Application.ScreenUpdating = True End Sub
@hazemali382
11 ай бұрын
always great Mynda
@MyOnlineTrainingHub
11 ай бұрын
Thanks so much!
@teoxengineer
11 ай бұрын
Thank you Mynda. 1- How can we reorder slicer buttons as we desire? 2- Can we change slicer buttons as image like describing button meannig? 3- Can we make slicer’s button names position as center because it is alligned by Left
@MyOnlineTrainingHub
11 ай бұрын
1. video coming soon! 2. www.myonlinetraininghub.com/symbols-in-excel-slicers 3. no
@albertogarcia8084
10 ай бұрын
Thanks
@MyOnlineTrainingHub
10 ай бұрын
Welcome 😊
@Masoom36
11 ай бұрын
Love this!!
@MyOnlineTrainingHub
11 ай бұрын
Great to hear!
@SanteFrezza
11 ай бұрын
Thank you!
@MyOnlineTrainingHub
11 ай бұрын
You're welcome!
@shanabenjamin8945
4 ай бұрын
thank you:)
@MyOnlineTrainingHub
4 ай бұрын
You're welcome!
@a7mad_ksa
3 ай бұрын
thanks 😊❤⤵ Video summary [00:00:00][^1^][1] - [00:04:59][^2^][2]: The video provides seven hidden formatting tricks for slicers in Excel, focusing on creating compact and stylish slicers for user-friendly interactive reports. It demonstrates customizing slicer styles, adjusting font sizes, removing borders for overlapping, and other techniques to optimize space and improve the visual appeal of Excel dashboards. **Highlights**: + [00:00:00][^3^][3] **Custom Slicer Styles** * Create custom styles for compactness * Adjust font size and style for smaller buttons * Remove borders to allow overlapping + [00:01:59][^4^][4] **Applying Formatting** * Apply new style to all slicers with a shortcut * Reduce button size and width for space efficiency * Overlap slicers slightly without visible borders + [00:02:41][^5^][5] **Header and Filter Button** * Hide headers when unnecessary * Use alternative methods to clear filters * Consider the trade-off of header removal + [00:03:06][^6^][6] **Slicer as Sheet Tabs** * Make slicers resemble sheet tabs * Draw a line shape for a page-top appearance * Add a drop shadow for a finishing touch + [00:03:54][^7^][7] **Preventing Accidental Changes** * Disable resizing and moving to prevent mishaps * Avoid accidental activation of pull handles * Ensure slicers remain neatly positioned + [00:04:15][^8^][8] **Grouping Dates in Slicers** * Hide unwanted grouped date items * Use slicer settings to hide items with no data * Workaround for single-item selection in slicers
@kkf224
11 ай бұрын
Instead of unchecking the Header box you can just remove text in the Header Caption. This way you will have your clear filters available, although you will still have a line above the slicers.
@MyOnlineTrainingHub
11 ай бұрын
Nice tip! Thanks for sharing 🙏😊
@aspectoflife
6 ай бұрын
thanks
@MyOnlineTrainingHub
6 ай бұрын
My pleasure 😊
@mochmaarif4808
11 ай бұрын
Awesome Mom.. I'm from Indonesia, I'm so impressed.. I want learn more about excel.. Maybe U can give me advise please, Mom.. 😊
@MyOnlineTrainingHub
11 ай бұрын
Glad you liked it! You can learn Excel in my courses here: www.myonlinetraininghub.com/courses
@AhmedOmar-mq2ed
11 ай бұрын
Good Job👍
@MyOnlineTrainingHub
11 ай бұрын
Thanks 😁
@mtop3147
11 ай бұрын
thank you so much
@MyOnlineTrainingHub
11 ай бұрын
Welcome 😊
@Ugk871
11 ай бұрын
Thank you very much for the sharing. Now i know that i didnt click set as default
@MyOnlineTrainingHub
11 ай бұрын
Glad I could help 😊
@dwang085
11 ай бұрын
Awesome!
@MyOnlineTrainingHub
11 ай бұрын
Glad you think so! 🙏
@KrishnaswamySrinivasan-m1s
11 ай бұрын
Super
@MyOnlineTrainingHub
11 ай бұрын
Thanks so much! 🙏😊
@jdogcisco1
11 ай бұрын
Amazing
@MyOnlineTrainingHub
11 ай бұрын
Thank you! 😊
@PWH1968
11 ай бұрын
Absolutely gutted, was so excited when I found this - only to realise it doesn't work on MAC 😢
@MyOnlineTrainingHub
11 ай бұрын
Oh, no! Time to get a PC?
@Seftehandle
11 ай бұрын
Perfect
@MyOnlineTrainingHub
11 ай бұрын
Thank you! 😁
@AjayKumarparmar
11 ай бұрын
Could you please advise which software you have used to record this. I like minimizing and full screen of your physical appearance in the video. It was very smoothly transitioned
@MyOnlineTrainingHub
11 ай бұрын
Premiere Pro.
@AjayKumarparmar
11 ай бұрын
Does it record your face from a computer camera or dslr Mynda...I mean to record face what have you used as a camera. Laptop or dslr because generally laptops won't have that clarity .
@othmanaljbory3649
11 ай бұрын
Thanks 🎉🎉
@MyOnlineTrainingHub
11 ай бұрын
My pleasure 😉
@othmanaljbory3649
11 ай бұрын
@@MyOnlineTrainingHub 🤍🤍
@ahmetx7456
11 ай бұрын
Thanks. 💎💎
@MyOnlineTrainingHub
11 ай бұрын
You're welcome 😊
@shoppersdream
7 ай бұрын
Mynda, do you have any videos on Pivot Table Two-Level Slicer? It is mainly because my Column has too much data. Thanks
@MyOnlineTrainingHub
7 ай бұрын
You can increase the number of columns in the Slicer on the Slicer formatting tab if you want to make it wider to allow for less scrolling through the buttons.
@shoppersdream
7 ай бұрын
@@MyOnlineTrainingHub Thanks! I can increase the number of columns but my columns are so big like "Hidden Formatting Tricks for Slicers :)" and if I increase the number of columns, it looks way ugly.
@MyOnlineTrainingHub
6 ай бұрын
Ah, I see. Then the only option is to abbreviate the name!
@davidhampson1958
6 ай бұрын
Hi If you want quite a few slicers on a data pivot table...but you want them smaller than the default...Can you somehow set them to a size that then remains each time you open a new slicer?
@MyOnlineTrainingHub
6 ай бұрын
Yes, you can create a custom slicer style and set it as the default: right-click the style in the gallery > set as default.
@Rice0987
11 ай бұрын
The main annoying feature of slicers that you cant track its changes, so you need to make additional table with tracking its values. Thanks for video, i also have no enough time to dig deeper into slicers settings.🤭
@MyOnlineTrainingHub
11 ай бұрын
Glad you liked it. Not sure why you're tracking changes because Slicers don't change anything, they just apply filters. You can see what filters are applied based on the button status. Maybe I've misunderstood what you mean.
@alvarorodriguezlasso
11 ай бұрын
Nice, but the "clean all filters icon" is not visible. Regards from Cali-Colombia.
@GeertDelmulle
11 ай бұрын
You can always put that icon on the QAT and use it from there.
@MyOnlineTrainingHub
11 ай бұрын
@alvarorodriguezlasso glad you liked it. Like Geert said, use the shortcut key, or you can left click and drag to select all items again, or select the first button, hold SHIFT and select the last button to select all items in long lists.
@Kokoro-Gamer
11 ай бұрын
Hi, how to change grand total to average while having calculated fields in pivot table. I tried changing it and got a message from excel which says it can’t be when having calculated fields.
@MyOnlineTrainingHub
11 ай бұрын
If the aggregation type is average, then the total will also be the 'total average', that is the sum of all items, averaged, as opposed to the average of the averages shown in the rows above. If the values in the column are summed, then you can't show an average in the grand total in a PivotTable. You'd have to add another column containing the averages. HTH. If you're still stuck, please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@Kokoro-Gamer
11 ай бұрын
@@MyOnlineTrainingHub Thank you so much for your reply, I’ll add another column for averages as you recommended.
@nazarkamal8831
7 ай бұрын
👍
@MyOnlineTrainingHub
7 ай бұрын
Thanks for watching!
@jualflowswitchhargamurah5273
10 ай бұрын
how to format text in slicer for aligning it in Center?
@MyOnlineTrainingHub
10 ай бұрын
Not possible, unfortunately.
@othmanaljbory3649
11 ай бұрын
❤❤❤❤
@MyOnlineTrainingHub
11 ай бұрын
🥰
@JamesLamica
11 ай бұрын
I always use date format yyyy-mm-dd, but when I make a date slicer, it comes in dd-mmm. Is there a way to format it?
@MyOnlineTrainingHub
11 ай бұрын
You can add the date as a text field to your source data table: =TEXT(date, "yyyy-mm-dd") then use this field in your Slicer.
@IamTheReaper911
11 ай бұрын
Always amazing 👍 🫶
@MyOnlineTrainingHub
11 ай бұрын
😁🙏
@gayatrikamath7016
3 ай бұрын
How to remove zeros
@MyOnlineTrainingHub
3 ай бұрын
You'd have to remove them from your dataset. Slicers simply display a list of items in the column.
@koa1663
Ай бұрын
instead of whole slicer, whole table pops up for me
@MyOnlineTrainingHub
Ай бұрын
Not sure how that's happening. You're welcome to post your question and screenshots on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Пікірлер: 112