Excel for Beginners - The Complete Course

This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching just one video. You'll learn spreadsheet terminology and the modern Excel layout, how to create and save workbooks, entering values into Excel, Excel formulas and functions, formatting, creating and editing Excel charts, printing options, and publishing options. After watching and mastering this video, you will be able to use Excel effectively in almost any professional setting.
Table of Contents:
00:00 - Intro
00:26 - Creating Workbooks, The Anatomy of a Spreadsheet / Spreadsheet Terminology
07:16 - Entering Cell Values and Data in Excel
20:18 - Formulas
30:21 - Functions: SUM, AVERAGE, MAX, MIN, COUNT
38:45 - Formatting Numbers, Text, Cells, Rows, and Columns
44:20 - Creating and Editing Charts
46:46 - Print Options and Publishing Options
Join this channel to get access to perks:
/ @techteachersandstudents
***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: bit.ly/begintoexcel #excel #exceltutorials #microsoft365

[@winim01]

Watching this because I lied in my resume 🤣

[@azizhammouda8775]

same broo 😂😂😂

[@AlphaOmegon]

I mean what them companies thought we would do?

[@eden3067]

Hahaahha same

[@manikantagogeri5267]

Today mrng I was in same situation

[@marie2721]

Me too

[@gehanoates885]

This video will help me so much. I have to use excel at work but no one wants to show us how to use it. People are being childish, withholding information. So that's why I am here. Thank you so much, very good teacher.

[@AustinIC]

My dear people can really be childish,but the good news is that you have the knowledge now

[@gehanoates885]

@@AustinIC Hi thank you for your reply. Yes, sadly you are right. Some people can be very childish. The 2 people in question here are managers. It is very clear to me that they are in the wrong position. Anyway, what is important is that I now have the knowledge. By the way I am taking the company to a tribunal, sadly things just got worse, I had no choice in the matter. I have a very very strong case. Have a great day wherever you are in the world.

[@AustinIC]

@@gehanoates885 Its well. Do have a great day to goodfriend.

[@clintonweckesser1807]

Thank you very much! I am working on a budget for a fire officer class. The class you provided helped alot! God bless and be with you!

[@julioplazaasmr175]

I just started excel course, please all of you wish me luck 🙏 I know that is going to be hard but not impossible.

[@user-lr2hr7hc3k]

I am a 65-y-o woman who has never before had the time or opportunity to learn Excel. I went through your video slowly several times, setting up a mock excel sheet for practice. That worked like a charm. Thank you so much. This was just what I needed.

[@brunovalentine61]

Thank u sir. Am thinking of a career change. My current job involves alot of standing and walking about and done it for 15years. I want to get a desktop job and the first skill I see thats needed mostly is excel so am teaching my self before I take the actual course for certification. Thanks for ur simple and understandable explanation.

[@temitopeolabisi896]

I went for an interview today And I successfully passed my excel test (as a first time attempt) due to your teachings. Thank you

[@techteachersandstudents]

Wonderful! That's so fun to hear. Thanks for sharing news of your success with me.

[@user-hb1in5nb1t]

How many days u pratice?

[@WilliamMsukwa-dz8vj]

wow this is great !

[@cinemaalden8880]

I have to take an excel test for my job and this comment says I chose a great course! Gives me hope!

[@michellegwaikolo5863]

I passed my excel test today thanks to you Ps: I had never in my life worked with excel prior to this video I’m grateful

[@NicCynthia]

Man I'm out of words... Can't even describe how important this video was to me... You are not only talented but the gift you have for teaching is inborn🤭.. Thankyou for this life changing video 💃🏿

[@techteachersandstudents]

I'm glad you found the video to be helpful. Thanks for your kind words. Please share it with others who might need it.

[@NicCynthia]

@@techteachersandstudents yes I've actually shared with my classmate thanks 😌

[@Jojosmith342]

i shared with my family members, friends. your teaching motivates us all. Never enough to thank you for spending your time to make our life much more enjoyable with coding. I became addicted to your classes now 👌. We appreciate your hard work and good heart to prepare all of these useful, valuable materials that improves our skills everry time taking your class. 👋🙏

[@abidurrahman5814]

@@techteachersandstudentsiuhoh up h hoooiiuhvoo hi koi up iuhiu uuuu uh hohhuoguooohohiuho hi uooohooouuiououioo hi oioouuu uh ooiihofvouvioho hi ohooohoooooooioui you oooooooiuujohooihhhhouuh up oohiuuh huh hi ovooooooooihuuuooiio

[@abidurrahman5814]

@@techteachersandstudents iohhuiouioiu uuuu uh ooohhooooouuoouo hi uuuu uh uuuooh ooiiiooooiioouohuiiohi you iouhoii

[@AlisaLewis]

Thanks so much for your illustration, Ive always been afraid of excel, but when I lost a job that paid $60,000 that was my awakening moment to learn excel. Ive been offered a job that pays $88,000 a year and I'm going to stay on top of excel for life. Nice video 😊

[@aleyah_1765]

What kind of job is it? What are your qualifications/education requirements?

[@lifesreality4230]

The easiest excel explanation ever. You deserve a follow. Thank you 🙏🏾

[@user-eb7nc7lx4y]

By far the most talented instructor in the world, I wanted to take Excel courses but after watching your amazing video I think I do not need it anymore, way useful , thank you so much I really appreciate YOU 😍😍😍

[@techteachersandstudents]

Thanks for your kind words. You’ve made my day!

[@renetatayo2260]

This video has changed my life. I cannot thank you enough for your time. God bless you.

[@user-my3yj5dm4v]

This is the best Excel course ever made, professional, well-produced, and right to the point. Great work and I hope that both the intermediate and advanced courses are uploaded in just one file, it makes it much easier to learn. Thank you very much.

[@ayoayo4234]

Wow! At 43 years old, I've watched numerous Excel tutorials and bought multiple courses, but I must say, this free video takes the cake! It's hands down the best Excel tutorial I've ever come across. My only dilemma now is, how do I keep progressing from here? I'm eagerly awaiting a follow-up video to continue my Excel development. Keep up the fantastic work!

[@Ren-em1xk]

21:46 (3 ways to write formulas in excel/relative cell values)$ 27:30 (Absolute cell references) 30:42 (Sum Function) 34:39 (Average Function) 36.35 (Max function) 37.19 (Min Function) 37.40 (Count function) 44:29 (Making charts Alt F1) Keyboard Shortcuts: Enter key: Down Enter key + Shift key: Up Tab key: right

[@crystalpolston4247]

Thanks

[@cupcake2009ist]

Thank you

[@michaelsevens]

Thank you...

[@HanaYanes-us4fu]

Thank you so much 😊

[@Ren-em1xk]

Guys I did this for myself not for you…

[@KamaraMikelWorldWide]

I have always shy’d away from Excel. I’m 57 and I told my supervisor that I would take a tutorial. This is better and more understandable than I’ve ever known. Thank you for your time and efforts and you now have a new subscriber!

[@dsamuels40]

same here

[@mrnonso188]

In 24 years time I will be your age. God bless you

[@naurajchetri6203]

This is the best video you will ever find which teaches you all the basics you need to use Excel

[@techteachersandstudents]

Wow, thanks! I'm glad you liked the video.

[@301ironmaiden]

I had a great job analyzing medical information for 34 years....never needed Excel and when AI took our jobs away, even entry level jobs required proficiency in Office and particularly Excel. I took a few hour course at the local community college, which was worthless. I started your beginner course and it is so easy compared to that. Thank you so much!

[@backasswards5250]

This video was exactly what I needed to understand the basics of Excel, easy to understand, and gets me ready for the next more advanced tutorials. Thank you so much!

[@chibaby5274]

I recently started a new job where I'l have to use excel much more than in previous jobs. I was worried about being in over my head until I discovered this video. Now I'm realizing that I don't have to fear excel. You've boosted my confidence and increased my knowledge. The way you explain everything is so easy to follow. I was gonna try and find private tutor or take some excel classes, but I'm so glad that I decided to try YT first!

[@andrewdapac6054]

Aw😊

[@iRegr3t]

For real starting a new job tomorrow and watched this video on repeat all week

[@sarahsapian9597]

Same to me😅

[@crystalpolston4247]

Same here on the confidence

[@alejandrolazcano1183]

@@andrewdapac6054Is not just to translate, need to be done on Spanish version, No es solo traducir al español, necesita realizarse en Excel en español

[@DanRamirez-ko4gg]

You are the best at teaching this!! It's been almost 20 years since I last tried using Excel and you have taught me so much more than I could have ever imagined ❤

[@techteachersandstudents]

Wow, thanks!

[@loujon191]

This is the first excel I have been able to sit through in years. You are an excellent teacher

[@dottisniff9483]

I had just bookmarked another video but took away that one as this one is SOOOOOOOOO much better. Clear, patient, easy to understand --- a true masterpiece. Thank you SO VERY MUCH. A job excellently done.

[@gyamfiadu4599]

The tutorials are great and simple to understand . Thank you for explaining complexity into simplicity .Good job done, grateful for this!

[@jonnywalton7083]

I’m 40 years and never been taught how to use Excel. I started back school working towards my B.S. and your videos have been super helpful with helping this old 29:38 guy going back school. Thank you for the work you put into it

[@LarieTaylor-vb6do]

Oppk9l Love 💕 oppk9

[@felicitasbamuna1854]

😯😶

[@stevenhulbert7540]

I'm older but I never learned Excel either and that's all any companies use, it's tough out there.

[@dionair13]

Didn't even know where to start with excel. I've never used it. This is a great tutorial! Quick, direct and easy to understand. Thanks!

[@HikeColorado]

I have excel at my work but have never been trained to use it really. We have some pre-made spreadsheets that I occasionally use but this video is Exactly what I’ve been needing for quite some time. It’s the perfect learning format. Thank you 👍

[@man4YAWEH454]

Thank you, thank you for sharing your love for excel and helping others. Your patience and teaching skills are far and away what a beginner needs. Just found you today and am highly impressed.

[@breadyforlife08]

Thank you! A whole course for one hour and for FREE! WOW!

[@keninfarinato1177]

What a great video! Your pace and flow of information are those of a seasoned educator. Thank you very much!

[@sheripresloid7839]

I am an Excel expert, but a coworker has a son who knows nothing about Excel. This is the best tutorial for a brand new user! I went through many and they immediately go into formulas without explaining what you are viewing in a worksheet with the Tabs, Ribbon and Quick Access toolbar. This is perfect! Thank you!

[@27May1988]

Not had any experience other than doing some ECDL online but when I found this course, it is not the expertise and the way it was delivered but also the simplification and the jargon free language used here, am 51 and never had this kind of experience, I already mustered but want to come back to watch all the time, it is really addictive; beautifully made and will benefit not only those in the UK but world wide. Thanks

[@BeColorBlind]

Oh wow! I purchased an Excel course that went into so much detailed explanation from the get-go that it made my head spin. This is very clear and easy to comprehend without a lot of extra blah blah that makes it harder to understand. It's just straight to the point! I love it!

[@KristinKristout]

This is exactly what I was looking for! Concise, easy to follow, and great to see you do the examples. This is the best beginning tutorial I've seen! Thank you so much :)

[@techteachersandstudents]

Glad it was helpful!

[@relaxbear4208]

Thank you so much. Your tutorial is very easy to follow especially for a total noob myself. Glad I didn't spend a fortune on books. Also, I love how enthusiastic your voice through the whole video not dull or monotone lecturer type.

[@tyshabolding2580]

Soooo glad I found this video. Just started a new job a cpl of weeks ago and I’m going to be using excel way more than I anticipated. I’ve worried myself sick over it. Your video has made me feel much more confident. Thank you so much for what you do! Extremely helpful!

[@redbrown134]

Thank you for putting this out for free. Your teaching still is perfection. Much appreciated.

[@slipkvenfold1810]

I'm an alright noob at Excel since working at Amazon. Thank you so much. This is seriously helpful! We just launched a new program and I'm trying to create organized spreadsheets with formulas ready for my team!👊🏻

[@itouchocarina]

Thank you very much for this video! I learned so much in only an hour's time. You were a really great teacher, and I will most definitely be checking out your other videos!

[@user-nm6yg4ke8o]

words are few to express, neat concise clear, and time-saving. Thank you so much. This was the best Excel tutorial that I have been searching

[@PigeonFace4Life]

This guy has been really helping me understand the software. Explains things really well and I have never been confused watching one of his videos. Thank you!

[@deepakv.2528]

Thank you so much for this, Sir! Most well-structured video, in terms of its thoughtful progressions, and exhaustive exemplifications! I'd very much appreciate similarly done videos on intermediate and advanced excel learnings, even if it'd mean a series of them. Many thanks for considering the suggestion.

[@yosefshawarma3739]

woow!!!! that's all i can say. I learned this 23 years ago in college, but the career that i've been working on didn't need these skills, so i forgot it all. Now that i'm in need of a career change, your course was more than refreshing. THANKS A LOT AND KEEP UP THE GOOD WORK.

[@pictureperfect6901]

SAME HERE

[@Metal_seer]

Very good teaching style -- clear and concise. I used Excel a lot in the previous century, but that was over 20 years ago, and I'm 78 now, so I found I've forgotten a lot. This is a great refresher. (BTW, the first spreadsheet I used was Visicalc, in the 70s)

[@karenharrison4382]

I cannot express how much this tutorial was clear and I was able to pick up on the first try. I took a class that did short overview of excel and i didn't learn anything but looking at this tutorial I was able to understand every concept that was discussed.

[@FanofLocke627]

Fantastic video! I've taken a few college-level courses, and this beats them all! Great job!

[@osazee_ehis-afeikhena]

One of the best tutorial videos I've watched online!!!! The clarity, and simplicity with which you teach is simply amazing!!! Thank you and thank you again!!!

[@sheilabeasley8060]

Thank you SO MUCH for this! You are an awesome teacher. I have a meeting on Monday and I had to learn Excel on the fly. You made this doable. Again, thank you for sharing such a great demo. Bless you!

[@habeebolalekan3952]

jus 5mins into it and am here to make a comment already jus the kind of excel tutorial i have been searching for, well detailed and comprehensive may God bless you greatly for this. Thank you

[@edwinrelf8454]

Very well done. I was very familiar with Excel until about year 2000. You're bringing me up to date!

[@wendyy3801]

This is literally one of the best tutorial videos I have ever come across good work champ!

[@phinehasevans7740]

Thank you so much for this simple and informative package you presented, I don’t have a word to describe how I feel. The way you presented it is a top notch ❤

[@benitawugate3531]

This is probably the most understandable video on the internet. Learnt a lot in just an hour. You're an amazing tutor👏👏👏

[@mamabear71234]

You are such a wonderful teacher! I really learned this quickly because of the way you taught it. I have watched other videos that made it much more complicated. Thank you!

[@zRonnyyG]

I can’t thank you enough for the amount of information and quality of these informations that you provided with this video. I always was afraid of Excel because i didn’t understand it Now, i can say that i know its basics! Can’t wait for the Intermediate Guide to progress in my learning journey!

[@SegunAraba]

Thank you so much . I literally understand the pros and cons of excel now , in addition i had zero knowledge in using ms excel. But now i can use it effectively. You’re a blessing.

[@user-zv6sx3rx3o]

Thanks a lot for the video..the last time I used excel when I was doing my business course 2007 . Now just doing my refresher course with you and I am now 70 years old.

[@iamspiritualtechnique4177]

How's it going

[@liveloveandesoterictarot8221]

EXCELLENT DEMONSTRATION/COURSE! EXECUTED PERFECTLY! This is by far the best video for learning excel, out of all of the videos that I've tried to follow. Thanks for taking the time to make these videos.👍🏽💃🏽

[@annagreene195]

Speechless and very thankful for your tutorial! You break it down it such a basic way that makes it easy for beginners to understand. You made me feel like a Rocket Scientist!🤓 I’m really excited to watch the rest of your tutorials! I should have done this years ago! 🙏🙏🙏

[@techteachersandstudents]

Glad it was helpful!

[@readingsbycara]

💯👍🏼 A+

[@oluchukwumaduka2967]

Thank you

[@aibrahim8189]

Hi great video. Do you have a playlist for Excel where each part is broken down. Especially about formulas. I need structured videos about formulas please. I love your delivery and style ​@@techteachersandstudents

[@sofiacovarrubias9088]

This is so perfect! Thank you so much for making such a concise and easy-to-understand tutorial. I've learned so much.

[@skip031890]

I used Excel slightly when I was in highschool back in 2004 as a freshman, but never used it again in any of my other grade levels. I've worked in jobs where I needed to use it, but I was using premade sheets and workbooks that someone else had already made. I never had to put something together myself from scratch and was insecure because I wasn't comfortable with Excel. I've been watching your videos and I feel more secure about Microsoft Excel than I ever have before by having at least a basic understanding of its structure and functions. This is helping me greatly. Thank you.

[@melaniedias2025]

Thank you so much. Your an excellent teacher. Very clear and precise.

[@mikeweaver7804]

Super helpful. Very clear, easy to follow tutorial even as a beginner. Thank you!

[@yazzleo913]

Omg of all the videos I been watching for 2 days now to learn this program, you are the Best of all , thank you for taking your time doing this video. You explain everything so easy that I safe the videos to go back. ❤

[@gvd3975]

I love this! I taught myself Excel years ago and this is reaffirming what I do right, and showing me how to improve my basics.

[@dijana4567]

Thank you for this nice, clear, interesting and to the point video! I love listening to you explaining :)

[@Shimawe]

Thanks a lot for this video, I was so intimidated by excel but now with your video I feel more confident. Extremely well explained!!

[@PresenceWithPurpose]

Thank you so much! I signed up for an online Excel Class via the local library, but it was so boring. I am so glad I found your video. I really enjoyed learning. You have a great way of bringing interest to the subject. Thanks again!

[@tyssys9559]

something u made in 2022 is helping me in 2024, thanks alot and gbu, love from india

[@priyale8130]

I'm very grateful to you for all videos on your channel. They're very great, valuable and very easy to understand for everyone. Thanks so much for all your hard work, great teacher ♥️

[@djideka]

Really,God bless you,gifted you are🎉🎉

[@lauraandrade2818]

By far the best intro video I've ever watched. Thanks so much!

[@KarenHRiceScott]

I love how you've broken down Excel into easy to follow steps. Thank you.

[@sherryricks7356]

You are an AMAZING teacher, and this is an AMAZING tutorial!!! I cannot wait to provide your channel information to my co-workers who need to brush up or to just learn from beginning to end. Thank you! Definitely will check out all of your other videos.

[@shaneeckman478]

As a 35 year old that has had the same job for 17 years and soon to be career changer. This was an awesome lesson and I thank you so much.

[@skip031890]

Wow, you started your job when you were 18. I was like that at my last job. Started when I was 19 and they laid me off when I was 31.

[@sunflowerdigital]

I'm so, so grateful for this video, really! Excel has always been a scary program for me, I will definetely check out the other videos. Thank you so much! :)

[@afomamyson942]

You are, by far, the best teacher so far. Amazing steps to follow. No one can miss it with this video. Thank you

[@tanyafryar3172]

I have exhaustingly watched about 10 hours of "Excel for beginners" from a lot of different videos and still felt lost. Most of them were zipping through the video while I'm still trying to find out where they're at on my own excel sheet before they had already moved on. I was constantly having to go back and forth between their video and my own excel sheet trying to learn. Or trying to copy what they did only to find that it did NOT work on my excel sheet. I did something wrong. Within 10 minutes, you had showed me how to do those things that I have tried and failed at multiple times. This video taught me some of the best shortcuts and examples that I need and have been wanting to learn for my job. The BEST video yet! You're awesome and have a wonderful gift of teaching others. Thank you!!

[@kimberlymartin4434]

Thank you for such an easily understandable Excel Tutorial Series. I am currently in a class for beginners and just felt so defeated after some of these classes. With the help you have given us with your tutorials here, I recognize a lot of the things you go over but most importantly I feel now like I am actually understanding it! What a great feeling! Thank you again.

[@techteachersandstudents]

You're very welcome! Thanks for watching the videos and for your kind comments. Please share the videos with others that you think could benefit from them.

[@vamsikrishna9563]

kkk##

[@halimainusah2576]

@@techteachersandstudentsthank you very much 😊

[@dougondrums6368]

Thank you for creating a great tutorial for beginning Excel! The examples you provided are excellent and easy to work with.

[@khadeejathasneem7544]

Great tutorial! Clear explanations and easy to follow. Thanks for breaking down Excel basics so well! ❤❤

[@amandahudson4770]

This taught me more in just a few minutes than taking a whole course to get certified in Excel did. Thanks so much for this video

[@jollingonzales575]

Thank you for your tutorial. This is an excellent, most comprehensive, and straightforward lesson I've ever seen! You've made it so easy to follow and understand. I look forward to watching and learning more from your next lesson, The Beginners Guide to Excel!

[@vandavidcastroverde4129]

This has been very helpful for me. As someone who had always been afraid of using it, now I become very excited and more interested because of this course. Thank you for this. Also, kudos to your teaching skills.❤

[@laylachanel.fitness]

Thank you so much for this video. Excel has been daunting me for years, this has been a life saver. I appreciate you taking the time to break down even the very basics. I feel much more confident with software in general after watching this video.

[@stardancer119]

Thank you for this video! I have lots of experience with an alternate-brand spreadsheet program, but I've never used Excel. After comparison, the one I'm familiar with is very similar to Excel, but I'm preparing for a job interview this week, and I wanted to get a basic knowledge of Excel before going into it. Your video was clear, concise, and easy to follow. I'm off to watch more of your tutorials!

[@abigailgarner1791]

Great beginners video! Been using Excel for a few years and still some things I learnt here that I didn't know. Thank you!

[@manuelnunez8802]

This video is PHENOMENAL!!! You've captured everything there is to know about Excel for general usage in less than an hour! KUDOS!

[@mikieniegas4170]

I am currently watching this tutorial for a beginner like with no work experience yet and this is the what I am looking for. Very much concise and easily understand. Hope to finish this course and gives me confidence. Best of luck to you .

[@pamelabooth5850]

This is the best video on Excel that I have found. Thank you so very much for your time and knowledge!!

[@nodnalneyugn8753]

I’m so excited for this lesson! thank you!

[@davince5059]

You are a genius 👏👏💯This is the best explanatory video on Excel have watched in my entire life. I am glad I found this video😍😍

[@LaTonyaBrewer]

This Excel course was incredibly helpful for beginners and simple to understand. I am more confident using Excel now. Your style of teaching is truly amazing! Thank you so very much for helping us ❤

[@marybeltorres6877]

I have always struggled with Excel but because of you I feel more confident to play with it. THANK YOU!!!!

[@tedhead3162]

Excellent work again! Great refresher course 😉

[@amun-ra7413]

New subscriber. Thank you so much, the lesson was great and you explained it well. Big thanks from Morocco 🇲🇦

[@paulnicy]

Your Excel tutorial is fantastic-clear, detailed, and every word is useful. I've started recommending it to friends. Thank you!

[@sarbeeb7910]

Dear lecturer, thanks for all insights you have given us . You gave us a great deal of knowledge in free.

[@engineerseth8783]

i have paid for this to be thought, but your videos have made it more easily for me. thanks so much

[@arnelsevilleno9810]

You have been extremely helpful.. Thank you so much..

[@thibaultmberabahizi9381]

You’re such an amazing instructor. What a beautiful way to give back. Stay blessed

[@princesspiwebaleni5535]

As someone who's never used excel 2mins made me to subscribe because I found me a free tutor thank you so much 🙏 ❤❤❤❤❤

[@_shelly_74]

Id actually like to leave this comment here because this video helped me so much ! Tomorrow I got an interview where I’ve to practically proven them I’m aware of all 😅. Therefore I learned these basics from you which is really helping me a lot so far . No words to describe you got great teaching skills as well. And thank you so much for these videos ❤️