Your videos are simple and easy to understand. Its the best excel channel on youtube so far. Please continue to load more exciting videos. I am in love with them!!
@@LeilaGharani You should join our next Excel-Stammtisch (meetup) in Vienna. It's a great exchange of ideas and knowledge we're doing regulary in some towns like Basel, Munich, Cologne and Essen.
Leila your videos are by far the best I have seen. It so easy to learn watching them. Please don't stop making them. Do you have any Pivot table videos in the works?
Thank you for the kind words. Currently, I have 2 videos related to Pivot Tables. I cover them in more detail in my advanced Excel course - but I'll add pivot table basics to my list for RUclips as well. Thanks for the suggestion.
Teacher, Ms. before I just looking for a good video that helps me improve my excel skill, after I started watching your vdo now I feel strange with your voice, I love your voice, I am crazy with you😍😍😍
Just want to say your video's are really good. Not to much information but also not to little, so just right and brought in a clear tone of voice. Thanks for a job well done ! I considered myself as someone who could also work quite well with excel, but thanks to you I already learned some new things and also got some new ideas to adjust my tables. Thanks, and please go on with the posts.
Nice use of the function option in Conditional Formatting! I like to use it to highlight whole rows based on single column values. For example making a row background light red when the status column is "Late".
Thank you Madam, in every video, you are doing a wonderful work/trick/tip. You are great indeed, and really an asset to our Excel lover/addict/user community. Waiting for some more useful tips/tricks/innovations/ideas from my beautiful, brilliant Excellent Excel Teacher.
This video has been so easy and understandable bcoz leila gharani is with us.......thanks a lot madam.....your style of teaching and presentation is very very good. I am a great fan of ur excel videos. Best of luck...
I love your videos; they're so clear and easy to understand. Plus, you've got the clearest and most understandable visuals of any Excel videos I've seen! Have you done any videos on Worksheet Change Events? I've got a co-worker with a problem that I THINK can be solved with Worksheet Change, but I don't know enough about it to actually implement it. I've watched a few videos on it, but none of them did my the least bit of good; I'm sure if YOU presented it, it'd make sense.
if you the table specified, you can also in the formula with the table name working. Example: =IF(C4="Total Sales",SUM(table_Apps[Sales]),COUNTA(table_Apps[Apps])). Is dynamic and clearer for large tables.
3:40, “I’m going to directly click on C4”. I am usually a lot more careful when dealing with C4. I tend to treat C4 with the respect it deserves, along with others like range M1:A1, B2, B29, F35 and many other dangerous parts of the spreadsheet. Ok enough of that. In the last year I have used a spreadsheet populated with about 6000 rows of data. There are about twenty columns that contain formula that are fairly complicated. I am also using 20 conditional formatting rules to set background color on the cells to make it easier to read and edit the data. Two co-workers that are helping to populate the spreadsheet started complaining that excel is locking up when they do simple operations. It took me a day to figure out that the conditional formatting rules had become fragmented and increased in quantity from 20 to around 200. When I finally got them fixed, the spreadsheet was quick again and the saved file size reduced from 1.5mb to 0.5mb. The cause of the fragmentation was the amount of copy and paste operations, where we were inserting new rows and pasting data, quietly causing more conditional formatting rules to be made. Since the original rules already apply to the cells, pasting creates a duplicate set of rules. Copying those cells and pasting them elsewhere doubles the number of rules again. When a version of the spreadsheet got corrupted again, I was able to clean it up easily by deleting all the rules (which caused excel to hang for half an hour), and paste in some cells from the good spreadsheet to bring in the 20 rules. It would be nice if excel had a better way to edit conditional formatting rules, like xml import /export or something.
Hi Leila All of your videos are always i^2, impressive and informative. Good to know that conditional formatting over rides the usual cell formatting like bold / italics etc. However the video that I really liked is the one about formatting using usual Ctrl+1. Cheers
Thank Leila, the problem with this solution is that it does not work on graphs, graph data series will be shown with the original number format, but if I use a custom format, it will be reflected correctly in the data series in the graph, but I don't know how to use custom format with a condition, i.e., if this cell equals that, this show number in millions.
Leila Mam: I'm a a great fan our yours,the you describe in details,by the way , I'm a civil engineer in construction field, could you pl, describe related tutorials like works plan, counting on preparation on materials cost item-wise, prepare their cost & finally abstract of cost, thank you
Can you please help me to copy a conditionally formatted cell with 3 condidions into 120 rows. But without having to go to each cell and change the row number one by one
Excellent video! Never thought of this method. Question though: in cell C5 where you have the IF function, could you also nest a TEXT function (plus the dollar format) so that if "Total Sales" is selected, the returned value will be formatted in dollars (currency for example). Hopefully that make sense!
Hi Mam Any video on task scheduler in detail as I am looking for tasks to run automatically at scheduled time which will help me in reducing some man-hours
“If you declare with your mouth “Jesus is Lord,” and believe in your heart that God raised Him from the dead, you will be saved” (Romans 10:9). Now is the time to accept Jesus as your personal Lord and Savior. Obey His commands and repent of your sins because Jesus is coming back soon. Tomorrow isn’t promised.
Great explanation , my question is how to make a rule so that the formatting of a cell let's say G4 is determined and changed based on 2 possible word (apple or Orange) in another cell B4 (same row) , and that would be the rule for the entire colomn G and B ?for example if B4 is orange then change the color of G4 to red and if it's B4 is apple then change G4 to green , Much appreciated if you give the answer .
I love the quality of your videos, biside excel you shuold do some videos about how to make a nice video like yours, which camera do you use, which mic do you use , and some tutorials how to edit video production... thank you ( sorry for my english)
Thank you Gerardo. I've listed my gear here: www.xelplus.com/resources/#gear - I'd love to do videos on editing, setup etc. Maybe in the future I will :) Thank you for your comment and suggestion. You have a wonderful channel yourself.
hi, love your work and thank you for sharing your time and videos, I have a question, I need to add a word in a different cell when it hits a certain time of day but cant seem to work it out. like when it is 2:30 pm the cell will say afternoon shift and if its before this time it will say day shift. thanks for any help you can give me.
When I was working with "Conditional formating" and then copying to other cells I remember I had problem with these relative and absolute addresses. Unfortunatelly I do not remember what it was. But I am avoiding it since...
It's actually better to avoid conditional formatting wherever you can - too much of it, slows down your spreadsheet. As you've discovered, condtional formatting can be really tricky regarding the absolute and relative formatting as you need to write the rule from the point of view of the first cell...
Hello Mem I have below query, How shell i do color scale conditional formatting in entire table formatted raw by every alternative column. Also any future raw or column to be added the it also should take similar formatting in auto mode. Thanking you in advance. Regards Bharat
Hello. Grat channel I love it. Been Learning a lot from it. I nead to conditional format a form meaning a cube or a circle. My objective is like the picture you develop but with formats, can it be done? regardas Hernan Cordero
maybe i'm doing something wrong, but when i create my table.. it doesn't include additional data.. i have to manually increase my ranges.. any ideas? using office 365
I have been doing exactly that. it does create the table but the table does not seem to be dynamic. if i type in a new row, it doesn't extend the table.
At 6:10 it looks like you lost the BOLD format when you select “Count of Apps”. I didn’t see you change anything. Did making the data a table or adding additional data to the table cause that? Did you notice it? Thank you!
You caught an interesting bug here. If I use table referencing the bold stays when I add new data to the table. If I don't use table referencing and want the bold to stay when I add new data, I need to add a new conditional format that makes the cell bold if the selection cell is "count of apps".
Mam, i recently came to know about your channel, can data entry in excel can be made directly with voice (using cortana or Google assistant)? , it can save hours together... Found one source called officeautomata.Com but he stopped doing videos last year
Can I count the number of words and characters and move to a new line when you finish selecting the cell specified by VBA Excel as in this example? wordcounter.net/
Anyone know how to setup an conditional format to highlight (i.e. format) the 1st unique rows of organised table? Thought I would try my luck here as I can not find how to do this anywhere Example: A B C 1 USA Fred 2019 Sales 2 USA Fred 2020 Budget 3 USA Fred 2020 Sales 4 5 USA Ted 2020 Budget 6 USA Ted 2020 Sales So in this example I would like to format row 1 and row 5 only as they are the 1st unique rows respectively. There will be some blank rows inbetween that should be ignored. I thought I the following link was the answer, but it does not seem to achieve what I need, but might give some reference: www.masterdataanalysis.com/ms-excel/7-tips-deal-duplicates-ms-excel/#highlight_four Thanks for any help in advance.
Madam u have given a brief of what can be done in excel in such a nice way as i have never Thought
Hatts off for u making this video😇😇😇
Your videos are simple and easy to understand. Its the best excel channel on youtube so far. Please continue to load more exciting videos. I am in love with them!!
Your video’s are really understandable
You deserve thumbs up all the time. God bless you Leila
I'm publishing Excel-tutorials since 2010, but I missed to show this simple but brilliant trick in my German channel. Thanks a lot!
Thank you Andreas! You have a wonderful Excel channel.
@@LeilaGharani You should join our next Excel-Stammtisch (meetup) in Vienna. It's a great exchange of ideas and knowledge we're doing regulary in some towns like Basel, Munich, Cologne and Essen.
Sounds good :) When do you hold one in Vienna?
useful and well explained, in a format which is pleasant to watch and listen.
Glad you think so!
You are d best teacher in excel world... thankx a lot laila...
That's very kind! Thank you bakthapuri.
OMG! God bless your heart! Was going crazy trying to figure this out. Thank You!
Leila your videos are by far the best I have seen. It so easy to learn watching them. Please don't stop making them. Do you have any Pivot table videos in the works?
Thank you for the kind words. Currently, I have 2 videos related to Pivot Tables. I cover them in more detail in my advanced Excel course - but I'll add pivot table basics to my list for RUclips as well. Thanks for the suggestion.
Teacher, Ms. before I just looking for a good video that helps me improve my excel skill, after I started watching your vdo now I feel strange with your voice, I love your voice, I am crazy with you😍😍😍
Learned good use of IF function along with custom formatting, thanks a lot Leila you are a fabulous teacher :)
Glad you like it Naved!
Just want to say your video's are really good. Not to much information but also not to little, so just right and brought in a clear tone of voice. Thanks for a job well done ! I considered myself as someone who could also work quite well with excel, but thanks to you I already learned some new things and also got some new ideas to adjust my tables. Thanks, and please go on with the posts.
Thank you Tom for your feedback. I'm glad you like the tutorials :)
Hi, You are the best Excel Teacher Leila.......
Wow, thanks for the compliment!
Hey congrats! Leila soon you are going to get RUclips sliver play button and offcourse you deserve it too.
Thanks Sachin, I did get it in the meantime actually! I'm very grateful for this community here!
I again can say . Your are superbly fantastic
Thank you so much 😀
Very happy and enjoy watching your lessons. You are really great
Love your videos !
Just purchased 4 of your courses!
Looking forward to learn from you :)
Thank you Henrik! Hope you find a lot of value in the courses. Looking forward to your feedback.
thanks Lelia valuable information from the queen.
Nice use of the function option in Conditional Formatting! I like to use it to highlight whole rows based on single column values. For example making a row background light red when the status column is "Late".
Love you, Leila. So informative.
Thank you Madam, in every video, you are doing a wonderful work/trick/tip. You are great indeed, and really an asset to our Excel lover/addict/user community. Waiting for some more useful tips/tricks/innovations/ideas from my beautiful, brilliant Excellent Excel Teacher.
Thank you very much Gopala for watching, commenting & thumbs up. Really appreciate your support.
This video has been so easy and understandable bcoz leila gharani is with us.......thanks a lot madam.....your style of teaching and presentation is very very good. I am a great fan of ur excel videos. Best of luck...
I appreciate the kind words! Glad you like the videos.
Very interesting thank you for sharing laila
You're very welcome Mehdi. Thanks for watching.
Wonderful...Many thanks Leila!
You're very welcome Zahid :)
I love your videos; they're so clear and easy to understand. Plus, you've got the clearest and most understandable visuals of any Excel videos I've seen!
Have you done any videos on Worksheet Change Events? I've got a co-worker with a problem that I THINK can be solved with Worksheet Change, but I don't know enough about it to actually implement it. I've watched a few videos on it, but none of them did my the least bit of good; I'm sure if YOU presented it, it'd make sense.
if you the table specified, you can also in the formula with the table name working. Example: =IF(C4="Total Sales",SUM(table_Apps[Sales]),COUNTA(table_Apps[Apps])).
Is dynamic and clearer for large tables.
Great video. Thank you
My pleasure Ben. Glad you like it.
Hi Leila - Simply rule yet very effective, thank you awesome tutorial
Glad you like it!
Great one Leila.. your videos are always creative and useful. Nice to add this one to my bag of EXCEL tricks. Thanks and Thumbs up!
Thank you Wayne for the comment and the thumbs up!
Nice one Leila. Awesome tip. Thanks.
You're welcome Monte. Thanks for dropping by.
Never thought of this one thank you, Leila,
You're welcome Mostafa. This was actually a question I go in the comments once :)
Great video. Thanks
Glad you like it Fabricio.
Excellent! Thanks!
Nice 👍🏻 Excel Learning session
Very useful indeed. Keep up the good work Leila!
Thanks alot
Thank you I am very interested with your videos
Thanks for the great video!
You're fabulous! thank you for sharing!
Awesome, Nice presentation Madam
You're very welcome Abu Nasreen.
Great as usual 👍👍👍💐💐💐💐💕💕💕💕
3:40, “I’m going to directly click on C4”. I am usually a lot more careful when dealing with C4. I tend to treat C4 with the respect it deserves, along with others like range M1:A1, B2, B29, F35 and many other dangerous parts of the spreadsheet. Ok enough of that.
In the last year I have used a spreadsheet populated with about 6000 rows of data. There are about twenty columns that contain formula that are fairly complicated. I am also using 20 conditional formatting rules to set background color on the cells to make it easier to read and edit the data. Two co-workers that are helping to populate the spreadsheet started complaining that excel is locking up when they do simple operations. It took me a day to figure out that the conditional formatting rules had become fragmented and increased in quantity from 20 to around 200. When I finally got them fixed, the spreadsheet was quick again and the saved file size reduced from 1.5mb to 0.5mb. The cause of the fragmentation was the amount of copy and paste operations, where we were inserting new rows and pasting data, quietly causing more conditional formatting rules to be made. Since the original rules already apply to the cells, pasting creates a duplicate set of rules. Copying those cells and pasting them elsewhere doubles the number of rules again.
When a version of the spreadsheet got corrupted again, I was able to clean it up easily by deleting all the rules (which caused excel to hang for half an hour), and paste in some cells from the good spreadsheet to bring in the 20 rules.
It would be nice if excel had a better way to edit conditional formatting rules, like xml import /export or something.
Awesome!!!!
Hi Leila
All of your videos are always i^2, impressive and informative. Good to know that conditional formatting over rides the usual cell formatting like bold / italics etc. However the video that I really liked is the one about formatting using usual Ctrl+1. Cheers
Very Nice Video Mam Bundle of Thanks
You're very welcome Khalid. Thank you for dropping by :)
Awesome tips thanks
You're welcome Rahul :)
Mis Leila please let me know more about Dynamic Arrays؛ we're love your videos.
Yes - sure :) I'll add more videos in the next months. I'm glad you like the videos :)
Thank you for the tutorial, useful lesson :)
I'm glad you like it. Thank you for the support.
Fantastic
Nice video love you.....
THANKS FOR THIS VIDEO MAM... YOU ARE SO SWEET
very nice, thank you.
thanks.
thanks for sharing, very nice video.
Thanks Laila, it's so awesome
You're welcome Lofty. Glad you find it useful.
My question is: is there something similar in google sheets? Thank you for the video anyway, It's really simple to understand
wise mam i like your videos.
Thanks lots.
can i get the different colors for different duplicate values through a single condition?
Excellent
Thank you
Thank Leila, the problem with this solution is that it does not work on graphs, graph data series will be shown with the original number format, but if I use a custom format, it will be reflected correctly in the data series in the graph, but I don't know how to use custom format with a condition, i.e., if this cell equals that, this show number in millions.
Leila Mam: I'm a a great fan our yours,the you describe in details,by the way , I'm a civil engineer in construction field, could you pl, describe related tutorials like works plan, counting on preparation on materials cost item-wise, prepare their cost & finally abstract of cost, thank you
You're very welcome! I'm glad you like the videos.
Usefull...Thanks..
You're welcome Petter
You are awesome 👏🌹
i love you ma'am
Hi Leila - is it feasible in Google sheets as well? Couldn't implement the same in Google sheets 😐
Can you please help me to copy a conditionally formatted cell with 3 condidions into 120 rows. But without having to go to each cell and change the row number one by one
Could you help with one session how to access ERP TOOL by using excel macro...
It really depends on the ERP tool you have.
@@LeilaGharani
Could you able to give idea for BAAN
Nice Vedio Ms Leila
Excellent video! Never thought of this method. Question though: in cell C5 where you have the IF function, could you also nest a TEXT function (plus the dollar format) so that if "Total Sales" is selected, the returned value will be formatted in dollars (currency for example). Hopefully that make sense!
Hi Mam
Any video on task scheduler in detail as I am looking for tasks to run automatically at scheduled time which will help me in reducing some man-hours
“If you declare with your mouth “Jesus is Lord,” and believe in your heart that God raised Him from the dead, you will be saved” (Romans 10:9). Now is the time to accept Jesus as your personal Lord and Savior. Obey His commands and repent of your sins because Jesus is coming back soon. Tomorrow isn’t promised.
Great explanation , my question is how to make a rule so that the formatting of a cell let's say G4 is determined and changed based on 2 possible word (apple or Orange) in another cell B4 (same row) , and that would be the rule for the entire colomn G and B ?for example if B4 is orange then change the color of G4 to red and if it's B4 is apple then change G4 to green , Much appreciated if you give the answer .
Lovely
Madam,
Is there any Function/System /VBA code to BLINK Text(Font) rather than Highlight it, to recognize easily?
Nice
Wow... just wow...
I love the quality of your videos, biside excel you shuold do some videos about how to make a nice video like yours, which camera do you use, which mic do you use , and some tutorials how to edit video production... thank you ( sorry for my english)
Thank you Gerardo. I've listed my gear here: www.xelplus.com/resources/#gear - I'd love to do videos on editing, setup etc. Maybe in the future I will :) Thank you for your comment and suggestion. You have a wonderful channel yourself.
@@LeilaGharani Thank you Laila..
hi, Leila, is it possible to do the same in google spreadsheet. Please do let me know.
hi, love your work and thank you for sharing your time and videos, I have a question, I need to add a word in a different cell when it hits a certain time of day but cant seem to work it out. like when it is 2:30 pm the cell will say afternoon shift and if its before this time it will say day shift. thanks for any help you can give me.
Hi leila, hope ur doing well, i would like learn from you, can you please make a tutorial for how fuzylook up in a data
Thank you Sridhar. I explain approximate matches for VLOOKUP here: ruclips.net/video/hwL6KKJP-_I/видео.html
When I was working with "Conditional formating" and then copying to other cells I remember I had problem with these relative and absolute addresses. Unfortunatelly I do not remember what it was. But I am avoiding it since...
It's actually better to avoid conditional formatting wherever you can - too much of it, slows down your spreadsheet. As you've discovered, condtional formatting can be really tricky regarding the absolute and relative formatting as you need to write the rule from the point of view of the first cell...
Hello Mem
I have below query,
How shell i do color scale conditional formatting in entire table formatted raw by every alternative column.
Also any future raw or column to be added the it also should take similar formatting in auto mode.
Thanking you in advance.
Regards
Bharat
Hello. Grat channel I love it. Been Learning a lot from it. I nead to conditional format a form meaning a cube or a circle. My objective is like the picture you develop but with formats, can it be done?
regardas Hernan Cordero
maybe i'm doing something wrong, but when i create my table.. it doesn't include additional data.. i have to manually increase my ranges.. any ideas? using
office 365
Highlight the area you want included and use Ctrl+T (or Insert - Table). This should do it.
I have been doing exactly that. it does create the table but the table does not seem to be dynamic. if i type in a new row, it doesn't extend the table.
At 6:10 it looks like you lost the BOLD format when you select “Count of Apps”. I didn’t see you change anything. Did making the data a table or adding additional data to the table cause that? Did you notice it? Thank you!
You caught an interesting bug here. If I use table referencing the bold stays when I add new data to the table. If I don't use table referencing and want the bold to stay when I add new data, I need to add a new conditional format that makes the cell bold if the selection cell is "count of apps".
Do you know if this works with the new dynamic array functions?
Yes - the functionality shown here will still work in the future. Dynamic arrays don't change anything in this regard...
Hmmm amazing
mam my question is how to format %value from the data
Mam, i recently came to know about your channel, can data entry in excel can be made directly with voice (using cortana or Google assistant)? , it can save hours together... Found one source called officeautomata.Com but he stopped doing videos last year
I like your dress, you looked very nice..
Thank you!
Can I count the number of words and characters and move to a new line when you finish selecting the cell specified by VBA Excel as in this example?
wordcounter.net/
stil downloading cuz of internet slowing down
Hope it's better now....slow internet is really frustrating!
Swag...!!! 😎
I gather you are not for beginners. You were a bit fast for me.
But thank you.
Sorry about that
Anyone know how to setup an conditional format to highlight (i.e. format) the 1st unique rows of organised table?
Thought I would try my luck here as I can not find how to do this anywhere
Example:
A B C
1 USA Fred 2019 Sales
2 USA Fred 2020 Budget
3 USA Fred 2020 Sales
4
5 USA Ted 2020 Budget
6 USA Ted 2020 Sales
So in this example I would like to format row 1 and row 5 only as they are the 1st unique rows respectively.
There will be some blank rows inbetween that should be ignored.
I thought I the following link was the answer, but it does not seem to achieve what I need, but might give some reference:
www.masterdataanalysis.com/ms-excel/7-tips-deal-duplicates-ms-excel/#highlight_four
Thanks for any help in advance.
Such a beautiful woman
😘😘😘
Leila can you make a video about yourself we would love to know where do u work what u do
In the meantime I did this one: ruclips.net/video/xvs3JdZMaVU/видео.html Hope you like it.