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

Подписаться 949 тыс.

Просмотров 143 тыс.

50% 1

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.tech/Excel_Beginn...
👍 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

Опубликовано:

2 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 132

@TeachersTech 6 месяцев назад

Try the next class where we will progress from the basics: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kSQmPK-tWnw.html

@natarajansundar3419 4 месяца назад

Sorry Sir I am not getting access to this link

@user-he9ow9rz7w 4 месяца назад

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

@arleenfamorcan8609 3 месяца назад

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 4 месяца назад

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 4 месяца назад

good luck😭😭 im in a similar situation

@xxLolingxx1 4 месяца назад

Fucking legend

@alexwilliams2488 4 месяца назад

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

@nastyboywin 4 месяца назад

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

@Skyline_r3496 4 месяца назад

Lmfaoooo that’s why I’m here too

@montanasxm 6 месяцев назад

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 6 месяцев назад

You are very welcome! So nice of you.

@lauradilaurenzio2098 5 месяцев назад

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

@Tristan-lm7ve 4 месяца назад

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

@iamlowfeh9792 6 месяцев назад

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

@jonathanwambua6477 2 месяца назад

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

@DanielSwagster 6 месяцев назад

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 6 месяцев назад

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

@ladytruth303 6 месяцев назад

Same here.

@user-vk7lv2ss8e 3 месяца назад

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 6 месяцев назад

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 6 месяцев назад

Best of luck in your interview!

@donaldromine5950 6 месяцев назад

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

@tshegofatsosilviamorentwa7114 3 месяца назад

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

@onealryan 6 месяцев назад

Thank you sooo much, sir Jamie!🫡

@user-en6cg8gm7j 4 месяца назад

Excellent training session and facilitation! Thank you.

@alessandrocolaiacovo4132 3 месяца назад

Thank you man, that was very clear and helpful.

@ecobb4344 6 месяцев назад

Great videos‼️ Thank you 🙏🏽❤️

@spottedasb 3 месяца назад

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

@awuorijullyanne4792 4 месяца назад

Thank you for sharing this video.

@startingoverbygrace 6 месяцев назад

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 6 месяцев назад

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

@startingoverbygrace 6 месяцев назад

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

@bettycordova1068 6 месяцев назад

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

@OmANnIe 6 месяцев назад

This is SOOO extremely helpful! Thank you!

@TeachersTech 6 месяцев назад

Glad it helped!

@dina5604 4 месяца назад

Thank you,, I really need this!

@42ronty 6 месяцев назад

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 6 месяцев назад

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

@42ronty 6 месяцев назад

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

@Richardclarkson7819 6 месяцев назад

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

@TeachersTech 6 месяцев назад

Thank you 😊

@neshas.4663 6 месяцев назад

Thank you for all that you do!!

@TeachersTech 6 месяцев назад

You are so welcome

@elena911000 Месяц назад

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 16 дней назад

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

@lcopeland3835 4 месяца назад

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 4 месяца назад

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

@ladytruth303 6 месяцев назад

You are an amazing teacher. Thank you very much.

@TeachersTech 6 месяцев назад

You’re welcome!

@onealryan 6 месяцев назад

Thank you so much to you, sir Jamie!

@TeachersTech 6 месяцев назад

You’re welcome!

@daisuke1320 6 месяцев назад

At last. .latest tutorial. Thank u

@JamesmayahSenesie 2 месяца назад

Thank you so much your videos are so helpful

@oluwatobilobaaremo2186 2 месяца назад

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

@TeachersTech 2 месяца назад

You're very welcome!

@sehajkahlon4432 2 месяца назад

Thank you Sir.❣

@kkartha 13 дней назад

Good Teacher 👍

@estherjacome2059 Месяц назад

thank so much, I learn so much

@ioniccrystal9999 5 месяцев назад

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

@joti5606 5 месяцев назад

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.😒

@albertoalamamoran6082 6 месяцев назад

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 6 месяцев назад

Awesome! Thank you!

@BPMusic27 4 месяца назад

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

@Anuoluwapo70X7 4 месяца назад

Thank you Sir ❤ much appreciated ❤

@TeachersTech 4 месяца назад

Welcome!

@mariaabijor8073 Месяц назад

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

@thohuynhmos 4 месяца назад

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

@TeachersTech 4 месяца назад

You are welcome!

@harrymulavu6898 6 месяцев назад

This has been helpful thanks 🙏

@TeachersTech 6 месяцев назад

Thank you 😊

@omneianabil3622 6 месяцев назад

thank you

@freedom888888 6 месяцев назад

Great video

@TeachersTech 6 месяцев назад

Thanks 🙏

@arviprayagraj2240 6 месяцев назад

Love from India🇮🇳

@raho24781 4 месяца назад

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

@BashiratIshola 2 месяца назад

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

@clairenubla9870 6 месяцев назад

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 6 месяцев назад

So glad you found it helpful.

@manishamanchanda1111 4 месяца назад

Thanku so much 🙏🙏✨

@TeachersTech 4 месяца назад

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

@manishamanchanda1111 4 месяца назад

@@TeachersTech God bless u ✨

@user-us1qb6gf7f 5 месяцев назад

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 5 месяцев назад

You’re welcome! So happy I could help.

@user-jz7dn5pz1u 4 месяца назад

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

@artsymiia 5 месяцев назад

Subscribed👍

@robertrydlewski9538 6 месяцев назад

Thanks

@TeachersTech 6 месяцев назад

Welcome

@vinovakumarrai8086 5 месяцев назад

Thanks sir 🙏 please upload advance Excel also with practical

@nydiarolon1486 5 месяцев назад

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

@pialhasan4114 4 месяца назад

Best

@devanshgupta8417 5 месяцев назад

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

@raho24781 4 месяца назад

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

@excxmoody 6 месяцев назад

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.

@kharahbah3287 6 месяцев назад

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

@sharonkane3031 Месяц назад

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.

@lakshmipatel4805 6 месяцев назад

very helpful but need more guidance on functions please,thanks

@TeachersTech 6 месяцев назад

I’ll make another video specifically on that!

@RussMcCurdy-bh1yw Месяц назад

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

@user-it1dh2pf5f 6 месяцев назад

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

@kathleendasilva9382 5 месяцев назад

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

@user-ue3os3rb7t 5 месяцев назад

❤❤❤❤❤

@user-sy7iq4hh1v 6 месяцев назад

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

@TeachersTech 6 месяцев назад

Here you go go.teachers.tech/Excel_Beginners_Class

@user-kg1vc7yo6s 3 месяца назад

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

@fallonrappaport5270 3 месяца назад

How do I acces the workbook?

@arviprayagraj2240 6 месяцев назад

Sir please make playlist beginner to advance

@shawncurtis8061 2 месяца назад

🙏

@princesssamsonaniyangha7694 4 месяца назад

How can I save this

@NepalivlogSB 6 месяцев назад

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 6 месяцев назад

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

@startingoverbygrace 6 месяцев назад

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 6 месяцев назад

@@TeachersTechthank you very much

@NepalivlogSB 6 месяцев назад

@@startingoverbygracethank you

@NepalivlogSB 6 месяцев назад

@@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 ❤

@user-gl5qb5zn8u 4 месяца назад

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

@normaverduzco6078 4 месяца назад

I dont see turorials in mine.

@normaverduzco6078 4 месяца назад

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

@arviprayagraj2240 6 месяцев назад

I need excel dashboard

@theharlz88 Месяц назад

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...

@IG-sb8mo 3 дня назад

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!

@user-he9ow9rz7w 4 месяца назад

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