Hi Leila for some reason I am not able to download this file. I got the email but when I click on download I am unable to get the file. I tried using two different emails. Can you help please? Thank you
I wanted to extend my gratitude for the excellent job you did in the video on "Four SMART Ways to Use Custom Formatting Instead of Conditional Formatting in Excel." Your explanation was clear and insightful, and it truly made a difference. You are an Excel evangelist, and your passion for teaching shines through!
I can’t believe I’m sitting here at home on my own time watching a video about Excel that makes me excited to get to work and see what I can do with Custom Formatting - thank you for a clear explanation, I had never really investigated the power of this tool in the past and can’t wait to see what I can do with it!
I just started a new job as a financial manager and your video are a tremendous help. There are lots of teachers out there but your the best hands down. Thank you!
This blew my mind. I've been using a combination of conditional formatting and the TEXT function and concatenating strings and all this time I could have simply used custom format!! OMG. Thank you so much. You're awesome.
THANK YOU for being the person to finally De-Mystify the Custom Format options in Excel. For years I have been a little intimidated by how this actually works, but YOU explained it perfectly and in a very useful & time efficient manner. Great job!
Wow. I've been curious about custom formatting for a while, AND I've recently been banging my way through conditional formatting. You've literally just saved me hours of work, and opened up a whole new function of Excel that I didn't know existed!
Wow Lelia, I always used to wonder the logic of the custom formatting. With this tutorial you have made it so easy to understand. You are very correct, this custom formatting is awesome, less time consuming and less complicated compared to conditional formatting. Time and again to say, I am a great fan of the way you explain complex excel concepts... GREAT JOB DEAR...
Thank you so much Sachin. Agree - custom formatting is indeed a very powerful feature. In the next video, we'll take a step further and look at how we can get custom formatting to handle thresholds, like conditional formatting can :)
Thank you Leila for not only training us in a lucid and a fun manner but also keep trying to update us with the latest tricks and Techniques.I am in real continuously being benifited to be the part of your course @ Udemy.
wow -- very nice. i had viewed ~8 vids, avoiding this one with a 'pretty face. turns out, u provided the best content, rhythm in explaining the content, and u explain both, basic and complex processes within the lesson. then i explored the library of great content and viewed your story -- triple wow. great job Leila -- thank you.
A short cut for getting the up triangle and down triangle is, for UP - ALT+30 (on numeric keypad), for down ALT+31 (on numeric keypad). This is quicker and easier to remember than inserting symbols
Remember she was teaching syntax, so in this example and ease of understanding without it becoming to overwhelmingly or confusing it was better to use insert symbols. However after the meaning concept was achieve using keyboards would be ideal 🎉
I had taught Excel for years, and knew about the power of custom formatting; but I had only taught it as useful for adding text to numbers, such as "sf" for square foot or "/mth" for per month. I was honestly not thinking I would get a much of a lesson with this video, BUT. I feel like I've been driving my Ferrari custom formatting without every getting out of first gear....I've just enjoyed a thrilling joy-ride with someone who knows how to take that Ferrari and run it thru the gears. Thanks!
Oh my word. Why am I so late here. Leila I'm a big fan of yours. The way you present the videos is excellent. You made me believe that I can learn more. I never thought I will learn excel more deeply. But now I guess I can do it.
Thanks, like a lot of others I was sort of aware that custom formatting existed but hadn't played round with it. For some time I've been wanting the '-' to show up for zero values when using the currency symbol with negatives in red, to hide zero value to a certain degree. Now I have the answer!!
My respected virtual teacher! The logic of custom formatting always remained a mystery for me, but this video revealed this secret now. Thank you so much. May you live long on youtube to share knowledge for spreadsheet lovers.
@@LeilaGharani I myself and few others are already considering your udemy courses for next month. I do have some suggestion for next topic video, not sure if you take youtube viewers request and consider them for your next youtube videos. I am sorry if you dont. But thanks a lot for all your time and effort.
Thank you Rohan for your support. Yes, I do take suggestion of course - Here's my process for creating videos: ruclips.net/video/muTLxMjaZww/видео.html
I wanted to thank you and mention for other viewers that I immediately discovered this also works well with emoji. Win+. (period) brings up the emoji keyboard. Because sometimes a facepalm is the correct symbol.
Thank you so much Leila. Your tutorial helped me create my Stock Portfolio and Tracker on Excel. Trust me those triangles look super cool on spreadsheet.
I just can't believe I learn the answer to this timeless question about the syntax of custom formatting with only 16 minutes. Thank you for the video!!!
أختي الغالية ليلى، شكرا بحجم السماء. بفضل الله ثم بفضل فديواتك اصبحت استخدم الاكسل - اللي كان شيء يخوف وغامض بالنسبه لي-. شكرا مره ثانيه وبارك الله فيك. Keep up the good work
Can you make whole cells a specific colour using this approach? Or do you have to use symbols? Given the performance boost, I want to start using custom formatting where I can - eradicating the need to use conditional formatting.
Thank you! I've been using Excel since first version and use format cell but used conditional formatting because I never took the time to learn custom format. This just saved performance of a large file I'm working on with lots of formatting.
Thank you Alberto for your comment! I'm very glad you find the content useful. I also learn a lot from the Excel online community here so everyone wins : )
Nicely presented Leila, thank you! I am now able to replace Conditional formatting with Custom formatting, so now my monster workbook looks and performs so much better!
You have explained so well Leila! Thank you so much! My excel skill is quite basic and I will continue to watch all the videos that you made and learned them all! Looking forward to seeing more videos from you! You are such a great teacher.
🤯🤯🤯 Woooow! I've always wondered what those codes meant. And this is super cool! Super easy to understand. Thanks thanks! It's only last week I've found your channel. And I've been binging since! I've also recommended it to my colleagues 🥰
I aplode you for your work, you are very dedicated, and your content has been very useful for me, and for many other people I'm sure. Thank you a lot ❤️❤️❤️❤️
Grab the file I used in the video from here 👉 pages.xelplus.com/custom-formatting-file
Hi Leila for some reason I am not able to download this file. I got the email but when I click on download I am unable to get the file. I tried using two different emails. Can you help please? Thank you
Hi Leila , I am unable to download the workbook. could you please check .
unable to download the workbook.
I wanted to extend my gratitude for the excellent job you did in the video on "Four SMART Ways to Use Custom Formatting Instead of Conditional Formatting in Excel." Your explanation was clear and insightful, and it truly made a difference.
You are an Excel evangelist, and your passion for teaching shines through!
Great to hear!
I have used excel for 25yrs and you are showing me simple things like the use of the * in custom formatting that I was never aware of.
Bravo!
I'm glad you find them useful :)
I can’t believe I’m sitting here at home on my own time watching a video about Excel that makes me excited to get to work and see what I can do with Custom Formatting - thank you for a clear explanation, I had never really investigated the power of this tool in the past and can’t wait to see what I can do with it!
Same here 🙌
I have been teaching Excel for many years but when I saw your videos I really impressed your teaching style. The way you instruct is really awesome.
Thank you Yasir for the kind words.
I just started a new job as a financial manager and your video are a tremendous help. There are lots of teachers out there but your the best hands down. Thank you!
Wow, thank you. Good luck with the new job!
The way you speak and clearly say each point and logic......is brilliant.
=If(Now()>0,"Leila is best","Earth has stopped rotating")
😘
This blew my mind. I've been using a combination of conditional formatting and the TEXT function and concatenating strings and all this time I could have simply used custom format!! OMG. Thank you so much. You're awesome.
You're very welcome Luciano! Glad you find this useful.
THANK YOU for being the person to finally De-Mystify the Custom Format options in Excel. For years I have been a little intimidated by how this actually works, but YOU explained it perfectly and in a very useful & time efficient manner. Great job!
Glad it was helpful! Thank you for the nice feedback.
Wow. I've been curious about custom formatting for a while, AND I've recently been banging my way through conditional formatting. You've literally just saved me hours of work, and opened up a whole new function of Excel that I didn't know existed!
Glad I could help!
Wow Lelia,
I always used to wonder the logic of the custom formatting. With this tutorial you have made it so easy to understand. You are very correct, this custom formatting is awesome, less time consuming and less complicated compared to conditional formatting. Time and again to say, I am a great fan of the way you explain complex excel concepts... GREAT JOB DEAR...
Thank you so much Sachin. Agree - custom formatting is indeed a very powerful feature. In the next video, we'll take a step further and look at how we can get custom formatting to handle thresholds, like conditional formatting can :)
Sure looking forward to it...
"Commnent id"
Leila, long time user of excel , considered expert by my coworkers…. You tips are excellent. See my question about time
Thank you Leila for not only training us in a lucid and a fun manner but also keep trying to update us with the latest tricks and Techniques.I am in real continuously being benifited to be the part of your course @ Udemy.
Thank you Munendra for your support! I'm very glad to hear you find the content useful and easy to follow.
Explaining the basic rules of custom formatting along with the color coding is simply outstanding!
Glad you like it!
wow -- very nice. i had viewed ~8 vids, avoiding this one with a 'pretty face. turns out, u provided the best content, rhythm in explaining the content, and u explain both, basic and complex processes within the lesson. then i explored the library of great content and viewed your story -- triple wow. great job Leila -- thank you.
Thank you Peter for your kind comment. I'm glad you decided to click!
After many many years of working with Excel I finally understand the idea of custom formatting. Thank you!!!
Great to hear Henric!
A short cut for getting the up triangle and down triangle is, for UP - ALT+30 (on numeric keypad), for down ALT+31 (on numeric keypad). This is quicker and easier to remember than inserting symbols
Thanks so much for this - my Symbols dialog was playing up so could only access normal arrows 🎉
Remember she was teaching syntax, so in this example and ease of understanding without it becoming to overwhelmingly or confusing it was better to use insert symbols. However after the meaning concept was achieve using keyboards would be ideal 🎉
thanks
Thank You Leila. You are researching every aspect of MS Excel. Hats off to you.
you are one of the greatest teachers.
I had taught Excel for years, and knew about the power of custom formatting; but I had only taught it as useful for adding text to numbers, such as "sf" for square foot or "/mth" for per month. I was honestly not thinking I would get a much of a lesson with this video, BUT. I feel like I've been driving my Ferrari custom formatting without every getting out of first gear....I've just enjoyed a thrilling joy-ride with someone who knows how to take that Ferrari and run it thru the gears. Thanks!
Glad you found something useful, Dan!
Oh my word. Why am I so late here. Leila I'm a big fan of yours. The way you present the videos is excellent. You made me believe that I can learn more. I never thought I will learn excel more deeply. But now I guess I can do it.
Thank you so much!
THANKS !!!, me encantó, LOVE IT!
THANKS SO MUCH LEILA. I LOVE YOUR VIDEOS. ITS SO EDUCATING
I'VE BEEN SUBSCRIBED TO UR CHANNEL FOR OVER A YEAR NOW
thank you for your video's they are awesome.
I have been using Excel for years and somehow never came across this channel, it's simply amazing.
Thank you for sharing this. It really means a lot in my office work.
Thanks, like a lot of others I was sort of aware that custom formatting existed but hadn't played round with it. For some time I've been wanting the '-' to show up for zero values when using the currency symbol with negatives in red, to hide zero value to a certain degree. Now I have the answer!!
My respected virtual teacher! The logic of custom formatting always remained a mystery for me, but this video revealed this secret now. Thank you so much. May you live long on youtube to share knowledge for spreadsheet lovers.
You're very welcome!
you are one of the best excel tutor in the world.
she has impressive talent to explain complex topics.. respect
Super Video... LG...great explanation. I have seen "n" number of excel videos in RUclips, among all you are the best teacher for my me.
You have the best didactic of all excel teachers !! Tks for sharing these excellent tricks, Leila !
ohhhh thank you Maique & you're very welcome.
Lovely.. These are some techniques which nobody teaches to make reports clean and impressive. Thanks a lot for all the efforts you take to educate us.
Thank you Rohan for your comment and support! I'm glad you like the tutorials.
@@LeilaGharani I myself and few others are already considering your udemy courses for next month. I do have some suggestion for next topic video, not sure if you take youtube viewers request and consider them for your next youtube videos. I am sorry if you dont. But thanks a lot for all your time and effort.
Thank you Rohan for your support. Yes, I do take suggestion of course - Here's my process for creating videos: ruclips.net/video/muTLxMjaZww/видео.html
I must say it is great to learn something new about excel everyday - thanks to you this is really possible!
I'm happy to hear that Srecko!
You have the perfect way of teaching training. Love the small bites of information.
wow...never knew that custom formatting could be this effective . and thanks for some good tips .cheers
Hello Leila; Thanks very much. I'm enjoying tutorials you provide through your channel. Thanks very much.
I wanted to thank you and mention for other viewers that I immediately discovered this also works well with emoji. Win+. (period) brings up the emoji keyboard. Because sometimes a facepalm is the correct symbol.
Hey,
I have been working with excel for 14+ years. What I came to know today, I have never thought of ...
Great tricks and thanks for the tips. ..
I also come across new stuff in Excel all the time... the fun doesn't end :)
Thank you Leila. Simple, yet practical tid bits.
Watching more custom videos during COVID! thanks for the refresher video!
You are a genius. Words cannot express my gratitude. Much appreciated.
Thank you so much Leila. Your tutorial helped me create my Stock Portfolio and Tracker on Excel. Trust me those triangles look super cool on spreadsheet.
Thanks for the video. I am an amateur and u made it all look so simple and ez to do. Thank you
Glad it was helpful!
Thank you! I needed to add "+" and "-" in front of some numbers and this was a BIG help!
Finally a great explanation about custom formatting! Many thanks for posting helpful tutorials!!
I just can't believe I learn the answer to this timeless question about the syntax of custom formatting with only 16 minutes. Thank you for the video!!!
You're welcome!
Thank you! I have not used Conditional Formatting this way... very refreshing way to use it.
You're welcome. Glad you find it useful.
Amazing information demonstrated with clarity. Thanks so much.
This video is a revelation about how good custom formatting can become.
what symbol she write before and after plus
P
Fantastic delivery of material. I found your tutorials very helpful. Thank you!
Beautifully done. The revelation of Excel beauty. Thank you Leila Gharani.
Glad you like it. You're very welcome Peter.
Leila, I was looking for this IF formula and your style just rocks ... solved my headache as simple as it sounds ))) 🔥
Very well explained with a clear voice. Thank you.
Thanks Leila. you are a champ. making a great difference in people's working life.
أختي الغالية ليلى، شكرا بحجم السماء.
بفضل الله ثم بفضل فديواتك اصبحت استخدم الاكسل - اللي كان شيء يخوف وغامض بالنسبه لي-.
شكرا مره ثانيه وبارك الله فيك.
Keep up the good work
Thank you.
It's really amazing what you can achieve in the Custom section of the Format Cells window. Wasn't aware you could do all that!
I wasn't aware either for the longest time :)
Can you make whole cells a specific colour using this approach? Or do you have to use symbols? Given the performance boost, I want to start using custom formatting where I can - eradicating the need to use conditional formatting.
You'll have to use symbols --- formatting like *█▌ would repeat this symbol till the cell is full and you could color this the way you want...
Brilliant custom formatting. just loved it and Thanks Leila Gharani.
My pleasure. Glad you like it.
I have been looking for these trick with colors. Thank you so much Leila.
Glad you finally found it :)
Madam Leila Gharani- You are my excel god and Guru. Thanks a lot.
Thank you! I've been using Excel since first version and use format cell but used conditional formatting because I never took the time to learn custom format. This just saved performance of a large file I'm working on with lots of formatting.
Great to hear Shawn!
This is a new concept for me. Thanks a lot. I like it better than conditional formatting.
You're welcome. So do I.
Valuable tip. Thanks for your sharing your knowledge and expertise
I am really enjoying working with excel now. Thanks, lady
That's great. I'm glad I could help with that :)
Leila, you are a gifted presenter with a beautiful mind.
Awesome and brilliant. Never seen such simple and useful trick in custom formatting. Way to use compare to conditional formatting. U r super.👏👏👏👏👏
Glad you like it :)
Just amazing. Its like you are doing magic with Excel. Wow.
Glad to hear that :)
Every video you produce is outstanding!! I always learn something and your teaching style is perfect. Thank you for sharing your vast knowledge.
Thanks for the kind feedback Scott. I'm glad you like the videos.
I always learn something new in Excel from your videos. Thanks for sharing!
My pleasure David. I'm glad there is something new in there for you.
This video helped me today. thank you Leila.
I'm so glad!
you are a good teacher, i learnt many things through your videos
Thank you! I'm very happy to hear this.
You are amazing Leila !!!!
Dear Miss Gharani,
your lessons are truly EXCEL-lent. Thank you so much for sharing your knowledge with such clarity and generosity.
Thank you Alberto for your comment! I'm very glad you find the content useful. I also learn a lot from the Excel online community here so everyone wins : )
This is what I have been searching for. Thanks a ton!
I'm learning a lot from you, Beautiful soul.
Nicely presented Leila, thank you! I am now able to replace Conditional formatting with Custom formatting, so now my monster workbook looks and performs so much better!
Very happy to hear that Bob :)
This was brilliant and just what I needed for work. Thank you so very much! You are the best Leila!
You're so welcome!
this is a fantastic video, I was searching for a proper custom formatting teaching from years... thanks a ton.. :)
Glad you find this useful! You're very welcome :)
Leila Gharani many thanks
You have explained so well Leila! Thank you so much! My excel skill is quite basic and I will continue to watch all the videos that you made and learned them all! Looking forward to seeing more videos from you! You are such a great teacher.
It's great you are dedicated to learning new things. I'm glad to have you here.
Brilliant as ever.
Thank you Leila for these grand tutorials. You are a treasure.
Simple & Easy way of Explaination... Thank You
You are most welcome.
What kind of sorcery is this. You deserve a like. Got to learn something new today. Thanks leila 😀👍
Thanks for the thumbs up!
Thumbs up from NL,EU very helpful. clear and calm voice. keep on the good work
🤯🤯🤯 Woooow! I've always wondered what those codes meant. And this is super cool! Super easy to understand. Thanks thanks!
It's only last week I've found your channel. And I've been binging since! I've also recommended it to my colleagues 🥰
Best Video explaining Custom Formatting
Glad you think so!
Hi Leila. i didn't know it could be possible to put a value in opposite side than symbol in the same cell ! thank you for link about the colors.
Glad you found this helpful :)
This is so fantastic! Worth the time viewing this video ! Awesome !
Thank you, I'm really glad you like it!
thank you for your great work
Complicated but simply explained video. Well done.
Thank you. Agree - it takes a while to get a hang of custom formatting....
Awesome tutorial as usual....
Thank you so much for a very informative and straight forward video--
My pleasure! Glad you liked it.
Great video & great explanation!
thank you Vida.
i'm loving this channel every single day !!!!! exactly what I was looking for and the execution from Leila is right on target. Thank you
Awesome! Thank you!
Excellent, this is very useful. Thanks
Thanks Leila Gharani. I am really impressed.
I aplode you for your work, you are very dedicated, and your content has been very useful for me, and for many other people I'm sure.
Thank you a lot ❤️❤️❤️❤️
YOU ARE AMAZING!!! You save my work! Tks a lot!
Glad to hear that!
Love your videos Leila. Thank you. Keep it up!!!
I did know how to custom format positive and negative values from an infographic tutorial of yours. But this is beyond my imagination. Thank you