Excel for Beginners - The Complete Course
HTML-код
- Опубликовано: 22 май 2024
- 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 - Хобби
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
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.
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!
If you don’t mind me asking, what type of job did you go for that required you to take a test at the interview? Also, did you have any excel knowledge prior to applying for the position or did you learn all the basics needed by watching this course?
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.
@@techteachersandstudents Hello sir! I just wanted to ask you, which part of this video teaches the skills needed for Data Entry? I am trying to start Data Entry and remote work, so this is why I am asking. Can you please tell me what I need to focus on? Thanks!
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 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
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?
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
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)
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 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.
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…
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 best video I ever saw on RUclips about Excel. Thank 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 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 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.
The easiest excel explanation ever. You deserve a follow. Thank you 🙏🏾
This is the first excel I have been able to sit through in years. You are an excellent teacher
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!
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!
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
Thank you! A whole course for one hour and for FREE! WOW!
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 tutorials are great and simple to understand . Thank you for explaining complexity into simplicity .Good job done, grateful for this!
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
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!
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’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.
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.
What a great video! Your pace and flow of information are those of a seasoned educator. Thank you very much!
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
I have watched a lot of excel videos and yours is by far the best. It gives such convenient short-cuts Thank you so much!
Amazing teaching... I've learnt excel when I was in school but ever since being a mum I've been at home for donkey yrs my excel skills have been wiped out totally.. thank U so much for this tutorial. You have gt urself a new subscriber!
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!👊🏻
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!
I used to know Excel at the intermediate level back in the mid 1990's and have not used it since then. It now has a lot more features, shortcuts and the ribbons is totally new for me. Time to catch up. Thanks for the tutorial to help jog my memory.
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.
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 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.
Your teaching is super awesome 👏.. I never knew excel could be this simple and easy to learn. I have 5 ⭐️ from me. 💯 helpful
This video is PHENOMENAL!!! You've captured everything there is to know about Excel for general usage in less than an hour! KUDOS!
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 is literally one of the best tutorial videos I have ever come across good work champ!
From someone who decided to skip the Excel course back in HS to play Tennis instead, THANK YOU! :D I truly learned a lot! Going to need this a lot in my 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. ❤
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!
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
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 for putting this out for free. Your teaching still is perfection. Much appreciated.
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.
Fantastic video! I've taken a few college-level courses, and this beats them all! Great job!
Thank you for the clarity in your explaination. I took this class since 1992 lol when we were using Doshell, and I did not remember any of it. This was very refreshing to my memory.
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.
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!
I am self-trained on Excel. I've learnt some new actions that will make my life much more easier. Very clear instructional video.
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
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.👍🏽💃🏽
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.
You are, by far, the best teacher so far. Amazing steps to follow. No one can miss it with this video. 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!!
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!
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 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 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.
😊🙏♥️🙏😊
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 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 😊
How amazing to have these courses for free, available on RUclips. I just learned so much in 1 hour. Thank you so much!
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 such an effective educator. Love your videos. I'd click the alert bell but, unfortunately, that means YT sends alerts for every single thing under the sun. There's no ability to just get notifications for only the channels you want. It's always been a peeve but I'm pretty sure it's just the way YT wants it.
Thank you for this nice, clear, interesting and to the point video! I love listening to you explaining :)
Im 38 and i forgot to use excel since i am working for longer years in sales and focusing on customer service alone, and seldom using computer. Thank you Sir for this detailed turorial, its easy to understand even if i watched it once only. Now my knowledge in excel slowly getting back and i need to watch it over and over so i will learn a lot.👍👌
Excellent work again! Great refresher course 😉
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! :)
I really want to say THANK YOU! I'm starting a new job on Monday where Excel is required and I had zero knowledge but now I'm certain I can do it!
Glad I could help!
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!
Thank you for creating a great tutorial for beginning Excel! The examples you provided are excellent and easy to work with.
Super helpful. Very clear, easy to follow tutorial even as a beginner. Thank you!
He has explained it in so much details that it is registered in my head for ever now.
This is probably the most understandable video on the internet. Learnt a lot in just an hour.
You're an amazing tutor👏👏👏
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🎉🎉
Thanks a lot for this video, I was so intimidated by excel but now with your video I feel more confident. Extremely well explained!!
Thank you so much for your detailed teaching. its my first time here. I enjoyed learning experience
I have searched for classes and resources to teach myself Excel. Even though this was one of the first I found, it is exactly what I need for my learning style. Thank you very much.
i have paid for this to be thought, but your videos have made it more easily for me. thanks so much
Nobody can teach it better than you did. It is so well explained 👍
Indeed
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 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. Your an excellent teacher. Very clear and precise.
By far the best intro video I've ever watched. Thanks so much!
You have a great informative voice which helps to keep up my attention I watched this video before and your intermediate video too, I just come back once in a while to see what I missed or what I could improve on. Thanks for this again you are a great teacher!
This is the best video on Excel that I have found. Thank you so very much for your time and knowledge!!
New subscriber. Thank you so much, the lesson was great and you explained it well. Big thanks from Morocco 🇲🇦
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!
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.
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.
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