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 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 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!
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!
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.
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!
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 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.
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 🎉
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.
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.
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.
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.
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!!
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!
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!!!
🤯🤯🤯 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 🥰
@@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! 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 : )
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.
Haha love that initial comment about getting scared of the formatting and pasting stuff from Google. I had no idea custom formatting was so logical till I saw this video. Thanks heaps!
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.
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 ❤️❤️❤️❤️
أختي الغالية ليلى، شكرا بحجم السماء. بفضل الله ثم بفضل فديواتك اصبحت استخدم الاكسل - اللي كان شيء يخوف وغامض بالنسبه لي-. شكرا مره ثانيه وبارك الله فيك. Keep up the good work
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!
This is so a pleasure to learn from you: first you find topic that is real painful, and with a nice voice, nice pace, and great pedagogy you walk us through. Thank you very much for this gift. This is typically something we need in a hurry and don’t know how and why ;-)
wow!~ so simple yet powerful formatting. Really learnt from you. Thanks. And I must tell you that your voice is so sweet and clear, so comfortable to listen to. Thank you again👍
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 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 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 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.
The way you speak and clearly say each point and logic......is brilliant.
=If(Now()>0,"Leila is best","Earth has stopped rotating")
😘
Leila, long time user of excel , considered expert by my coworkers…. You tips are excellent. See my question about time
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.
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.
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!
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!
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"
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.
Super Video... LG...great explanation. I have seen "n" number of excel videos in UA-cam, among all you are the best teacher for my me.
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
Explaining the basic rules of custom formatting along with the color coding is simply outstanding!
Glad you like it!
I have been using Excel for years and somehow never came across this channel, it's simply amazing.
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 Leila. You are researching every aspect of MS Excel. Hats off to you.
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!
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!
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.
Hello Leila; Thanks very much. I'm enjoying tutorials you provide through your channel. Thanks very much.
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!
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!!
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!
You have the best didactic of all excel teachers !! Tks for sharing these excellent tricks, Leila !
ohhhh thank you Maique & you're very welcome.
Thank you for sharing this. It really means a lot in my office work.
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 :)
Fantastic delivery of material. I found your tutorials very helpful. Thank you!
wow...never knew that custom formatting could be this effective . and thanks for some good tips .cheers
You have the perfect way of teaching training. Love the small bites of information.
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.
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!
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 :)
Amazing information demonstrated with clarity. Thanks so much.
Thank you! I needed to add "+" and "-" in front of some numbers and this was a BIG help!
Beautifully done. The revelation of Excel beauty. Thank you Leila Gharani.
Glad you like it. You're very welcome Peter.
Watching more custom videos during COVID! thanks for the refresher video!
she has impressive talent to explain complex topics.. respect
🤯🤯🤯 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 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!
Leila, I was looking for this IF formula and your style just rocks ... solved my headache as simple as it sounds ))) 🔥
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: ua-cam.com/video/muTLxMjaZww/v-deo.html
Thank you! I have not used Conditional Formatting this way... very refreshing way to use it.
You're welcome. Glad you find it useful.
you are one of the best excel tutor in the world.
Finally a great explanation about custom formatting! Many thanks for posting helpful tutorials!!
Thumbs up from NL,EU very helpful. clear and calm voice. keep on the good work
Thank you Leila. Simple, yet practical tid bits.
THANKS !!!, me encantó, LOVE IT!
This video is a revelation about how good custom formatting can become.
what symbol she write before and after plus
P
Thanks Leila. you are a champ. making a great difference in people's working life.
What kind of sorcery is this. You deserve a like. Got to learn something new today. Thanks leila 😀👍
Thanks for the thumbs up!
Madam Leila Gharani- You are my excel god and Guru. Thanks a lot.
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!
you are one of the greatest teachers.
Very well explained with a clear voice. Thank you.
Leila, you are a gifted presenter with a beautiful mind.
Valuable tip. Thanks for your sharing your knowledge and expertise
This was brilliant and just what I needed for work. Thank you so very much! You are the best Leila!
You're so welcome!
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!
Brilliant custom formatting. just loved it and Thanks Leila Gharani.
My pleasure. Glad you like it.
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.
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 : )
I have been looking for these trick with colors. Thank you so much Leila.
Glad you finally found it :)
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.
I am really enjoying working with excel now. Thanks, lady
That's great. I'm glad I could help with that :)
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.
Haha love that initial comment about getting scared of the formatting and pasting stuff from Google. I had no idea custom formatting was so logical till I saw this video. Thanks heaps!
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...
Just amazing. Its like you are doing magic with Excel. Wow.
Glad to hear that :)
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 ❤️❤️❤️❤️
Hi Leila - this is super helpful! ...really appreciate your dedication to helping Excel users. R
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
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 :)
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
thank you for your video's they are awesome.
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!
أختي الغالية ليلى، شكرا بحجم السماء.
بفضل الله ثم بفضل فديواتك اصبحت استخدم الاكسل - اللي كان شيء يخوف وغامض بالنسبه لي-.
شكرا مره ثانيه وبارك الله فيك.
Keep up the good work
Thank you.
Simple & Easy way of Explaination... Thank You
You are most welcome.
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 :)
you are a good teacher, i learnt many things through your videos
Thank you! I'm very happy to hear this.
I'm learning a lot from you, Beautiful soul.
This is so a pleasure to learn from you: first you find topic that is real painful, and with a nice voice, nice pace, and great pedagogy you walk us through.
Thank you very much for this gift.
This is typically something we need in a hurry and don’t know how and why ;-)
wow!~ so simple yet powerful formatting. Really learnt from you. Thanks.
And I must tell you that your voice is so sweet and clear, so comfortable to listen to.
Thank you again👍
You're very welcome. Glad you find the tutorial helpful.
This is a new concept for me. Thanks a lot. I like it better than conditional formatting.
You're welcome. So do I.
Thank you so much for a very informative and straight forward video--
My pleasure! Glad you liked it.
Leila, Awesome trick. This is really easy to use instead of conditional formatting. Thanks & Regard.
You're welcome Sanjay. I find it easier too :)
YOU ARE AMAZING!!! You save my work! Tks a lot!
Glad to hear that!
This video helped me today. thank you Leila.
I'm so glad!
It is simple but very useful in any important presentation. From those small and simple it is helping lectures to influence audiences. Thanks a lot!
Thank so much for the very informative video, its helpful a lot.. you really such a one-in a million..! thumbs up
Complicated but simply explained video. Well done.
Thank you. Agree - it takes a while to get a hang of custom formatting....
Thank you Leila for these grand tutorials. You are a treasure.
Thanks for your sharing. The content is very useful.
This is what I have been searching for. Thanks a ton!
Huh🤔, use excel a lot in office,, still cannot think of what you have done with custom formatting 👌 ... thanks , its amazing ...
Excellent, this is very useful. Thanks