🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html 📊 In-depth Pivot Table tutorial: th-cam.com/video/PdJzy956wo4/w-d-xo.html
how shot I do not suppose theres away to count how many cells are in a certain colour. E.G if I make a cell blue it adds another to blue its for an occupancy tracker?
If you actually go to a quiz to test your excel knowledge, keep in mind that the name of the functions is translated to the language excel ia installed in. So lookout for that. Example in italian the "IF" function is called "SE". And this apply to all functions.
As I'm sure everyone else watching these videos can agree, I truly appreciate all the effort you give to create these videos, Kevin. I've watched this one as well as your video vlookups and find them to be extremely helpful and well explained. You're going to help me advance my career tremendously. Please continue doing what you're doing and spread the knowledge
As I'm sure everyone else watching these videos can agree, I truly appreciate all the effort you give to create these videos, Kevin. I've watched this one as well as your video vlookups and find them to be extremely helpful and well explained. You're going to help me advance my career tremendously. Please continue doing what you're doing and spread the knowledge.
I'm THIIIISSS CLOSE to landing a job, have a meeting with their "Data Science" head today to judge my excel skills. I was worried until you said "I got you" - This video literally refreshed the 20 year old excel skills I learned in college enough that I feel confident I will pass their test. Thanks man, you really got straight to the point with everything. I'M GONNA BE THE BEST GOD DAMNED COOKIE SALESMA...!... I mean Fuel Delivery Fleet Manager... Damn, now I want cookies.
I’m currently taking Excel and I don’t know anything about computers. I started my course and they just threw me there and nobody teaches me, they just tell me what to do and to complete my assignments. I have to watch videos and figure out all on my own. It’s very frustrating but I’m glad TH-cam exist. This tutorials are amazing. Thank yoh
Been using Excel for decades but you taught me something new in the first minute... ! Also brought back the happy memories of discovering spreadsheets right at the beginning, and made me fall in love with that simple power all over again. It really helps that your delivery is flawless, the effort you must have made to achieve it is much appreciated.
A full chapter in my school lessons in computer science about formulas and functions. More than 2 hours of classes, but this video definitely has got more value! Amazing!
What I liked most about your tutorial is that everything is connected as if you are solving a real-life problem. That brings up the 'narrative' in your instruction which makes it even easier to remember. Can't thank you enough. Brilliant job, Kevin!
Provided pin-pointed and subtractive explanations of formulas and functions, making the complex concepts clear and concise for the students to grasp easily. Thank you.
I wish I could click like multiple times. This is the best Excel training I have ever come across on TH-cam. I will be watching and listening to the rest of your videos. Stay great as you are.
Wow, Thank you Kevin for making a 52 minutes video tutorial just of formulas and functions. Many formulas and functions in one video. Thank you, thank you, thank you.
The fill handle is EXACTLY what I was looking for to speed up my homework using excel functions. Thank you and bless you for this video. I will definitely be bookmarking for future reference too.
I consider myself quite proficient in Excel, and I learned a few little tips in this video (mostly just little shortcuts that will make troubleshooting a bit easier). Thanks.
I'm always learning new things in Excel... I don't think that will ever change! I love researching these topics and digging back into the basics to find new shortcuts to make my workflows easier and more efficient. 😁
This one-hour video basically helped me get to “Expert level” from “Proficient level” at work skill assessment. That’s how helpful it is. Thank you very much!!
Kevin bro, I've been watching your videos for years now, I'm in university and studying IT now and honestly your videos are informative and concise, thanks for all the help bro. I also like how you include the worksheet as that it makes retaining the information much easier and helps with learning keep up the good work
" many thanks " from the Philippines. I enrolled myself to an online data analytics course and this is amazing additional reference . You are just amazing! more power to you Kevin.
One of the best tutor I have seen this far. Very practical and easy to follow even if you are unfamiliar or have no idea such functions could do those stuff. @kevin thank you sir!
Thank you. Always learn something new from your valuable video lesson. Today I learned what is K in large and small functions. I need to practice more on excel
My notes: SUM MAX MIN LARGE (eG 2nd most) SMALL (eG 2nd least) Count Counta Countblank Average Median (middle number) Mode (which number occurs most frequently) Sumif (sum up values if it meets a certain criteria. Eg how many cookies we sold ONLY in US so first u highlight the row of US for ur range, then ur criteria is just US, sum range is what numbers u wanna get back to ) Sumifs Averageif Averageifs Countif Cluntifs Minifs Proper (to make every word have capital letter ) Trim (to remove the extra space in front) Concat (to join cells in a single cell) Textjoint (also to join cells in a single cell but u can include space in between them by typing “ “, TRUE, then highlight ur cells)
Kelvin, your lectures are always amazing, I have been look for someone to explain these codes and functions in simple terms for a better understanding. Thank you.
I watched the whole thing, except from that If fuction part with Or/and etc (too complicated for me) I cant thank you enough fot the course. I already subbed from the shorter version which was like 13 min long
The thing I love about your videos is that I always learn something new, even if I've been using an application for years. The LEFT + FIND formula would have saved me SOOOO much time in my last job where I frequently had to parse data out of email addresses. (Since I didn't know about this formula, I did it using Text to Columns, which was much more time-consuming.)
Excellent learning presentation. Thank you so much I always had Office but never had made it to work for me until now!! I only being using simple tasks but not the whole range of formulas bacause I was always getting errors and frustraction keept me away from even retraying then again, I been missing a lot! Thanks again and will pass it ON.
If "like" and "subscribe" came in jumbo size, I "love" and "am stalking" this channel. If I can remember half of what I'm learning from Kevin, I may streamline my job so much I can actually leave my work at the office. THANK YOU, Kevin!
Hi Kevin. I love watching your videos as they are easy to follow. I've been learning a lot and your tutorials have been a big help to me in doing my reports. By the way, do you have a tutorial on how to plot x,y,z, data (3-dimentional data) on excel?
Thank you Kevin! I found myself with a sudden need to learn to use Excel better and this video was very helpful. I even learned a couple tricks some more experienced Excel users didn't know!
Thank you for being more informative on your video. Your hard work is truly appreciated in your videos. Thank you for also making it simple so that it can be understandable.
Thanks for you help with excel, I can listen to you all day, could you please advise me how to find a circular reference that is not apparent and is hidden within a large excel sheet. Thank you from the UK
This is what I have been needing, find them to be extremely helpful and well explained plus it's an excellent tutorial that makes you understand functionalities to the core.
You are an Excel genius! Your instructional cadence is exceptional! Please keep the tutorials coming. I am subscribed and waiting....! Thank you once again for sharing your skills with us.
🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com
⏭ Watch more free Excel tutorial videos: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
📊 In-depth Pivot Table tutorial: th-cam.com/video/PdJzy956wo4/w-d-xo.html
how shot I do not suppose theres away to count how many cells are in a certain colour. E.G if I make a cell blue it adds another to blue its for an occupancy tracker?
If you actually go to a quiz to test your excel knowledge, keep in mind that the name of the functions is translated to the language excel ia installed in. So lookout for that.
Example in italian the "IF" function is called "SE". And this apply to all functions.
I hope you can a short video for advance quickbook. Thank you!
Thank you so much Sir ❤ Big help 🙏
As I'm sure everyone else watching these videos can agree, I truly appreciate all the effort you give to create these videos, Kevin. I've watched this one as well as your video vlookups and find them to be extremely helpful and well explained. You're going to help me advance my career tremendously. Please continue doing what you're doing and spread the knowledge
As I'm sure everyone else watching these videos can agree, I truly appreciate all the effort you give to create these videos, Kevin. I've watched this one as well as your video vlookups and find them to be extremely helpful and well explained. You're going to help me advance my career tremendously. Please continue doing what you're doing and spread the knowledge.
@
I'm THIIIISSS CLOSE to landing a job, have a meeting with their "Data Science" head today to judge my excel skills. I was worried until you said "I got you" - This video literally refreshed the 20 year old excel skills I learned in college enough that I feel confident I will pass their test. Thanks man, you really got straight to the point with everything. I'M GONNA BE THE BEST GOD DAMNED COOKIE SALESMA...!... I mean Fuel Delivery Fleet Manager... Damn, now I want cookies.
Did you get the job? Cause this is where I'm at.
@@JustJulie-cz8fs now did you get the job because I am exactly where you are
Thank you so much Kevin, I cleared my interviews and now I am a Business Analyst!!
Congratulations bro!
I’m currently taking Excel and I don’t know anything about computers. I started my course and they just threw me there and nobody teaches me, they just tell me what to do and to complete my assignments. I have to watch videos and figure out all on my own. It’s very frustrating but I’m glad TH-cam exist. This tutorials are amazing. Thank yoh
Been using Excel for decades but you taught me something new in the first minute... !
Also brought back the happy memories of discovering spreadsheets right at the beginning, and made me fall in love with that simple power all over again.
It really helps that your delivery is flawless, the effort you must have made to achieve it is much appreciated.
you are the best. the way you are talking and explaining, alongside with showing the view of the pages correctly, is incredible
A full chapter in my school lessons in computer science about formulas and functions. More than 2 hours of classes, but this video definitely has got more value! Amazing!
What I liked most about your tutorial is that everything is connected as if you are solving a real-life problem. That brings up the 'narrative' in your instruction which makes it even easier to remember. Can't thank you enough. Brilliant job, Kevin!
Provided pin-pointed and subtractive explanations of formulas and functions, making the complex concepts clear and concise for the students to grasp easily. Thank you.
The video is a bit long but very educational, thank you very much!!! Now you know that my Excel has errors when using some functions.
mmm it's complicated to tell you what it could be but it's most likely but can I ask you how you got it?
I downloaded it completely from a page
Then maybe you downloaded it incompletely, try searching on a BNH software type page that gives it to you with all the functions enabled
aha and what is the difference with the other pages?
Well, at least they sell the office packages and have the official license.
I wish I could click like multiple times. This is the best Excel training I have ever come across on TH-cam. I will be watching and listening to the rest of your videos. Stay great as you are.
Ohhhh yess! This is what I have been needing. Love all the helpful timestamps and workbook for this course. Thanks Kevin. :)
Wow, Thank you Kevin for making a 52 minutes video tutorial just of formulas and functions. Many formulas and functions in one video. Thank you, thank you, thank you.
Thank you so much Kevin! Couldn't be better. Free files to download, unlike many other TH-camrs, as well as timestamps. So thoughtful!
Brother, would you please tell me how can I download those workbooks? I'm having a hard time downloading them. 🙏🏻
@@htp1425 Hi, once you open the link (located in the description box of the video), you can go to the top left corner, File, and Save it as a copy.
The fill handle is EXACTLY what I was looking for to speed up my homework using excel functions. Thank you and bless you for this video. I will definitely be bookmarking for future reference too.
I consider myself quite proficient in Excel, and I learned a few little tips in this video (mostly just little shortcuts that will make troubleshooting a bit easier). Thanks.
I'm always learning new things in Excel... I don't think that will ever change! I love researching these topics and digging back into the basics to find new shortcuts to make my workflows easier and more efficient. 😁
Thank you soooo much. This hour of your life just saved several thousands in our lives
This one-hour video basically helped me get to “Expert level” from “Proficient level” at work skill assessment. That’s how helpful it is. Thank you very much!!
Love it! Thanks for sharing, Yiyi!
@@KevinStratvert 😇🙏
My father knew Xcel better than my school teachers, and I was always in spotlight in my computer class😁
ikr
You guys learned Excel in school?? :(
@@Fubblsome yes
Then why are you watching this video
@@redevil5352 because I don't know them.
I never got a chance to have interest in excel.
Giving tis video a view was just a curiosity.
I amazed on how you teach kev, it’s clear and the sequenze is so good how you introduce the elements
An Haitian who watching those wonderfull videos from the dominican republic,thaaaank you so much.
Kevin bro, I've been watching your videos for years now, I'm in university and studying IT now and honestly your videos are informative and concise, thanks for all the help bro. I also like how you include the worksheet as that it makes retaining the information much easier and helps with learning
keep up the good work
" many thanks " from the Philippines. I enrolled myself to an online data analytics course and this is amazing additional reference . You are just amazing! more power to you Kevin.
You saved me at least 12 hours worth of hand jamming calculations 😂 you’re the best!
Thank you so much. I have learnt many things of excel just from this single video. You are very dedicated and also a good person.
One of the best tutor I have seen this far. Very practical and easy to follow even if you are unfamiliar or have no idea such functions could do those stuff. @kevin thank you sir!
Thank you. Always learn something new from your valuable video lesson. Today I learned what is K in large and small functions. I need to practice more on excel
My notes:
SUM
MAX
MIN
LARGE (eG 2nd most)
SMALL (eG 2nd least)
Count
Counta
Countblank
Average
Median (middle number)
Mode (which number occurs most frequently)
Sumif (sum up values if it meets a certain criteria. Eg how many cookies we sold ONLY in US so first u highlight the row of US for ur range, then ur criteria is just US, sum range is what numbers u wanna get back to )
Sumifs
Averageif
Averageifs
Countif
Cluntifs
Minifs
Proper (to make every word have capital letter )
Trim (to remove the extra space in front)
Concat (to join cells in a single cell)
Textjoint (also to join cells in a single cell but u can include space in between them by typing “ “, TRUE, then highlight ur cells)
I can't actually explain how much you helped me, I teach a course now thanks to your materials and your way of teaching, Great job
One of the best excel courses I have come across. Thanks, Kevin!
Thank you for this Kevin. Professional, straightforward and easy to follow.
Very Well Sir Just Completed my assignment and wanna thank you😊. Keep making such useful and knowledge building videos.
Thanks Kevin. I love the way you explain these things. So far this is the best excel tutorial I've seen
Much appreciated 👍. Keep up the good work. Much love from Ghana 🇬🇭
This video has been very helpful for excel training on formula and functions. Thank you so much
1.4 Million views and only 22k likes. What a shame.
Thank you for taking the time to share your knowledge, Kevin! I truly appreciate it. 🙏
I appreciate the combo of practicality & clarity, you're a fantastic teacher
I use nested if statements quite a bit. Glad to have learned IFS. That will save me tons of time and headaches when I make a typo.
Kelvin, your lectures are always amazing, I have been look for someone to explain these codes and functions in simple terms for a better understanding. Thank you.
Ahhhh! Finally the boss is here. Thank you so much man.... So much.
Mr. Kevin Stratvert your the best teacher in the World. !!!!
I live in Excel and SAS Enterprise for my job. Learned a few things! Thanks!
kevin the way u taught it was mind blowing and so simply u explain. amazing man really so gooood........
I watched the whole thing, except from that If fuction part with Or/and etc (too complicated for me)
I cant thank you enough fot the course.
I already subbed from the shorter version which was like 13 min long
Good video. It is easy to learn this. You just need to apply some effort
All the way from Fiji. Thanks Kevin for the effort you put in, has help me in all my questions regarding formulas & functions. God Bless you.
This video, is incredible.. I have been using excel and macros for ages - and learn so much from just these "basics" really good
You're the best Kevin! 😊😊😊 I'm a big fan...
The thing I love about your videos is that I always learn something new, even if I've been using an application for years. The LEFT + FIND formula would have saved me SOOOO much time in my last job where I frequently had to parse data out of email addresses. (Since I didn't know about this formula, I did it using Text to Columns, which was much more time-consuming.)
Kevin. Excellent presentation.
you're a very good teacher
You absolutely blew my mind with the status bar metrics. How the heck did I not notice that after so much Excel use??
Excellent tutorial that makes you understand functionalities to the core...Well done Kevin
Kevin you have got a very excellent skill and thanks for helping a lot of millions like me...
Thank You very much. I'll never be an Excel genius but this video helped me so much.
HELLO KEVIN! YOU'RE A GREAT TEACHER, I'M A BEGINNER BUT I CAN UNDERSTAND IT EASIER, IT IS CLEARER ENGLISH AND STEP BY STEP TUTORIAL... EXCELLENT
👍👍
Excellent learning presentation. Thank you so much I always had Office but never had made it to work for me until now!! I only being using simple tasks but not the whole range of formulas bacause I was always getting errors and frustraction keept me away from even retraying then again, I been missing a lot! Thanks again and will pass it ON.
If "like" and "subscribe" came in jumbo size, I "love" and "am stalking" this channel. If I can remember half of what I'm learning from Kevin, I may streamline my job so much I can actually leave my work at the office. THANK YOU, Kevin!
Thanks Kevin this will help with my Microsoft Excel certification test.
Hi Kevin. I love watching your videos as they are easy to follow. I've been learning a lot and your tutorials have been a big help to me in doing my reports. By the way, do you have a tutorial on how to plot x,y,z, data (3-dimentional data) on excel?
He's also a cute guy.
What a excellent Tutor you are Kevin, Many thanks from retired Tutor, also named Kevin! from the UK 😊👍
Thank you Kevin for helping us, who aspires to be excel formula and function pro
Awesome! Very comprehensive tutorial on how to maximize the use of Microsoft Excel. I've learned a lot from you. Thank you
Game changer video for me .Literally I started liking excel after watching this masterpiece , Thanks Kevin for sharing such a helpful video.
I love your videos as well as your character your videos are so cool
Thank you very much for helping me out during my interview today 🥰🥰🥰
Such a clear and quick explanation. Helped a lot to refresh my Excel knowledge.
Your videos have been a game-changer for me. I'm finally starting to understand trading basics. 🌏
THIS LESSON WILL HELP TO GET "A" IN MY PRACTICAL EXAM 😇😇
Exactly! A job interview. I've always found Kevin's videos so helpful.
Thank you Kevin! I found myself with a sudden need to learn to use Excel better and this video was very helpful. I even learned a couple tricks some more experienced Excel users didn't know!
Great content and very easy to understand! Thank you Kevin for putting the effort, much appreciated.
Thanks Kevin for wonderful video because I revised again excel formulas and function which you explained marvelously❤
This is great. I am not proficient at all in excel and you just made this lesson so easy for me to understand
I appreciate every single minute of this stupendous video !😘😘😘😘
You put a lot of time and effort into this, as a result it's a lot of fun to learn about excel and super easy to understand. Thank you!!!
Glad it was helpful!
Just wanted to comment and say your video really helped me man !! Watched it 3 times literally and got the hang of it ! Thanks !!
I"ve not used Excel in probably 10 years, so this is refresher for me. Thanks. :) lol
This is just Awesome...... A very good Presentation much love from Nigeria
Thank you for being more informative on your video. Your hard work is truly appreciated in your videos. Thank you for also making it simple so that it can be understandable.
Thank you so much!!! Having the workbook to practice alongside was so helpful!!!! I definitely will be maximizing my Excel skills!!!
Hello where do I find the workbook
I always use your videos as reference and learn new tricks that have not known before. Great presentations. Thank you.
you are the best teacher brother God bless you
Thanks for you help with excel, I can listen to you all day, could you please advise me how to find a circular reference that is not apparent and is hidden within a large excel sheet. Thank you from the UK
This is what I have been needing, find them to be extremely helpful and well explained plus it's an excellent tutorial that makes you understand functionalities to the core.
AMAZING. Very organized and clear to the point. Easy to follow. Thank you!
You explanation is simple and excellent. You are genuis
I love your presentations. You make it very easy to understand and I always learn something new. Thanks.
You are an Excel genius! Your instructional cadence is exceptional! Please keep the tutorials coming. I am subscribed and waiting....! Thank you once again for sharing your skills with us.
What a great review, knew most of the formulas, but not the hotkeys(function keys) for some. MUCH appreciated!!!
The most helpful tips on TH-cam!!!
Thanks
Thanks for your support brother🙏 🙌 👍 ❤ 😀 😊
Sir, you have explained everything very beautifully, liked it. Thanks a lot 💎💎💎💎💎💎💎💎💎💎💎💎💎💎💎💎💎💎
Thank you very much Kevin for your great excel classes I have learned a lot
Good video for beginners. A lot of good stuff to know. Although, a lot of it isn't really necessary to know if you use pivot tables.
U made it so easy to learn seriously Good job sir
Thank you so much your videos are short and full of info. I hope you make a video for quickbook in 15 min