How to Use Symbols and Icons Instead of Text in Excel Slicers

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/pivot-slicer-symbols-file

[@sergeypautov8086]

Ого! Никогда не задумывался над изменением дизайна срезов. Спасибо огромное!

[@LeilaGharani]

Glad you found something new :)

[@irshadali4273]

You are making things understand so politely 😀

[@sneeuwgetsie]

Thank you. You're a very good teacher. I've learned a lot already 👌

[@LeilaGharani]

I'm very happy to hear that.

[@osamasalah341]

Always you have new brilliant techniques in MS-Excel.

[@LeilaGharani]

Glad you like it Osama.

[@1gopalakrishnarao]

Your intelligence cannot be measured, doing a great job. I like it & I respect you for your knowledge in Excel.

[@LeilaGharani]

Thank you Gopala for the kind words. Glad you enjoy the videos.

[@niqdin]

All your tutorial are the best in the world, can I call you a God of Excel 🤭?

[@torgal786]

You are absolute genius.. I salute you..

[@smalldjo]

you are making excel more interesting and exciting , thanks

[@LeilaGharani]

Very happy to hear that. Thank you for the comment.

[@RobertLongM]

I submit to you

[@binumathew721]

Thank you Leila Is it possible to connect one slicer to Pivot table and Data Table at the same time.

[@urbaneplanner]

another good video. I am also working through your vba course, which I would recommend to others. Its a very good deal - you learn a lot (in my experience, its weeks worth of material, working at a moderate pace) and the approach is actually quite similar to a course you could pay a lot more for at a local college

[@LeilaGharani]

Awesome, thank you! I'm glad you like the course.

[@jihadalbustanji3760]

Many thanks for the great videos you share all the times. You are doing an amazing job.

[@barunmajumder5739]

Your magical excel tutorial ...makes professional life easier, thanks

[@LeilaGharani]

Very happy to hear that Barun! Thanks for dropping by :)

[@vipinsingh4047]

I really love you, I have learnt lot from your videos💯

[@calvingouw9002]

Thank you very much for the tutorial! Is there a way to disable right-click on slicers?

[@yanmike5212]

Thank you for imparting the knowledge.

[@javierlainez8376]

Great tool and so simple. Excellent videos, always!

[@LeilaGharani]

Thank you Javier.

[@gregorymoureau6170]

Love your work. Learned so much from your vids. Respect ✊.

[@ngilsz3]

All your videos are excellent .. thank u 💙 New informations in this video thanks a lot 💙

[@balamuniyandi]

Hello Leila,am impressed your excel videos which is helped me a lot. Is that possible to prepare a pivot table with countries flags?? Based on the flag the report will display..can you do it for me??

[@mizu436]

That's amazing! thanks 🙏👍

[@yashsomaiya8141]

That's unique n very treat to anyone's eyes who observes it.

[@叶萌-b6d]

simple to master , thanks teacher !!

[@sinahosseinzadeh736]

Thank you so much, It was really useful.

[@LizWagner-f3y]

Hello Leila, We are trying to connect 1 slicer (for dates) to multiple pivot tables that are connected to different queries" any recommendations would help thank you.

[@frachiar4444]

Really nice!! 🙂

[@sanchezsanchez1668]

You are a genius

[@luisguillermoperezmejia7907]

Que fantasía. estoy feliz de haberte encontrado. Saludos cordiales desde Medellín Colombia

[@jplug93]

Symbol template.. Cool idea.

[@ngedwin6174]

Leila, I am just wondering, by adding slicers (which we will later use it as part of dashboard), we are spending most of the time arranging and making it more presentable to whoever that is on the receiving end. Was this the key purpose of it all? I mean, as someone who crunches data, we look at large set of data and are able to tell some story. But doesn't seems to be the case for any non-data cruncher. So with that in mind, all we care for, is to make data presentable for dummy user, which means, rearrange, and to beautify, right??

[@evgeniam8882]

That was a masterpiece!! And this function, Unichar is awesome! I am very excited with this video! Thank you so so much Leila! :)

[@LeilaGharani]

You're very welcome Evgenia. No one called it a masterpiece before. I like that :)

[@himanshudalai1028]

Thank you Leila. This is a great video & great learning.

[@LeilaGharani]

You're very welcome! Thank you for your support.

[@semperdiscendum7439]

That was awesome! Thank you so much! Please keep enlightening us!

[@LeilaGharani]

You're welcome. Will do my best :)

[@joinsocial8308]

Thanks Leila !

[@mohitdhanwani5540]

WOW! Well Explained. Thanks for the video!

[@LeilaGharani]

You're welcome Mohit.

[@mohamedmami2480]

Absolutely beneficial, thanks a lot Leila. All the best,

[@LeilaGharani]

You're very welcome Mohamed.

[@martinwaren46]

Hello, can u help with sequence slicer with alpabet with number, like ( A1, A9, A10, B1, B2, B9, B10, B11)

[@shivanagaraj8516]

As always very help full. Thanks

[@LeilaGharani]

You're very welcome.

[@phamhoangtien]

It's a very nice tip! How can we set the symbol centered inside the button Ma'am?

[@LeilaGharani]

Until now, there isn't an option that can control that....

[@lakshmipathiganesan6332]

Thanks for sharing an informative tips. In the slicer, you removed the filter icon but selecting the male female icons. How to defilter it in such a way that the values to show for both?

[@frachiar4444]

Just press SHIFT while clicking icons

[@eslamfahmy87]

Can u share with us the refrence for symbols which founded in the condition formating (icon)

[@ForeverMods]

Great tutorials !! Is there a method to centre justify the icons or text in slicers please?

[@nagendraprathap9697]

thank you so much madam, God bless you and yours Family ,

[@LeilaGharani]

You're very welcome. Thank you very much for your support and your kind comment.

[@s.y.daniel2137]

nice tricks!

[@sauravkragrawal]

Love this!

[@algawzy]

Could you please make example for slicer connected to different data tables

[@BayuHendra-qe7kg]

Thank you for your attention and support gablesyou🎉🎉

[@robertakwasiadjei8223]

Great Job Leila

[@LeilaGharani]

Thank you Robert.

[@OzduSoleilDATA]

Very very nice!

[@LeilaGharani]

Glad you like it.

[@cmlosaria]

Hi Leila, what if I want to use text with symbols in the slicers?

[@bricc322]

So cool! :) Thank you for sharing.

[@LeilaGharani]

You're welcome Celia :)

[@johannesmp3]

Leila, is there a way to change a slicer based on cell input. Without vba.so if I enter john into A1, the slicer automatically changes to john

[@fionamehta7381]

Really useful! thank you so much for this.

[@LeilaGharani]

You're very welcome Fiona.

[@alirezamogharabi8733]

Thanks, very useful. Please introduce some other features in pivot tables, LEILA!

[@LeilaGharani]

Ok. For sure. Have added this to my list.

[@alirezamogharabi8733]

Leila Gharani Thanks for your attention!

[@ub9731]

Wow...! What a great idea. 👍👍👍

[@LeilaGharani]

Gives a nice touch to reports. Thanks :)

[@diannedrechsler4792]

So useful!

[@LeilaGharani]

Glad to hear that!

[@rrrprogram8667]

Nice one liela..thanks

[@LeilaGharani]

You're very welcome.

[@dalekriens1397]

very interesting

[@ahmedbakr3198]

Thanks A lot Lelia

[@LeilaGharani]

You're welcome Ahmed.

[@mostafa4321]

Awesome Laila.

[@LeilaGharani]

Thanks Mostafa.

[@potatohead6470]

Hi Leila, i ve watched all your videos and impressed with you. Is there any way i can contact you i wana ask something

[@channel100tube]

Magnifique

[@BinoyEmmanuel]

How can we change the field position in a slicer. for example , i need in my slicer i need to change jan and feb in the last

[@ExactProBi]

awesome trick

[@LeilaGharani]

Glad you like it :)

[@mohitverma8190]

Awesome

[@hosseinhosseinpoor4845]

thanks thanks

[@thevoiceoftruth5116]

good job

[@LeilaGharani]

Thank you. Glad you like it.

[@karthikmohanraj1542]

Hi, it's a great learning!!! cld u pls teach us d digital dashboards which includes KPI and forecasting and budgeting examples

[@LeilaGharani]

Glad you like it Karthik - I have a course on this that's over 10 hours. You can see what's included in this video: kzbin.info/www/bejne/oHWYhJWog7B1mbc

[@rsvn29]

Too good for anyone...

[@alpeshdoshi7827]

Nice one madam.... thank... Madam can u make videos on Excel VBA... Pls .... Thank you so much...

[@LeilaGharani]

You're welcome Alpesh. Yes, yes. Videos in progress....

[@alpeshdoshi7827]

Ok.... madam.. N... Thanks for replying....

[@jmschroen-hendriks4542]

Looks beautiful. Put the pivot table in a separate folder. Then put the code below in the folder in program. The pivot table is now automatically updated when the folder is activated. Pivot table is now always up-to-date. Management love it. Private Sub Worksheet_Activate() Dim pt As PivotTable For Each pt In ActiveSheet.PivotTables pt.PivotCache.Refresh Next pt End Sub

[@LeilaGharani]

Agree - the code is very practical and easy to implement. I have these actually as a part of my dashboard and VBA courses :) Many thanks for sharing.

[@shyamn7998]

I want to make condition in slicer like sal >500 and < 100 like condition to be display in slicer.

[@imranmushtaq7445]

Miss Liela Absolutely Astounding

[@imranmushtaq7445]

You are using multiple commands in a very fast flow

[@mohammadasad9890]

Good job

[@LeilaGharani]

Thanks Mohammad.

[@aksohal]

Hii Leila You are the One of the BEST . (Y)

[@LeilaGharani]

THANK you Ankur!!

[@aksohal]

Kindly Mail me Some Problems on which i can make practice. Plzz

[@sultanrony4826]

there are any short cut key to up down slicer in excel????

[@senthilvelan990]

I am not able to import the CSV file Once we set the format the table.pls help to fix the problem.

[@vickyrodriguez4779]

Hi how to freeze this slicer pls share with us

[@teoxengineer]

I followed your instructions but, when I changed the Unicode number to symbol, slicer looks Unicode Word and I never changed it a symbol. How can I do it easly?

[@mudassarrahman3942]

I have a query about the pivot table and the query is .. Suppose i have a data in excel ..and the 1st hadder is product and 2nd hadder is cost and 3rd hadder is quantity.. And then i make a pivot in diff sheet ..and i put the 1st hadder in rows and 2nd hadder in rows and 3rd as well..and then i want to multiply for 2nd and 3rd hadder ..and thr grandtotal will not be multiply ...in the pivot field.. The field 3rd value in pivot would be come for the total of ..field not be multiply with qty and cost If you have any video in channel then plz send the link ..

[@ehsanabbasi9405]

مرسی خاله لیلا

[@prakshalshah1291]

Hi, is there any way where we can select multiple fields in slicers

[@LeilaGharani]

Yes - you just have to hold down the control key.

[@prakshalshah1291]

Thanks...

[@taherpoonawala7766]

How to I use column headers as slicers?

[@sachinrv1]

Hi Leila; I have one situation in excel. As you must be aware; in India; a person is required for have a PAN no. for his income tax purpose. This PAN is a 10 digit alpha-numeric and has a specific format. for e.g. ADGPV9999K. Wherein as you can see, 1. The first 5 are alphabets, 2. The fourth is always "P" which stands for "Person" ("C" for company, "T" for trust and so on), 3. From 6th to 9th are whole numbers and 4. the last is again an alphabet. I want to have a single integrated function (validation) which will take care of all these validations and shall throw a result "VALID PAN" when all these conditions are satisfied or "INVALID PAN" if any of the conditions are not met. the problem I am facing is that each of the 1st 5 are alphabets. In above example ADGPV. Supposing if a person wrongly enters a whole number or a special character in any of the 1-5 positions; using ISTEXT function; still validates the input; which is wrong. Will you please help solve this? I know this video is not the right platform for this query but hope you won't mind.

[@LeilaGharani]

Hi Sachin - I think something like this might work: =AND(NOT(ISNUMBER(AGGREGATE(14,6,VALUE(MID($A2,{1,2,3,4,5},1)),1))),NOT(ISNUMBER(RIGHT($A2,1))),ISNUMBER(VALUE(MID($A2,6,4))),LEN($A2)=10) You could use an IF before this to check if the entry is valid or not. Alternatively you can use it inside a data validation - because of the array reference to numbers though, you'll need to either use name manager or to use a function that gives a 1 to 5 array, like the indirect function... For the data validation, you'll need to select "custom" and make sure you uncheck "ignore blank". Hope this helps....

[@sachinrv1]

Thanks for your quick support Leila. Shall try and get back :)

[@sachinrv1]

Hi Leila, I have tried the above nested function. Its works fine except the last place from the right, which is an alphabet. Even when one enter a whole number the result is TRUE. Anyway I have come-up with this very long a "Railways coaches" kind of integrated function using IF, ISERROR, AND, MATCH which works fine. I was wondering if there is any specific function in excel which determines whether a particular data in the data string is an alphabet, whole number or a special character and returns true or false. Thanks for your kind support. Your videos have really been of great help all this time. =IF((ISERROR((AND((MATCH(LEFT(A2,1),$XFC$1:$XFC$26,0)),(MATCH(MID(A2,2,1),$XFC$1:$XFC$26,0)),(MATCH(MID(A2,3,1),$XFC$1:$XFC$26,0)),(MATCH(MID(A2,4,1),$XFC$1:$XFC$26,0)),(MATCH(MID(A2,5,1),$XFC$1:$XFC$26,0)),(MATCH(RIGHT(A2,1),$XFC$1:$XFC$26,0)),(MATCH((VALUE(MID(A2,6,1))),$XFD$1:$XFD$27,0)),(MATCH((VALUE(MID(A2,7,1))),$XFD$1:$XFD$27,0)),(MATCH((VALUE(MID(A2,8,1))),$XFD$1:$XFD$27,0)),(MATCH((VALUE(MID(A2,9,1))),$XFD$1:$XFD$27,0))))))=FALSE,"VALID PAN","INVALID PAN")

[@LeilaGharani]

Thanks Sachin for the feedback. For the last one, I forgot to wrap it up in the Value function. So Just before Right, we can put it in Value(). Glad you figured it out though :)

[@prasannakulkarni2045]

Does it work for 2007 also? Cz I didn't find it in 2007 version.

[@LeilaGharani]

Unfortunately not! Slicers exist from Excel 2010 onwards.

[@nagsan2000]

one more question on slicer some times when i click on the value to open the data in a new sheet it returns all rows in stead of filtered no of rows , not sure why it happens but when i add them as a report filter in the pivot table it returns the right data . can you let me know why it happens

[@LeilaGharani]

Not really. Are you using the same slicer for different pivot tables? If yes, make sure it has the connection to the other pivot tables as well.... I can't imagine why it would behave like this.

[@nagsan2000]

Leila no it is just one. The weird thing is if you add report filter and then the slicer it works fine

[@laurarivera5365]

I have a question, a problem actually. I have a column named "days" that shows the sum of days an active employee has (e.g. 1250 days/ so I don't have an end date) and I need to change that into the number of months (e.g. 365 days = 12 months) in Excel 2016. I tried to look for a formula that can help me, but I'm not able to find one. I will sure appreciate if you can help me.

[@LeilaGharani]

Since it's just going to be an estimate, how about using a formula to get the estimate =(days*12)/365 ?

[@saumilparadkar8636]

I could hear you laughing while typing Sex Symbol 😂 🤣😂... Anyways a great content and videos Leila... Keep it up

[@hiteshsirohia]

you couldn't control your laugh while writing "sex symbol" :D

[@trevorbbeairsto]

Leila is my secret weapon

[@LeilaGharani]

:)

[@nagsan2000]

Hi , When i tried it find the Unichar symbol in a blank sheet as you had mentioned i got #name? error. do i need to do any formatting

[@LeilaGharani]

I think it depends on your Excel version. I have office 365 - it might not be available in your version....

[@nagsan2000]

Leila Gharani hi I noticed that it is not supported in excel 2010

[@nagsan2000]

is there any other way to get those characters in Excel 2010

[@Compexcel]

👍

[@chillihi]

Hi, I love your instructional videos! A question on sorting legend on a pivot chart. It won't allow me to sort or change order of the legend in the pivot chart, it's greyed out. Help!

[@SothearithKONGMrMuyKhmer]

❤

[@NaftuliSinger]

@7:56 When Win+V didn't work yet...

[@shreyashshetty7584]

PUT VIDEO OF TALLY ERP 9 BASIC OR ADVANCE TALLY

[@ismailismaili0071]

Hi i really like your way of teaching thank u so much can I get your email i wanna study online

[@LeilaGharani]

Hi Ismail - glad you like the videos. You can find the list of my online courses on my website...

[@ismailismaili0071]

I'm really watching your videos the whole day even at work hhhh i liked the videos that talked about goal seek and solver oh my gosh u just let me know that i still know nothing about excel

[@LeilaGharani]

:) The best thing about Excel is the learning never ends. I'm learning every day.

[@ismailismaili0071]

You are absolutely right and I really have so much fun while I'm working on it can you send me the link of your videos website in my email please [e-mail]

[@mohammedfarooq9829]

What I can say to you !!!!!!!!

[@sandarmyint4011]

Thanks a lot for your teaching!

[@LeilaGharani]

You are welcome!