🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Kevin, you never let me down. You are so articulate, and thanks to your expertise in teaching, I am gaining a vast array in many different areas of Excel.
Honestly, I have yet to see another youtube actual given the sample document. Its very hard to follow videos like this without having the data set. Very grateful, thank-you. Slowly learning excel skills I'll need.
Omg, I had to comment because you just saved my night, I have this late assignment thing due and I had no idea how to use excel and I was LITERALLY ABOUT to SPEND ALL NIGHT writing out the function for every box literally am so thankful for this video bless you, my guy.
First I want to say Thankyou. I would therefore like to critic that if you did a short intro less than a minute then take the rest of the time creating the actual content then you won’t have me trying to skip your video cz guess what? I (including thousands of other people) am doing homework and I don’t have the time to watch 6min video long for every question I come across on my test. The shorter the video the more meaningful the content. You did great!
Greetings Kevin - your teachings are very informative. I have Microsoft 365 on my pc.although it is activated, I am unable to use the if function in excel even though I used the formula that has been explained. Does it mean that updates have not been received from Microsoft
Tip ! You don't need to type the quotes in the Insert Function dialog. Simply type the text and press Tab. Excel will surround the text with quotes for you!
Thank you for this. I have an ICT exam coming up on Wednesday as part of an early years education qualification and I need to do some serious revision. Your videos are excellent.
Thank you very much for your tutorials you make excel very easy to learn and use. I have a question. What does the next formula mean in words =if(row()-1
Hello kevin what of cases where you use dashes, how do you use IF to count some of the dashes as values and some as just blanks if you do not want to use zero
hey kev, please use nested if statement whereby a teacher can assign grades to the learners mark, for instance if its 60% the grade will be C. and also please use vlookup to also assign grade whereby you will create a table on the side with the parameters of grades boundaries, lowest score and grade value.
Hi Kevin. Is it possible when the THEN funcion is true instead of a text to ask the excel to create a box with a mesage i.e. "create new product" and also have a sound. Basically to force you to take an action ??? . I am trying to work in my inventory excel file and I idealy look for such a solution. Thank you in advance. NIck
Hey Kevin I just wanted to thank you for the videos you make it helped me start my RUclips channel knowing witch recorder and video editor to use so thanks and keep up the awesome work.
Hi Kevin! I'm doing excatly what you told in the video. However, instead of showing Over Budget-Investigate, the Status of the Entertainment I have is still "Within Budget". Why is that? What did I do wrong?
Kevin, I was hoping you could send some advice or point me in the right direction: I am trying to create a score sheet and the if/then basic formula doesnt work because the = isnt just yes or no. There are 5 attempts per round. the scorekeeper is either putting a 1 or a zero (hit or miss). If the person hits the first one, it is 5X the score. 2nd shot is 4X the distance, etc. The "value" changes each round, with each round being 5 attempts. Example with 500 being the distance: =IF the score in C9 = 1, THEN (5*500) if not THEN zero =IF the score in D9 = 1, THEN (4*500) if not THEN zero =IF the scote in E9 = 1, THEN (3*500) if not THEN zero so on, and so forth. to make it interesting, I want all the values to add at the end of the card. I just dont know how to get the THEN to calculate rather than be a simple number/text. I know this is a lot to ask- but as a fellow PNW person, I am hoping you can at least tell me if its even possible or if I need a different program! I have Office 365 and use Sharepoint, Teams, and all the programs associated with that. THANK YOU!!!!
I have an excel question, I want to record the win/loss record of two mini golf players. How do I make a function that finds who has the lower score and adds a win to there win column. And adds one loss to the losing player?
What if I want to use a "=date" formula for if the statement is true or false? For example, if something is true then it will populate a date that is one year later and if false the date is only 3 months later. Can that be done and if so how?
I'm trying to add a formula to add employee related data to multiple columns. I've created a data validation reference but I can't seem to get the data to pre-populate based on the employee information. Can I use the "IF" formula for this? If not, what can I use to do this? OBTW, I'm working on a MAC.
Hi i need your help please. how do i go about fixing my excel sheet, there’s 4 cells Total, Min, Max & Comment. if the Total is less than Min & more than Max i want the Comment cell to be automatically highlighted?
So I am trying to come up with a formula that used the IF function as well as the TODAY() function. Basically, I need to it to display a text IF TODAY() -30 is true. Please help with that format.
I was hoping to get the IF formular where If a number is less than zero (for example), then the cell takes Zero, and if it's greater than Zero, then it takes the Number. Any help?
Is it possible to use the if function to automatically go to the next cell below once the original cell value is now at zero? What is the bwxt function to use to for this. Many thanks
I want to use the if function to find a certain name within a column infinitely. To trigger a sum function for a specific cell within the row that the name occurred on a separate sheet.. So we have different drivers doing different jobs and I want to keep running totals of each drivers totals fares on a separate sheet. Then repeat for each individual driver. Then each week is gonna have its own sheet. I’m going to copy my formulas for each sheet to create the next week. So if possible have it continue onto the next sheet or at least keep weekly totals that I can carry and summarizing it from there will be easy. Thank you
I really need help on Writing a formula, Well I have a formula ready so ultimately I need a sale to read another sale like the (if) function so that way it can calculate a number for me so what I’m getting at is that if the sale equals a certain amount of words that I already have an a list then it will calculate “this” But if it’s The words are not in the sale then calculate “that”. I know that sounds a little confusing I was trying to make it not but. I can definitely show you my spreadsheet so that way you can understand what I’m doing. I just really need some help because I cannot figure it out for the life of me.
Hi kevin. Can you walk me through the steps on how to use the (if function) to get a range of random numbers in a row in one column. eg: RANGE #1 to #36............ Row 2. 6. 9.17. 28. 35
How can I compare an empty cell and return a value if it is empty (no value in the cell) with the if function? Is it something like if C8=" "? Please help
Hi bro kevin can you teach me how to add the two variable Example l need to count all check symbols and Letter C how to make a formula for that Thank you l hope you can help me Pls
Just wondering if you could do something on Query's for the internet and from another workbook, a more advances formulas & functions, wrapping formulas, and basically using functions & formulas in intermediate stage and advanced stages. You are the only person on RUclips I can find that deals directly with MS Office 365, I am getting some glitches trying to merge between 2016 tutorials and yours on 365. I'd much prefer to learn from you where you are using 365, also could you tell me if 365 has that "What are you looking for" feature, there is only an average search which doesn't give the information 2016 claims to show the user.
EXCEL - How to use the IF function to find a particular word in a STRING of text ? Hi so i am creating an excel function. The cell D5 contains a full sentence of words. I want to create a function that detects the word "work" in that sentence. If it finds that word within the sentence I want it to print the word "employment". THe formula/function i have created only detects the word "work" if its the only word in the cell. Here is my function: =IF(K2="work","EMPLOYMENT") - its not doing what i want it to do!!! My question is - Is there a way of Excel finding the word "work" in amongst the other words?
Hello, Everything is possible in Excel, the answer to your problem is easy but combines multiple functions in one formula: =IF(IFERROR(FIND("work",A1),0),"employment","") Explanation: first FIND function will find the word "work" first and then will return it's location, if not found it will return an error, therefore we used the IFERROR function so that if the result of FIND is an error it will return 0 or FALSE finally we use the IF function, if the value of the IFERROR is any number, it will return employment, while if it was FALSE it will keep the cell empty.
"OOoOOh I wonder if 525 is LESS than 600!!¿¡? Lemme just type out an extremely long over complicated formula to chECK THaT!" I fucking hate this job so much
Hey Kevin. I have a question.. For example i use the function "IF" like this: =IF(A2=B2; B4; C4)… If its true, then it will appear the content of the cell B4.. However, when i want to appear the content of the cell with its special formatting, what can i do for this?? For example, if there is a thick outline out of the cell, i want to appear the content of the cell with the thick outline... You will help me a lot!
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
this links takes me to powerpoint tutorials
Hi Kevin, there`s a bit of confusion here. It takes you to Powerpoint presentations and not Excel
I realize I am quite off topic but does anyone know of a good place to stream newly released tv shows online?
@Nehemiah King flixportal :P
@Santana Mordechai thanks, signed up and it seems like they got a lot of movies there =) Appreciate it!
Kevin, you never let me down. You are so articulate, and thanks to your expertise in teaching, I am gaining a vast array in many different areas of Excel.
This video is what I needed for the last 7 years of my life.
Honestly, I have yet to see another youtube actual given the sample document. Its very hard to follow videos like this without having the data set. Very grateful, thank-you. Slowly learning excel skills I'll need.
I feel like you are speaking a different language 🤯
How’re you doing with excel now?
@@zakimuharam2978Lol
Omg, I had to comment because you just saved my night, I have this late assignment thing due and I had no idea how to use excel and I was LITERALLY ABOUT to SPEND ALL NIGHT writing out the function for every box literally am so thankful for this video bless you, my guy.
You’re the reason I have an A in my class. Thank you
You’re the best Ryan Seacrest!
Thank you Kevin :) You make learning all of these functions so much easier. You are the best!!!
First I want to say Thankyou. I would therefore like to critic that if you did a short intro less than a minute then take the rest of the time creating the actual content then you won’t have me trying to skip your video cz guess what? I (including thousands of other people) am doing homework and I don’t have the time to watch 6min video long for every question I come across on my test. The shorter the video the more meaningful the content. You did great!
Thank you, made it simple for my introduction to IF function.
Awesome video,
Tommorow is my ict exams,
i hope i pass
It didn't help me from what I needed it for but you got a thumbs up for doing it on the dialog box. Thank you.
Greetings Kevin - your teachings are very informative. I have Microsoft 365 on my pc.although it is activated, I am unable to use the if function in excel even though I used the formula that has been explained. Does it mean that updates have not been received from Microsoft
Sorted -thank you- I omitted to select the 'insert option- God bless
Tip ! You don't need to type the quotes in the Insert Function dialog. Simply type the text and press Tab. Excel will surround the text with quotes for you!
Thank you so much. I was about to fall apart trying to do my homework. You’re a life saver 😭
I just used the lesson learnt to answer a question in few seconds😊 Thank you Kelvin.
Can you do a video on more advanced IF formulas, i.e. the nested ones? Thanks Kevin!
Thank you, your video solved the issue, after looking at many videos
Your video's are very useful, you made me like excel.
Thank you for this video, it was clearly explained that made me learn it faster than any other tutorials that I tried to watch.
Excellent teaching 👍🏻👍🏻👍🏻
Best tutorial ever.
Very helpful. Couldn't remember how to use the IF function. Video was great help.
thank you so much. I am budgeting at the moment and new to excel. This video gave me a lot of information on how to effectively plan my spend!
THANK U this helped so much for my exam
you teach so well 👏👏👏
Thank you so much; you made it so easy to understand!
you are the best teacher
Thank you for this.
I have an ICT exam coming up on Wednesday as part of an early years education qualification and I need to do some serious revision.
Your videos are excellent.
I have it Tomorrow, that really helped
@@farhadaliyev6962 me 2
thanks for the video!! do all of your videos show Excel for PC? or Mac too?
Thank you, you really made it easy to follow.
Thank you very much for your tutorials you make excel very easy to learn and use.
I have a question. What does the next formula mean in words =if(row()-1
Can you use the IF function for words and not just numbers?
Hello kevin what of cases where you use dashes, how do you use IF to count some of the dashes as values and some as just blanks if you do not want to use zero
hey kev, please use nested if statement whereby a teacher can assign grades to the learners mark, for instance if its 60% the grade will be C. and also please use vlookup to also assign grade whereby you will create a table on the side with the parameters of grades boundaries, lowest score and grade value.
This video was quite useful.
hi, in google sheet where is the insert function to show the instruction like in this video, because in my google sheet I can not see this
You are the best! Anyday, Anytime
How'd you give the cells units like dollar signs?
Hi Kevin. Is it possible when the THEN funcion is true instead of a text to ask the excel to create a box with a mesage i.e. "create new product" and also have a sound. Basically to force you to take an action ??? . I am trying to work in my inventory excel file and I idealy look for such a solution. Thank you in advance. NIck
Awesome , simple vedios for understanding easily.
Agree. One of the best functions.
Hey Kevin I just wanted to thank you for the videos you make it helped me start my RUclips channel knowing witch recorder and video editor to use so thanks and keep up the awesome work.
thank you so much bro!keep going
Hello Kevin how do you use the IF function if I have more than 1 argument?
Hi Kevin! I'm doing excatly what you told in the video. However, instead of showing Over Budget-Investigate, the Status of the Entertainment I have is still "Within Budget". Why is that? What did I do wrong?
I want to verify that a certain value is on a list and return that it exists on a list or not. What is the best vid for that?
So helpful and comprehensive.
it easy for me. i have studied programming.
Please show a video of Nested IF and structured references using IF
I wonder if you have a multiple ifs tutorial
Kevin, I was hoping you could send some advice or point me in the right direction:
I am trying to create a score sheet and the if/then basic formula doesnt work because the = isnt just yes or no.
There are 5 attempts per round. the scorekeeper is either putting a 1 or a zero (hit or miss). If the person hits the first one, it is 5X the score. 2nd shot is 4X the distance, etc. The "value" changes each round, with each round being 5 attempts. Example with 500 being the distance:
=IF the score in C9 = 1, THEN (5*500) if not THEN zero
=IF the score in D9 = 1, THEN (4*500) if not THEN zero
=IF the scote in E9 = 1, THEN (3*500) if not THEN zero
so on, and so forth.
to make it interesting, I want all the values to add at the end of the card.
I just dont know how to get the THEN to calculate rather than be a simple number/text.
I know this is a lot to ask- but as a fellow PNW person, I am hoping you can at least tell me if its even possible or if I need a different program! I have Office 365 and use Sharepoint, Teams, and all the programs associated with that.
THANK YOU!!!!
Could you color highlight the cell if the expense was over budget?
hi Kevin, what about if function where the logical test is " BEGINS " (with this XXX number for instance..."?)
Thank you for your help sir ❤️
that's not a function. that is a formula. thanks for correctly labeling things.
Thank you. It would be helpful to zoom in and show us what you are doing.
I have an excel question, I want to record the win/loss record of two mini golf players. How do I make a function that finds who has the lower score and adds a win to there win column. And adds one loss to the losing player?
Thank you so much kevin for explaining it nicely. Keep making such type of videos so that we can learn from you .
Excel hero!
Well explained thanks
What if I want to use a "=date" formula for if the statement is true or false? For example, if something is true then it will populate a date that is one year later and if false the date is only 3 months later. Can that be done and if so how?
Thanks for this!
I'm trying to add a formula to add employee related data to multiple columns. I've created a data validation reference but I can't seem to get the data to pre-populate based on the employee information. Can I use the "IF" formula for this? If not, what can I use to do this? OBTW, I'm working on a MAC.
Hi i need your help please. how do i go about fixing my excel sheet, there’s 4 cells Total, Min, Max & Comment. if the Total is less than Min & more than Max i want the Comment cell to be automatically highlighted?
So I am trying to come up with a formula that used the IF function as well as the TODAY() function. Basically, I need to it to display a text IF TODAY() -30 is true. Please help with that format.
HI Mentor, whats up with IF AND function, ant tutorial?
You’re a star
I was hoping to get the IF formular where If a number is less than zero (for example), then the cell takes Zero, and if it's greater than Zero, then it takes the Number. Any help?
I very interested to learn other excel function, how can you notify me of your every tutorial video on solving excel function, thank you.
Thank you so much 👌🏼
Is it possible to use the if function to automatically go to the next cell below once the original cell value is now at zero? What is the bwxt function to use to for this. Many thanks
Very Helpful and yes I'd like to see this type of video in the future as you explain things very well.
Keep up the good work.
I want to use the if function to find a certain name within a column infinitely. To trigger a sum function for a specific cell within the row that the name occurred on a separate sheet.. So we have different drivers doing different jobs and I want to keep running totals of each drivers totals fares on a separate sheet. Then repeat for each individual driver. Then each week is gonna have its own sheet. I’m going to copy my formulas for each sheet to create the next week. So if possible have it continue onto the next sheet or at least keep weekly totals that I can carry and summarizing it from there will be easy. Thank you
Can you combine an if with a VLookup ? - i am using lookup to return a value, then need to create a formula using the returned data? Thank you,
small point but why is the dollar sign spaced so far from the number?
Great video 👍
I really need help on Writing a formula, Well I have a formula ready so ultimately I need a sale to read another sale like the (if) function so that way it can calculate a number for me so what I’m getting at is that if the sale equals a certain amount of words that I already have an a list then it will calculate “this” But if it’s The words are not in the sale then calculate “that”. I know that sounds a little confusing I was trying to make it not but. I can definitely show you my spreadsheet so that way you can understand what I’m doing. I just really need some help because I cannot figure it out for the life of me.
Thank you ✌
Hi kevin. Can you walk me through the steps on how to use the (if function) to get a range of random numbers in a row in one column. eg: RANGE #1 to #36............ Row 2. 6. 9.17. 28. 35
How can I compare an empty cell and return a value if it is empty (no value in the cell) with the if function? Is it something like if C8=" "? Please help
Can you do this with numbers vs text pls
Thank you so much
I have a question what if you need to know if it's greater than zero and if its equal to zero. What function is that?
Brilliant explanation of the IF function thank you
Thanks Kev
very helpful thanks
Can you a) make the text a color and/or b) make the cell change color
Does if functions work with rang?
Pls Mr Kelvin can u give more tutorals on excel
Hi bro kevin can you teach me how to add the two variable
Example l need to count all check symbols and Letter C how to make a formula for that
Thank you l hope you can help me
Pls
Thanks man!
Just wondering if you could do something on Query's for the internet and from another workbook, a more advances formulas & functions, wrapping formulas, and basically using functions & formulas in intermediate stage and advanced stages. You are the only person on RUclips I can find that deals directly with MS Office 365, I am getting some glitches trying to merge between 2016 tutorials and yours on 365. I'd much prefer to learn from you where you are using 365, also could you tell me if 365 has that "What are you looking for" feature, there is only an average search which doesn't give the information 2016 claims to show the user.
U're really amazing, thanks very much for d video
Thank you for making it so simple
EXCEL - How to use the IF function to find a particular word in a STRING of text ?
Hi so i am creating an excel function. The cell D5 contains a full sentence of words. I want to create a function that detects the word "work" in that sentence. If it finds that word within the sentence I want it to print the word "employment".
THe formula/function i have created only detects the word "work" if its the only word in the cell.
Here is my function:
=IF(K2="work","EMPLOYMENT") - its not doing what i want it to do!!!
My question is - Is there a way of Excel finding the word "work" in amongst the other words?
Hello,
Everything is possible in Excel,
the answer to your problem is easy but combines multiple functions in one formula:
=IF(IFERROR(FIND("work",A1),0),"employment","")
Explanation:
first FIND function will find the word "work" first and then will return it's location, if not found it will return an error,
therefore we used the IFERROR function so that if the result of FIND is an error it will return 0 or FALSE
finally we use the IF function, if the value of the IFERROR is any number, it will return employment, while if it was FALSE it will keep the cell empty.
"OOoOOh I wonder if 525 is LESS than 600!!¿¡? Lemme just type out an extremely long over complicated formula to chECK THaT!" I fucking hate this job so much
Thank You
Hey Kevin. I have a question.. For example i use the function "IF" like this: =IF(A2=B2; B4; C4)… If its true, then it will appear the content of the cell B4.. However, when i want to appear the content of the cell with its special formatting, what can i do for this??
For example, if there is a thick outline out of the cell, i want to appear the content of the cell with the thick outline...
You will help me a lot!