Excel 2021 Beginner Tutorial

Excel 2021 Beginner Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3xZKDiw
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Start Screen 2:35
Excel Interface 7:03
Zooming, Navigating, and Shortcuts 13:31
Performing Excel Calculations 28:19
Simple Excel Functions 36:53
ABS, REF, and AutoFill Functions 42:25
Checking Compatibility 47:51
Inserting, Moving, and Cutting 49:29
Cell Styles 54:30
Themes 59:41
Showing and Hiding Worksheets 1:03:16
Grouping Worksheets 1:06:19
Freeze Panes 1:08:45
Custom Views 1:14:15
Saving Templates 1:16:09
Spell Check 1:18:36
Print Preview 1:20:09
Conclusion 1:23:17
#excel #excel2021 #exceltutorial
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@amirrezaax22]

Bro.. we spent a whole semester in University learning what could have been thought in 1.5 hours. Thanks a ton Faz!

[@LearnitTraining]

Happy to help!

[@seglaw7819]

I swear to you ...jezz men

[@ahmednavivwala1707]

2:45

[@andyfernandez9599]

I purchased a beginners course online and quite frankly it was too thorough. I just needed the basics (functions that are most often used) so I could practice and learn quickly. This video has been a godsend. I knew nothing, I mean absolutely nothing about Excel and this video has changed that. I learned and retained (the most important thing) more in 90 minutes than I did in 20 hours with that other course. I am unemployed and I am just trying to improve my skill set. Thank you, Learnit Training!

[@LearnitTraining]

You are very welcome! We are glad you learned so much!

[@Joy3LastNames]

I have been laid off since the Pandemic. I am watching as a refresher. I have to take tests all the time before job interviews. I hate those tests. Thanks for making this available.

[@LearnitTraining]

You are welcome! Good luck on the tests, you can also practice on our exams at www.learnitanytime.com

[@ahmednavivwala1707]

@@LearnitTraining 47:18

[@victoromokide]

This is absolutely precise... it's faster for people with a little experience though. But yeah, great work Faz! My favorite feature is definitely ability to save templates and customize them... Just fantastic!

[@syedimad4999]

I would like to express my gratitude to Faz. While I have encountered numerous courses on KZbin, learning Excel from your channel has truly been transformative for me. To be completely honest, this is the first course I've engaged with consistently, without any procrastination. Thank you once again for this excellent course :)

[@courtneyskeels3726]

This is pure gold. I need to cover excel for my job and I feel so lucky to have found this channel. The slow but steady pace at which you cover material makes it much easier to comprehend.

[@LearnitTraining]

Welcome aboard!

[@edreesalimy5166]

wonderful lectures, learnt a lot. In addition, my favorite feature was pane freezing.

[@LearnitTraining]

Glad you like them!

[@kathleenbrown1453]

My favorite aspect of this course is your clarity of communication, Faz. Thank you.

[@LearnitTraining]

Happy to hear that!

[@franciselcano7668]

To be perfectly honest, this is one hell of a course. Although I dabbled in Excel before, there are some new things I learned in this video. It was concise, very hands-on, and Faz did a good job in explaining the features. Awesome work!

[@LearnitTraining]

Thank you for watching!

[@onesandzeroes]

Agreed. But if you sift out the waffle, it might be half an hour long max :)

[@ahmednavivwala1707]

@@onesandzeroes 2:57

[@ruedizzle317]

Man, you're good. This was really easy to follow. I have been watching tutorial on excel for months and just wasn't able to fully get it. I feel like the pacing on these videos are spot on, the scenarios and examples everything fit so perfectly. I suggest anyone watching should follow along with the videos for best results. I'm so happy right now, you have no idea. Thanks man.

[@LearnitTraining]

Great to hear!

[@ahmednavivwala1707]

@@LearnitTraining 46:25

[@paularitztabinas909]

Thank you so much for this. What I enjoyed the most is that you created a story teaching excel. Usually, I get bored learning excel if it's being taught like a manual, but since you incorporated this with a story, it makes me enjoy it.

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 46:36

[@user-oz3bd8zb5n]

Faz you have done a phenomenal job with this tutorial! Very well developed and incredibly user friendly. Thank you.

[@LearnitTraining]

Thank you for the kind words!

[@queenrahma6373]

I definitely enjoyed this course and my favourite two features was Auto fill and the Savin options. Thanks karim for putting together this course for us 😊

[@LearnitTraining]

Glad you enjoyed it!

[@ahmednavivwala1707]

@@LearnitTraining 46:09

[@RogerClubv]

Though I didn't learn anything new in the beginner tutorial, I thought it was done incredibly well. I watched the entire video and thought it was possibly one of the best tutorials I have come across on KZbin. Thank you so much. I can't wait to watch the rest of the course on Excel. I rate your content 5 Stars!!!

[@LearnitTraining]

Glad you enjoyed it!

[@suzieogeto6319]

Best Excel tutorial, very detailed and simple to understand. Thank you!

[@LearnitTraining]

You're very welcome!

[@user-uc2tr6bd8n]

This video is super clear. Thank for the video. You are a genius you explain it clear even someone who is not easy to understand things you made it clear to the least person

[@LearnitTraining]

You're very welcome!

[@PortiaKhwekhwe2]

Whaw 👍👏This is amazing, not rushed and very easy to understand. Keep it up !!

[@LearnitTraining]

Thank you! 😃

[@nandishns5021]

Great explanation!! I felt I learnt something great as a beginner in Excel now. well, I am looking forward to going further and making foundations to learn Data Analytics in the future.

[@colleenbarrette]

initially discovered the Quick Access Toolbar using your method, but saw it when playing with the Ribbon display playing around. Great presentation, clear and concise.

[@LearnitTraining]

Glad it helped!

[@ahmednavivwala1707]

@@LearnitTraining 47:00

[@guntherpleml4968]

Fantastic course for a beginner. I really enjoyed the course. I loved the way you gave us some time to absorb the material . Thanks Karim for a great job.

[@LearnitTraining]

You are very welcome! We are glad you enjoyed the course!

[@ahmednavivwala1707]

@@LearnitTraining 46:17

[@ramchandra1814]

Thank you for sharing this wonderful course! Loved it..

[@LearnitTraining]

You are so welcome!

[@AdesijiDareYomi]

This video has really been helpful. It's awesome.

[@LearnitTraining]

Thanks!

[@mellahsara5531]

WAW amazing! I've just discovered your channel. Thank you so much. It's really helpful

[@LearnitTraining]

You're so welcome!

[@Blinklift]

Good work.. Easy to learn with you

[@LearnitTraining]

Glad to hear that!

[@PeterlyMerlus]

Amazing course! Very detailed and easy to follow. Thank you so much.

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 46:45

[@IonutPop9]

Good Job Man ... Thank you !!

[@LearnitTraining]

You're welcome!

[@lucaslegz]

Love Mr Karin’s voice and training.

[@LearnitTraining]

We will let him know!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@KC-nh2he]

Fantastic training!! Your voice is so soothing and encouraging. Thank you

[@LearnitTraining]

Thank you for watching!

[@ahmednavivwala1707]

@@LearnitTraining 57:19

[@axelalejandrocruzgalvan7170]

Great video!!! Helped me a lot. Thanks buddy.

[@LearnitTraining]

No problem 👍

[@user-bz8ol7ss6b]

Excellent video, beautiful professional voice (even though the slow speech made me feel like I want to sleep) the value in this first beginner video is awesome. Thank you a lot Faz

[@LearnitTraining]

Glad you enjoyed it!

[@bud5977]

Thanks a lot for this video. Very useful!

[@LearnitTraining]

You are very welcome!

[@mariagambuti8787]

Awesome video! SAving templates and grouping sheets rock!!

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 51:09

[@nathanielbalmes6597]

Thank you, Faz! I learned a lot from this course.

[@LearnitTraining]

Glad it was helpful!

[@ahmednavivwala1707]

@@LearnitTraining 50:26

[@Petershd138]

I Like the way she's talking. Very smooth, relaxing and enjoyable

[@LearnitTraining]

😊 thank you

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@MuhammadJamalAsadi-rv3od]

Brother For men we use HE not SHE

[@khalilgujjar92]

Sir I really appreciate your lecture and I learned a lot from it. Thank A ton to you. May God bless you and your loved ones.

[@LearnitTraining]

Thank you!

[@dushimiyimanajeanbaptiste2706]

Thank you Faz, This is a very interesting and important Excel tutorial for beginners. I learn a lot from this

[@LearnitTraining]

Glad it was helpful!

[@ginabarrell2155]

Fantastic course...was easy to follow and understand. Thank you!

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 47:06

[@mylibrary8315]

THANKS FOR THIS GREAT CLASS.

[@LearnitTraining]

You're very welcome!

[@stathis108]

Thank you for your video! Much appreciated!!!🙂

[@LearnitTraining]

You are so welcome!

[@ahmednavivwala1707]

@@LearnitTraining 57:09

[@MohammadAli67333]

Never learned these things in 4 years of BS(IT). Thanks, FAZ JAN

[@LearnitTraining]

You are very welcome!

[@rosemontfleury9158]

Great tutorial

[@LearnitTraining]

Thank you! Cheers!

[@mustafaibrahimi7715]

Thanks bro, It was very interesting and your explanation methodology was great! very clean and simple.

[@LearnitTraining]

You're welcome!

[@DareDreamTv-gr6rb]

Thank you so much I want to be data analyst that's why I'm learning excel and I hope to master Excel ❤

[@IdisWaidis]

Wonderful tutorial, definitely gonna watch the rest of the excel tutorial videos. Thanks a lot Faz.

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 50:44

[@akashtewari2607]

Thanks a lot... I like the formula adding part...

[@LearnitTraining]

You are welcome 😊

[@faroukyt1104]

Thank you brother ❤

[@LearnitTraining]

You are welcome!

[@yaniranazario5098]

you are an amazing instructor. I understood everything you were explaining. Your voice is smooth and pleasant. I lost my fear of Excel.

[@LearnitTraining]

Wow, thank you!

[@ruthdanaiahchen9474]

I enjoyed the course! Thank u so much for sharing this for us! ;) definitely worth of our time for learning the excel skills!

[@LearnitTraining]

Glad you enjoyed it!

[@ahmednavivwala1707]

@@LearnitTraining 47:11

[@maimisa]

Great Presentation...

[@LearnitTraining]

Glad you liked it!

[@Balmistic]

THANK YOU!

[@LearnitTraining]

You are welcome!

[@user-pn1zg4ey5p]

Thanks for this video man

[@LearnitTraining]

No problem!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:54

[@lockheedmartin3275]

huge thanks to you man! thank you very much. love you from Azerbaijan!

[@LearnitTraining]

You're welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@jomarpatawaran1599]

Thanks a lot !!!!

[@LearnitTraining]

You are welcome!

[@dav.naturalbeautychannel7720]

You are amazing. Thank you

[@LearnitTraining]

You are welcome!

[@aneessarachandran2519]

GREAT WAY TO EXPLAIN

[@LearnitTraining]

Thanks!

[@EshaqSafi]

thank you 🤗

[@LearnitTraining]

You're welcome 😊

[@johnravi1683]

Hi Faz, It was a great watch! I have been using Google Sheets for a long time because it works perfectly with the rest of the tools I use, but it lacks some features, and this is why I have switched to Excel for a few projects. I think both of these tools are fairly similar, but I have been thinking about learning more about Excel so I can use it more productively. Thanks a lot for sharing this video, I learned several things, and I hope you do one for some advanced users as well, I will definitely check that one out.

[@rizkyaprianto3992]

thankyou very much

[@LearnitTraining]

You are most welcome

[@subratapaul3532]

This is Great!!!!

[@LearnitTraining]

Thanks!

[@prathimag5423]

Well articulated with right pace & navigation . My fav part is Custom views. Thanks a lot!

[@LearnitTraining]

You're most welcome!

[@ahmednavivwala1707]

@@LearnitTraining 52:56

[@4nxy]

9:53 - Quick Access 20:38 - Shortcuts (CTRL SHFT ARROW ... CTRL SHFT 4 ... ALT + =) 46:05 - Absolute Reference 1:07:00 - Grouping Sheets 1:14:20 - Custom Views

[@LearnitTraining]

Thanks for the bookmarks!

[@ahmednavivwala1707]

@@LearnitTraining 1:06:52

[@eibnakaesh325]

thank you so much sir to teach as soo much

[@LearnitTraining]

You are most welcome

[@mnurullahh]

The favourite feature is definitely the Freeze Panes, it can be really useful when analysing data.

[@kingstontheone]

This is verry helpful, you made my work easier by jsut showing me you could make and pin excel templates. Real office hero!

[@LearnitTraining]

We are glad we were able to help!

[@ahmednavivwala1707]

@@LearnitTraining 56:27

[@user-fr1dg7zl1r]

wow, personally it was really amazing one and half hour to learn excel for beginners. Thanks brother

[@LearnitTraining]

You are most welcome

[@lokeshmadiga6215]

Thank you Faz !! I learned Freeze Pans Saving as template Alt Shortcuts

[@LearnitTraining]

Happy to help!

[@ahmednavivwala1707]

@@LearnitTraining 58:19

[@mennaehab8185]

Thanks!

[@LearnitTraining]

You are welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:09:58

[@phuonglenguyen3137]

Used Excel many years but only just discover(Absolute Referencing + the Auto Date) useful. Thank you. :)

[@LearnitTraining]

You are very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 53:19

[@laurevanloo3899]

e cam on c rat nhieu a bai giang rat chi tiet va de hieu a mong chi luon co nhieu suc khoe de co the tiep tuc ra nhieu video hap dan a

[@LearnitTraining]

Không có chi! Cảm ơn vì đã xem!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@urazovakz]

Thank you Faz Karim

[@LearnitTraining]

You are welcome!

[@bangetlyrics5041]

Thanks for the great video! My favorite feature is Freeze Panes.

[@LearnitTraining]

You are welcome! Thank you so much for watching!

[@ahmednavivwala1707]

@@LearnitTraining 55:43

[@alejandrorempillo1251]

Thank you Faz!

[@LearnitTraining]

You are welcome!

[@sylvianjeri1427]

This is perfect

[@LearnitTraining]

Thank you!

[@villa_fan8882]

Great video :) Just what I needed. I am learning on a Mac, so there where was a little bit of finding stuff! Having said that, it was very transferrable and not as bad as I thought it was going to be! Thanks for uploading this, I use Numbers (Apple's version of Excel) but I need to share things with colleagues and it was pain everyone else using excel. I thought it would be worse on a Mac but I am pleasantly surprised at how fast it is on a Mac. Now going to do the advance course and then I should be good to go!

[@LearnitTraining]

We will be adding Excel for Mac hopefully later this year!

[@ahmednavivwala1707]

@@LearnitTraining 46:53

[@juanvaldes7873]

Faz, I appreciate your unique teaching style; I was able to clearly understand and retain the information provided. I know this video is roughly a year old, but I'd still like to comment and say THANKS! (By the way, my favorite part was the formula section. I do believe this is the heart of Excel.) P.S. It'd be cool to provide a project challenge at the end of every course for a more formal learning feel! :)

[@LearnitTraining]

Glad it was helpful!

[@contehalimamy4872]

Thanks very much we really appreciate your effort

[@LearnitTraining]

Our pleasure!

[@ahmednavivwala1707]

@@LearnitTraining 58:40

[@gaamaofficial2468]

wow Karim you expanded me widely when i faded up and thought ms not for you i have really really enjoyed all your videos Ms word, Excel, PP thanks alot🥰

[@LearnitTraining]

I'm so glad!

[@ahmednavivwala1707]

@@LearnitTraining 55:02

[@vickihale4080]

great class - thanks

[@LearnitTraining]

Glad you enjoyed it!

[@ahmednavivwala1707]

@@LearnitTraining 58:03

[@suryateja1290]

thank you so much sir . this helped me a lot

[@LearnitTraining]

Most welcome!

[@ahmednavivwala1707]

@@LearnitTraining 57:32

[@johnadam422]

Thanks a lot for your efforts

[@LearnitTraining]

Our pleasure!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:07

[@PampostReturning]

Thank you so much!.

[@LearnitTraining]

You're welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:04:00

[@catfordkat]

Brilliant beginner tutorial I learned a lot. Thanks. Just on 1:07:47, I grouped this and then ungrouped it as you did and it shows the word internal on both sheets, but only on the second sheet without the formatting?

[@thousandsunny2572]

Great help! Thanks

[@LearnitTraining]

You are welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:16

[@phamnguyenthephong]

Cảm ơn bạn từ Việt Nam

[@udcentrepreneur2566]

Thank you Faz for this tutorial. I have searched a lot on KZbin to find you. However, I have possibly a very naïve question. Having the Microsoft release 2021 Excel version, why bother on learning older versions such as 2019, 2016, 2013 and 2010? thank you

[@LearnitTraining]

We always recommend watching the training video that aligns with the version of Excel you use most. For lots of people that can be older versions they use at their office.

[@ugandanfinesse8543]

You are born to teach mate. ❤

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 52:46

[@hamzaal-laham9863]

شكرا لك , تعلمت الكثير منك

[@ahmednavivwala1707]

53:30

[@AnupXlup]

Very Great Work....! Big Thank you... Form India

[@LearnitTraining]

Our pleasure!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@gold_friday]

Thank you.. I just finish this section.

[@LearnitTraining]

Great job!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@mohammedjamal7598]

thank you ... great guy

[@LearnitTraining]

You're welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:04:52

[@tszamriabubakar3008]

GREAT

[@LearnitTraining]

Thanks!

[@user-ez5vx8cc7w]

thank you so much ❤❤

[@LearnitTraining]

You're welcome 😊

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@tonimaschler920]

Thank you so much for this course. It was very informative. Can you include a link to the Intermediate class? For some reason I see beginning and advanced Excel 2021 but not intermediate.

[@LearnitTraining]

The Advanced class is the next video. Sorry for the confusing titling. We have since fixed that.

[@tchkbty7489]

Gold Mine in a word❤

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@mosesvandy1519]

i was a good time spent thanks

[@LearnitTraining]

You are welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:11:21

[@lucaslegz]

Good Morning and thank you

[@LearnitTraining]

Good morning!

[@ahmednavivwala1707]

@@LearnitTraining 1:11:49

[@briansatria5946]

this guy is bob ross of excel training videos, thanks man I learned a lot!

[@LearnitTraining]

Wow, thanks!

[@ahmednavivwala1707]

@@LearnitTraining 53:41

[@dimitrie17]

thank you!

[@ahmednavivwala1707]

1:03:39

[@khakimov_18]

thanks for all

[@LearnitTraining]

Most welcome

[@uziel1221]

Great Course

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 1:04:43