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
Пікірлер: 1 900
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
11 ай бұрын
I just started excel course, please all of you wish me luck 🙏 I know that is going to be hard but not impossible.
Watching this because I lied in my resume 🤣
@azizhammouda8775
11 күн бұрын
same broo 😂😂😂
@AlphaOmegon
10 күн бұрын
I mean what them companies thought we would do?
@eden3067
9 күн бұрын
Hahaahha same
@manikantagogeri5267
9 күн бұрын
Today mrng I was in same situation
@marie2721
9 күн бұрын
Me too
This is the best video you will ever find which teaches you all the basics you need to use Excel
@techteachersandstudents
3 күн бұрын
Wow, thanks! I'm glad you liked the video.
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.
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
8 ай бұрын
Wonderful! That's so fun to hear. Thanks for sharing news of your success with me.
@user-hb1in5nb1t
2 ай бұрын
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!
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
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
11 күн бұрын
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 😍😍😍
@techteachersandstudents
3 ай бұрын
Thanks for your kind words. You’ve made my day!
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
10 ай бұрын
Thank you
@michaelsevens
10 ай бұрын
Thank you...
@HanaYanes-us4fu
10 ай бұрын
Thank you so much 😊
@Ren-em1xk
10 ай бұрын
Guys I did this for myself not for you…
This video has changed my life. I cannot thank you enough for your time. God bless you.
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!
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 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
3 ай бұрын
same here
@mrnonso188
2 ай бұрын
In 24 years time I will be your age. God bless you
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!
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
8 ай бұрын
Oppk9l Love 💕 oppk9
@felicitasbamuna1854
8 ай бұрын
😯😶
@stevenhulbert7540
23 күн бұрын
I'm older but I never learned Excel either and that's all any companies use, it's tough out there.
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
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 👍
The easiest excel explanation ever. You deserve a follow. Thank you 🙏🏾
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.
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.
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!
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!
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.
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!
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!
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
The tutorials are great and simple to understand . Thank you for explaining complexity into simplicity .Good job done, grateful for this!
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
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)
What a great video! Your pace and flow of information are those of a seasoned educator. Thank you very much!
This is the first excel I have been able to sit through in years. You are an excellent teacher
This video is PHENOMENAL!!! You've captured everything there is to know about Excel for general usage in less than an hour! KUDOS!
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!!
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
10 ай бұрын
SAME HERE
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.
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.
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 KZread and you came up. You are an AMAZING teacher, and now I can create my own. Thank you for your KINDNESS and EXPERTISE😊!
@techteachersandstudents
10 ай бұрын
Glad it was helpful! Thank you for your kind words.
Very well done. I was very familiar with Excel until about year 2000. You're bringing me up to date!
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!
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. 😊🙏♥️🙏😊
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.
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!
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.
Thank you for putting this out for free. Your teaching still is perfection. Much appreciated.
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
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!
Fantastic video! I've taken a few college-level courses, and this beats them all! Great job!
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. ❤
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!
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
10 ай бұрын
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.
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!!!
I am self-trained on Excel. I've learnt some new actions that will make my life much more easier. Very clear instructional video.
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.
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.❤
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 ❤
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're an amazing Teacher!! I had learned Excel in the past, but Teachers never spoke about the Anatomy of a Spreadsheet!!! Excellent Tutorial, I'm so grateful for!
This is literally one of the best tutorial videos I have ever come across good work champ!
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
6 ай бұрын
kkk##
@halimainusah2576
5 ай бұрын
@@techteachersandstudentsthank you very much 😊
You are, by far, the best teacher so far. Amazing steps to follow. No one can miss it with this video. Thank you
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
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 ❤️
I have always struggled with Excel but because of you I feel more confident to play with it. THANK YOU!!!!
Thank you! A whole course for one hour and for FREE! WOW!
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.👍🏽💃🏽
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.
I've used Excel for years and thought I knew all the basics. After watching this video, I learned quite a few things that I didn't know. Since my job involves heavy usage of Excel, this video was very helpful and I will definitely be viewing your other videos to expand my knowledge. Thank you for explaining concepts in an easy to understand, concise manner.
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!
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
5 ай бұрын
Thank you
@aibrahim8189
3 ай бұрын
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
This is probably the most understandable video on the internet. Learnt a lot in just an hour. You're an amazing tutor👏👏👏
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.
Super helpful. Very clear, easy to follow tutorial even as a beginner. 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 ♥️
@djideka
8 ай бұрын
Really,God bless you,gifted you are🎉🎉
He has explained it in so much details that it is registered in my head for ever now.
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 ❤
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! :)
Thank you so much. Your an excellent teacher. Very clear and precise.
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 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!
Thank you for this nice, clear, interesting and to the point video! I love listening to you explaining :)
actually i have never had so much fun doing excel sheet until now! thank you so much sir for making this video! this was super helpful to me! l must say i m a quite a bit confident in using the excel sheet now. ❤❤😊😊
Wish you were my IT teacher back in the day, because you made this SO ENGAGING. Thank you!
This is so clear and well taught! I have been trying to crash learn very basic excel and every v😅demo and course I tried made me tense Ann's anxious. This one soothed me and let me take in information so much more easily! I may need to rewatch over time if I don't use it right away, but I'm totally confident about my capability to do so! Brilliant teacher!
i have paid for this to be thought, but your videos have made it more easily for me. thanks so much
By far the best intro video I've ever watched. Thanks so much!
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.
Thank you so much. After being retired awhile, I needed this to bring me up to date in preparation for returning to the workforce.
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😍😍
Thank you for creating a great tutorial for beginning Excel! The examples you provided are excellent and easy to work with.
This video is a MASTERCLASS. You think you know a bit, then you get so much more. ......Thank you
How amazing to have these courses for free, available on KZread. I just learned so much in 1 hour. Thank you so much!
Great beginners video! Been using Excel for a few years and still some things I learnt here that I didn't know. Thank you!
Nobody can teach it better than you did. It is so well explained 👍
@ThapiM689
7 ай бұрын
Indeed
This is so perfect! Thank you so much for making such a concise and easy-to-understand tutorial. I've learned so much.
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!
New subscriber. Thank you so much, the lesson was great and you explained it well. Big thanks from Morocco 🇲🇦