Excel Tutorial for Beginners
Ғылым және технология
🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Are you looking to upskill your Excel game? Look no farther than this step-by-step tutorial! Learn the essentials of how to use Microsoft Excel, starting with the absolute basics like entering data and formatting. From there, we cover conditional formatting, sorting, filtering, and advance to charts and pivot tables. By the end of this video, you'll have a strong understanding of the fundamentals of Excel.
📚 RESOURCES
- My Excel course that will teach you the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com/
- All the Excel shortcut keys: bit.ly/excelhotkeys
⌚ TIMESTAMPS
00:00 Introduction
00:26 Get Excel
01:01 Start page
01:30 Cells, columns, and rows
02:08 Adjust zoom
02:23 Enter data
03:41 Format cells
04:36 Auto fit contents
05:20 Hide and unhide
05:55 Move columns and rows
06:32 Tables
07:19 Insert columns and rows
07:46 Conditional formatting
08:25 Status bar
08:45 Analyze data
09:15 Formulas
09:49 Functions
10:39 Sorting and filtering
11:37 Charts
12:18 Pivot tables
15:02 Collaborate with others
15:26 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZread
kzread.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #excel
Пікірлер: 631
🥷 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: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzread.info/dash/bejne/gph-3NtyZZndn5c.html
@AaronThurman4-fk6fp
10 ай бұрын
Wes lpr 6
@smirtibasnet1448
8 ай бұрын
@@AaronThurman4-fk6fp❤
@PenugondaSubramanyam-hc5ze
7 ай бұрын
My laptop has not activated Microsoft activation how can get it free please tell me 😢
@MyStudio-io3so
7 ай бұрын
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?
@NinaKurumaloo
3 ай бұрын
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!
@DandyBeingTandi
7 ай бұрын
Same girl, same 😂😂😂😂
@stephaniecastagnera6285
7 ай бұрын
Same. Do people use this in real life
@jakecorpuz9163
3 ай бұрын
Same 😂
@josephh1283
3 ай бұрын
That’s why we’re here!!
@SaraStiltner
3 ай бұрын
So we're all here for the same reason? Lol
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
@evaguerrero6661
10 ай бұрын
Same!!!
@user-tu2ce4lw4w
9 ай бұрын
You guys don’t use excel at work?
@itsgodice7210
9 ай бұрын
so true
@dis5164
8 ай бұрын
The almighty algorithm is always watching!
@saoussanhouali
7 ай бұрын
@@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…
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!
@epsiiota
7 ай бұрын
i also start a new job tomorrow! How did yours went? :0
@noonespecial1178
6 ай бұрын
wellsaid
@sisekelompanza4737
4 ай бұрын
may God bless all of you in your journies🙏🏽
Wow! A 6 hour training course in 16 minutes. I'm impressed.
@Dimitar77
7 ай бұрын
im not
@ianl1052
7 ай бұрын
@@Dimitar77 Well, if you think you can do better, I'll watch out for your video. I won't hold my breath though.
@PrinceLied
6 ай бұрын
@@Dimitar77 Lol, get rekt!
@thejolieplayzroblox4994
23 күн бұрын
😅
@thejolieplayzroblox4994
23 күн бұрын
Mmm hhmmm
I sugarcoated the truth on my resume and now im here😂😂
@DeniseVioletta
2 ай бұрын
Hahaha same here 😂
@MartinaMatak-nq4nv
2 ай бұрын
@@DeniseViolettawell i got the job and it was my first day today, this did the trick😂😂
@DeniseVioletta
2 ай бұрын
@@MartinaMatak-nq4nv congrats!!! Wish me luck lol
@Chris_editz2234
2 ай бұрын
Same 😂😂😂😂
@baloch9966
2 ай бұрын
Hh same here
I am an economist and data analyst, working as a business intelligence consultant. With Kevin everything looks so clear. Thank you man
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
10 күн бұрын
Wait are u fr lol
@doctordestructo3360
10 күн бұрын
@@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.
@keziagreste
10 күн бұрын
@@doctordestructo3360 Damn.. never would've thought that.. interesting for sure
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
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!
@Tsigetesfatsion.
Ай бұрын
How do get your new job
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! ✨️💓
@elisesnyder5809
7 ай бұрын
How did the interview go??
@komalsaini839
7 ай бұрын
YES ,TELL US....HOW DID THE INTERVIEW GO ? @@elisesnyder5809
@georgefrank3436
Ай бұрын
How was your interview
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!
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!
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
@lagosammbone6020
4 ай бұрын
very true
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. 👍
@binkyfaith
7 ай бұрын
Same here I know nothing of it
This was a super quick and straightforward tutorial. It makes me feel like it’ll be a breeze. Thanks!
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.
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 💛
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😊
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 didn’t realize how incredible excel really is and h the is is just some basics. Anyone who is proficient in excel should definitely be paid their worth. Lol
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.
Short ,concise and informative, thank you so much !
THIS IS WHY HE'S THE GOAT
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!
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 🙏🏾
Best and most clear tutorial I've ever seen! Thank you so much!
Thank you for your revue, I haven't used EXCEL in years and I'm writing a budget and this was perfect!
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 👍
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!!!!
My mom wanted me to use excel to help her with work, and this is the first thing that pops up in my KZread feed, Thanks Kev
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
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
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
@D-Cosmicgypsie
10 ай бұрын
I'll just keep struggling the old way 2. Yhyh GOOD PLAN 😊❤ 2.22 into this video and have shut down
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.
Thank 🙏🏻 you so much man for explaining us everything so clearly and briefly. Really appreciate your efforts you put in this video !
This video was super helpful, easy to follow and straight to the point! Thanks Kevin!
This is the best tutorial I've ever seen. Complex makes simple. Thank You Kevin !
Kevin thanks for the brilliant video. So helpful. You have a great knack for making complicated things seem easy
This tutorial was concise and easy to follow. I'm confident it will be straightforward. Thanks!
Thank you so much for making these videos they are so helpful. It's so easy to forget all the little tricks and tips in excel
Thank you Kevin. You are a good teacher.
Thank you! Your teaching style 🔥
How simply you're explaining everything and we are understanding every single word very easily. Thanks a lot! Please share more videos on Microsoft.
@KevinStratvert
10 ай бұрын
More to come!
Thank you for posting this! So helpful!
Thank you. This video is clear and the right length for memory retention
Wow. This was such a helpful video. Thank you for making it easy to understanding
Thank you so much Kevin !
Thank you!! This video is one of the easiest to follow for me. Feel like I learned a lot!
Great video! Thank you!
Very helpful and interesting tutorial. Thank you a lot kev.
Love the video. Thank you for the videos. Would love to lear more. Ill check out your course.
Thank you so much I have never used Excel but this was very helpful. I hope I find a video of yours to gain basic knowledge of Excel and become proficient with time. ❤ from London
What a brief way to explain something I considered complex. Thank you 🥰
Thank you so much, it was really simple and beneficial.
Wow! This was sooo helpful.thank you
My fullest deepest appreciations to your great work, thanks.
the best thing was you didn't waste any time in useless description of anything. loved it.
thank you so much for this video, very helpful
Great videos, thank you so much Kevin
It's really easy to understand. Thanks.
Thank you so much!
Great job. It's very helpful
Excellent!!! Quick simple and straight to the point
Thanks. its very helpful.
this is so helpful thank you so much! love your channel! you're a great teacher!
Thank you for providing training with this fantastic tool.
Thank u so much! I'm learning a lot
You are awesome! Thank you! I wanna have a work from home job and i really need this tutorial.
This is brilliant! So easy to understand!
This was great thank you
Thank you Kevin.More informative 👍
Thank you for this video. It's amazing!
This guy makes things sooo easy. Great job as always.
Its great. Thank you Kavin.
Thank you! A short video full of great info
Thank you for this very useful course!
I learnt more in 15 mins about excel than I have in the past 18 years of my life...... THANK U!
wow! thank Kevin. you have just revolutionalized my work. Great job
Getting into inventory management and logistics and i really need to work on my excel skills. This is really helpful, thank you!
incredibly useful - thanks
This is a great tutorial. And it's short too. Thanks a lot.
Great video! Concise and very clear.
Honesty, you are a great tutor. Thanks so much.
Very pleasurable videos.Thanks
Such a great video. Thank you.
Thanks for this amazing tutorial!
Very Helpful thanks for posting
Good stuff. Thank you.
Bro... honestly .... I have no words. I owe you ❤
Thank so much, i love this training. Thanks so much. I need more sir. Take care. I love it
Many thanks for this!
Thank you very much . Such a great video.
One of the usefull videos in KZread.tank you brother
I just started to learn data analysis and this video is really helpful to start with. Thank you.
@Fridayy.Blessed
7 ай бұрын
Same here, I'm learning data analytics and frontend dev
Thank you. This class was soo clear and detailed.
Such a nice summarized lesson, thank you so much
Thank you so much this was really help ful
Thank you Kevin you are awsome