🆓 Watch my FREE Full Course on Excel Formulas and Functions (New for 2022): th-cam.com/video/Y8xhrUa3KH4/w-d-xo.html 🏫 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com ⏭️ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Question: my workbook has multi tabs- is there a way to search for a specific tab without scrolling thru all the tabs -Example tabs are named for numbers 4196-7690--- Can I make it jump to tab 5628 without scrolling thru each tab
Hi, I am using two date columns to check if an incident occurred BEFORE or AFTER a certain date in a column but when I use the IF formula, it shows the same output even when there’s nothing in one of the date columns. Not sure what’s wrong. Can I send you my example?
Hi Kevin, I’m an accounting student and I wanted to say I appreciate your excel tutorials. They’ve helped me greatly. I had finals and needed to know how to use some excel functions and I can’t thank you enough. Your videos are straight to the point and easy to understand.
The formulas were the most complicated thing for me but thanks to this video I will be able to use them without complications, as soon as I get a product key for my laptop, of course... Thanks for the video tho!
I am 29 years old and have never understood Excel, so many people have tried teaching me but I have not been able to retain the information. Your video makes it so simple and now I have completed my first comprehensive excel sheet. Thank you so much
Ive been through a lot of TH-cam Excel tutorials in the last couple of days and yours is the most professional, easy to follow and to the point. Keep up the good work, liked and subscribed.
I have a practical exam tomorrow, portion is just excel, I had to miss the first week of school because I was still writing final exams in my previous school. I haven’t had much time to study and didn’t really understand excel formulas well, but this has saved me. Gonna go learn charts too because that’s coming too. I salute you
I have always wanted to learn the basics of Excel but would die inside when I look at the program. Thank you Kevin for being such a great teacher. I no longer have to hide my fear. Excellent introduction for beginners.
Kevin, I've used excel for a number of years so many of the items listed I had experience, but others I needed to brush up on. The way you laid out your table of examples and listed across examples was great. I've seen other videos and yours I will say are the best with simple straight forward examples. Thanks
This was insanely helpful and easy to understand! I’m taking an accounting class and I need to create an excel using formulas, but I’ve never been taught or had to use them before. Thanks a ton!
Thank you Kevin, for clarity and ease. I did excel way back in time, I always thought the more modern method were a bit complicated to access. Glad is not the headache I was afraid of.
I'm only 16 and Kevin I love your video's it really helps to understand everything I like subscribe and comment love you Kevin keep up the good work your very smart it isn't every where you go you can find someone this smart😎😇
I'm starting a payroll position soon where they use excel frequently and I am not familiar with formulas so I found your video to learn before I start and this has been SUPER helpful for me!! thanks so much, I feel a little more prepared! :)
This guy should be rewarded a medal for clear explanation...you are like the only person in youtue who teach stuff properly...thank you so much, if it werent for you i would have failed my practical exam...
I like this guy already after a second, no back story jump right in and validated his experience in the award winning company that stands out Microsoft!
Thank you so very very much. This was so self-explanatory. You made it look so simple. However I know there will be difficulties in trying to remember everything but for the most part I think I got it. I just needed a good refresher and this was awesome and I will continue to go back and look at this video and check out more of your videos this is the first one I've checked out ever thank you again
I can't thank you enough Kevin, wow, my teacher tought the whole year and it made no sense & you made me understand just from a single video, thank you so much!!!
It honestly took me 3 hours trying to figure out that was I supposed to do from the book, then when I saw this video, I learnt it in 15 minutes!! Thank youuuuu!!!!!
Thank you Kevin for a video of substance with a pace that shows you want us to learn not just show off what you know by flying through it. Much appreciated!
Omg I just learned excel so fast!! lol.. After watching so many videos, this one has been the most useful!! Thank you so much, looking forward to watching more videos from you!
I think I should learn how to start following you. This is a very good video. After seeing this, I deleted all the video films I had on my phone so I can get space to save many of your tutorials. Your great and I hope I saw this before my current interviews. Without I've from Africa
Hi kevin, excel is my problem during never taught how to navigate this thing, but your video really help me a lot and improve my excel skills. Thank you
This is the best excel tutorial i have come across, you made it so simple and easy as ABC. The time stamp is awesome, so easy to jump to what you intend to learn. Thank you so much Kelvin
Thank you for being so clear and easy to understand. I have been working with Excell for years but didnt know how to do some of the things that you just showed. great job!!!!
Hii Kevin Stratvert, my name is harshita. I am from India. I hope you are doing well and i appericiate your teaching skill. Anyone who dont understand the formula in the excel, this is the very excellent platform to learn excel. and also you are looking very smart. May god bless you. I pray for you. Good Bye
thank you for this tutorial and all of your other tutorials :) you are very helpful and explain everything well. I have been out of work for many years due to 12 surgeries that I have had and am now trying to get back into the working field. some of my excel areas were a bit rusty and your tutorials have been very helpful so thank you :)
Thank you Kevin, this is so easy and well explained. In older versions, to add numbers i just click in the cell add the = then i could just tap on the cell I needed to add and it will automatically add the + sign, the newer version does not do that. What setting should I change, to have it?
Hola! Tengo 44 años y quiero aprender como usar excel solo que las clases y mi horario de trabajo no me dejan, y encontrar tus videos tan bien explicados me ponen muy contenta. Muchas gracias por compartir tu sabiduria.😊
thank you so much. I have a oot of trouble with stuff like this and trying to learn it online with a teacher not showing it like you had me so stressed. You are amazing. Thank you so much. I can do it now.
wow time stamps he is a great guy!!!!! I only needed to watch count but end up watching the all video because he sounds calm and gives detail meaning amazing
Thank you sincerely for posting this video. I have decided to continue my education and it has been years since my last accounting course. This video is a great refresher.
🆓 Watch my FREE Full Course on Excel Formulas and Functions (New for 2022): th-cam.com/video/Y8xhrUa3KH4/w-d-xo.html
🏫 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com
⏭️ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
How do I get mean of only one value
Kevin Stratvert add
Kevin Stratvert thanks a lot for ur simple way to explain it wish u all the best
How do you find and calculate percentages
Question: my workbook has multi tabs- is there a way to search for a specific tab without scrolling thru all the tabs -Example tabs are named for numbers 4196-7690--- Can I make it jump to tab 5628 without scrolling thru each tab
Any guy who has time stamps in the video, is a good guy.
Good idea. I'm gonna put timestamps in all my videos. Thanks
Hi, I am using two date columns to check if an incident occurred BEFORE or AFTER a certain date in a column but when I use the IF formula, it shows the same output even when there’s nothing in one of the date columns. Not sure what’s wrong. Can I send you my example?
@@theaccountant5846 i
@@lifeofapunjerican8135 You can send me your example and I can try to figure it out
Absolutely agree
What you taught me in 15 minutes, I have been trying to figure out for the past two hours from my book. Thank you sooo much!!
the irony is professors make it boring. You-tubers make it interesting.
@@selectivemusictracks3372 yupp!! Cuz it's TH-cam!!
the video is only 15 min
I’m trying with books for ages and this video just nails it.
Dido
That joy when you find exactly what you want and it’s as straightforward as possible.
Thank Kevin Stratvert
Hi Kevin, I’m an accounting student and I wanted to say I appreciate your excel tutorials. They’ve helped me greatly. I had finals and needed to know how to use some excel functions and I can’t thank you enough. Your videos are straight to the point and easy to understand.
well I don't
well I don't
@@yousefe7804 why
👏👌💯
👏👌💯
The formulas were the most complicated thing for me but thanks to this video I will be able to use them without complications, as soon as I get a product key for my laptop, of course... Thanks for the video tho!
Hi! For the product key, I got mine from BNH Software, and it was straightforward to use. You might want to give it a try if you’re looking for one.
Thank you! I got it!
I am 29 years old and have never understood Excel, so many people have tried teaching me but I have not been able to retain the information. Your video makes it so simple and now I have completed my first comprehensive excel sheet. Thank you so much
Ive been through a lot of TH-cam Excel tutorials in the last couple of days and yours is the most professional, easy to follow and to the point. Keep up the good work, liked and subscribed.
agreed, please make more videos
Totally agree I've been going through multiple videos myself
Likewise. I agree too.
easy and straight forward, thanks buddy
alMutaz Shora '.
I have a practical exam tomorrow, portion is just excel, I had to miss the first week of school because I was still writing final exams in my previous school. I haven’t had much time to study and didn’t really understand excel formulas well, but this has saved me. Gonna go learn charts too because that’s coming too. I salute you
This is exactly what I needed - so many flabby pointless Excel videos online, but this is the good stuff. Big thanks.
I lied on my resume and now here I am
LMAOOOO SO REAL 😭 (here I am rn as well)
Lmao I didn’t lie but did say I knew basics which I did but I kinda forgot so now here I am 😂
😂😂😂😂
Im your boss ur Fried🫡
@AzraČengić-u9d if my boss knew my online alias, we'd have bigger problems than lying on my resume
I have always wanted to learn the basics of Excel but would die inside when I look at the program. Thank you Kevin for being such a great teacher. I no longer have to hide my fear. Excellent introduction for beginners.
same dude
I was feeling ashamed of not knowing Excel and my colleagues being used to it for a whole year. You're a saviour. Thank you so much.
I missed important classes and this helped clear things up. wish me luck lads, i have a paper tomorrow. its a practical
Ahad Rehman how did you do?
@@aaroncook7866 pretty good actually. Nailed it
Ahad Rehman nice one ☝️
Good luck. Come back and let us know how you did
Diamond T she said she did pretty good
He did what my teachers been doing for 3 months IN 12 MINUTES
Kevin, I've used excel for a number of years so many of the items listed I had experience, but others I needed to brush up on.
The way you laid out your table of examples and listed across examples was great. I've seen other videos and yours I will say are the best with simple straight forward examples. Thanks
never felt more comfortable using sumif & vlookup function. Thanks a bunch
You have no idea how much you helped and how fast....Thank you.
And the detailed time fraims...wow.
Shush this video is old
This was insanely helpful and easy to understand! I’m taking an accounting class and I need to create an excel using formulas, but I’ve never been taught or had to use them before. Thanks a ton!
From now on i'm looking this guy's videos before anyone else, it's esasy to understand and has a excelent way of teaching.
exactly - he is the best x far x ever.
Thank you. I’m getting a new job and needed to brush up on things like this.
Thank you for always having the exact way to teach something with your personable demeanor and not just some mouse moving on a screen.
Definitely subscribed! Thank you for providing easy to understand and straightforward tutorials.
Thanks for the note Deja. Let me know if there are any other topics that would be helpful.
One of my biggest weaknesses was not knowing excel, And because of you Kevin I learned it in 12.28 minutes. Thank you
Thanks Kevin! It is awesome how when writing formulas, Excel provides real-time assistance via auto suggestions. Fascinating!
Very easy to understand , adequate speed, looking forward to more complex formulas video.
Thank you Kevin, for clarity and ease. I did excel way back in time, I always thought the more modern method were a bit complicated to access. Glad is not the headache I was afraid of.
Thank God for you! I've googled Excel formulas many times and gave up every time! You explain it so easy. I'll watch the full course too. Thank you!
Thank you! Saved me. I understood this easier than my instructor. Zoom classes are somewhat difficult at times. Glad your videos are here
I'm only 16 and Kevin I love your video's it really helps to understand everything I like subscribe and comment love you Kevin keep up the good work your very smart it isn't every where you go you can find someone this smart😎😇
I'm starting a payroll position soon where they use excel frequently and I am not familiar with formulas so I found your video to learn before I start and this has been SUPER helpful for me!! thanks so much, I feel a little more prepared! :)
Did this actually work for you? Are you still with the company?!
Please never delete this 🙏 I watched this a year ago and I needed a refresher today
I actually got what I was looking for!!! Thanks so much.. you are a good teacher :)
This guy should be rewarded a medal for clear explanation...you are like the only person in youtue who teach stuff properly...thank you so much, if it werent for you i would have failed my practical exam...
I like this guy already after a second, no back story jump right in and validated his experience in the award winning company that stands out Microsoft!
Thank you so very very much. This was so self-explanatory. You made it look so simple. However I know there will be difficulties in trying to remember everything but for the most part I think I got it. I just needed a good refresher and this was awesome and I will continue to go back and look at this video and check out more of your videos this is the first one I've checked out ever thank you again
THANK YOU!!!!! THIS IS THE BEST EXPLANATION! YOU HAVE LITERALLY TAUGHT ME HOW TO DO STATISTICS !!!!!
That is awesome you include the worksheet. Your tutorial is quick, easy to follow and to the point. Thank you
Thank you sir ,so much 😘😘
I can't thank you enough Kevin, wow, my teacher tought the whole year and it made no sense & you made me understand just from a single video, thank you so much!!!
Thank you for this, it's a super quick and simple explanation without going too overboard!
Nice
It honestly took me 3 hours trying to figure out that was I supposed to do from the book, then when I saw this video, I learnt it in 15 minutes!! Thank youuuuu!!!!!
That was so informative, easy to watch and learn from! Going to watch them all now - thank you!
Jargon-free straight tutorial. Never I heard someone explain excel so simply, Thanks Kevin
This man is more valuable than any college book you can buy
very easy to follow and most importantly i have learnt a new skill. THANKS KEVIN
The sound, timing and explanation is one of the best on your video., I love it both soft world and excel I subscribed.
Thank you very much brother you help me for my final exams at my school👌👌👍👍👍👍👍👍👍👍
Clear, concise, and direct Excel tutorial. Thanks Kevin!
Thank you Kevin for a video of substance with a pace that shows you want us to learn not just show off what you know by flying through it. Much appreciated!
Omg I just learned excel so fast!! lol.. After watching so many videos, this one has been the most useful!! Thank you so much, looking forward to watching more videos from you!
I think I should learn how to start following you. This is a very good video. After seeing this, I deleted all the video films I had on my phone so I can get space to save many of your tutorials.
Your great and I hope I saw this before my current interviews.
Without I've from Africa
I am taking a test and need excel. Your video is great! Thank you for the professionalism and easy to follow explanations!
I usually don't write comments but must say very quick and handful video, straight to the point to develop some routine basic excel skills.
Thanks for simplifying the tutorial for this knucklehead.
Much appreciated.
Hi kevin, excel is my problem during never taught how to navigate this thing, but your video really help me a lot and improve my excel skills. Thank you
This is the best excel tutorial i have come across, you made it so simple and easy as ABC. The time stamp is awesome, so easy to jump to what you intend to learn. Thank you so much Kelvin
Thank you for putting things into its simplest form and getting to point.
Thank you for being so clear and easy to understand. I have been working with Excell for years but didnt know how to do some of the things that you just showed. great job!!!!
To the point and no wastage of time .
I used to see videos at 1.5x bcoz they waste a lot of time ,but here I don't need to do this
Thank you so much for this video Kevin, please upload more, maybe that help with bookkeeping purposes!
This was simple, to the point, and had clear examples. Miles better than many excel videos I’ve watched.
it is so simple and straight forward, thank you
Thank you, I am 60 and still learning because people like you. God Bless
Thank you! I am reviewing Excel for a new job. I'll definitely be watching your other videos.
Hii Kevin Stratvert, my name is harshita.
I am from India.
I hope you are doing well and i appericiate your teaching skill.
Anyone who dont understand the formula in the excel, this is the very excellent platform to learn excel.
and also you are looking very smart.
May god bless you.
I pray for you.
Good Bye
thank you for this tutorial and all of your other tutorials :) you are very helpful and explain everything well. I have been out of work for many years due to 12 surgeries that I have had and am now trying to get back into the working field. some of my excel areas were a bit rusty and your tutorials have been very helpful so thank you :)
Thank you, retired and needed to get a refresher!!! You did a great job, looking forward to watching more,
Thank you Kevin, this is so easy and well explained. In older versions, to add numbers i just click in the cell add the = then i could just tap on the cell I needed to add and it will automatically add the + sign, the newer version does not do that. What setting should I change, to have it?
I learned much much more than I learned at the university in one and a half hour today. Thanks!
Great video! Thank you for doing these. Just went into business for myself and your videos are helping so much with time management and work flow!!
This is the best tutorial I have ever came across on TH-cam, easy and straight forward, thank you Kevin
Nice tutorial and an even nicer jaw-line
Charlie u be gi I was going to write mock and was sitting on rock bottom thank u may God bless u
I hope u come up with you own spreadsheet one day
We must admire the level of human intelligence and memory capacity.
Wow 5 years ago. Today I learnt a lot, thanks so much!
Better than my math teacher, computer teacher and my father
This guy is amazing im excel pro now because of your excellent teaching 🎉🎉🎉🎉
Hi Kevin!
Great tutorial! I just wanted to ask which screen recorder you use, and whether or not it's better than Xbox game bar. Thanks
use "OBS STUDIO". I ALSO LEARNT ABOUT THIS FROM KEVINS VIDEOS
Hola! Tengo 44 años y quiero aprender como usar excel solo que las clases y mi horario de trabajo no me dejan, y encontrar tus videos tan bien explicados me ponen muy contenta. Muchas gracias por compartir tu sabiduria.😊
This is an equivalent of learning commands in Minecraft.
You are a great teacher. Your explainations are clear THANK YOU. Please continue making videos
I want to learn how to format excel
I must say Kevin, you posses Mind-blowing mentoring quality! Thank you so much. It was very helpful.
I am the 10th dislike do I get a prize? :)
Thanks for the like.
youre Welcome
:)
Thanks bro for the support couldn't do it without the fans.
youre Welcome
:)
Thanks bro for the support couldn't do it without the fans.
thank you so much. I have a oot of trouble with stuff like this and trying to learn it online with a teacher not showing it like you had me so stressed. You are amazing. Thank you so much. I can do it now.
Thanks bro from somalia 🇸🇴
thankyou so much Kevin, thus was really helpful.......what you just taught me in 12 mins was what i was trying to learn from my book since hours
wow time stamps he is a great guy!!!!! I only needed to watch count but end up watching the all video because he sounds calm and gives detail meaning amazing
I watched so many videos to understand this perfectly.. but you’re the one who taught it perfectly..... Thank you so much!!:)
Literally, the best tutorial, easy and straight to the point, thank you ver much.
Wow, what an awesome big deal in few minutes! I can't wait to get more from you.
Grace Uganda 🇺🇬
THANKS FOR THE VEDIO...SUPER HELPFUL😊😁❤
i love your lectures, i understand better
I’ve learned more from youtube and other online video platforms in a year then what I was taught in Highschool. Thanks prof. Bless
Very much appreciated! Saw this just before my practicals and I have to say, I learnt more from here than my own professor XD
Thank you. I've been in IT for over 10 years and Excel is the one thing I just never learned for whatever reason 😆
Thank you sincerely for posting this video. I have decided to continue my education and it has been years since my last accounting course. This video is a great refresher.
Thanks for this simple & benefit description.
This video was really helpful, I feel like I understand Excel a bit better now. Thank you!
THANK YOU for turning my 33 page lecture on excel formulas into an easy to follow 12 minute video. ur a life saver!