🆓 Watch my FREE Full Course on Excel Formulas and Functions (New for 2022): ua-cam.com/video/Y8xhrUa3KH4/v-deo.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: ua-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 UA-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.
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
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.
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 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 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! :)
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 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!
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!
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 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!!!!
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!!!
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
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😎😇
Thank you for the extreme basics in the formulas! Question - is there a formula to: - multiply - subtract all cells within a range? Kind of like how it was done to add? Thank you once again :)
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.
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 :)
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
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 tried so hard to understand excel on Lectures and seminars for 3 hours straight and kevin managed to make me understand all that in two 15 minute videos.this man is a legend
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!
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...
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.
🆓 Watch my FREE Full Course on Excel Formulas and Functions (New for 2022): ua-cam.com/video/Y8xhrUa3KH4/v-deo.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: ua-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 UA-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 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 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 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 UA-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 '.
This is exactly what I needed - so many flabby pointless Excel videos online, but this is the good stuff. Big thanks.
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
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
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
You have no idea how much you helped and how fast....Thank you.
And the detailed time fraims...wow.
Shush this video is old
He did what my teachers been doing for 3 months IN 12 MINUTES
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
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.
never felt more comfortable using sumif & vlookup function. Thanks a bunch
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!
Jargon-free straight tutorial. Never I heard someone explain excel so simply, Thanks Kevin
Thank you. I’m getting a new job and needed to brush up on things like this.
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.
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!
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?!
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 😘😘
THANKS FOR THE VEDIO...SUPER HELPFUL😊😁❤
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 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!
I actually got what I was looking for!!! Thanks so much.. you are a good teacher :)
One of my biggest weaknesses was not knowing excel, And because of you Kevin I learned it in 12.28 minutes. Thank you
Thank you for this, it's a super quick and simple explanation without going too overboard!
Nice
This man is more valuable than any college book you can buy
This is the best tutorial I have ever came across on UA-cam, easy and straight forward, thank you Kevin
That was so informative, easy to watch and learn from! Going to watch them all now - thank you!
Thank you for always having the exact way to teach something with your personable demeanor and not just some mouse moving on a screen.
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!
Thank you, I am 60 and still learning because people like you. God Bless
Thank you! Saved me. I understood this easier than my instructor. Zoom classes are somewhat difficult at times. Glad your videos are here
This was simple, to the point, and had clear examples. Miles better than many excel videos I’ve watched.
I am taking a test and need excel. Your video is great! Thank you for the professionalism and easy to follow explanations!
very easy to follow and most importantly i have learnt a new skill. THANKS KEVIN
Clear, concise, and direct Excel tutorial. Thanks Kevin!
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 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!!!!
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!!!
The sound, timing and explanation is one of the best on your video., I love it both soft world and excel I subscribed.
I must say Kevin, you posses Mind-blowing mentoring quality! Thank you so much. It was very helpful.
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
Thanks for this simple & benefit description.
Thank you so much for this video Kevin, please upload more, maybe that help with bookkeeping purposes!
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😎😇
Thanks for simplifying the tutorial for this knucklehead.
Much appreciated.
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.
Thank you for the extreme basics in the formulas!
Question - is there a formula to:
- multiply
- subtract
all cells within a range? Kind of like how it was done to add?
Thank you once again :)
Thank you, retired and needed to get a refresher!!! You did a great job, looking forward to watching more,
Please never delete this 🙏 I watched this a year ago and I needed a refresher today
Thank you! I am reviewing Excel for a new job. I'll definitely be watching your other videos.
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.
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 :)
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
it is so simple and straight forward, thank you
I watched so many videos to understand this perfectly.. but you’re the one who taught it perfectly..... Thank you so much!!:)
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 tried so hard to understand excel on Lectures and seminars for 3 hours straight and kevin managed to make me understand all that in two 15 minute videos.this man is a legend
We must admire the level of human intelligence and memory capacity.
i love your lectures, i understand better
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!!
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!!!!!
Nice tutorial and an even nicer jaw-line
You've made it look so simple. Professionally presented. Thank you.
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
Wow, what an awesome big deal in few minutes! I can't wait to get more from you.
Grace Uganda 🇺🇬
Better than my math teacher, computer teacher and my father
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!
This is an equivalent of learning commands in Minecraft.
Thanks bro from somalia 🇸🇴
I want to learn how to format excel
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 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.
I’ve learned more from youtube and other online video platforms in a year then what I was taught in Highschool. Thanks prof. Bless
Literally, the best tutorial, easy and straight to the point, thank you ver much.
Thank you for putting things into its simplest form and getting to point.
This video was really helpful, I feel like I understand Excel a bit better now. Thank you!
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.😊
Just what I was looking for. Thanks Kevin! Also, I'm now a subscriber.
You are a great teacher. Your explainations are clear THANK YOU. Please continue making videos
I am amazed at how many new things I learned in a 12 minute video. Thanks, Kevin!
Great to hear!
What an excellent teacher you are. Best video i have ever stumbled across.. Thank you!!! Wow
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 5 years ago. Today I learnt a lot, thanks so much!
Learned what I needed by 1:51 in the video. Thank you! 🙏🙏
I learned much much more than I learned at the university in one and a half hour today. Thanks!
THANK YOU for turning my 33 page lecture on excel formulas into an easy to follow 12 minute video. ur a life saver!
Very much appreciated! Saw this just before my practicals and I have to say, I learnt more from here than my own professor XD
Thanks Kevin, really helpful!👍👍👍