hey Kenji , you explained so well , i watch your videos a lot , i want to become a data analyst and your program of data analyst seems quite fascinating , but i am unable to purchase it , i am from a underdeveloped country , the prices are much higher, we can't even afford that , do you have any financial aid for these certificates , like just other websites usually have , i really want to complete your data analyst course , if you are willing to do so will you help me to access that for free with a certificate , i'll be thankful to you for this kindness , thank you.
Hi Kenji I'm Wezza from Angola I'm an enthusiastic excel and I'm impressed by the clear and simple way you explain complex formulas with the if statement.
10:20 We can enter this formula as well, right ```=SUMIFS(W4:W19,V4:V19,Z4,U4:U19,"*spain*")``` Don't need to put extra / unnecessary `&` sign. hope it helps
Fantastic stuff, well done. Have you got a solution for the following, I need excel to calculate the number of hours and minutes between a range of hours, for example, between the hours of 19:00 and 6:00 I get 30 dollars, were from 6:00 to 19:00 my pay is 25 dollars an hour. What formula do I use to calculate the following scenario, I start at 18:00 and finish at 7:00, obviously my penalty hours are 11, and total hours are 13, I need the formula to give me the penalty hours worked within the total hours. I would appreciate any help.
I've got a sheet with a column (C) with client ID's (formatted in 'general' and ranging from 1 to 10) and a column (D) with the hours of work i did for them (formatted in 'custom' as: hh:mm). Now I want to create a similar 'dynamic' overview table, like your example with spain and the olives, so that i can simply check my work for a specific client by filling in the client's ID number. I've got my formula like this: =SUMIFS(D3:D18,C3:C18,G3). So it's written exactly the same as the formula at 7:20 min in this video, but without a second criteria (i tried it with a second simple criteria but same result). It just doesn't want to work somehow. EDIT: apparently i needed to set the results cell to exactly the same format (hh:mm) for it to work. This really is a crucial aspect i feel gets left out a lot in these explanation videos. I get that you have to keep focused on the prime topic of the video, but it's such an important thing to overlook for a beginner. Speaking of which, all the examples given here are still rather simple. For me as a beginner it's hard to find mixes between different formats, like time (worked) and currency. 99% of examples on youtube just have simple bare numbers, which seems a lot easier to work with anyway
Have been trying to add up some customers purchases for different products using this SUMIFS formular but it only gives me one product and not the summation of all others. How do I get this done please
Thanks so much for the template on 3 financial modeling Where can get the video for beginners or is there anything site you can refer to We appreciate you
Thank you, thank you, thank you! Great tutorial. I was pulling my hair out trying to work out how to put the brokerage rate in for sales over and under 10,000 etc.
Thanks for the lesson but I'm having little problem performing this function to find the sum where cell A1 contain 76 ,B1 87 C1 67 Divided by 3 plus 76 in cell D1 divided by 2 to display in cell E1. Please I need your help.
Hello respected sir...thank you for your good lecture ....but please solve my one question that i have..Which formula i should apply that...if sale increased from 100 give incentive 2% but does not increase dont give
I’m looking to change the value of a cell on an anniversary date. I’m calculating longevity payments that increase $100 on an employees anniversary date but starts on their 5th year. Can it be done? Can you help? Thanks in advance
I hope I can get in touch with you. Been dealing with a nested IF statement that I really can't figure out. It's something like: Number of conditions - 3 Number of return value - 4 Help? 😅
Please tell me if i have 50 sheets in one excel report and its all in same format, at the end there is master sheet so how can i vlookup by dragging down. My concern is if i am dragging down the formula sheet number must change please advise
Hi, your video is great, I have a question, I want to create a formula that will only allow values from 600 to 1200 and do not allow other values to be entered. can you help?
I want to mark a blank cell (A2) with a color (with no text) if B2 has a specific text on it, once B2 has the text, I want to fill manually A2, I want that Excel advise me once B2 has the specific text but I want to receive the warning on A2 cell, can that be done? how do I do that if so? or that is not IF/Conditional formatting, thank you!
🔥Take our Excel course: www.careerprinciples.com/courses/excel-for-business-finance
hey Kenji , you explained so well , i watch your videos a lot , i want to become a data analyst and your program of data analyst seems quite fascinating , but i am unable to purchase it , i am from a underdeveloped country , the prices are much higher, we can't even afford that , do you have any financial aid for these certificates , like just other websites usually have , i really want to complete your data analyst course , if you are willing to do so will you help me to access that for free with a certificate , i'll be thankful to you for this kindness , thank you.
I have been using Microsoft Excel since 2017 but the way you teach IF, IFS, SumIFS functions is on next level
Thank you for your lovely comment!
@@KenjiExplains it's my pleasure to appreciate you because you are one of them who are changing newbies life to teaching top class IT field
Personal tips on how to learn from basically zero, would be helpful.
Where should I start when first learning excel?
Honestly...he is trying
If I want to enroll in this. How will I start please
Excellent presentation, your grasp of the subject is quite impressive, but how you explain all the concepts is even more impressive IMHO.
thank you!
Best Excel tutorials out there👌🏻
Glad you think so! thanks for watching :)
❤❤❤ it’s a wow. Thanks for this short presentation
This is the best part of UA-cam...good teachers. Cant find a Kenji at a college. Love it
Kenji you make Excel look so simple🥰. The best tutorials I've ever had🥰
Hi Kenji I'm Wezza from Angola
I'm an enthusiastic excel and I'm impressed by the clear and simple way you explain complex formulas with the if statement.
Thank you for this it really helped 😊
Hey Kenji! The wildcard saved me tons of time. Thanks so much!!!
Yes, that is awesome!
Thank you Kenji the way you explain it is so interesting
I used to learn in UA-cam for awhile but never seen such talented teaching techniques
One of my favorite channel. Thanks Kenji
You make learning fun. Keep up the good work and thank you Kenji.
Thank you!!! Really appreciate your comment 😁
Great man. Very informative and precisely explained everything !
How interesting I had never heard about the wildcard formula. Data at my work tends to be messy this video is a godsend😂 thank you kenji
Awesome to hear! Thanks for letting me know glad it was helpful :)
Yeah, neither have I! This just makes my job easier now.
Thanks so much for these tutorials!
this is the best tutor of excel that i have even seen during my last 5 years big like thumb for you and keep the good work
Thank you so much!
Thank you so much , English is not my first language, but you explain very good and speak clearly ,🤗 I’m happy that I found you !
Thank you! 😃
Thank you, It is very simple and easy to understand.
way you teach IF, IFS, Sum IFS functions is on next level. Ooosome, Thank you🙏
This has been so helpful and you explain it in great detail!! Thank you!!
i have my excel exam today and u r SAVING ME I LOVE U KENJI
Making it very simple to understand. Thank you
Totally agree. Without this function my job would be so much harder.
Excellent, simple so simple but perfect.👍👍👍👍👍
Your tutorials are the best it was a refresher for me Thank you!!!
Best presentation, I am learning some new concepts
10:20
We can enter this formula as well, right ```=SUMIFS(W4:W19,V4:V19,Z4,U4:U19,"*spain*")```
Don't need to put extra / unnecessary `&` sign.
hope it helps
Nice and neat explanation ..... as always. Kudos
Thanks a lot!
The way you explain this topic is really clear. Thanks.
Excellent presentation. Thanks a lot.
Glad it was helpful!
I used the shortcuts and functions in my job related exam, I passed it at got my job too❤ Tysm Kenji...
Thank you very much for this amazing tutorial
Thank you for sharing your knowledge to us. Highly appreciated 💙
Nice content! I didn't know the last trick, pretty interesting!!😲
Glad you liked it!
Kenji the goat let’s goooooo
Excellent content, thank you
Fantastic stuff, well done. Have you got a solution for the following, I need excel to calculate the number of hours and minutes between a range of hours, for example, between the hours of 19:00 and 6:00 I get 30 dollars, were from 6:00 to 19:00 my pay is 25 dollars an hour. What formula do I use to calculate the following scenario, I start at 18:00 and finish at 7:00, obviously my penalty hours are 11, and total hours are 13, I need the formula to give me the penalty hours worked within the total hours. I would appreciate any help.
This is so incredible and amazing.
Thank you so much ❤
Simply amazing...Thank you!
@Kenji Explains, Insightful way and nicely explained the IF, SUMIF Conditions with perfect examples 👌
Thank you so much!!!
Love your videos
Thank you so much for this very informative video.
Glad it was helpful!
Very good teaching dear.
Thank you so much for making it easy to understand the if function
You so kind in your teaching method, making it so easy to learn. God bless you richly.
I've got a sheet with a column (C) with client ID's (formatted in 'general' and ranging from 1 to 10) and a column (D) with the hours of work i did for them (formatted in 'custom' as: hh:mm). Now I want to create a similar 'dynamic' overview table, like your example with spain and the olives, so that i can simply check my work for a specific client by filling in the client's ID number. I've got my formula like this: =SUMIFS(D3:D18,C3:C18,G3). So it's written exactly the same as the formula at 7:20 min in this video, but without a second criteria (i tried it with a second simple criteria but same result). It just doesn't want to work somehow. EDIT: apparently i needed to set the results cell to exactly the same format (hh:mm) for it to work. This really is a crucial aspect i feel gets left out a lot in these explanation videos. I get that you have to keep focused on the prime topic of the video, but it's such an important thing to overlook for a beginner. Speaking of which, all the examples given here are still rather simple. For me as a beginner it's hard to find mixes between different formats, like time (worked) and currency. 99% of examples on youtube just have simple bare numbers, which seems a lot easier to work with anyway
Kenji Can we use Switch function instead of If functions??? Please make a video on Switch functions replacing If functions..
Thank you
I love this wild card💕
Have been trying to add up some customers purchases for different products using this SUMIFS formular but it only gives me one product and not the summation of all others. How do I get this done please
very useful information thanks
Nice content 👍
What is the formula for not add the trike out amounts to your total? Thank you
thank you so much sir learnt more things from your and videos.
thank you very much. i am struggling for IF function formula but you explain in best way now i learnt all .
The video editing skill is just another level.... Fantastic.
Make a video of excel video editing
Thank you! It's the " " explanation! I finally nailed my formula ❤❤❤
Thanks a million
well done good videos to the point and well explained thanks from S Africa
I want MS Excel to change from numbers I like to numbers letters I like example 1= w f s o, 2 = j o h n, 3 = c r p c
It is possible ?plz help me sir
I am using your excel course 🎉 great gob
The best man ever
Keep on good sir , I like the way you teach
Thank you for sharing
Interesting video, thanks for sharing
Thanks for watching!
Thanks so much for the template on 3 financial modeling
Where can get the video for beginners or is there anything site you can refer to
We appreciate you
Nice, thanks! It would help if you also put your questions so we can try it first. Thanks
THANKS FOR YOUR VIDEO, I'M REALLY LEARNING IT,I'M A BENNIGER LEVEL. WATCHING FROM PUERTO RICO
Thank you Kenji
Thank you, thank you, thank you! Great tutorial. I was pulling my hair out trying to work out how to put the brokerage rate in for sales over and under 10,000 etc.
your excel short videos are very well moreover concept clear compare to other one 👍
Thanks for the lesson but I'm having little problem performing this function to find the sum where cell A1 contain 76 ,B1 87 C1 67 Divided by 3 plus 76 in cell D1 divided by 2 to display in cell E1. Please I need your help.
Hi, how to create a formulae, eg: if in Column A1 is 1, therefore the Answer shall be the same as shown in it.
Hello respected sir...thank you for your good lecture ....but please solve my one question that i have..Which formula i should apply that...if sale increased from 100 give incentive 2% but does not increase dont give
Thank so much for explaining this I was getting so frustrated.
I like the ampersand wildcard tie 👍😎✊
@KenjiExplains what's the best formula for a 3 criteria problem in excel?
For some reason I kept getting #name error with the IFS function the formulas correct but when I input it I kept getting the error
same for me, idk why but it worked for me like that: =IFS(C3>40;4000;C3>20;1000;C3
Wow this is great thank you ..
I’m looking to change the value of a cell on an anniversary date. I’m calculating longevity payments that increase $100 on an employees anniversary date but starts on their 5th year. Can it be done? Can you help? Thanks in advance
Kenji how do I send you a sample of an if formula i cant get right
please i try to change to different country but it does not reflect the changes in the results unless i insert the cursor and press enter
I am happy about all your tutors but in this lesson /formula 3 &2/how do you take the =IF() from E3 TO D3? Regards
Hi,
Pls share excel file also for Practise.
I hope I can get in touch with you. Been dealing with a nested IF statement that I really can't figure out. It's something like:
Number of conditions - 3
Number of return value - 4
Help? 😅
If a B3 says Deposit then I want B5 to be positive and if not negative. Is that possible?
Please tell me if i have 50 sheets in one excel report and its all in same format, at the end there is master sheet so how can i vlookup by dragging down.
My concern is if i am dragging down the formula sheet number must change please advise
Thanks for sharing the wildcard IF function. Please can you share an approach to clean the data and produce only the country name.
Well detailed ,take your flowers 🎉
Whats your opinion about ai and ongoing fear of replacing most of „corpo” jobs in near future? Would it be still worthy to get into finance career?
Simply Amazing
smart teacher thank you very much for the lesson
thank You kenji
Hi, your video is great, I have a question, I want to create a formula that will only allow values from 600 to 1200 and do not allow other values to be entered. can you help?
Can you write the formula for IFS function as shown in this video for me to look at it closely and apply.
I want to mark a blank cell (A2) with a color (with no text) if B2 has a specific text on it, once B2 has the text, I want to fill manually A2, I want that Excel advise me once B2 has the specific text but I want to receive the warning on A2 cell, can that be done? how do I do that if so? or that is not IF/Conditional formatting, thank you!
but what if u want the IF to be related to between a number eg (If x is is between 20-40 = £10 bonus)