👉 If you're new to Excel and want to master the basics, check out 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
Good tutorial. However, when I click and drag over the cells eg: B3:E3 I numbers I enter changes from what I entered. Example: $5,500 will change to $2,000. Also when I drag down in the total column to copy and paste the formula it changes all the values in the other cells to the same value as the first cell. Example: 600 in the first cell the other cells will change to 600 also. Why is this?
honestly your teaching and delivery is perfect for people with short-term memory/attention spans like me. those 6-hour long videos make me forget more than i actually learn 😭so vids like this are perfect. i start a new job tomorrow and i haven't used excel since 2014 lmao so i was terrified about all this stuff, but this video has given me some confidence, thank you!
Brother. I’ve never used Excel in my life. After your video and 30 minutes of messing around with it, I feel pretty damn confident in my abilities. Thank you!
I'm a college biology major, and I've learned over my 4 years of this that knowing how to use Excel is way more valuable than learning the steps of glycolysis. Thanks.
@@keziagreste Absolutely. I've utilized Excel way more in my classes than I have the steps of glycolysis. Plus oftentimes you really don't need to know the individual steps as long as you know what happens at the start and end. With Excel you need to know the little things, like how to show legends in graphs, how to write equations, how to move things around, etc.
I just randomly thought "I should look for an introduction into Excel basics when I get home" and this is the first recommended I get opening my phone 😂👌 cheers
@@azizaaaa5655 actually your phone CAN read our thoughts. It’s new technology, there was this conference I saw about phones and Bluetooth.. and it was about how the electric signals in the brain can be read by phones and transferred at pictures in their system…
You saved my life with this, because I accidentally signed up for a medium level excel course while looking for a basic one and I had no idea what excel even does. The way you talked and explained things was wonderful for my AuDHD dumbass. Godspeed
This is so helpful! Fully lied at a job interview, got a job with a huge brand and I’ve never used excel once! But now I can say I know what I’m doing. Absolutely a life saver!
Same😭 I didn’t know how big the company was until I was sat in the seat at my interview. She just rang me saying I got the job I need to now watch this video all weekend
I have an interview tomorrow and they require advanced excel skills- I totally lied and said I knew about it! Hoping this video can help me like it has with the rest of you!
I have a job interview tomorrow and decided to recall how Excell works and this video is very well made. It sums up pretty much all the basics you need and is very useful. Good job and thank you for your help! ✨️💓
I start an office job on Tuesday I am a very practical hands on person and I said I have a little experience with computers and excel. I do not. I failed my IT gcse with the lowest score so thank you so much for this! Hopefully I know what I’m doing by Tuesday!
kevin sir; I wanted to express my heartfelt gratitude for your outstanding teaching. Your dedication and passion for imparting knowledge have truly made a difference in my life. Your guidance has not only enriched my understanding of the subject but also inspired me to strive for excellence. Thank you for being an exceptional teacher!
Many sellers and tools can activate Office. I tried various sources, including eBay, but they also stopped working after a few months. I had to reinstall my OS due to malware so I stopped using free options. After thorough research I found a great company with fair prices and haven't had any issues since. Else you can buy directly Office 365 and pay every month for the license key
This is by the far the best tutorial and I was a beginner just knew some of the basics but I’m glad I know more and this guy speaks so clearly and concise and is straight to the point
Kevin, you are saving me! I don’t use Excel at work all the time but that once a year is crucial I learn it. I’m taking your beginner course because I know the basics but I do EVERYTHING MANUAL the long way!!! I MUST BECOME EFFICIENT
I felt like a total idot for not knowing this most basic skill and it severly hamperd my job search. This short video has completely given me the confidence now to widen my job search👌🏻 Thank you
Completely lied and said I have the required Excel skills that they need! Job interview is tomorrow! Watching this video and hoping to learn as quickly as everyone who’s also watched it!
This was fantastic! I am working with a massive excel table and need to produce different graphs. The shortcuts, the small tricks and the very clear introduction to pivot tables (and pivot charts in another video) hacked it for me. You saved me hours!
I’m here because I learned on Google Sheets by luck of the draw in prior work places. Got laid off two years in a row and the market demands Excel knowledge for the fields I am focusing on. Thanks for the great, quick video! This is exactly what I needed!
Your expertise and clarity in delivering the presentation on Excel made my life and many other lives I am sure exceptionally beneficial. Perfect timing, short, simple and easy to follow. THANK YOU!!!!
World best teach. I am a masters degree hold from a recognised University in England. Do not have any knowledge of excel, but with this video, my confidence of knowing excel just reminded be that a am a Nigerian that should be naturally bold and smart❤. Thanka bro
I’ m gonna start a new job soon, a job I always dreamed of to have. I hope I will be good with these Microsoft programs,God bless me! I really want this 🙏
Bro I signed in just to comment… this is the best excel 101 videos I’ve seen.. the explanation step by step is perfect for me & I hope I find more videos of excel on your channel!
I am glad I found you man! Wrote "can do excel" for years in resume but procrastinated to learn longggg training courses. Needed to do a basic excel sheet for work tomorrow and here you are with 15 min video to save my life :) Thank you!
Honestly I love this video and the way you are teaching! It's not too fast and everything is well understood and on the same hand it's not too slow! I think it's really important to not slow down too much, because one might loose the viewers attention - you did PERFECTLY!! :))
Amazing! You did it in 15 minutes. Great job. You covered the key points nicely. I've been using Excel since it was introduced and learned some new features I hadn't explored before. Thank you so much.
Love the video Kevin! Particularly like the part about using Color Scales in Conditional Formatting, such a great tool for highlighting important sections of your data.
Today at school we were doing a work on excel, at the start i was doing pretty good but the teacher started going to fast and i got lost, this video is really helpful
God bless you Kevin. If I could hug you right now I would - since I can't - All I can do is send you hugs, prayers and blessings from this black lady in her 60s - across the pond here in England, UK ❤❤❤❤🕊
Thanks Kevin 🤙 I appreciate the info. I’m going out for a new role that involves data entry and a WIP report. All has to be very precise. This was a nice refresher. A bit nervous 😅 going to poke around your other videos to see what I can learn. Have a good one 👍
Duuude like thank you so much for this video. I was mind blown by watching it especially the pivot tables part. You make excel sound less intimidating. I never really liked it when I was learning it in school lol thank you!
Interviewer: We use Excel for 80% of our filing. Is that an issue. Me: *Internal scream* Excel and I are best mates. Proceeds to get a job offer for THE job. Now I'm here. 😂
Along with many of the other people watching this video, I also lied on a job application about knowing excel. I’ve never used this a day in my life or knew what it was until today, I hope I learn it quick😅
great, thank you. I wathced this video half asleep at speed 0.25. It's so gooooood that TH-cam offers that option. It made learning so oooo much easier + easier to focus! Thank you for sharing this education
i really dislike the 365 , it is just so inhibiting and frustrating to use . Saving documents also a disaster , i just cancelled mine . why dont they also create an offline one like all the previous versions . That was perfect fort me .
I was trying this on Excel web version today and when I used shift it wanted to move the date column directly on top of the sales one ( trying to replace it ). After banging my head against the computer I simply tried to move the date column without shift and it allowed me to move it to the left of the sales column like he did in the video. Sorry for replying a year late but maybe this helps someone else too !
These videoes are very informative! I'm currently studying to brush up on my skills. Every video I have watched has been perfect for me to understand and learn from. Thanks team!!
That was amazing. I went from „I hate excel, it keeps doing things on its own!“ to „I love excel, it keeps doing things ON ITS OWN!“ in about 15 minutes 😄
I have very minimal experience using Excel, and just got a new job where I might have to be using it. This was pretty informative and helpful. Thanks for the info!
I have an interview tomorrow that requires Excel and of course like many of us on here, I embellished the truth 😂 Now I know l I’ll be ok since I found you! Thank you!!!
I love excel. I’m retired now. But used it a lot when I was working. I wasn’t an expert by any means. I was just dangerous. 😊. With Excel you can turn your data every which way but lose.
👉 If you're new to Excel and want to master the basics, check out 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
Wes lpr
6
@@AaronThurman4-fk6fp❤
My laptop has not activated Microsoft activation how can get it free please tell me 😢
Good tutorial. However, when I click and drag over the cells eg: B3:E3 I numbers I enter changes from what I entered. Example: $5,500 will change to $2,000. Also when I drag down in the total column to copy and paste the formula it changes all the values in the other cells to the same value as the first cell. Example: 600 in the first cell the other cells will change to 600 also. Why is this?
You talk too fast so had to pause each section.😊
Lied about my experience with excel (haven’t used it in 8 years) and was panicking about a job interview but this video saved my life!
Same girl, same 😂😂😂😂
Same. Do people use this in real life
Same 😂
That’s why we’re here!!
So we're all here for the same reason? Lol
honestly your teaching and delivery is perfect for people with short-term memory/attention spans like me. those 6-hour long videos make me forget more than i actually learn 😭so vids like this are perfect. i start a new job tomorrow and i haven't used excel since 2014 lmao so i was terrified about all this stuff, but this video has given me some confidence, thank you!
i also start a new job tomorrow! How did yours went? :0
wellsaid
may God bless all of you in your journies🙏🏽
I am an economist and data analyst, working as a business intelligence consultant. With Kevin everything looks so clear. Thank you man
BLimey, you are all that and you don't know Excel, I feel better already..
😂😂
🤣🤣
Please I'm also an Economist and also pursuing Data Analytics skill, can you be my Mentor?
Brother. I’ve never used Excel in my life. After your video and 30 minutes of messing around with it, I feel pretty damn confident in my abilities. Thank you!
Really. I wish I can too
I'm a college biology major, and I've learned over my 4 years of this that knowing how to use Excel is way more valuable than learning the steps of glycolysis. Thanks.
Wait are u fr lol
@@keziagreste Absolutely. I've utilized Excel way more in my classes than I have the steps of glycolysis. Plus oftentimes you really don't need to know the individual steps as long as you know what happens at the start and end. With Excel you need to know the little things, like how to show legends in graphs, how to write equations, how to move things around, etc.
@@doctordestructo3360 Damn.. never would've thought that.. interesting for sure
A biologist here as well
Also a bio major and it’s more helpful than most of what i learned 👍🏽
I just randomly thought "I should look for an introduction into Excel basics when I get home" and this is the first recommended I get opening my phone 😂👌 cheers
Same!!!
You guys don’t use excel at work?
so true
The almighty algorithm is always watching!
@@azizaaaa5655 actually your phone CAN read our thoughts. It’s new technology, there was this conference I saw about phones and Bluetooth.. and it was about how the electric signals in the brain can be read by phones and transferred at pictures in their system…
You saved my life with this, because I accidentally signed up for a medium level excel course while looking for a basic one and I had no idea what excel even does. The way you talked and explained things was wonderful for my AuDHD dumbass. Godspeed
Wow! A 6 hour training course in 16 minutes. I'm impressed.
im not
@@Dimitar77
Well, if you think you can do better, I'll watch out for your video. I won't hold my breath though.
@@Dimitar77 Lol, get rekt!
😅
Mmm hhmmm
This is so helpful! Fully lied at a job interview, got a job with a huge brand and I’ve never used excel once! But now I can say I know what I’m doing. Absolutely a life saver!
And it's going well? 👀
Same😭 I didn’t know how big the company was until I was sat in the seat at my interview. She just rang me saying I got the job I need to now watch this video all weekend
I haven't used Excel in depth, since I graduated college.
I have an interview tomorrow and they require advanced excel skills- I totally lied and said I knew about it! Hoping this video can help me like it has with the rest of you!
I sugarcoated the truth on my resume and now im here😂😂
Hahaha same here 😂
@@DeniseViolettawell i got the job and it was my first day today, this did the trick😂😂
@@MartinaMatak-nq4nv congrats!!! Wish me luck lol
Same 😂😂😂😂
Hh same here
I have a job interview tomorrow and decided to recall how Excell works and this video is very well made. It sums up pretty much all the basics you need and is very useful. Good job and thank you for your help! ✨️💓
How did the interview go??
YES ,TELL US....HOW DID THE INTERVIEW GO ? @@elisesnyder5809
How was your interview
im about to start my very first data entry job and wanted a little refresher before i get thrown into training, this helped so much, thank you!
How do get your new job
Same 😂😂
Omg same here !
I start an office job on Tuesday I am a very practical hands on person and I said I have a little experience with computers and excel. I do not. I failed my IT gcse with the lowest score so thank you so much for this! Hopefully I know what I’m doing by Tuesday!
kevin sir;
I wanted to express my heartfelt gratitude for your outstanding teaching. Your dedication and passion for imparting knowledge have truly made a difference in my life. Your guidance has not only enriched my understanding of the subject but also inspired me to strive for excellence. Thank you for being an exceptional teacher!
Thanks a lot for the video! Btw how can I get an Excel product key? I used a free method but it stopped working.
Many sellers and tools can activate Office. I tried various sources, including eBay, but they also stopped working after a few months. I had to reinstall my OS due to malware so I stopped using free options. After thorough research I found a great company with fair prices and haven't had any issues since. Else you can buy directly Office 365 and pay every month for the license key
@@Benjaminpro55 I prefer to pay one time for a key and that's it. Could you share the name of the company that you found?
Yup you right.. Their name is BNH-Software
BNH Software
@@Benjaminpro55 Thanks! Bought Office 2021 and activated my Excel :)
This is by the far the best tutorial and I was a beginner just knew some of the basics but I’m glad I know more and this guy speaks so clearly and concise and is straight to the point
very true
I learned excel in school and forgot it all so glad I found you since now I need it work at least once a month 🙏🏾
Kevin, you are saving me! I don’t use Excel at work all the time but that once a year is crucial I learn it. I’m taking your beginner course because I know the basics but I do EVERYTHING MANUAL the long way!!! I MUST BECOME EFFICIENT
I'll just keep struggling the old way 2. Yhyh GOOD PLAN 😊❤ 2.22 into this video and have shut down
I felt like a total idot for not knowing this most basic skill and it severly hamperd my job search. This short video has completely given me the confidence now to widen my job search👌🏻 Thank you
Wow!! This is the first time I’m learning Excel!! I wanna learn and be confident in the basics at least and I’m so glad I found you. 👍
Same here I know nothing of it
You saved my life!! I have an interview tomorrow and I lied about being advanced in excel ( I definitely am not) but you saved me! Thank you🙏🏻
I love that 95% of us are here because we may or may not have lied on our resumes LMAO Cheers 🍻
That's a definite for me lol
100% exactly why I'm here.
Completely lied and said I have the required Excel skills that they need! Job interview is tomorrow! Watching this video and hoping to learn as quickly as everyone who’s also watched it!
Gen X here, Thank You! This wasn’t taught when I went to college and I prefer how you explain these products. Top notch! Ty
so we all lied on our CVs?
Yup
But y are u like this 😂 am about yo go for an interview and have remember this 😂 that's y am here 😂😂😂
Yes 😂😂😂
Lol
😭😂
People with such a teaching ability should be teaching absolutely everywhere. I never learned anything so easily in my entire life so dynamic! ❤
This was fantastic! I am working with a massive excel table and need to produce different graphs. The shortcuts, the small tricks and the very clear introduction to pivot tables (and pivot charts in another video) hacked it for me. You saved me hours!
I’m here because I learned on Google Sheets by luck of the draw in prior work places. Got laid off two years in a row and the market demands Excel knowledge for the fields I am focusing on. Thanks for the great, quick video! This is exactly what I needed!
Your expertise and clarity in delivering the presentation on Excel made my life and many other lives I am sure exceptionally beneficial. Perfect timing, short, simple and easy to follow. THANK YOU!!!!
World best teach. I am a masters degree hold from a recognised University in England. Do not have any knowledge of excel, but with this video, my confidence of knowing excel just reminded be that a am a Nigerian that should be naturally bold and smart❤. Thanka bro
One day you are looking for Call of duty clips and now you are looking for how to use excel
Nah fr bro
Lmfaooo real !
😢😢😢😢😢
My mom wanted me to use excel to help her with work, and this is the first thing that pops up in my TH-cam feed, Thanks Kev
This was a super quick and straightforward tutorial. It makes me feel like it’ll be a breeze. Thanks!
I’ m gonna start a new job soon, a job I always dreamed of to have. I hope I will be good with these Microsoft programs,God bless me!
I really want this 🙏
How simply you're explaining everything and we are understanding every single word very easily. Thanks a lot! Please share more videos on Microsoft.
More to come!
Haven't used Excel since roughly 2013, some things are still the same, but there is plenty of new features to it. Glad I am finally updated again.
When your interview is tomorrow 😅
LOL mine is next week. I have NEVER used Excel but because of this I passed their assessment test(73%). Hoping I can do ok on the actual job🤣
omg it IS tomorrow for me. i gotten training and a certificate in this in 2016 but i don't remember jack nothing
Mine is today 😂
@@lolokazi Good luck!!
THIS IS WHY HE'S THE GOAT
Bro I signed in just to comment… this is the best excel 101 videos I’ve seen.. the explanation step by step is perfect for me & I hope I find more videos of excel on your channel!
I am glad I found you man! Wrote "can do excel" for years in resume but procrastinated to learn longggg training courses. Needed to do a basic excel sheet for work tomorrow and here you are with 15 min video to save my life :) Thank you!
Who's here because they have a job interview and they mentioned theres gonna be a basic Excel test? 😂😂😂
here but she is my cousin
Honestly I love this video and the way you are teaching! It's not too fast and everything is well understood and on the same hand it's not too slow! I think it's really important to not slow down too much, because one might loose the viewers attention - you did PERFECTLY!! :))
You are awesome... I love your tutoring style... straight forward, polite, charasmatic... Excel is fun - looking forward to learning more 💛
Amazing! You did it in 15 minutes. Great job. You covered the key points nicely. I've been using Excel since it was introduced and learned some new features I hadn't explored before. Thank you so much.
This is the best tutorial I've ever watched in my life till now !
Love the content and the way you teach
Believe me after watching your videos I think no need to going school or university
Learn everything In minutes
😅 2:09
Thank you so much Kevin..loved your video. It was so nicely put together for better understanding for a person who is new to excel😊
Thank you Kevin. You are a good teacher.
Tomorrow is my Computer Practical Exam and i am not interested in computer science but you cleared my doubts:) Thanks Man
Short ,concise and informative, thank you so much !
this is amazing, this is my question long time ago, i ask peoples help, no one answers and here you answered and helped me all the way
Wow Kevin, thanks, I learned a whole lot about excel in a very short time. Now I need to practice it. Thank you, love this format to learn.
the best thing was you didn't waste any time in useless description of anything. loved it.
I'm watching this before a job interview 💀
Lol I already had the interview, and I told them I'm proficient in Excel, knowing good and well I'm at a beginner level 😅. So I'm taking notes
Started college for accounting and about to take the excel course. This helped me get a jump start! Thanks!
Who else is hear because they're writing a test tomorrow😂
Me😭
Me 🙃
That's me 😂
Job interview 😅
Thank you for posting this, I learned this back in high-school many many years ago, I wanted to refresh and relearn so thank you
Best and most clear tutorial I've ever seen! Thank you so much!
This is the best tutorial I've ever seen. Complex makes simple. Thank You Kevin !
My fullest deepest appreciations to your great work, thanks.
I learnt more in 15 mins about excel than I have in the past 18 years of my life...... THANK U!
I just started to learn data analysis and this video is really helpful to start with. Thank you.
Same here, I'm learning data analytics and frontend dev
One of the best valuable and straight to the point videos on TH-cam ❤
Love the video Kevin! Particularly like the part about using Color Scales in Conditional Formatting, such a great tool for highlighting important sections of your data.
Today at school we were doing a work on excel, at the start i was doing pretty good but the teacher started going to fast and i got lost, this video is really helpful
I loved that simple click to adjust the columns in a structured way❤
Wow, amazing lecturing I do enjoy it, am learning now when am 27 😊, never too late. Thanks, bro. Would keep learning more from your videos.
Excellent and very informative
The Pivot table is underrated, I love it!
Pivot tables are the best!
Kevin, as always, another informative video, thanks!
Thanks again!
God bless you Kevin. If I could hug you right now I would - since I can't - All I can do is send you hugs, prayers and blessings from this black lady in her 60s - across the pond here in England, UK ❤❤❤❤🕊
Thanks Kevin 🤙 I appreciate the info. I’m going out for a new role that involves data entry and a WIP report. All has to be very precise. This was a nice refresher. A bit nervous 😅 going to poke around your other videos to see what I can learn. Have a good one 👍
Excellent!!! Quick simple and straight to the point
Awesome 👌
Kudos to you for these great and well summarized videos. To think I was scared learning excel was gonna be super tough 😂
Duuude like thank you so much for this video. I was mind blown by watching it especially the pivot tables part. You make excel sound less intimidating. I never really liked it when I was learning it in school lol thank you!
Interviewer: We use Excel for 80% of our filing. Is that an issue.
Me: *Internal scream* Excel and I are best mates.
Proceeds to get a job offer for THE job. Now I'm here. 😂
Along with many of the other people watching this video, I also lied on a job application about knowing excel. I’ve never used this a day in my life or knew what it was until today, I hope I learn it quick😅
Excellent presentation within a short time... Thank you
Glad you liked it!
I have learnt so much from You Kevin over the years. And I continue to learn. Thank you.
Please which excel are you using
Mine doesn’t have analyze data
great, thank you. I wathced this video half asleep at speed 0.25. It's so gooooood that TH-cam offers that option. It made learning so oooo much easier + easier to focus!
Thank you for sharing this education
i really dislike the 365 , it is just so inhibiting and frustrating to use . Saving documents also a disaster , i just cancelled mine . why dont they also create an offline one like all the previous versions . That was perfect fort me .
One of the usefull videos in TH-cam.tank you brother
I don’t understand how you moved the date and sales column in 6:10
I was trying this on Excel web version today and when I used shift it wanted to move the date column directly on top of the sales one ( trying to replace it ). After banging my head against the computer I simply tried to move the date column without shift and it allowed me to move it to the left of the sales column like he did in the video. Sorry for replying a year late but maybe this helps someone else too !
Taking research in Grad school. This was very helpful, thank you !
These videoes are very informative! I'm currently studying to brush up on my skills. Every video I have watched has been perfect for me to understand and learn from. Thanks team!!
That was amazing. I went from „I hate excel, it keeps doing things on its own!“ to „I love excel, it keeps doing things ON ITS OWN!“ in about 15 minutes 😄
You've made this video tutorial very concise, clear, and simple. 100% helpful
Majoring in business at college. Video helped a ton. Thanks Kevin
I have very minimal experience using Excel, and just got a new job where I might have to be using it. This was pretty informative and helpful. Thanks for the info!
Smooth easy learning. Awesome video!
I thought I was pretty good at the basics, but I learnt so much from this quick and easy tutorial! Moving onto more!
It covers a lot within 16 mins. Thank you so much.
I have an interview tomorrow that requires Excel and of course like many of us on here, I embellished the truth 😂 Now I know l I’ll be ok since I found you! Thank you!!!
Thank you Kevin for a thorough explanation of the basics.
Just wanted you to know your video is so good, I got it as homework at my university.
Thank you for the wisdom you pass to us. You've made it easier to understand even the toughest things and we appreciate you
wow! thank Kevin. you have just revolutionalized my work. Great job
I love excel. I’m retired now. But used it a lot when I was working. I wasn’t an expert by any means. I was just dangerous. 😊.
With Excel you can turn your data every which way but lose.
My first time he is a good teacher ❤❤❤