The Beginner's Guide to Excel - Excel Basics Tutorial
Вставка
- Опубліковано 26 сер 2024
- Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.
Join this channel to get access to perks:
/ @techteachersandstudents
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Consider saying "Thanks" by clicking the Thanks button below the video. If you like this video, here's my entire playlist of Excel tutorials: bit.ly/tech4excel
Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels: amzn.to/2xTpck1
Ladyhawke: amzn.to/2xOhLsA
Stardust: amzn.to/2yjJvs9
Young Sherlock Holmes: amzn.to/2xaJJNv
Absolutely a clear and concise explanation of everything one needs to know to get started, and an excellent "brush-up" if you haven't used Excel for awhile. Your delivery, articulation and presentation was exceptional. Great teacher. Thank you so very much!!!
:(
MrSinister718 Some people come here to learn, not to be mocked by strangers. Sir, let's push each other up, rather than pull each other down. Have a nice day.
Now I know that I understand English the issue was with others speaking unclearly thxxxx
Exactly!!
Karen Gates
I finally landed a job after being unemployed for over 2 years and lied about having excel experience, these videos are saving my ass. Thank you so, so much for making them so clear and easy to understand. You're a hero
Plss give me some motivation or any words how you do that Im still on this phase and feels useless I cant move
@@sanjivinsmoke4587 You can do it! I believe in you :)
@@spunkymushroomsfirst of thank you and god bless you... I got a job interview last week and the interviewer ask me what Im doing with my life hahaha I feel belittled.... next time whats the right response
@@sanjivinsmoke4587 A good response might be "bettering myself", or you could come up with an answer in relation to the job and the career you hope to gain from it before the interview just in case :) it's good to prepare, but not over prepare- don't make yourself any more nervous than you need to be. Finding work is really hard these days, but you can do it! You will find an employer who values you eventually. Please try not to get discouraged, I know how easy it is to feel bad about yourself and your prospects, but it's not good for your heart to focus on that-- focus instead on learning new skills online that you can bring to interviews/jobs, find an interview outfit you feel powerful and comfortable in, practice staying calm while speaking and make sure you keep your voice evenly paced. Interviews go well when you come across as confident and well-prepared, even if inside you don't feel like that :) fake it til you make it is a silly saying, but it is very applicable here
@@spunkymushrooms I dont know u but I wish a good fortune for u and ur family thanks bud!!
Started an internship and yesterday they asked if I’m excel “savvy”. Lawd have mercy, I said “yes” and now here I am. Trying to salvage myself.😂😭
Same 🤦🏻♀️😂
same girl. I'm over here like "Yesss I know excel real well. so proficient. no worries" *runs home and searches youtube*
I also took an assessment on Indeed for it and it basically said "You suck you're screwed" lol
Esi Obeng you got this 💪🏾
lol
Wow! I didn't know excel is this easy to assimilate! I just got a job and I'm required to use excel. I searched for "the easiest way to learn excel" and this video came up first. I'm so glad I discovered this channel.
Thank you for being explicit.
Same thing brought me here. I am really happy
Lord I hope this helps me coz I got a new job and I need to know how to use excel
@@ricardomartin627 hope you were able to learn ?
I am doing it right now as hoping to get a new position at my work and requires use of excel and this video helped a lot 👍
Thanks for this tutorial
Have gone through many Excel Basics tutorials before , but have never experienced this crisp and clear explanation. Thank you so much for making this video . God bless :)
Glad it was helpful!
2:17 *Blank Workbook*
2:47 *Opens up Ribbons*
2:59 *Ribbons divided into groups*
3:23 *Launch Button*
4:24 *Columns and Rows*
5:01 *Cell*
5:54 *Range*
7:35 *Multiple Sheets*
7:41 *Workbook*
10:09 *Stretching a column*
11:33 *Tips*
13:13 *fixing misspell on a cell* (To get in a cell you have to double click on it)
16:30 *Merge & Center*
16:59 *Click and Drag*
17:04 *Click and Drag SHORTCUT*
17:43 *Trick*
18:33 *Trick to resize columns*
Thnx
Good
Thank you 🙏🏼
Nice one mate.
you're awesome
Kudos to this Excel tutorial! The instructor's knack for simplifying complex concepts, practical examples, and engaging style make it stand out. Clear visuals, perfect pacing, and top-notch production quality. A gem for beginners!
Thank you so much for being so clear and concise with the tutorial. I have been handwriting my rosters for a year now because I was intimidated by excel and making spreadsheets. I go back to work tomorrow and after watching your tutorials I'm confident you just helped me to work smarter not harder lol.
If you’re reading this.... calm down you got this!!! You’re going to kill it at work tomorrow!
Amen
It's tomorrow actually
Thank you
Amen
Thanks I really needed this! Cause I lied and said I'm good at this 😳
@@dejonwalker7824 haha me too 😂😭
Everybody might teach, but not everybody is a good teacher. You are indeed a good teacher. Thank you for the tutorial; you just earned a subscriber.
Now THAT's real!
s
s
So true!
Your videos have been extremely helpful. When I was in school (K-12), we were taught how to use Word and used in constantly for assignments. I vaguely remember we were taught a bit of Excel in elementary or middle school, and that was it. We never used it for school assignments, and were never made to put it into practice the way we did with Word. You're definitely helping to fill a large knowledge gap that many of us have, and it's very much appreciated.
Yeah same. In elementary and high school. We didn't even use word or excel at all. We used google drive for everything
I'm new here and the moment I entered the channel, I headed straight for the comments because I believe what people have to say plays a big role in calming my nerves down. Being more informed is more or a blessing to me because I get to get encouraged to learn with this Tutor and have a great experience. So, thank you to everyone who commented. It was refreshing going through the comments section.🧡✨💜✨❤️✨💙✨💚
"Just say yes and learn it later once you get the job" they said
that's
what they told me before and today
Me rn
🤣
😂😂😂😂😂
me rn
I should've learned Excel a long, long time ago. Following an Excel tutorial on UA-cam works for me. Learning does not have to be tedious when you have the right Teacher like this gentleman.
5 years on and you're video is still helping people like me who knows nothing about excel....thank you.👍
I know this video is older (5years), however this has been an absolutely crucial influence on me for my occupation!
I seriously feared projects and applying for promotions, simply because I have 0 Excel education.
I plan to utilize this information in an upcoming Business Review. I now have the conference to demonstrate changes I have implemented.
Thank you! Truly a life saver!
The comment section made me realise that I wasnt alone who din know how to do excel... thank you so much😊
😂😂😂exactly
Hello fellow dummies
Hit thumbs up if you're watching this because you lied to your temp agency that you know Excel.
John Field Show omgggggg me
John Field Show I was asked "on a scale of 1-10 how familiar with excel are you" I answered 8 😅😅
John Field Show omgggggg I just did yesterday 😂😂😂
John Field Show hahaha yea
Lol! Thank goodness it’s just not me 😂
I am just beginning to learn Excel and your presentation was very clear and made me feel very comfortable and gave me the confidence to be able to master it! Thank u so much!!!
You are welcome! Thanks so much for your kind gift.
2:26 LEARN ABOUT THE LAYOUT 2:32 TABS 2:45 RIBBONS 2:56 EACH RIBBON IS DIVIDED INTO GROUPS 3:18 LAUNCH BUTTON 5:50 RANGE 6:13 RANGES CAN BE NAMED-(L7:N12)
Bv
I am 66 years old. Talk about teaching an 'old dog new tricks"! Thank you for making this tutorial so understandable, especially for a non-computer person. I have a new 'part-time' volunteer job, as I worked as a nurse for years. Learning this is going to be SO HELPFUL to what I need to do. Thank you! If I can learn this... anyone can!
:)
Lmao....I'm almost graduating my nursing college..don't see myself working as a nurse a day in my life ....looking forward to revive my logistics diploma to a degree that's how I ended up here
your comment made my day... :) Now i will learn with full devotion... thankyou dear..*!!*
Hi Jane, I hope you are doing well ❤️
Do you know that this kind of lesson worth 50$ and now I don't need to pay that money. I don't know how to say thank you more than thank you. May your kindness return to you as a bunch of luck.
No way this lesson cost 50$, i would give it maybe 2$ because you can learn all this by yourself just experimenting what some buttons do
@@Pulko172 I mean including all staffs like basic word,excel, PowerPoint,autoCad. 50$ for all.
@@hninthazin2944 okey that sounds more reasonable
@@hninthazin2944gvvstt
you should thank him by liking and subscribing
I'm a beginner with Excel, and this is the best tutorial video I've watched on how to use Excel for the first time! Logical and easy to understand explanations
OMG TY TY TY - i feel so much better now - i hope you could make a newer version of this tutorial
When you lied that you're proficient in excel on your resume :')
😂😂😂So true
@@erfaina5472 lol, i'm going through this rn omg!
That what my family told me to do 😆
😂😂😂omg! I thought it was just me! I just got an interview opportunity for a job I said I am proficient in excel😂
I’m so dead 😂
@@Joshivibes Me tomorrow man got an interview on excel😅😅
If my school taught me like this I wouldn't have to search for this video 😂
Me too. Haha😅
True😂😂😂 bawa g
I feel the same
I am working on my mpharm project and its pity that I have to search for this video 😅😅😅😅
The funny thing is, my school did teach this to us. I just didn't listen haha. Now, here I am back at square one.
Thank you so much. This was a much needed and extremely helpful video tutorial. Not too brief. Not too detailed. Just a very well-balanced demonstration.
Excellent. I needed to refresh my Excel knowledge for my job in 2 hours and this is exactly what I need.
when you write on your resume you know how to use excel but you really dont, so you end up here
Hahah
that's actually me and I have a test help LMFAO
Sarah Roronoa lmao good luck sis
Correct 😂😂😂😂😂😂 same here
Sarah Roronoa did you take your test yet? I have to take one too and I’m scared lol
Thank you so much for this! I'm trying to pickup Microsoft 365 to better my career, and you're the only channel that makes any sense!
Been an Excel user for a while and this is one of the best beginner's tutorial I've come across. Superb quality content!
I will SERIOUSLY legitimately pay (cashap or PayPal) for someone to do my excel project due Saturday I’ve been struggling with help and even with tutors and videos it’s just not clicking at all. There’s 15 steps I got up to step 5. I can send the list all all info.
Dude you are the GOAT! I'm interviewing for a data entry job and only used excel a little for school and didn't even half of this stuff even existed. Sharing your knowledge might actually help me get this job thank you!
Goat is insulting name
The full form goat is greatest of all,time
I needed to become Excel literate, and your pacing, thoroughness, and excellent explanations were exactly what I needed. Thank you so much!
🙂
Clear and well-presented! Your voice, inflection, and vocabulary make everything easy to follow and understand. Thanks!
Absolutely clear and concise this explains everything you need to know to get started. I lied at this new job. I applied to they asked me if I knew about excel it was a plus for them and now you see me here watching videos 😅 thanks for running into your video first you saved me.
strongly recommend taking this workshop if you're new to Excel. Very clear, step by step instructions on how to navigate your way through and hands on so you actually get a feel of what to do rather then being walked through visually. Great job Steff! Thanks for running it
I think I had an Excel mental block. This was an excellent tutorial.
@@HogwartsAlum. me too. I'm wondering why I was so confused and intimidated by it.
I am 80 and computer illiterate and I was able to do an address list with almost no problems. This was the clearest computer instruction I have ever received. Kuddos!
Getting such kind of a teacher is a blessing, am now learning computer packages but bfo I attend my classes I always watch this and it's helping me so much to understand when iam being taught. Thank you
Beautifully explained in lucid language and in simplistic way.
I used to fear using excel. So glad that I came across this video. Absolutely a clear and concise explanation of everything one needs to know to get started. Your delivery, articulation and presentation was exceptional. Great teacher. Thank you so very much!!!
I was an Excel virgin up until an hour ago, I had to create a form with a table so I headed to Excel, it was all gobbledygook to me, Excel had always been a mystery so I used to use Word and tables etc, this is so much easier and no longer a mystery. I searched and saw your video tutorial, great teaching method and now I have the basics, my form is ready and finished, I even created a template from it to fill in anytime. I have been just messing around and because of your teaching I wasn't bothered about messing anything up.
Next to a little more intermediate lesson.
Thanks so much. 👍
Thanks for ur insight and motivation
I m super happy about this tutorial.having wasted a lot of time on other ones,I finally happy coming across this one
Watched several of your Excel videos to help me (complete excel novice) prepare for a word/excel skills test for a job application. I don’t think I would have passed without them. Thank you!!
Great job! And thank for your kind words.
I will remember this day when I took a deliberate decision to becoming a data analyst. the knowledge to use Excel is one of the steps and that is how I found myself reading this informative tutorial. On to the next tutorial about the Advanced Excel Tips. Thank you very much.
Clear, articulate explanation of everything to know to get started, and allowed time to follow along. Thank you so much!
Hi april
Excel is amazing
👍👍💕
Broken down into the simplest terms at a pace where you can hear, see, and learn. Also explained in clear English and not in a boring put you to sleep monotone sound or foreign accent that doesn't allow you to understand what is being said. Thank you n may God bless you .
I didn’t even know the video was 5years ago , I literally just learnt how to use excel and was easy for me .Thank you so much
Who else is learning this because they have spare time while quarantined ?
BoredOfQuarantine ... actually for a technical course I’m taking but this comment was funny. You must be super bored to be watching this. Dude go watch Netflix or something. Lmao
lol from the learn quick guy
@@donovanmckenzie5608 yea mike boyd
@@donovanmckenzie5608 Yeah
My teacher is making me do it during lockdown
I'm an English learner and basically knew nothing about Excel. After watching this, I now know a little bit of it and I understand everything you say without problems. How amazing is this? Your tutorial is a masterpiece. To make a video like this, first you need a delicate design in order to include all the tips and tricks and put them in a logical order, and second you need to explain them in clear and accurate words and third you need to know how to record the screen and edit it. Very likely there were even more work done behind the scene. Thank you very much because I do benefit from it a lot.
I was an intermediate-level excel user 25 years ago. i now need it again, but am 78 and have forgotten much of it. your courses are a big help. thanks.
Glad it was helpful!
This is one of the simplest and well well-explained foundational videos on learning how to use Excel. Thanks so much 🙏🏾
Thank you for your kind words! I'm thrilled you found the video useful.
thank the lord in heaven i found this video, not funny when you need skills to apply for a job but your last experience with the program was in high school 15 years ago.
Relatable 😂
My family has been patronizing and chastising me for YEARS about how I don't know how to use Excel. It has been 25 years, since I last had a keyboarding class (It was a middle school requirement). For all my classes from middle school to college, I used Microsoft Word because I had no reason to use Excel.
Almost every clerical job expects people to know how to use Excel, which has always been intimidating for me. Here's the kicker. I learned how to create my own website using a website builder by watching a UA-cam tutorial 7 years ago, and it's mostly drag and drop features that I use.
After watching this informative UA-cam tutorial that you made, I realized that most of what you have done is drag and drop. I no longer feel insecure, intimidated, and unconfident in using Excel. With that being said, thank you so much for creating this tutorial! You managed to help me overcome my fear of using Microsoft Excel, after 25 years! Now, I can apply for clerical jobs that require the use of it.
This is so helpful. As a 17 year old in today's modern society everybody expects me to know these things but I just never had a good teacher so I don't. This really helped me. Ty!!
I have never used excel before, infact in my pc i don't even go close to it. Till i came across this video, Wow! He makes learning so easy, with his explicit explanations, now am good to go.
Thank you so much sir.
I used to be scared and insecure about Excel. I am now more confident and doing things I never thought I would be doing in Excel. Glad to hear you have learned.
I have just watched this tutorial after trying for an hour to set up a basic ‘grid’ document to draw up my own personal development plan.
I now have a professional looking work book using all the basic tips you have shown .
I am so thrilled having spent 20 years on site and now find myself office based starting all over again.
Just need the development to go in it now lol.
Thank you so so much 👍👍👍👍 subscribed straight away.
Coming from a credentialed, experienced teacher, you explained Excel perfectly! Thank you for the tutorial.
z
I learnt excel back in the late 80s when it first came out and then promptly forgot how to use it - this is an excellent refresher as well as beginner's guide - one comment on your explanation of correcting typos at the approx 13:45 point, "being in a cell - being on a cell" - using a mouse you don't need to double click, you can just click once in the ordinary manner and make the change without losing data / without having to retype all of the words - thank you for your clear and concise tuition.
Brilliant! You are a very gifted teacher and I could have listened to you for much, much longer! I am sure you enjoy your day job, BUT, what a wonderful TV presenter you would be! Thank you!
more blessings to everyone who come to youtube and teach us things that helps us in real life thank you so much guys this has helped me a lot
Yes Sean. It's hard work.
This helped me for my job position I applied for. I felt like my memory was so vague using excel because I haven’t gone on it since high school. So now watching this video did wonders when I went to do my test for my job... passed 👍🏽
H Good Job!
What did the test consist of? I take mine soon I need to know what I’m getting myself into
Christiana Marie did you take your test? If so..What did it consist of?
H UPDATE US!!!!!
Congrats!!
Not only I need it this for future work because our didn't teach us this but his voice is just so relaxing and making me finish and excited to learn more
Thank you for this video, it's very helpful. I found that it's important to know excel as many jobs are looking for people to know how to use it.
OMG hands down the best presentation I've watched on Excel. While quarantined I decided to come and see what I could learn and I understood everything you shared, thanks☺
This is the best tutorial for learning MS Office, especially if you are a layman. The orator is exceptional with respect to detailed explanation. The more you go through these kinna videos, the more knowledge you'll gain, which will inturn improve your skills in MS office.
agreeeee
Brief and perfectly clear... Just what you need from a tutorial, well done!
I am a BBA corporate student in 1st year graduation.i decide to follow up ur vedios for my studies in excel..i is so good 👍 well done with the presentation
English is not my native language, but your diction is so clear I understood everything. I am sharing this tutorial with my friends. Thank you so much!
i want u r xcel class
Thank you Maria diction is very clear and understandable.
umm...
I really want you to know that you helped me through my college course and I cannot thank you enough!!!!! I genuinely feel much better about excel and excited to use it more throughout my career and personal life!!!
Really a good effort
M'¹11o÷ldllsosp sa L. Isu8i1i19qq1eikiieiq8
Just amazing 😍 I recalled all what I've studied few years back through this video. Thank you so-so much
All I have to say is "thank you". You are a life-saver.
Finally, I get to learn Excel appropriately. You are a really good teacher, summarising all that will be needed to know and begin using Excel confidently.
I need to learn excel for tomorrow, since my new position requires excel, tbh this is the best guide lol.
😜😜😜
Same
Omggg the procrastination hahaha lol hope it worked out!
That was quick and easy to follow.
I completely understand why this video has received so many Thousands of 'Likes.'
Well earned ✅.
I just started an internship recently and omg you’ve saved me so much for a project I have to start tomorrow thank you so much!
I didn't realize how 20mins passed. excellent
Excel lent ? Im dead
@Mean Jjj as a black guy, I find that offensive. We're people just like everyone else.
Was thinking the same thing.
Jimminy Christmas this is quality content. My friend, I just got my first job in the office after 15 years in the field. Excel has been daunting my mind some. This video has done more for my confidence than any other thing since I started there. THANK YOU.
I have some excel experience. I'm in the process of trying to get promoted at my current job. One of the 'requirements' is knowledge of excel 'formulas and vlookups'. I'm definitely browsing this channel more.
Thanks for your work!
Thank you! I’ll be coming back to your excel tutorials as I settle into my new admin job!!
All these 1.7k dislikes are those who got fired for lying in their resume about knowing MS Excel
😆
Hahaha
Lol😆
But there are 130 K likes !!!!!!
I watch This Video For My Computer Class and I Just Learned This On The Day Of Exam.
This tutorial is a GEM. Short, simple & precise with every detail taken into consideration for 'dummy' like me. Thanks. Truly appreciate.
He’s brilliant , learn more from him than course teachers .
21 hours is short
You just saved my life, I've been given a task to do a spreadsheet at work as i type and i didn't know where to begin...thanks ❤
You saved me with this video. I recently got a promotion at work and quickly realized I never learned how to use Excel, after watching this, I feel like I can go in tomorrow and make myself a nice little sheet.
Wow! You are super concise and articulate! It's very impressive how smooth your overall oral presentation was on Excell. You have a great voice too! You could totally do voice overs and do very well in my opinion. Thanks so much for sharing this video with us. 😊
Life changer. I need to learn and learn fast, and this was a great start. You have no idea how much I appreciate it.
Thank you for your kind comments! Thanks for watching my video, and I hope you’ll watch more of my Excel tutorials.
Wow, explanations are concise and easy to understand. I'm so glad i chose this from the hundreds of videos that popped up when i typed "Excel Basics Tutorial". Liked and subscribed!
Simply Wow! you did this presentation with finesse. clear, concise explanation, how can anyone not understand! Keep it up!
Excellent beyond word, I wish everyone had a teacher like you. God bless you.
10 minutes in and this is the best teacher i have ever had. Amazing. Clear and concise.
Fantastic tutorial! Very clear and understandable for beginners. Thank you so much.
I've never been IT Orientated. I actually just had a promotion at work. Up to a week ago, I used to be a Electrical Foreman for a Huge Solar Company. I worked outside leading a group of electrician, making sure everything was done right and in a timely manner. I recently got promoted to an Electrical Superintendents position. Now I'm in the office and I have to deal with computers. Watching your videos has helped me so much. Your teaching methods are so easy to follow. Thank you so much!!!
Congrats on your promotion
This is, by far, the BEST Excel tutorial I've found. You explained this so clear and had me understand the program so much more! Thank you, thank you, thank you!!
I paid for an Excel class and your videos are so much easier to follow !
Thank goodness for your video! Currently going to school and one of my classes is self teaching how to use for the most part since it's online. It's been a struggle because I need someone to actually explain it and not just read it and try to figure it out. I caught on to this way easier and learned shortcuts that weren't taught so thank you so much!
Whelp, it's 2019 and my anxiety about my upcoming administrative assessment has gone from a 10 to about a 5 now. This was very interesting and informative. Thank you!! (** clicking link for the Intermediate video NOW)
How did your assessment go?
What's a Administrative Job? Like a Receptionist?
Providing basic terminology and very clear directions / examples at the very beginning, and a quick recap before going on - Ahhhhh - a real teacher. Thank you. I will share with my international students. Some of them are whizzes at Excel in their own language, but watching and learning from you is going to be extremely valuable. And, they'll be able to "make friends" in English.
And a comment to those who are binge-learning to get/keep a job....Good for you. You've come to the right place. All the best.
Thank you so much! Your tutorial really helps a lot, especially for beginners like me. I will watch all your videos about Microsoft and am hoping you will do more videos about it.
What a great way to Teach ! I hope i have had few teachers like you during my school times. Your simple & effective communication skill, technical explanations and knowledge have made me a fan of yours teaching skills. I am from India, so my English is not up to the mark and on excel i have worked very less- so I don't have that confidence in both but, but but.....the game is going to take a turn now & for sure one reason will be you!
Blessing from India !!
youtube videos better than buying courses online this channel is super awesome
I have certification in all Microsoft Office software from Beginner to Advanced, but have never used it in a workplace since I got them when I was 12. I am 24 now and I am looking for my first job and hope these certificates can help me somehow. I don't remember much anything about Microsoft Office, so this has helped me out alot.
Bercle Thurston sex
First job at 24? Lucky dog