Microsoft Excel Tutorial - Beginners Level 1
Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E... This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel.
Intermediate Microsoft Excel Class: • Microsoft Excel Interm...
Dive deeper into formulas and functions in excel with this playlist: • Formulas and Function ...
Creating Charts in Excel: • How to Create Charts a...
0:00 Start
1:07 Starting up
1:27 Recent documents and pinning documents
1:54 Templates
2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel
3:48 Rows, Columns, Cells and Ranges
5:49 Worksheets in Microsoft Excel
6:52 View and zooming
7:30 Inputting Data
10:56 Formatting Data
13:38 Wrapping Text
14:22 Insert Row/ Merge & Center cells
15:41 Currency formatting
16:20 Print view
17:02 Add cell borders and colors
18:18 Basic formulas in Microsoft Excel
21:17 Copy formula
23:45 Freeze Pane
24:52 Basic Microsoft Excel functions
28:59 “Tell Me” in Microsoft Excel
29:43 Inserting charts in Microsoft Excel
Excel for Beginners Tutorial - Level 2: • Microsoft Excel Tutori...
Excel for Beginners Tuotiral - Level 3: • Microsoft Excel Tutori...
Excel for Beginners Tutorial - Level 4: • Microsoft Excel Tutori...
Microsoft Excel for Beginners - Level 5: • Microsoft Excel Tutori...
VLOOKUP Function for Excel: • Vlookup Function in Ex...
Learn Pivot Tables for Beginners: • Excel Pivot Table Tuto...
10 Best Excel Beginners Tips: • 10 Best Excel Tips for...
Make a Line Graph in Excel: • How to Make a Line Gra...
I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Looking for more? Here's a level 2 Excel tutorial for beginners: kzhead.info/sun/lcyTk8-Pi36hfYU/bejne.html
Teacher's Tech Your Tutorial Vides is really very helpful & easy to Understand. Thanks a lot!
Thank you!
Wow
Superb teaching skills. I've subscribed and will be back for more of your videos. Thanks so much ..extremely well done!
Thanks for nice lessons for excel
I lied on my resume, got the job, now I'm here
lmfao!! me too!
Brea Evans You too??!! 😂😂 Fake it til you make it!
getting ready here lol
The HR of your company must be aware about your lie but they ignore it and hire
Lol! legit what I'm doing!....well...I applied for it. Lol this is too funny
can we just take a moment to appreciate this guy for providing this type of content for free ? great help, Thank you sir!
Yes, I haven't even started and I'm grateful for the find! Looking forward to learning and growing with everyone!
Indeed!!! Thank you for the wonderful training. Stay blessed...
Couldn’t agree more. I start a new job next week and they said it will involve a lot of Excel. Thank you for providing such an informative and easy to follow video, really helped me a lot!
thanks a lot!it really helps!
Agreed 👍 thank you sir for sharing.
I got the job as Admin. And i have to learn the excel. So here i am. Thanks it's so much helpful.
And how you doing so far ??. Same over here, I going for an interview today and they required me to know how to use Excel . 🙃
Did you manage to learn it fast enough? Im trying to change jobs and would need some knowledge in this@@mdzayrbs8855
@@mdzayrbs8855any updates? Did you get the job fully?
5 years later and this is still useful. absolute legend👍
Successful people don't become that way overnight. most people see at a glance-wealth, a great career, purpose-is the result of hard work and hustle over time. I pray that anyone who reads this will be successful in life.. 🤑
I have heard a lot about investments with Clara and how good she is, please how safe are the profits ?
@@Michael-bx1sb I have also been tradingwith her. profits are secured and over a 100 percent return on investment..
My first investment with Clara gave me upto $53,000 and that has made me invest without the fear of losing, I got four of my friends involved with her already.
@@estherjack6027 wow that's very nice Please how can i be able to reach out to your broker, my income stream is in a mess.pls
Pls how I can get in touch with this Expert Clara?
Honestly, this 33min video alone was more helpful than 16 years of schooling when it comes to Excel.. And the in depth and professional way you explain everything truly makes it both easy to understand and enjoyable! Thank you!🙏🏻 - Part 2, here I come!
Was thinking that, school made it sound alien!!
this! school made it more difficult to understand at the time.
Really?!
As a data analyst beginner, this was insightful. Your explanation were simple and clear. Thank you
I just completed a certificate based Excel for beginner's course and although I passed the required test, I left feeling as though I still did not know excel. This guy explains excel in a way that is very easy to understand and apply in real life. Great channel!
Often you need to apply an application to real world events, and use it a lot to get a firm grasp on not only how to operate it, but how to use it as a productive tool. I would recommend looking at data that you can put into excel and obtain some useful output. The month to month reading from the power meter would be a good example. You could even compare daily reading for a month to the same month last year. I would also correlate that data with the daily temperature readings for that month as well. Anything you can practice. You can become good at, and perhaps even master.
I feel exactly the same. I find it so incredibly hard
As someone with little knowledge of Excel, if I were to watch this video and learn all that has been said, would I be safe to put it on my Resume? Would it give enough information to the point where I am not lying when I say I have a good knowledge of the program?
It helps when you actually have your own stuff that you want to do with an app. You put a lot more effort into any task if you find it interesting or useful.
Spot on! I've a new role I'm learning about data entry/creating worksheets. Brilliant delivery 👏 👌 Great aid to de mystifying Excel.
I wouldn’t dare to lie, but what I’m doing is every time I look at a job and see that I don’t know something, I get tools and spend days learning and practicing at home. That way, I can have that new skill and be able to put it on on my resume with confidence :)
i don’t think anyone actually gives a fuck
@@jjankiefn1152 I do actually give a few. This is what I'm doing as well.
@@jjankiefn1152 no need to be negative man, chill
im going to start doing that too!! it's hard out here, i wish you luck with everything ❣️
@@jjankiefn1152 🤣🤣🤣🤣🤣🤣
Age 61 and in grad school- thank you- this older brain needed this. I can watch it over and over until it sinks in.
You sound like me over and over again I fall asleep and have to start over ha ha
This guy defines the word “selfless” thank you for your video! Wow it’s amazing, I graduated High School in 1999 and I am required to know excel and you Sir are a life saver!
Man you are a life saver bro. I'm starting a new job as a Production manager for a Marking company. and these videos helped me out so much !! I'm grateful for what you do. Your videos are super simple and easy to learn from. Thank you so much for taking the time to do them !!!!
You know how to teach. Everything is on point, voice control, step by step directions, everything.
IiykaGh . The
Nice work and well understood
@IrfanullahTechnical
Damn... Finally someone who actually takes their time and explains instead of someone who is just rambling as if we know the material already. It's one thing to know excel. It's another thing to know how to teach. You know both. Thanks so much. This was great.
very nice video
He really explains Excel spreadsheet in details but he needs to ZOOM IN
Well said
Agree!
@hotboiboi Amen to that. I thought I was seriously loosing my faculties. All these other "instructors" , just droning on and have the nerve to call themselves instructors. SMH.
I got an internship program just today and was assigned to an office that requires an employee to be computer-literate, specifically for Microsoft Excel. With an utmost willingness to learn and provide a great contribution to the office, I went to KZhead to seek some tutorials for Excel beginners and came up first with your video. Very informative and very helpful. Thank you, sir.
I I don’t don’t know how how to to church church church do church church church get church do you you want want to to church church or or church
😮
For the first time in my life, I have gotten a chance to really understand what Excel sheets really are. I can't believe that I have always sat on a powerful tool. Until I finished this beginner's tutorial. I appreciate your way of presenting is super fun and you're just able to breakdown complex stuff to digestible small pieces. Thank you and I will definitely recommend it to anyone.
I quit my job of 10 years last week because I was not being treated nor compensated fairly. I'm terrified about starting over and wanted to brush up on some skills for job opportunities that will come my way. This is incredible to have access to for free. You're changing lives! Thank you Jamie!
I've never been so actively engaged in a tutorial video before. This was EXTREMELY helpful. Pacing was perfect, information was clear, and it was presented in such a way that I didn't feel like there was any unnecessary repetition or need to skip ahead. I'm so glad this exists!
I got the job as Admin. And i have to learn the excel. So here i am. Thanks it's so much helpful. 😁
As someone who finds Excel extremely intimidating, this video was easy to follow and understand. Thank you so much!
Me too it makes me extremely anxious 😂
I don’t usually leave comments but this was so well delivered and easy to understand so thank you. I truly appreciate this
You are so welcome!
Sure
I should be thanking you Not you thanking me
Mrs Anna is legit and her method works like magic I keep on earning every single week with her new strategy
Wow I' m just shock someone mentioned expert Mrs Anna thought I' m the only one trading with her
She helped me recover what I lost trying to trade my self
Trading with an expert is the best strategy for newbies and busy investors who have little or no time to monitor trade
She’s technical analysis is dope and her interpretation/projections of the market is so accurate I sometimes ask myself if he is human haha. Point is, Anna is the perfect trader to follow for advise and daily signals
I'm from Brazil, I and two other of my friends tried her immediately we testified, her performing wonders🇧🇷
Thank you so much! I'm starting a new job tomorrow and we use Excel. I appreciate the help 😊
New students here and find it helpful. Thank you
I just learned more in the first 16 mins of this video then anybody have ever told me about Excel. Every question I have ever had was answered. Keep up the good teaching.
Zy
Ditto!!
data entry editing formatting kzhead.info/sun/Z9KepbuRqot3ops/bejne.html
😊Thank you 🙏 you saved my ass
Felt like that was a full semester of excel 101. Thank you! You’re an excellent teacher. I had to slow and pause several times but it was incredibly informational.
yeah... same with me... very informative..
may i ask you how can i insert the data especially for the next 4 advanced levels videos
So true. This beginner video was more in depth than I realize. This 1 video can help you through college if you need excel for college.
I may be 14, but having the skill i need for the future is a great idea, thanks!
I am 63 year old guy till now I felt learning excel is very difficult, thanks to him because I can master excel within no time…
love how he teaches and you can actually see everything he is doing. so, happy i found this channel.
shut up
I am very impressed by how efficiently you were able to communicate excel fundamentals in in such a short amount of time. In over 25 years, you were the first person that made me feel confident about using excel.
An excellent way to break things down. I'm helping a family member by managing the office, and it has been many years since I have used Excel. I tried several "Excel Help" videos, yet the majority of the time I finished the video more confused than when I started. Your way of breaking things down in a patient, relatable way without veering too far away from the fundamentals makes all the difference. Definitely gained a subscriber, and look forward to learning more!
I just wanted to drop a big THANK YOU. I am trying to figure out a chart of my hours for work both weekly and monthly. You have just helped me tremendously with this one alone. I am looking forward to watching the rest of your videos. So, THANK YOU!!!! I truly appreciate you. I hope your day is as amazing as you just made mine.
So am here to become proficient like my resumes says.. I'm giddy with excitement that I've learned something so easily
This is an open invitation for you to become part of the World's biggest conglomeration and reach the peak of your career. As we begin this year's recruitment programme and our annual feast of harvest is almost at hand. The Grand master gave us the mandate to always reach out for people like you so take advantage of this opportunity and join the great brotherhood of Illuminati. WhatsApp +2348079514838
Studying up on Microsoft programs for a potential job opportunity, knowing absolutely nothing about them. This one video gave me so much information, but didn’t over load me! I feel like I learned a lot, and will continue watching his videos to expand my knowledge.
Legit doing the same 😭😭😭😭
You are a great teacher! I knew a little about excel from self taught but I needed to really expand my knowledge but was intimidated for some reason. I am so glad I found your video. It took away the anxiety. Easy sub for me!
I’m just grateful for Teacher’s Tech and how he keeps it simple to explain. My favorite tutorial place for Excel
I usually have a hard time trying to learn new things because most of the time it's something written in a textbook or online reading is involved and I get overwhelmed very quickly. Then I struggle to retain what I learned. Your online tutorial was so helpful because I followed along while you were doing it and I learned stuff I did not know which is great! I also feel very confident that I will retain what I have learned because I did it myself and that will stick in my brain for longer. Thank you so much for the tutorial! I am very excited to try lesson 2 and the other ones to learn more about this great program which used to intimidate me!
Dude, you´re incredible, I been trying to complete a UDEMY curse that is more than boring, it kills me!!!..... you have made my day!!!..... I´m from Mexico, IN THE NAME OF ALL COOL MEXICANS, WE ARE GRATEFUL!!!!!! GRACIASSSSSSSS!!! TE AMAMOSSSSS!!!
You are very welcome! I'm glad I could help you out.
I'm a complete noob when it comes to this sort of stuff. Iv just followed you step by step. And made everything you just did. This is fantastic. I'm looking forward to trying level 2 tomorrow. Lol
Thanks for this! I'm starting my "year of learning excel" this week and, as a self-taught person, this whole playlist is going to be my starting point. I'm a graphic designer so excel has been something I interact with often when I need to pull data for a graph or chart, but haven't ever done a deep-dive into. I'm sure finance is going to be thrilled when I stop coming to them, hat in hand because I accidentally broke one of their formulas.
This is an absolutely fantastic tutorial. Easy to digest, incredibly helpful and unbelievably - free - content! Thank you for making this accessible to so many!
data entry editing formatting kzhead.info/sun/Z9KepbuRqot3ops/bejne.html
This was amazing , are you able to demonstrate how to use conditional formatting please ?
I'm starting to learn Excel from Zero, this is exactly the tutorial I needed. Thank you.
This is an open invitation for you to become part of the World's biggest conglomeration and reach the peak of your career. As we begin this year's recruitment programme and our annual feast of harvest is almost at hand. The Grand master gave us the mandate to always reach out for people like you so take advantage of this opportunity and join the great brotherhood of Illuminati. WhatsApp +2348079514838
Me too
Love the Channel and the help you are providing to newbies like me. I'm 54 years old and just started my lessons. At 54, I suddenly realized I didn't know anything. So TG for Utube and videos like yours. Keep up the great work, big fan. Subscribe student
Great tutorial! Excited about the remaining ones to come! Very easy to understand, follow and was engaging 👌🏽
This guy is AWESOME!! He is clear, concise, and very easy to follow. Hands down the best tutorial I've ever watched on Excel. He left me feeling confident that I can really learn to use Excel. Thank you!
can we just take a moment to appreciate this guy
Shut up
@@semirasuleman1989 you shut up
Sir. You are a literal life saver. I've been tasked with putting something like this together but specifically regarding information within my company and you have made it so there is a groundwork for what even needs to be explained. You are amazing!
Spot on!!!
I lied to my future employer during the interview process, that I was familiar with MS Excel & other office related Apps & programs. I got the job and used this tutorial to learn it quickly. Thanks
This was super helpful and easy to understand!! I’ve tried watching multiple videos on this and it was over complicated for absolutely no reason. Thank you so much for sharing!!!
You're so welcome!
This guy is amazing, if my teachers taught like this I would have graduated top of my class !!
Thank you! I am a complete tech noob and I am starting a Data Analytics Course to upskill myself and I am so grateful to have found your channel!
This was amazing less intimidating and I can wrap my brain around it, THANKS SO MUCH!!!
Im a high school student looking to advance my skills. this video helps enormously. While watching along I created a spreadsheet to track my progress in the gym utilizing all the skills learned in this video. Im super proud of it and am excited to continue learning. Thank you so much for the work and knowledge you put into these videos.
This tutorial has really assisted me a lot in Ms Excel. I can't just thank this guy enough for rendering such a fantastic explanation for free.
I have used Excell for a long time in different positions however there are still things to learn. I even have my staff using this tutorial to learn how to use Excel or learn how to use it better.
God bless you for this, the step by step process was so easy to learn, i was so happy watching, learning and applying. Thumbs up for this honestly, this is an in demand skill and your video is helping thousands of people.
It's refreshing to have someone make a video tutorial that a layperson can understand. Thank you.
Hello, Preciously welcomed you to come Join us the Illuminati and become rich and influential in life... Money is not an issue for us, join us today and kick out your financial problems with a monthly salary of $900,000 USD. Your financial welfare is our aim; fame and power will be added unto u after two weeks of your Membership. If u wish to become a member or want more info on how to join, please do reply with "I'M INTERESTED TO JOIN" to this message or message us directly on whatsapp +447451216557. so we can proceed.
Absolutely great teaching. In my prior job, I had only used it for data entry, and when I took this one, I had no idea how to use this and had to find video help. You are BY FAR, the best one out there. Thank you!
20 mins in and I already feel like a pro. your explanation is so good. Let me continue..
Best Excel tutorial I have found so far and oh boy I have searched online. I am definitely sharing this video. Easy to understand, well explained and less than an hour!!!
Never watched a youtube video for this long without missing a second of it. The most insightful video! Thank you and keep them coming!!
Thanks, will do!
Hello
What is your age
What is your name.
@@stranger9735 bruh
I like how you simplify it so anyone can understand. My introduction of Excel was learn as I go and tutorials such as this would have been great back then. Thank you for sharing.
Unfortunately I was unable to attend college due to my circumstances. I have subsequently been working as a server for years. I'm now trying to teach myself some skills such as Excel in hopes I can land a better position with possible benefits and have an actual career. Thank you so much for the free lesson!
I've only looked at the first 22 minutes and found it quite helpful. Like the slow, deliberate way you explain.
Thank you for this! I attended a beginners Excel course through work recently. I’m aware I couldn’t pause the tutor so I could practice then catch up with the rest of the class. But I found you so much easier to understand and have gained a lot more confidence using a spreadsheet 👍🏼
This is a GREAT tutorial for for "brushing up" on Excel: It's easy to follow and very informative! This is a big help for me with a job that I just landed!
This tutorial is superb Went from a zero to a 50 in minutes..great job…I’m definitely going to watch more
Just started my new job as a support engineer (fancy word for level 1/2 help desk) - had not previous experience or education in Microsoft 365 but your videos have help be create a bigger picture when clients request support.
I struggle with learning any type of formatting/computer programming, and it is an essential tool for my profession. I'm so glad I found your channel! You do such a great job breaking down Excel and making it so easy to understand! Thank you!
This was so enlightening, thank you. Was made redundant from a job I’d done for 37 years and desperately needed to brush up on IT skills. You made it straightforward and easy to understand. I am actually excited about practising on my new laptop. Thanks again
You are so welcome
Hey Good Luck Debi with job search, it's been a trying period for lots, myself included. Thank you for the cool training and explanation @Teachers Tech..
Very easy to understand as I was struggling with the basics but here i am feeling good so far . Thanks to you 😊
Dude, your a good teacher.
Great refresher for "skills test" at 2nd round interview! Thank you Jamie! :)
Thank you for taking the timeout to break down Microsoft Excel learning tutorial. I got the idea now how to organized a worksheet.
Your videos are helping me become more proficient in doing my job. Thank you for making these so easy to follow and understand.
Thank you for this. I appreciate all of the time and effort that you put into making this understandable and most of all free. Thank you again!!!
It isNew Year’s Eve 2022 - coming up to midnight my son is gone out and I am on taxi duty and I am watching this excel tutorial- and I think this guy is absolutely fabulous-I can’t wait to get out the lap top and input this data and practice- I purchased ‘Excel For Dummies’ expecting there to some practice sheets etc that you could mess around with but it is all text - so I am going to “latch” on to this guy and learn everything he has to say - this guy is BRILLIANT- Happy New Year 🥂
I am so grateful to have found you. I am taking an Excel course and this tutorial saved my life. You are great at explaining things really smooth and very simple to follow along. I am looking forward to watching more of your videos. Thank you so much.
Amazing!! So precise and to the point. I’ll be taking notes and learning from you!
love the speed and the explanation of things, thank you so much.....
Best tutorial! You really explain to the person who knows nothing about Excel so we understand the place to go to get the results needed. I am so glad you are here. Thank you!
Have just paid to take a masterclass course and after a very painful hour decided enough was enough. Out of curiosity I searched on KZhead for a class and came across this. Learned so much more as very interactive class . Really great job and very enjoyable. Thank you, thank you!
Thank you for making this easy to understand. I can't wait to watch level 2 and more.
With Microsoft Excel, Word, and Outlook being the norm for Admin positions, I am enjoying your tutorials, easy to understand, thanks heaps.
I thoroughly enjoyed this tutorial. Taking breaks and coming back after each section made this more engraved into my memory.
I never knew excel is this much used and this powerful, i have never used it, and now since i have a job, i embarrassed myself by not knowing anything about excel, so I'm here. I want to learn it all and never embarrass myself again. 🥺 ps - you are teaching so amazingly, i hope i learn everything about excel from you, thank you❤️
Much too you all,🤑
I really appreciate your time and teaching. Thank you!
You are such a great teacher! I'm a beginner user, and you made everything make sense. Thank you!!!!
Hi there Professor, we must call you that Title because you really deserve it for the vital knowledge you are providing to humanity. You are doing a great and amazingly priceless service to the humanity and i would like to say thank you, may God bless you for these lessons. I learned better watching you than assisting in class teachings, you are brilliant. Kind regards sir, Ben from United Kingdom.
Absolutely brilliant. I have learned so much from this video. I have been very apprehensive to use excel for a number of years and as I work in finance I really do need it. I have used only the very very basic on excel sheets. I decided I really needed to look into excel and learn more about formatting and setting up charts etc. This video is absolutely brilliant. For the first time I am able to format/set up charts - something I thought I would never be able to do. Level 2 here I come. Thank you.
I lied on my CV about knowing Microsoft excel, 😂😂 called for interviews and this video has fully prepared me for the interviews with regards to Microsoft excel.❤❤❤❤❤😂
Thank you so much u can just imagine how much you help me, I pray may continue to bless you abundantly tly 🙏🙏😊
Absolutely a clear and concise explanation of everything one needs to know to get started, and an excellent "brush-up" if you haven't used Excel for awhile. Your delivery, articulation and presentation was exceptional. Great teacher. Thank you so very much!!!
kzhead.info/tools/0PcCP6UE5rPLMIlPQ5Xwlg.html
Clicked on hear because i needed a refresher, I'm glad i started from the beginning. Learned some new stuff, like to freeze panes. Great stuff!
I AM SO THANKFUL SEEING THIS TUTORIAL. LOOKING FORWARD FOR MORE TECH TUTORIALS.
This video is truly valuable. Kudos to those who don't fully understand English but are here to learn. Many language learners need to start with English because their native language isn't widely used in tutorials. If they aim to learn other languages, they must learn English first, as most references use English as the medium of instruction. Learning Excel whist learning English at the same time 😂😂
BEST tutorial video. THANK YOU SO MUCH. I take the spreadsheet class in a college. A professor doesn't lecture like you. Now its crystal clear hot to use it. I can do my homework now!!
This is the best tutorial I have seen. I have zero experience with Excel and with just one tutorial I feel more at ease. Thank you for your classes, I look forward to learning with you.
You're an excellent teacher. Your lesson has simplified the understanding of excel operations.