Microsoft Excel Tutorial - Beginners Level 1
Вставка
- Опубліковано 7 чер 2024
- 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: ua-cam.com/video/bhZckWTLkJM/v-deo.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
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 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
5 years later and this is still useful.
absolute legend👍
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?
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?!
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.
As a data analyst beginner, this was insightful. Your explanation were simple and clear. Thank you
New students here and find it helpful. Thank you
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?
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.
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 !!!!
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!
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 ua-cam.com/video/4neuWYsYAoc/v-deo.html
😊Thank you 🙏 you saved my ass
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.
Thank you so much! I'm starting a new job tomorrow and we use Excel. I appreciate the help 😊
Hi
Me too don't know diddly but I'm going to learn this
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.
You know how to teach. Everything is on point, voice control, step by step directions, everything.
IiykaGh . The
Nice work and well understood
@IrfanullahTechnical
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 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 UA-cam 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
😮
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!
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 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!
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.
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 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!
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
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!
Great tutorial! Excited about the remaining ones to come! Very easy to understand, follow and was engaging 👌🏽
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.
love how he teaches and you can actually see everything he is doing. so, happy i found this channel.
shut up
I’m just grateful for Teacher’s Tech and how he keeps it simple to explain. My favorite tutorial place for Excel
This tutorial is superb
Went from a zero to a 50 in minutes..great job…I’m definitely going to watch more
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!
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!
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 😂
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.
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 🤣🤣🤣🤣🤣🤣
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.
Very easy to understand as I was struggling with the basics but here i am feeling good so far . Thanks to you 😊
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
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 👍🏼
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🇧🇷
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!!!
20 mins in and I already feel like a pro. your explanation is so good. Let me continue..
Have just paid to take a masterclass course and after a very painful hour decided enough was enough. Out of curiosity I searched on UA-cam 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!
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 was amazing less intimidating and I can wrap my brain around it, THANKS SO MUCH!!!
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 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.
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 😭😭😭😭
Amazing!! So precise and to the point. I’ll be taking notes and learning from you!
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!!!
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 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.
I've only looked at the first 22 minutes and found it quite helpful. Like the slow, deliberate way you explain.
This is so helpful! You’ve simplified it better than my place of employment training program.
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!
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.
Your videos are helping me become more proficient in doing my job. Thank you for making these so easy to follow and understand.
This is absolutely great learning. This helped me a lot to get into a new job after 5 years of gap. 🙏
Brilliant and helpful for someone in their 40s and have never used Excel. Looking forward to watching the next levels. Thank you so much.
data entry editing formatting ua-cam.com/video/4neuWYsYAoc/v-deo.html
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.
With Microsoft Excel, Word, and Outlook being the norm for Admin positions, I am enjoying your tutorials, easy to understand, thanks heaps.
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
this is the best tutorial on youtube i have seen so far. thank you for teaching the excel for beginers, it just refreshed my mind when i learnt years ago and didnt use it afterwards.
That's me, in 2024. Have you always had this style and ease for teaching?
You are such a great teacher! I'm a beginner user, and you made everything make sense. Thank you!!!!
Been wanting to learn excel for a while now, and this helped me so much! He made so much more sense than my own teacher did! 🤣
😂😂 yes pliz,my teacher was also speaking jibarish
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.
A lot many people know how to work on excel , but it takes more to teach well. You teach well.Appreciate it.Thank you.
You're a life saver. I been wanting to learn excel for some time and I finally discovered you I'm positive before this year ends I would've been on a different level. #Beginners
So happy to discover this UA-cam Channel 2 days ago. I have really enjoyed everything. THANK YOU.
Thank you for the video! I took an online Excel class at the local community college in 2020. It was using a printed textbook, which was extremely tedious and very difficult to understand. The print was so small and I had no teacher to answer questions! You just taught me in this video what a whole semester in college couldn't make clear to me! I will definitely continue with your videos! FIVE STARS!
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
Thank you so much Sir! you've explained it to the simplest way. Learned a lot and looking forwards to the next levels .
thankyou..
from 0 knowledge and now i found myself enjoying on how to learn and use Microsoft Excel, really appreciate it.. definitely will watch your other videos!
Godbless
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!
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 was searching to buy a book to refresh my excel skills and thought, perhaps UA-cam. So glad I did, you are an amazing teacher! Well explained and to the point with examples. I am excited to get back to it and create some spreadsheets. Thank you for your time and skills.
That's me, rriiiight there!😊
im super excited listening to this, have learnt a lot and looking for more. thanks.
I watched the video till the end , never getting bored at all , you’re amazing .♥️ now I am getting to watch the Level 2 tutorial
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 ua-cam.com/video/4neuWYsYAoc/v-deo.html
This was amazing , are you able to demonstrate how to use conditional formatting please ?
I got the job as Admin. And i have to learn the excel. So here i am. Thanks it's so much helpful. 😁
OMG where were you when I was in college? This would have saved me so much headache!! You have made my day. You have made steps so simple that I can understand it. For the longest time I thought I was dumb and wouldn't be able to get it but I'm so excited to learn Excel and can't wait to put this on my resume!
I thoroughly enjoyed this tutorial. Taking breaks and coming back after each section made this more engraved into my memory.
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!!!
ua-cam.com/channels/0PcCP6UE5rPLMIlPQ5Xwlg.html
have not used Excel in almost 10 years this was a huge help
Probably one of the most unselfish video of all time. This guy is awesome. Thank you so much Sir.
Thank you so much. You're the first person to actually explain MS excel in such a way that I can comprehend what you're teaching through my own way of understanding, if that makes sense. I enjoyed it and you made it easy. 👍
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!
Just wanted to quickly say this video was incredibly helpful! Thank you!
So well delivered. Easy to understand. 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.
Thank you so much for this. I enjoyed excel when I initially learned about it, but it has been a long time since I have actually used it. If anything I learned more dedicating time to watching this than I did sitting through classes. Best part about videos is you can pause and rewind :) I got 2 pages of solid notes out of this. Liked and subscribed.
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 can’t believe this detail course on Excel is Free😮. Thanks a lot. I will watch the whole series.
Just watching this now...learning Excel at a late stage, and so happy I found these videos. Well-explained and uncomplicated. Thank you!
@Jesus is coming. Read the Gospel. Dude stop.
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..
Absolutely incredible information. You certainly know how to explain this so well, thank you.
Wow! Man you are a gifted teacher. God bless you for giving this premium content for free.