Excel 2021 Beginner Tutorial

Поділитися
Вставка
  • Опубліковано 2 січ 2025

КОМЕНТАРІ • 503

  • @amirrezaax22
    @amirrezaax22 Рік тому +131

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

  • @andyfernandez9599
    @andyfernandez9599 10 місяців тому +18

    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
      @LearnitTraining  10 місяців тому +4

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

  • @Joywith3LastNames
    @Joywith3LastNames 2 роки тому +18

    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
      @LearnitTraining  2 роки тому

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

    • @ahmednavivwala1707
      @ahmednavivwala1707 Рік тому

      @@LearnitTraining 47:18

  • @syedimad4999
    @syedimad4999 Рік тому +8

    I would like to express my gratitude to Faz. While I have encountered numerous courses on UA-cam, 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
    @courtneyskeels3726 Рік тому +6

    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.

  • @franciselcano7668
    @franciselcano7668 2 роки тому +47

    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!

  • @RenMiyazaki-n2i
    @RenMiyazaki-n2i Місяць тому +2

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

  • @kathleenbrown1453
    @kathleenbrown1453 11 місяців тому +3

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

  • @mamtasoni265
    @mamtasoni265 10 днів тому +2

    Thank you so much....great video🙏🏻

  • @ruedizzle317
    @ruedizzle317 Рік тому +5

    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.

  • @4nxy
    @4nxy Рік тому +17

    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

  • @edreesalimy5166
    @edreesalimy5166 9 місяців тому +6

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

  • @paularitztabinas909
    @paularitztabinas909 Рік тому +9

    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.

  • @RogerClubv
    @RogerClubv Рік тому +2

    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 UA-cam. Thank you so much. I can't wait to watch the rest of the course on Excel. I rate your content 5 Stars!!!

  • @ReadAndBeKind
    @ReadAndBeKind 3 місяці тому +1

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

  • @yaniranazario5098
    @yaniranazario5098 Рік тому +1

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

  • @jesusreyes4762
    @jesusreyes4762 7 місяців тому +1

    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.

  • @Petershd138
    @Petershd138 Рік тому +2

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

  • @suzieogeto6319
    @suzieogeto6319 11 місяців тому +2

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

  • @guntherpleml4968
    @guntherpleml4968 Рік тому +5

    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.

  • @IvonneNorman
    @IvonneNorman Рік тому +2

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

  • @lucaslegz
    @lucaslegz 2 роки тому +2

    Love Mr Karin’s voice and training.

  • @victoromokide
    @victoromokide 7 місяців тому +2

    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!

  • @ContehAlimamy-p1k
    @ContehAlimamy-p1k 10 місяців тому +3

    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

  • @aleagersalinas5113
    @aleagersalinas5113 6 місяців тому +1

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

  • @AbdElRahmanAkram-g1z
    @AbdElRahmanAkram-g1z 11 місяців тому +1

    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

  • @maimisa
    @maimisa 10 місяців тому +2

    Great Presentation...

  • @dushimiyimanajeanbaptiste2706
    @dushimiyimanajeanbaptiste2706 9 місяців тому +2

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

  • @Jrv001
    @Jrv001 Рік тому +2

    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! :)

  • @Mona-Ali.
    @Mona-Ali. 3 місяці тому

    Great Course !

  • @phuonglenguyen3137
    @phuonglenguyen3137 2 роки тому +3

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

  • @queenrahma6373
    @queenrahma6373 2 роки тому +12

    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 😊

  • @colleenbarrette
    @colleenbarrette 2 роки тому +5

    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.

  • @kingstontheone
    @kingstontheone Рік тому +1

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

  • @PortiaKhwekhwe2
    @PortiaKhwekhwe2 Рік тому +1

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

  • @khalilgujjar92
    @khalilgujjar92 Рік тому +1

    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.

  • @SalamatJoldasbaev-z1v
    @SalamatJoldasbaev-z1v 8 місяців тому +1

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

  • @gaamaofficial2468
    @gaamaofficial2468 Рік тому +2

    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🥰

  • @LastUncle
    @LastUncle Рік тому +1

    You are born to teach mate. ❤

  • @IdisWaidis
    @IdisWaidis Рік тому +1

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

  • @mellahsara5531
    @mellahsara5531 Рік тому +1

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

  • @KC-nh2he
    @KC-nh2he 2 роки тому +1

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

  • @tchkbty7489
    @tchkbty7489 Рік тому +2

    Gold Mine in a word❤

  • @udcentrepreneur
    @udcentrepreneur Рік тому +2

    Thank you Faz for this tutorial. I have searched a lot on UA-cam 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
      @LearnitTraining  Рік тому +1

      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.

  • @CristianoEditz77
    @CristianoEditz77 11 місяців тому +1

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

  • @AdesijiDareYomi
    @AdesijiDareYomi 8 місяців тому +1

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

  • @mrmerlus
    @mrmerlus Рік тому +3

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

  • @disturbiant
    @disturbiant 6 місяців тому +1

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

  • @ramchandra1814
    @ramchandra1814 Рік тому +1

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

  • @ruthdanaiahchen9474
    @ruthdanaiahchen9474 Рік тому +1

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

  • @nandishns5021
    @nandishns5021 7 місяців тому +1

    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.

  • @prathimag5423
    @prathimag5423 Рік тому +2

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

  • @axelalejandrocruzgalvan7170
    @axelalejandrocruzgalvan7170 10 місяців тому +1

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

  • @AhmedGamal-mi1ns
    @AhmedGamal-mi1ns Рік тому

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

  • @LeviLironB
    @LeviLironB 8 місяців тому +2

    Good work.. Easy to learn with you

  • @mylibrary8315
    @mylibrary8315 11 місяців тому +1

    THANKS FOR THIS GREAT CLASS.

  • @nathanielbalmes6597
    @nathanielbalmes6597 2 роки тому +3

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

  • @reginauhio4529
    @reginauhio4529 2 роки тому +3

    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?

  • @ximenaallen-j4i
    @ximenaallen-j4i 5 місяців тому

    Thank you for sharing this wonderful course!

  • @BelénMartínez-v2z
    @BelénMartínez-v2z Рік тому +1

    Hi, first, thank you for teaching us! but a have a mistake in my practice, the function of "Goal Met" min 44:00 doesn’t work. I do all, step by step, but the function said it´s incorrect. Could someone help me?

    • @LearnitTraining
      @LearnitTraining  Рік тому

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

    • @ahmednavivwala1707
      @ahmednavivwala1707 Рік тому

      @@LearnitTraining 1:04:14

  • @laurevanloo3899
    @laurevanloo3899 2 роки тому +1

    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

  • @vlavoir
    @vlavoir Рік тому

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

  • @ginabarrell2155
    @ginabarrell2155 Рік тому +2

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

  • @bud5977
    @bud5977 Рік тому +1

    Thanks a lot for this video. Very useful!

  • @rektison
    @rektison Рік тому +1

    Ur voice is so relaxing

  • @AnupXlup
    @AnupXlup 2 роки тому +1

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

  • @TepieRyan
    @TepieRyan Рік тому +2

    Thanks for this video man

  • @nazimsalah8388
    @nazimsalah8388 Рік тому +1

    Bro you are creative and beyond Normal

  • @mariagambuti8787
    @mariagambuti8787 Рік тому +1

    Awesome video! SAving templates and grouping sheets rock!!

  • @다우우우아
    @다우우우아 Рік тому +1

    Hello why the formula at 44:44 is invalid for me? I typed the same formula

    • @LearnitTraining
      @LearnitTraining  Рік тому

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

    • @ahmednavivwala1707
      @ahmednavivwala1707 Рік тому

      @@LearnitTraining 1:12:07

  • @martin7437
    @martin7437 Рік тому +2

    Hello, I was trying to (1:06:54) type in all sheets. I dont know how but it doesnt change color or size of the text I am writing. In main sheet where I am typing something I can change color and size but it doesnt apply for all selected sheets. Can anyone help me with this problem?

    • @LearnitTraining
      @LearnitTraining  Рік тому

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

    • @ahmednavivwala1707
      @ahmednavivwala1707 Рік тому

      @@LearnitTraining 1:04:08

  • @DareDreamTv-gr6rb
    @DareDreamTv-gr6rb 7 місяців тому +1

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

  • @suryashree3003
    @suryashree3003 Рік тому +2

    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
      @LearnitTraining  Рік тому +1

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

  • @IonutPop9
    @IonutPop9 7 місяців тому +1

    Good Job Man ... Thank you !!

  • @lockheedmartin3275
    @lockheedmartin3275 2 роки тому

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

  • @mnurullahh
    @mnurullahh Рік тому

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

  • @nhikilnash4447
    @nhikilnash4447 6 місяців тому +1

    Appreciate you brother, amazing video.

  • @Herinbt
    @Herinbt 6 місяців тому

    57:27 Can we format something like Red for False and Green for true In “Goal Met?” Column

  • @aneessarachandran2519
    @aneessarachandran2519 11 місяців тому +1

    GREAT WAY TO EXPLAIN

  • @tonimaschler920
    @tonimaschler920 Рік тому +1

    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
      @LearnitTraining  Рік тому

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

  • @dav.naturalbeautychannel7720
    @dav.naturalbeautychannel7720 7 місяців тому +1

    You are amazing. Thank you

  • @bangetlyrics5041
    @bangetlyrics5041 2 роки тому +2

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

  • @greeshmaabhat
    @greeshmaabhat 10 місяців тому

    1:07:59 when I group the sheet the font colour and size is not changing

  • @Fatfrogsrock
    @Fatfrogsrock Рік тому

    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?

  • @MohammadAli67333
    @MohammadAli67333 9 місяців тому +2

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

  • @greeshmaabhat
    @greeshmaabhat 10 місяців тому

    Can someone explain 34:40 I'm getting total below that's at b9 c9 d9 e9 but not getting at the right. How to fix this?

  • @rosemontfleury9158
    @rosemontfleury9158 8 місяців тому +1

    Great tutorial

  • @stathis108
    @stathis108 Рік тому +1

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

  • @ابنالجراح-ل5و
    @ابنالجراح-ل5و 5 місяців тому +1

    thank you for this great work 🌟⭐☀

  • @mob-g5259
    @mob-g5259 2 роки тому +4

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

  • @johnravi1683
    @johnravi1683 2 роки тому +4

    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.

  • @akashtewari2607
    @akashtewari2607 10 місяців тому +1

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

  • @karolinamorris8168
    @karolinamorris8168 Рік тому +1

    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
      @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
      @ahmednavivwala1707 Рік тому

      @@LearnitTraining 1:05:22

  • @Balmistic
    @Balmistic 10 місяців тому +2

    THANK YOU!

  • @decebalusflorei6164
    @decebalusflorei6164 11 місяців тому +1

    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
      @LearnitTraining  11 місяців тому

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

    • @decebalusflorei6164
      @decebalusflorei6164 11 місяців тому

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

  • @lucaslegz
    @lucaslegz 2 роки тому +2

    Good Morning and thank you

  • @siddarthrajesh4825
    @siddarthrajesh4825 Рік тому +1

    Thank You I just finished this beginner course 🥰

  • @villa_fan8882
    @villa_fan8882 Рік тому +1

    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!

  • @regfr14tqq
    @regfr14tqq 9 місяців тому +3

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

  • @khalilsantarellicoach
    @khalilsantarellicoach 11 місяців тому

    On Mac I can't group sheets together (min 1:06:00)