Microsoft Excel Beginner's Class - Master the Basics! 📊

No video

Microsoft Excel Beginner's Class - Master the Basics! 📊

Рет қаралды 171,031

Күн бұрын

Welcome to my Microsoft Excel Beginner's Class! Whether you're new to Excel or need a refresher, this video is your one-stop guide to mastering the fundamentals of one of the most powerful and widely used spreadsheet tools in the world.
Try this intermediate class next: • Microsoft Excel Interm...
Learn more about OneDrive: • How to use the NEW Mi...
📊 What You'll Learn:
0:00 Introduction: A brief overview of what this class will cover.
0:51 Opening Microsoft Excel: Getting started with Excel.
2:47 Creating a Blank Workbook: Learn how to start your Excel journey.
2:53 Basic Excel Terminology and Layout
5:14 Tabs, Ribbons, and Groups: Navigating the Excel interface.
6:52 Saving Your Workbook: Essential tips on saving your work.
8:22 Entering Column Headers
9:43 Formatting Columns and Rows: Adjusting widths and heights for better readability.
11:54 Formatting Text and Cells: Enhance the look of your data.
15:55 Using Cell Styles: Quick styling for efficient data presentation.
16:34 Text Wrapping and Merging Cells: Organize your data better.
19:39 Adding Dollar Symbols and Number Formatting: Essential for financial data.
21:03 Printing in Excel: Tips for perfect printouts.
22:31 Creating and Naming New Sheets: Organize your work effectively.
23:09 Creating Formulas with Cell References: Learn the basics of Excel formulas.
27:49 Absolute Cell Referencing: A key concept for formula accuracy.
30:18 Adding Functions (3 Ways): Enhance your data analysis skills.
34:57 Sorting and Filtering: Manage large sets of data easily.
37:40 Adding Charts: Visualize your data with charts.
44:02 Customizing Your Excel Ribbon: Personalize your Excel experience.
Whether for personal use, school, or your professional life, understanding Excel can significantly boost your productivity and analytical skills.
Excel Tutorials to help Beginners 🎥
How to Print in Excel - • How to Print in Micros...
Formulas and Functions in Excel - • How to use Formulas an...
Charting in Excel = • How to Create Charts a...
Absolute Cell Referencing - • Relative vs Absolute C...
Try the intermediate class - • Microsoft Excel Interm...
📥 Downloadable Resources: Don't forget to download the accompanying Excel workbook mentioned in the video for hands-on practice.
go.teachers.te...
👍 Like, Share, and Subscribe: If you find this video helpful, please like, share, and subscribe for more educational content. Your support helps us create more tutorials like this!
💬 Feedback/Questions?: Have questions or feedback? Leave a comment below, and we'll get back to you!
#ExcelTutorial #MicrosoftExcel #ExcelForBeginners #DataAnalysis #SpreadsheetSkills

Пікірлер: 147

@TeachersTech 8 ай бұрын

Try the next class where we will progress from the basics: kzfaq.info/get/bejne/obmBoLN8ktq7nqs.html

@natarajansundar3419 7 ай бұрын

Sorry Sir I am not getting access to this link

@user-he9ow9rz7w 6 ай бұрын

Berrygood. ☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆

@arleenfamorcan8609 6 ай бұрын

Hi sir jamie😊 ..Thankyou always for all your videos it helps me a lot to learn more about microsoft excel... i'm enjoying watching your video it's very cleared to me 😊❤

@rmsshorty564 7 ай бұрын

Lied on the job interview, they asked if I knew how to use excel and write formulas and everything, I said, "Of course I do its been a few years since ive used it in depth like that but i can get back on track quick" and I got the job I start in February so now I'm here 😂

@dereckpereira5726 7 ай бұрын

good luck😭😭 im in a similar situation

@xxLolingxx1 7 ай бұрын

Fucking legend

@Gannysews 6 ай бұрын

I’m here cus I’m afraid to lie. 😂

@nastyboywin 6 ай бұрын

Lol same, i start monday morning and i gotta cram all this in

@Skyline_r3496 6 ай бұрын

Lmfaoooo that’s why I’m here too

@RobinSkeene-yp6oc 14 күн бұрын

Your videos are so easy to understand and learn from scratch. I'm unemployed and actively applying for jobs. Most require Excel knowledge which I had zero until watching your videos, recently. I repeat videos, play around and take notes. Thank you very much for educating us people that are beginners. I will be watching more videos on a daily basis. Greatly appreciative!!!!!

@montanasxm 9 ай бұрын

Hi Sr. I just wanted to truly thank you for giving us some of your time to make this video. This is truly priceless information that you are genuinely sharing with us. I am one of your subscribers and I just wanted to thank you so much for your refresher simple way of how to explain everything 😉👍🏼

@TeachersTech 9 ай бұрын

You are very welcome! So nice of you.

@DanielSwagster 9 ай бұрын

I"ve been going through your beginner videos from 2021 and I have been loving them! Just saw that you uploaded on the recommended bar and now I'm watching this one too. Thank you for being such a great teacher, you have helped me out so much in such a little amount of time.

@TeachersTech 9 ай бұрын

You’re welcome and so glad you find the videos helpful.

@ladytruth303 9 ай бұрын

Same here.

@user-vk7lv2ss8e 5 ай бұрын

I have now taken both the beginner's and intermediate class in excel from you. You really explain it beautifully and I took several notes. Thank you so much for your efforts. Excellent!

@oneworldfamily 9 ай бұрын

A God-send! Thanks so much, Jamie. Perfect timing for my job interview, which includes an Excel assessment, tomorrow. Beautifully presented and very easily to follow along. Very best wishes to you. Adam

@TeachersTech 9 ай бұрын

Best of luck in your interview!

@startingoverbygrace 9 ай бұрын

This is awesome. Thank you so much. I've recently landed a WFH job and Microsoft Excel will be one of the software I will utilize for my workflow. I'm a bit rusty as I have not used Excel in quite some time. However, I'm a quick learner and can absorb information very easily. So, I've been bench-watching your previous videos which is extremely useful even now post 2 years. I really needed a refresher and a quick crash course-like overview and your videos have been a great asset thus far. I definitely look forward to this updated series/playlist/class. Blessings

@TeachersTech 9 ай бұрын

So happy to help! I will be following this up with an intermediate class as well.

@startingoverbygrace 9 ай бұрын

@@TeachersTech Awesome. Sounds great. Definitely will turn post notification on.

@iamlowfeh9792 9 ай бұрын

am from KENYA,and am really glad i found your channel cause it has been helpful alot.THANK YOU VERY MUCH SIR.

@jonathanwambua6477 5 ай бұрын

Am as well from Kenya and I can attest his tutorials are incredible

@Tristan-lm7ve 7 ай бұрын

Really needed this training especially I’m doing 50% desk job for my current role in Supply Chain. Thank you!!

@lcopeland3835 6 ай бұрын

Thank you so much for your video's. I can't say enough how much your teaching style is top notch. I've take many classes in college getting my bachelors where I wished I had had someone who explains things so clearly like you. I am a subscriber and a thumbs up follower forever. Thanks Jamie for all your time.

@TeachersTech 6 ай бұрын

You’re welcome and thank you! So happy you find my videos helpful.

@onealryan 9 ай бұрын

Thank you sooo much, sir Jamie!🫡

@lauradilaurenzio2098 8 ай бұрын

Your tutorials are easy to understand. Great lessons, Great teacher thanks so much!

@Richardclarkson7819 9 ай бұрын

Hi Jamie. i learned a few new things about excel from your video. Nicely done !!!

@TeachersTech 9 ай бұрын

Thank you 😊

@tameshim7110 28 күн бұрын

Thank you very very much Sir,really appereciate the way and methodology you use to show each and every step in different alternatives in a simplified manner.Thank you

@joti5606 8 ай бұрын

Hi jamie...I recently started watching your videos and still am.....your videos are so so helpful and had helped me so much that I cant even put it into words. I really appreciate your effort to provide this level of content for free. You have my respect man🙇‍♀️. And just one more thing, can you please tell which version of excel are you using? cuz in my version of excel I don't have some features and that's a bit of annoying.😒

@tshegofatsosilviamorentwa7114 5 ай бұрын

Thank you Sir. Came across your tutorial and I would love to say it saved me.

@albertoalamamoran6082 8 ай бұрын

simply great job from You Jamie. I am so thankful because of you is how Ihave learned a lot. God bless you indeed. Regards from Trujillo- Perú.

@TeachersTech 8 ай бұрын

Awesome! Thank you!

@ladytruth303 9 ай бұрын

You are an amazing teacher. Thank you very much.

@TeachersTech 9 ай бұрын

You’re welcome!

@OmANnIe 9 ай бұрын

This is SOOO extremely helpful! Thank you!

@TeachersTech 9 ай бұрын

Glad it helped!

@neshas.4663 9 ай бұрын

Thank you for all that you do!!

@TeachersTech 9 ай бұрын

You are so welcome

@elena911000 3 ай бұрын

Excellent class, and easy to follow. Thank you! The only thing that I couldn't get it right was the series names, I just got the titles: series1, series 2, etc. instead of the real titles: world wide gross/ domestic gross etc.

@ilahagulieva 3 ай бұрын

same issue but i somehow fixed it,delete the chart and do it again

@spottedasb 6 ай бұрын

Wow a fantastic review and very good detail Ty for doing these !!!

@oluwatobilobaaremo2186 4 ай бұрын

Thank you teacher’s tech, this is an amazing lecture.

@TeachersTech 4 ай бұрын

You're very welcome!

@alessandrocolaiacovo4132 6 ай бұрын

Thank you man, that was very clear and helpful.

@onealryan 9 ай бұрын

Thank you so much to you, sir Jamie!

@TeachersTech 9 ай бұрын

You’re welcome!

@42ronty 9 ай бұрын

Hi there. Is this an updated addition to your existing "Microsoft Excel Tutorial - Beginners Part 1" or entirely new series. Will appreciate some clarification. Thanks

@TeachersTech 9 ай бұрын

Very similar to Part 1. Just updating the tutorial with the newer version of Excel.

@42ronty 9 ай бұрын

Thank you for the prompt response. Looking forward to this@@TeachersTech

@clairenubla9870 9 ай бұрын

Thank you for making this video....I already forgotten how to use my excel 😅 but after through watching you video, I get to remember the basic excel l...more videos on this sir 😊

@TeachersTech 9 ай бұрын

So glad you found it helpful.

@ayahkawaiitv4138 7 күн бұрын

Very informative ❤

@user-kl9dw7db7e 16 күн бұрын

You teaching is simply,I like it 😅

@TeachersTech 16 күн бұрын

Thank you! 😃

@user-us1qb6gf7f 8 ай бұрын

Thanks so much coz this video has helped me a lot....All this time I was scared to use or even to open a Microsoft Excel because things felt too too hard....Due to this video it has solved my fear...Again thank you so so much .

@TeachersTech 8 ай бұрын

You’re welcome! So happy I could help.

@Anuoluwapo70X7 7 ай бұрын

Thank you Sir ❤ much appreciated ❤

@TeachersTech 7 ай бұрын

Welcome!

@ecobb4344 9 ай бұрын

Great videos‼️ Thank you 🙏🏽❤️

@user-en6cg8gm7j 6 ай бұрын

Excellent training session and facilitation! Thank you.

@ioniccrystal9999 7 ай бұрын

Thank you, you are the best Teacher, you help me a lot

@harrymulavu6898 9 ай бұрын

This has been helpful thanks 🙏

@TeachersTech 9 ай бұрын

Thank you 😊

@donaldromine5950 9 ай бұрын

Great tutorial! You're a very good teacher. Thanks.

@mariaabijor8073 3 ай бұрын

Thanks so much for this tutorial...I have learnt a lot from this nd it has really helped my learning process

@devanshgupta8417 7 ай бұрын

I am not able to copy formulas down through dragging down or double click. Either way its not working pls help

@sudheerbabu9987 Ай бұрын

Excellent tutorial

@awuorijullyanne4792 6 ай бұрын

Thank you for sharing this video.

@daisuke1320 8 ай бұрын

At last. .latest tutorial. Thank u

@JamesmayahSenesie 4 ай бұрын

Thank you so much your videos are so helpful

@thohuynhmos 7 ай бұрын

Thanks a lot :) Your videos are so helpful to me

@TeachersTech 7 ай бұрын

You are welcome!

@BashiratIshola 5 ай бұрын

Hi sir,I just want to say thank you so muchhhhhh for 😊making this easy ❤

@dina5604 6 ай бұрын

Thank you,, I really need this!

@BPMusic27 6 ай бұрын

Thank You So Much for your video's. I always watch ur video. i like your share excel.

@anyqdarwishz7398 Ай бұрын

Thank you Sir.

@TeachersTech Ай бұрын

You are most welcome

@sehajkahlon4432 5 ай бұрын

Thank you Sir.❣

@JrKite-xc1fi Ай бұрын

Do you have the 'base' files available so I can make the changes as you make the changes so it's more hands on for me? For example, the first workbook has the changes already made with the data you are working with, and it would be great to watch your video and be able to make the changes to mimic your changes.

@kkartha 2 ай бұрын

Good Teacher 👍

@manishamanchanda1111 7 ай бұрын

Thanku so much 🙏🙏✨

@TeachersTech 7 ай бұрын

You're welcome! I'm glad I could help.

@manishamanchanda1111 7 ай бұрын

@@TeachersTech God bless u ✨

@amirhoseinkargar3733 23 күн бұрын

i enjoyed this tutorial

@freedom888888 9 ай бұрын

Great video

@TeachersTech 9 ай бұрын

Thanks 🙏

@estherjacome2059 4 ай бұрын

thank so much, I learn so much

@taniaperea5678 2 ай бұрын

HI there. How were you able to bypass the ability to edit the excel data sheet? I cant, I am stuck and I need to be able to do this in order for me to learn and move forward. Can you help me Please?

@RussMcCurdy-bh1yw 3 ай бұрын

Download the sheet in the description??? Where is that?

@raho24781 6 ай бұрын

O by the way my name is Michael and Thank you Sir this is Great and the Hours are flying by

@robertrydlewski9538 9 ай бұрын

Thanks

@TeachersTech 9 ай бұрын

Welcome

@arviprayagraj2240 9 ай бұрын

Love from India🇮🇳

@2guysperth Ай бұрын

Valeu!

@sharonkane3031 4 ай бұрын

How do you enter in a sequence of dates in one cell. For example January 5-10, 2024 or 1/5-10/2024. Thanks. Also, if I need to sort such info how would that be done.

@bettycordova1068 9 ай бұрын

your the greatest. thanks you for every video...💯💕💕

@raho24781 6 ай бұрын

Thank You For Taking your time and putting these up my work uses these all day and Everyday I work for the State ,and a Friend and Coworker will give me a shot at something new ,and i pray i can keep up i have learned a lot with tis first one well actually im only half way thru it ,one thing about Downloading Note Book ,i don't know what ya mean ,my State Laptop has all of it already Installed ,But i had to write in or type in all the list and Costs ,the only one so far that i cant get is Top gun cause of the word Text But i;ll get a clear view and get back to it

@vinovakumarrai8086 8 ай бұрын

Thanks sir 🙏 please upload advance Excel also with practical

@omneianabil3622 8 ай бұрын

thank you

@whoatethechocolate Ай бұрын

Argh, I did the download but I can't figure out how to get out of view only mode to do any of the changes you're showing us. What am I doing wrong, please?

@artsymiia 8 ай бұрын

Subscribed👍

@lakshmipatel4805 9 ай бұрын

very helpful but need more guidance on functions please,thanks

@TeachersTech 9 ай бұрын

I’ll make another video specifically on that!

@kharahbah3287 8 ай бұрын

Thank you for sharing but please at times i cannot see whats written in the excel sheet clearly please can you make them more visible to the screen by may be zooming ,THANKS A LOT

@user-jz7dn5pz1u 6 ай бұрын

Great video so far! How do I download the work sheets so that the data fills in?

@pialhasan4114 7 ай бұрын

Best

@nydiarolon1486 8 ай бұрын

Hi, I need to learn for be a Line Leader in my job!!! 😊so is already in my computer or I have to put on it

@kathleendasilva9382 7 ай бұрын

I am looking for a tutorial on taking income and expenses from the last year and create a budget worksheet on excel.

@taniaperea5678 2 ай бұрын

I am not able to edit the download data sheet, can anyone help me?

@hmcsr Ай бұрын

How to print your work to the right sheet?

@excxmoody 8 ай бұрын

Is there a way to name each sheet in a manner similar to for example when adding dates...one can drag down ultimately allowing the dates to appear per however many cells. Going through individually...while possible, extremely time consuming.

@fallonrappaport5270 5 ай бұрын

How do I acces the workbook?

@arviprayagraj2240 9 ай бұрын

Sir please make playlist beginner to advance

@user-kg1vc7yo6s 6 ай бұрын

how do I download the sheet down below in the description....

@user-it1dh2pf5f 9 ай бұрын

Can you also make excel videos for iPad too? :)

@shawncurtis8061 5 ай бұрын

🙏

@user-sy7iq4hh1v 9 ай бұрын

very new to excel...but cant figure out where to download the work book so i can follow along

@TeachersTech 9 ай бұрын

Here you go go.teachers.tech/Excel_Beginners_Class

@user-ue3os3rb7t 8 ай бұрын

❤❤❤❤❤

@princesssamsonaniyangha7694 6 ай бұрын

How can I save this

@user-gl5qb5zn8u 6 ай бұрын

What year Microsoft office are you using, because its different from mine. Though am using 2010 Microsoft excel. 😂😂😂

@NepalivlogSB 9 ай бұрын

I don't know how to ask this question 😢 it's like how can we link one Excel sheet to another one for example one sheets have data as closing shift and I want same number in other one as opening data .

@TeachersTech 9 ай бұрын

I have a video on this, I’ll search for the link.

@startingoverbygrace 9 ай бұрын

Formula Method: Select the Cell: Click on the cell where you want the linked data to appear. Type Equal Sign: Start by typing the equal sign (=). Navigate to the Other Sheet: Click on the sheet tab at the bottom of Excel to navigate to the other sheet. Select the cell or range of cells you want to link. Complete the Formula: Press Enter, and the formula will be completed. Example: =Sheet2!A1 This formula links to cell A1 in Sheet2.

@NepalivlogSB 9 ай бұрын

@@TeachersTechthank you very much

@NepalivlogSB 9 ай бұрын

@@startingoverbygracethank you

@NepalivlogSB 9 ай бұрын

@@TeachersTech yes please it will be very helpful for me . I have learned excel from your channel (excel for the beginners) u can give me hint or title or I will search link myself ❤

@normaverduzco6078 7 ай бұрын

I dont see turorials in mine.

@normaverduzco6078 7 ай бұрын

Nevermind, I found it. I searched tutorials in the Template tab and found it. TY!😃

@theharlz88 4 ай бұрын

You go way too fast.....yes i know how to use pause....but to listen and follow and learn..........if i already knew how to do all this i wouldn't need to watch your videos...

@arviprayagraj2240 9 ай бұрын

I need excel dashboard

@IG-sb8mo 2 ай бұрын

To all of you that had to tell a little “Porky” to get the job and are now here cramming, Kudos to you all and good luck in your new careers, you were all ballsy enough to will your opportunity into a success and that alone is a win! excel is a skill set that is so useful to so many roles and can help open so many more doors, respect to you all!