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
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.
My dear people can really be childish,but the good news is that you have the knowledge now
@@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.
@@gehanoates885 Its well. Do have a great day to goodfriend.
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!
I just started excel course, please all of you wish me luck 🙏 I know that is going to be hard but not impossible.
This is the best video you will ever find which teaches you all the basics you need to use Excel
Wow, thanks! I'm glad you liked the video.
Watching this because I lied in my resume 🤣
same broo 😂😂😂
I mean what them companies thought we would do?
Hahaahha same
Today mrng I was in same situation
Me too
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.
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.
I went for an interview today And I successfully passed my excel test (as a first time attempt) due to your teachings. Thank you
Wonderful! That's so fun to hear. Thanks for sharing news of your success with me.
How many days u pratice?
wow this is great !
I have to take an excel test for my job and this comment says I chose a great course! Gives me hope!
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 😊
What kind of job is it? What are your qualifications/education requirements?
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
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 😍😍😍
Thanks for your kind words. You’ve made my day!
This video has changed my life. I cannot thank you enough for your time. God bless you.
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 💃🏿
I'm glad you found the video to be helpful. Thanks for your kind words. Please share it with others who might need it.
@@techteachersandstudents yes I've actually shared with my classmate thanks 😌
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. 👋🙏
@@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
@@techteachersandstudents iohhuiouioiu uuuu uh ooohhooooouuoouo hi uuuu uh uuuooh ooiiiooooiioouohuiiohi you iouhoii
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!
same here
In 24 years time I will be your age. God bless you
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.
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 👍
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!
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!
The easiest excel explanation ever. You deserve a follow. Thank you 🙏🏾
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.
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!
Aw😊
For real starting a new job tomorrow and watched this video on repeat all week
Same to me😅
Same here on the confidence
@@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
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
Oppk9l Love 💕 oppk9
😯😶
I'm older but I never learned Excel either and that's all any companies use, it's tough out there.
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.
The tutorials are great and simple to understand . Thank you for explaining complexity into simplicity .Good job done, grateful for this!
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!
I just got myself a PhD in Excel in just 54:55.❤
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.
What a great video! Your pace and flow of information are those of a seasoned educator. Thank you very much!
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!
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!
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
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!
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
Thanks
Thank you
Thank you...
Thank you so much 😊
Guys I did this for myself not for you…
He has explained it in so much details that it is registered in my head for ever now.
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!
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!👊🏻
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
Thank you for putting this out for free. Your teaching still is perfection. Much appreciated.
This is the first excel I have been able to sit through in years. You are an excellent teacher
Thank you! A whole course for one hour and for FREE! WOW!
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.
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)
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!
Fantastic video! I've taken a few college-level courses, and this beats them all! Great job!
Very well done. I was very familiar with Excel until about year 2000. You're bringing me up to date!
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
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.
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.
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.
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!
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 ❤
This is probably the most understandable video on the internet. Learnt a lot in just an hour. You're an amazing tutor👏👏👏
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!!!
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!
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
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.❤
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! 🙏🙏🙏
Glad it was helpful!
💯👍🏼 A+
Thank you
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
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!
This is so perfect! Thank you so much for making such a concise and easy-to-understand tutorial. I've learned so much.
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 .
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.
This is literally one of the best tutorial videos I have ever come across good work champ!
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!
You are, by far, the best teacher so far. Amazing steps to follow. No one can miss it with this video. Thank you
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 ♥️
Really,God bless you,gifted you are🎉🎉
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.
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.
kkk##
@@techteachersandstudentsthank you very much 😊
This lesson is everything a beginner needs. Thumbs up 👍
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.
Thank you for creating a great tutorial for beginning Excel! The examples you provided are excellent and easy to work with.
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.
SAME HERE
This video is PHENOMENAL!!! You've captured everything there is to know about Excel for general usage in less than an hour! KUDOS!
Oh my, this is FANTASTIC! For 25 years I have ALWAYS had my Excel Spreadsheets created for me. Now that I have my own business, I have to do my own spreadsheets and I had no clue how to do them. Until I searched on KZhead and you came up. You are an AMAZING teacher, and now I can create my own. Thank you for your KINDNESS and EXPERTISE😊!
Glad it was helpful! Thank you for your kind words.
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 :)
Glad it was helpful!
Super helpful. Very clear, easy to follow tutorial even as a beginner. Thank you!
I love how you've broken down Excel into easy to follow steps. Thank you.
This is so helpful. I am a clinician and not very tech oriented, but who needs to set up a database to track the clients I am working with. The prospect of doing that has been really intimidating until I found your videos. Thank You very much for these tutorials. Now I anticipate the project to set up my Excel workbook as fun rather than frightening. 😊🙏♥️🙏😊
Thank you so much. Your an excellent teacher. Very clear and precise.
Thank you for this nice, clear, interesting and to the point video! I love listening to you explaining :)
Wish you were my IT teacher back in the day, because you made this SO ENGAGING. Thank you!
This was an excellent course. I am a true beginner. The instructor speaks clearly and in terms that can be understood. I followed along on 2 screens. Taking notes on one and creating a sample spreadsheet on the other. Thank you!!
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.👍🏽💃🏽
By far the best intro video I've ever watched. Thanks so much!
I am self-trained on Excel. I've learnt some new actions that will make my life much more easier. Very clear instructional video.
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. ❤
Thanks a lot for this video, I was so intimidated by excel but now with your video I feel more confident. Extremely well explained!!
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 ❤️
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.
I have always struggled with Excel but because of you I feel more confident to play with it. THANK YOU!!!!
i have paid for this to be thought, but your videos have made it more easily for me. thanks so much
Excellent work again! Great refresher course 😉
this is exactly what I have been looking for and he makes it so easy to learn, love these tutorials
How amazing to have these courses for free, available on KZhead. I just learned so much in 1 hour. Thank you so much!
Excell for beginners keep up the great work iam not good at computer but your tuturles are great the are are great help to learn from
All in one, best advance guide ever. Wonderful
This is the best video on Excel that I have found. Thank you so very much for your time and knowledge!!
I don't usually remember to give comments but your content is hard to pass by without words. Your content is top tier! Thanks for your time and very detailed knowledge. You are appreciated! Your ways of teaching are unmatched.
Glad you enjoy it!
You have been extremely helpful.. Thank you so much..
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! :)
Dear lecturer, thanks for all insights you have given us . You gave us a great deal of knowledge in free.
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.
Nobody can teach it better than you did. It is so well explained 👍
Indeed
I’m so excited for this lesson! thank you!
Your Excel tutorial is fantastic-clear, detailed, and every word is useful. I've started recommending it to friends. Thank you!
I am so thankful that I found this video. The new job requires to know excel. I had no idea how much this could do. Now I'm practicing at home. Thank you for doing this.