Grab the file I used in the video from here 👉 pages.xelplus.com/pivot-slicer-symbols-file
@sergeypautov80865 жыл бұрын
Ого! Никогда не задумывался над изменением дизайна срезов. Спасибо огромное!
@LeilaGharani5 жыл бұрын
Glad you found something new :)
@irshadali42734 жыл бұрын
You are making things understand so politely 😀
@sneeuwgetsie5 жыл бұрын
Thank you. You're a very good teacher. I've learned a lot already 👌
@LeilaGharani5 жыл бұрын
I'm very happy to hear that.
@osamasalah3417 жыл бұрын
Always you have new brilliant techniques in MS-Excel.
@LeilaGharani7 жыл бұрын
Glad you like it Osama.
@1gopalakrishnarao7 жыл бұрын
Your intelligence cannot be measured, doing a great job. I like it & I respect you for your knowledge in Excel.
@LeilaGharani7 жыл бұрын
Thank you Gopala for the kind words. Glad you enjoy the videos.
@niqdin2 жыл бұрын
All your tutorial are the best in the world, can I call you a God of Excel 🤭?
@torgal7864 жыл бұрын
You are absolute genius.. I salute you..
@smalldjo6 жыл бұрын
you are making excel more interesting and exciting , thanks
@LeilaGharani6 жыл бұрын
Very happy to hear that. Thank you for the comment.
@RobertLongM5 жыл бұрын
I submit to you
@binumathew7213 жыл бұрын
Thank you Leila Is it possible to connect one slicer to Pivot table and Data Table at the same time.
@urbaneplanner4 жыл бұрын
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
@LeilaGharani4 жыл бұрын
Awesome, thank you! I'm glad you like the course.
@jihadalbustanji37603 жыл бұрын
Many thanks for the great videos you share all the times. You are doing an amazing job.
@barunmajumder57396 жыл бұрын
Your magical excel tutorial ...makes professional life easier, thanks
@LeilaGharani6 жыл бұрын
Very happy to hear that Barun! Thanks for dropping by :)
@vipinsingh40474 жыл бұрын
I really love you, I have learnt lot from your videos💯
@calvingouw90023 жыл бұрын
Thank you very much for the tutorial! Is there a way to disable right-click on slicers?
@yanmike52123 жыл бұрын
Thank you for imparting the knowledge.
@javierlainez83767 жыл бұрын
Great tool and so simple. Excellent videos, always!
@LeilaGharani7 жыл бұрын
Thank you Javier.
@gregorymoureau61703 жыл бұрын
Love your work. Learned so much from your vids. Respect ✊.
@ngilsz33 жыл бұрын
All your videos are excellent .. thank u 💙 New informations in this video thanks a lot 💙
@balamuniyandi6 жыл бұрын
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 🙏👍
@yashsomaiya81415 жыл бұрын
That's unique n very treat to anyone's eyes who observes it.
@叶萌-b6d4 жыл бұрын
simple to master , thanks teacher !!
@sinahosseinzadeh7362 жыл бұрын
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.
@frachiar44442 жыл бұрын
Really nice!! 🙂
@sanchezsanchez16683 жыл бұрын
You are a genius
@luisguillermoperezmejia79074 жыл бұрын
Que fantasía. estoy feliz de haberte encontrado. Saludos cordiales desde Medellín Colombia
@jplug932 жыл бұрын
Symbol template.. Cool idea.
@ngedwin61743 жыл бұрын
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??
@evgeniam88825 жыл бұрын
That was a masterpiece!! And this function, Unichar is awesome! I am very excited with this video! Thank you so so much Leila! :)
@LeilaGharani5 жыл бұрын
You're very welcome Evgenia. No one called it a masterpiece before. I like that :)
@himanshudalai10286 жыл бұрын
Thank you Leila. This is a great video & great learning.
@LeilaGharani6 жыл бұрын
You're very welcome! Thank you for your support.
@semperdiscendum74397 жыл бұрын
That was awesome! Thank you so much! Please keep enlightening us!
@LeilaGharani7 жыл бұрын
You're welcome. Will do my best :)
@joinsocial83083 жыл бұрын
Thanks Leila !
@mohitdhanwani55406 жыл бұрын
WOW! Well Explained. Thanks for the video!
@LeilaGharani6 жыл бұрын
You're welcome Mohit.
@mohamedmami24807 жыл бұрын
Absolutely beneficial, thanks a lot Leila. All the best,
@LeilaGharani7 жыл бұрын
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)
@shivanagaraj85167 жыл бұрын
As always very help full. Thanks
@LeilaGharani7 жыл бұрын
You're very welcome.
@phamhoangtien6 жыл бұрын
It's a very nice tip! How can we set the symbol centered inside the button Ma'am?
@LeilaGharani6 жыл бұрын
Until now, there isn't an option that can control that....
@lakshmipathiganesan63323 жыл бұрын
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?
@frachiar44442 жыл бұрын
Just press SHIFT while clicking icons
@eslamfahmy875 ай бұрын
Can u share with us the refrence for symbols which founded in the condition formating (icon)
@ForeverMods3 жыл бұрын
Great tutorials !! Is there a method to centre justify the icons or text in slicers please?
@nagendraprathap96976 жыл бұрын
thank you so much madam, God bless you and yours Family ,
@LeilaGharani6 жыл бұрын
You're very welcome. Thank you very much for your support and your kind comment.
@s.y.daniel21373 жыл бұрын
nice tricks!
@sauravkragrawal4 жыл бұрын
Love this!
@algawzy5 жыл бұрын
Could you please make example for slicer connected to different data tables
@BayuHendra-qe7kg Жыл бұрын
Thank you for your attention and support gablesyou🎉🎉
@robertakwasiadjei82237 жыл бұрын
Great Job Leila
@LeilaGharani7 жыл бұрын
Thank you Robert.
@OzduSoleilDATA7 жыл бұрын
Very very nice!
@LeilaGharani7 жыл бұрын
Glad you like it.
@cmlosaria4 жыл бұрын
Hi Leila, what if I want to use text with symbols in the slicers?
@bricc3227 жыл бұрын
So cool! :) Thank you for sharing.
@LeilaGharani7 жыл бұрын
You're welcome Celia :)
@johannesmp33 жыл бұрын
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
@fionamehta73816 жыл бұрын
Really useful! thank you so much for this.
@LeilaGharani6 жыл бұрын
You're very welcome Fiona.
@alirezamogharabi87336 жыл бұрын
Thanks, very useful. Please introduce some other features in pivot tables, LEILA!
@LeilaGharani6 жыл бұрын
Ok. For sure. Have added this to my list.
@alirezamogharabi87336 жыл бұрын
Leila Gharani Thanks for your attention!
@ub97316 жыл бұрын
Wow...! What a great idea. 👍👍👍
@LeilaGharani6 жыл бұрын
Gives a nice touch to reports. Thanks :)
@diannedrechsler47927 жыл бұрын
So useful!
@LeilaGharani7 жыл бұрын
Glad to hear that!
@rrrprogram86677 жыл бұрын
Nice one liela..thanks
@LeilaGharani7 жыл бұрын
You're very welcome.
@dalekriens13973 жыл бұрын
very interesting
@ahmedbakr31987 жыл бұрын
Thanks A lot Lelia
@LeilaGharani7 жыл бұрын
You're welcome Ahmed.
@mostafa43216 жыл бұрын
Awesome Laila.
@LeilaGharani6 жыл бұрын
Thanks Mostafa.
@potatohead64705 жыл бұрын
Hi Leila, i ve watched all your videos and impressed with you. Is there any way i can contact you i wana ask something
@channel100tube4 жыл бұрын
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
@ExactProBi7 жыл бұрын
awesome trick
@LeilaGharani7 жыл бұрын
Glad you like it :)
@mohitverma81904 жыл бұрын
Awesome
@hosseinhosseinpoor48453 жыл бұрын
thanks thanks
@thevoiceoftruth51165 жыл бұрын
good job
@LeilaGharani5 жыл бұрын
Thank you. Glad you like it.
@karthikmohanraj15427 жыл бұрын
Hi, it's a great learning!!! cld u pls teach us d digital dashboards which includes KPI and forecasting and budgeting examples
@LeilaGharani7 жыл бұрын
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
@rsvn294 жыл бұрын
Too good for anyone...
@alpeshdoshi78277 жыл бұрын
Nice one madam.... thank... Madam can u make videos on Excel VBA... Pls .... Thank you so much...
@LeilaGharani7 жыл бұрын
You're welcome Alpesh. Yes, yes. Videos in progress....
@alpeshdoshi78277 жыл бұрын
Ok.... madam.. N... Thanks for replying....
@jmschroen-hendriks45426 жыл бұрын
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
@LeilaGharani6 жыл бұрын
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.
@shyamn79982 жыл бұрын
I want to make condition in slicer like sal >500 and < 100 like condition to be display in slicer.
@imranmushtaq74456 жыл бұрын
Miss Liela Absolutely Astounding
@imranmushtaq74456 жыл бұрын
You are using multiple commands in a very fast flow
@mohammadasad98907 жыл бұрын
Good job
@LeilaGharani7 жыл бұрын
Thanks Mohammad.
@aksohal7 жыл бұрын
Hii Leila You are the One of the BEST . (Y)
@LeilaGharani7 жыл бұрын
THANK you Ankur!!
@aksohal7 жыл бұрын
Kindly Mail me Some Problems on which i can make practice. Plzz
@sultanrony48265 жыл бұрын
there are any short cut key to up down slicer in excel????
@senthilvelan9904 жыл бұрын
I am not able to import the CSV file Once we set the format the table.pls help to fix the problem.
@vickyrodriguez47792 жыл бұрын
Hi how to freeze this slicer pls share with us
@teoxengineer5 жыл бұрын
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?
@mudassarrahman39426 жыл бұрын
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 ..
@ehsanabbasi94056 жыл бұрын
مرسی خاله لیلا
@prakshalshah12916 жыл бұрын
Hi, is there any way where we can select multiple fields in slicers
@LeilaGharani6 жыл бұрын
Yes - you just have to hold down the control key.
@prakshalshah12916 жыл бұрын
Thanks...
@taherpoonawala77665 жыл бұрын
How to I use column headers as slicers?
@sachinrv16 жыл бұрын
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.
@LeilaGharani6 жыл бұрын
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....
@sachinrv16 жыл бұрын
Thanks for your quick support Leila. Shall try and get back :)
@sachinrv16 жыл бұрын
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")
@LeilaGharani6 жыл бұрын
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 :)
@prasannakulkarni20457 жыл бұрын
Does it work for 2007 also? Cz I didn't find it in 2007 version.
@LeilaGharani7 жыл бұрын
Unfortunately not! Slicers exist from Excel 2010 onwards.
@nagsan20006 жыл бұрын
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
@LeilaGharani6 жыл бұрын
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.
@nagsan20006 жыл бұрын
Leila no it is just one. The weird thing is if you add report filter and then the slicer it works fine
@laurarivera53657 жыл бұрын
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.
@LeilaGharani7 жыл бұрын
Since it's just going to be an estimate, how about using a formula to get the estimate =(days*12)/365 ?
@saumilparadkar86362 жыл бұрын
I could hear you laughing while typing Sex Symbol 😂 🤣😂... Anyways a great content and videos Leila... Keep it up
@hiteshsirohia2 жыл бұрын
you couldn't control your laugh while writing "sex symbol" :D
@trevorbbeairsto7 жыл бұрын
Leila is my secret weapon
@LeilaGharani7 жыл бұрын
:)
@nagsan20006 жыл бұрын
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
@LeilaGharani6 жыл бұрын
I think it depends on your Excel version. I have office 365 - it might not be available in your version....
@nagsan20006 жыл бұрын
Leila Gharani hi I noticed that it is not supported in excel 2010
@nagsan20006 жыл бұрын
is there any other way to get those characters in Excel 2010
@Compexcel3 жыл бұрын
👍
@chillihi4 жыл бұрын
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 Жыл бұрын
❤
@NaftuliSinger3 жыл бұрын
@7:56 When Win+V didn't work yet...
@shreyashshetty75845 жыл бұрын
PUT VIDEO OF TALLY ERP 9 BASIC OR ADVANCE TALLY
@ismailismaili00717 жыл бұрын
Hi i really like your way of teaching thank u so much can I get your email i wanna study online
@LeilaGharani7 жыл бұрын
Hi Ismail - glad you like the videos. You can find the list of my online courses on my website...
@ismailismaili00717 жыл бұрын
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
@LeilaGharani7 жыл бұрын
:) The best thing about Excel is the learning never ends. I'm learning every day.
@ismailismaili00717 жыл бұрын
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 besmilingforever120@gmail.com