Excel 2021 Beginner Tutorial

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

[@PriyankaTamta-zn9dw]

0:59 ❤

[@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!

[@Joywith3LastNames]

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

[@RenMiyazaki-n2i]

I use LTSC standard edition, its like a mix of 2019 and 2021. Still my brother has been very helpful

[@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 :)

[@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!

[@ReadAndBeKind]

Thank you so much brother. I tried watching a few excel videos before this never successfully able to complete any of those. You are great. You have a gift. Thank you again!!!

[@LearnitTraining]

You are most welcome

[@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!

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

[@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!

[@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!

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

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

[@jesusreyes4762]

I watched your training video and it was great. I learned a lot. I fully recommend this video to anyone who wants to learn Excel. Thank you for making this video.

[@LearnitTraining]

Glad it was helpful!

[@ContehAlimamy-p1k]

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!

[@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!

[@LearnitTraining]

Thank you for watching!

[@disturbiant]

Thank you for this great refresher in excel as I used excel daily it Just made it way easier ❤

[@LearnitTraining]

You're very welcome!

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

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

[@LearnitTraining]

You will be there soon!

[@mnurullahh]

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

[@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!

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

[@SalamatJoldasbaev-z1v]

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

[@LearnitTraining]

You are most welcome

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

[@Jrv001]

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!

[@MohammadAli67333]

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

[@LearnitTraining]

You are very welcome!

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

[@LearnitTraining]

Thank you for the kind words!

[@maimisa]

Great Presentation...

[@LearnitTraining]

Glad you liked it!

[@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!

[@IvonneNorman]

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!

[@AbdElRahmanAkram-g1z]

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!

[@pnwesterner6220]

You can use KZbin speed at 2x

[@aleagersalinas5113]

I learned a lot in just 1hr and 30min! Thank you, Faz!

[@LearnitTraining]

Glad it was helpful!

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

[@suzieogeto6319]

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

[@LearnitTraining]

You're very welcome!

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

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

[@lucaslegz]

Love Mr Karin’s voice and training.

[@LearnitTraining]

We will let him know!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@bymichaelcastro]

Muito bom. Obrigado! Sou do Brasil e entendi tudo perfeitamente.

[@LearnitTraining]

Você é muito bem-vindo!

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

[@reginauhio4529]

Bro been taking your Courses on Excel 2019... So far it's been resourceful. Please is it possible to have a video made on Data Analytics?

[@LearnitTraining]

Here is the video: kzbin.info/www/bejne/i5atiHanf96mgas

[@ahmednavivwala1707]

@@LearnitTraining 55:12

[@CristianoEditz77]

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

[@LearnitTraining]

You're welcome!

[@regfr14tqq]

I'm a beginner in learning excel and this course help me very much Thanks ❤

[@LearnitTraining]

You're very welcome!

[@AhmedGamal-mi1ns]

Thanks for the great lesson. I've used Excel a lot but there is always more to learn. Thanks, Karim. Thanks learnit.

[@LearnitTraining]

You are welcome!

[@ahmednavivwala1707]

@@LearnitTraining 54:02

[@udcentrepreneur]

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.

[@siddarthrajesh4825]

Thank You I just finished this beginner course 🥰

[@LearnitTraining]

You are welcome!

[@ahmednavivwala1707]

@@LearnitTraining 56:36

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

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

[@vlavoir]

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

[@LearnitTraining]

Wow, thanks!

[@ahmednavivwala1707]

@@LearnitTraining 53:41

[@karolinamorris8168]

Hello Faz, I enjoy your courses, so I decided to subscribe. The commercials are still running, so I wonder if I did something wrong?

[@LearnitTraining]

Hello Karolina! You can access the ad-free videos by going to our main channel page: www.youtube.com/@LearnitTraining Then click on the membership tab just to the right of the community tab. All the ad-free videos are there for you to view!

[@ahmednavivwala1707]

@@LearnitTraining 1:05:22

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

[@ramchandra1814]

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

[@LearnitTraining]

You are so welcome!

[@PortiaKhwekhwe2]

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

[@LearnitTraining]

Thank you! 😃

[@LeviLironB]

Good work.. Easy to learn with you

[@LearnitTraining]

Glad to hear that!

[@mellahsara5531]

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

[@LearnitTraining]

You're so welcome!

[@ximenaallen-j4i]

Thank you for sharing this wonderful course!

[@AdesijiDareYomi]

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

[@LearnitTraining]

Thanks!

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

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

[@ugandanfinesse8543]

You are born to teach mate. ❤

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 52:46

[@axelalejandrocruzgalvan7170]

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

[@LearnitTraining]

No problem 👍

[@nazimsalah8388]

Bro you are creative and beyond Normal

[@LearnitTraining]

Thank you for the kind words!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:23

[@rektison]

Ur voice is so relaxing

[@LearnitTraining]

Glad you think so!

[@KC-nh2he]

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

[@LearnitTraining]

Thank you for watching!

[@ahmednavivwala1707]

@@LearnitTraining 57: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

[@mrmerlus]

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

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 46:45

[@catboy721]

Faaaannnnn-tastic. Delivery, approach, content... spot on for everything. One note... when you address saving as a template, I noted that autosave was still on, so the data would've been lost from your original. Shouldn't you save as template first, then delete the data so that your original is preserved? Or turn off autosave, or save a copy prior to deletion? Thanks!!

[@LearnitTraining]

Great tip!

[@ahmednavivwala1707]

@@LearnitTraining 55:34

[@suryashree3003]

ARE EXCEL 2021TUTORIALS ENOUGH FOR THE PRESENT SCENARIO OR EVEN THE TUTORIALS OF 2019 ,2016 AND OTHER YEARS EXCEL TUTORIALS TO BE LEARNT AS WELL ??

[@LearnitTraining]

We always recommend watching the videos with the software versions you use most.

[@tchkbty7489]

Gold Mine in a word❤

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@mob-g5259]

Please do a video on After efffects too,beginner to expert👍👍

[@LearnitTraining]

Will do soon!

[@ahmednavivwala1707]

@@LearnitTraining 58:09

[@nathanielbalmes6597]

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

[@LearnitTraining]

Glad it was helpful!

[@ahmednavivwala1707]

@@LearnitTraining 50:26

[@bud5977]

Thanks a lot for this video. Very useful!

[@LearnitTraining]

You are very welcome!

[@akashtewari2607]

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

[@LearnitTraining]

You are welcome 😊

[@nhikilnash4447]

Appreciate you brother, amazing video.

[@LearnitTraining]

We appreciate that!

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

[@lokeshmadiga6215]

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

[@LearnitTraining]

Happy to help!

[@ahmednavivwala1707]

@@LearnitTraining 58:19

[@mylibrary8315]

THANKS FOR THIS GREAT CLASS.

[@LearnitTraining]

You're very welcome!

[@decebalusflorei6164]

Hello, does this 3 videos offer an in depth knowledge of excel or we should watch the 2019 training and then this 2021 one? Thanks.

[@LearnitTraining]

We always recommend using the version of Excel that you use most.

[@decebalusflorei6164]

@@LearnitTraining I have the 2021 ( bought it to take this course) so I will asume that all I need to know about excel is in this 2021 version videos. Thanks.

[@rosemontfleury9158]

Great tutorial

[@LearnitTraining]

Thank you! Cheers!

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

[@nurawario1235]

Wow thanks a million. Would you please consider making such for R ?

[@LearnitTraining]

We will look into it Nura!

[@nurawario1235]

Will appreciate big time, thanks

[@ahmednavivwala1707]

@@nurawario1235 1:00:16

[@dav.naturalbeautychannel7720]

You are amazing. Thank you

[@LearnitTraining]

You are welcome!

[@moneybag9520]

Will you be making a 2023 course aswell or this is valid for this year too?

[@LearnitTraining]

This was recorded using Excel 2021 and everything in the video is still valid today.

[@moneybag9520]

@@LearnitTraining thank you soo much for your response

[@ahmednavivwala1707]

@@moneybag9520 1:05:08

[@ابنالجراح-ل5و]

thank you for this great work 🌟⭐☀

[@LearnitTraining]

You are so welcome

[@mariagambuti8787]

Awesome video! SAving templates and grouping sheets rock!!

[@LearnitTraining]

Thanks!

[@ahmednavivwala1707]

@@LearnitTraining 51:09

[@TepieRyan]

Thanks for this video man

[@LearnitTraining]

No problem!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:54

[@ginabarrell2155]

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

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 47:06

[@gold_friday]

Thank you.. I just finish this section.

[@LearnitTraining]

Great job!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@AnupXlup]

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

[@LearnitTraining]

Our pleasure!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@stathis108]

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

[@LearnitTraining]

You are so welcome!

[@ahmednavivwala1707]

@@LearnitTraining 57:09

[@aneessarachandran2519]

GREAT WAY TO EXPLAIN

[@LearnitTraining]

Thanks!

[@IonutPop9]

Good Job Man ... Thank you !!

[@LearnitTraining]

You're welcome!

[@lockheedmartin3275]

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

[@LearnitTraining]

You're welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:03:02

[@VictimFrank]

I appreciated the breakdown of how to write out the IF function. Thank you!

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 53:03

[@Balmistic]

THANK YOU!

[@LearnitTraining]

You are welcome!

[@MarkFloyd7451]

I have Microsoft Office Home and Student 2016. I can't afford the subscription. Can one learn from this course using an older version of Excel (Excel 2016 in my case)?

[@LearnitTraining]

Here is Excel 2016: kzbin.info/www/bejne/qqbOamyJnMhpfNk

[@Mona-Ali.]

Great Course !

[@LearnitTraining]

Thanks!

[@ahmadayanah243]

thank you for being simple & clear, that's great. I'm using office 365 but grouping is not working good as what I write appear on the other sheet in same cell location but without formating (only words) ??

[@LearnitTraining]

Hello Ahmad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@suryapratapchauhan2506]

yeah same thing happened with me too. Only the word "internal" was their, but not the font,size and color.

[@lucaslegz]

Good Morning and thank you

[@LearnitTraining]

Good morning!

[@ahmednavivwala1707]

@@LearnitTraining 1:11:49