Excel 2021 Beginner Tutorial
Вставка
- Опубліковано 15 лип 2024
- 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.
Bro.. we spent a whole semester in University learning what could have been thought in 1.5 hours. Thanks a ton Faz!
Happy to help!
I swear to you ...jezz men
2:45
0:59 ❤
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 :)
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!
You are very welcome! We are glad you learned so much!
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.
Welcome aboard!
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.
You are welcome! Good luck on the tests, you can also practice on our exams at www.learnitanytime.com
@@LearnitTraining 47:18
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!
Thank you for watching!
Agreed. But if you sift out the waffle, it might be half an hour long max :)
@@onesandzeroes 2:57
My favorite aspect of this course is your clarity of communication, Faz. Thank you.
Happy to hear that!
wonderful lectures, learnt a lot. In addition, my favorite feature was pane freezing.
Glad you like them!
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.
You're very welcome!
@@LearnitTraining 46:36
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 😊
Glad you enjoyed it!
@@LearnitTraining 46:09
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.
Great to hear!
@@LearnitTraining 46:25
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!!!
Glad you enjoyed it!
Faz you have done a phenomenal job with this tutorial! Very well developed and incredibly user friendly. Thank you.
Thank you for the kind words!
Best Excel tutorial, very detailed and simple to understand. Thank you!
You're very welcome!
Whaw 👍👏This is amazing, not rushed and very easy to understand. Keep it up !!
Thank you! 😃
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.
Glad it helped!
@@LearnitTraining 47:00
WAW amazing! I've just discovered your channel. Thank you so much. It's really helpful
You're so welcome!
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
You're very welcome!
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
Glad you enjoyed it!
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.
You are very welcome! We are glad you enjoyed the course!
@@LearnitTraining 46:17
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.
Thank you!
The favourite feature is definitely the Freeze Panes, it can be really useful when analysing data.
Thank you for sharing this wonderful course! Loved it..
You are so welcome!
I learned a lot in just 1hr and 30min! Thank you, Faz!
Glad it was helpful!
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
Thanks for the bookmarks!
@@LearnitTraining 1:06:52
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.
Glad it was helpful!
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.
Thank you Faz, This is a very interesting and important Excel tutorial for beginners. I learn a lot from this
Glad it was helpful!
Amazing course! Very detailed and easy to follow. Thank you so much.
You're very welcome!
@@LearnitTraining 46:45
you are an amazing instructor. I understood everything you were explaining. Your voice is smooth and pleasant. I lost my fear of Excel.
Wow, thank you!
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!
Thank you for watching!
Thanks bro, It was very interesting and your explanation methodology was great! very clean and simple.
You're welcome!
Thank you, Faz! I learned a lot from this course.
Glad it was helpful!
@@LearnitTraining 50:26
Love Mr Karin’s voice and training.
We will let him know!
@@LearnitTraining 1:03:02
Fantastic training!! Your voice is so soothing and encouraging. Thank you
Thank you for watching!
@@LearnitTraining 57:19
Thanks a lot for this video. Very useful!
You are very welcome!
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! :)
Glad it was helpful!
huge thanks to you man! thank you very much. love you from Azerbaijan!
You're welcome!
@@LearnitTraining 1:03:02
Fantastic course...was easy to follow and understand. Thank you!
You're very welcome!
@@LearnitTraining 47:06
Used Excel many years but only just discover(Absolute Referencing + the Auto Date) useful. Thank you. :)
You are very welcome!
@@LearnitTraining 53:19
Awesome video! SAving templates and grouping sheets rock!!
Thanks!
@@LearnitTraining 51:09
Great video!!! Helped me a lot. Thanks buddy.
No problem 👍
Thanks a lot... I like the formula adding part...
You are welcome 😊
Thank you for this great refresher in excel as I used excel daily it Just made it way easier ❤
You're very welcome!
Wonderful tutorial, definitely gonna watch the rest of the excel tutorial videos. Thanks a lot Faz.
You're very welcome!
@@LearnitTraining 50:44
This is verry helpful, you made my work easier by jsut showing me you could make and pin excel templates. Real office hero!
We are glad we were able to help!
@@LearnitTraining 56:27
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.
Thank you for the kind words!
Good work.. Easy to learn with you
Glad to hear that!
THANKS FOR THIS GREAT CLASS.
You're very welcome!
wow, personally it was really amazing one and half hour to learn excel for beginners. Thanks brother
You are most welcome
I enjoyed the course! Thank u so much for sharing this for us! ;) definitely worth of our time for learning the excel skills!
Glad you enjoyed it!
@@LearnitTraining 47:11
This video has really been helpful. It's awesome.
Thanks!
Well articulated with right pace & navigation . My fav part is Custom views. Thanks a lot!
You're most welcome!
@@LearnitTraining 52:56
THANK YOU!
You are welcome!
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!
We will be adding Excel for Mac hopefully later this year!
@@LearnitTraining 46:53
Thank you for your video! Much appreciated!!!🙂
You are so welcome!
@@LearnitTraining 57:09
Thank you Faz !!
I learned Freeze Pans
Saving as template
Alt Shortcuts
Happy to help!
@@LearnitTraining 58:19
Appreciate you brother, amazing video.
We appreciate that!
Thanks for the great video! My favorite feature is Freeze Panes.
You are welcome! Thank you so much for watching!
@@LearnitTraining 55:43
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🥰
I'm so glad!
@@LearnitTraining 55:02
Never learned these things in 4 years of BS(IT).
Thanks, FAZ JAN
You are very welcome!
شكرا لك , تعلمت الكثير منك
53:30
I Like the way she's talking. Very smooth, relaxing and enjoyable
😊 thank you
@@LearnitTraining 1:03:02
Brother For men we use HE not SHE
Cảm ơn bạn từ Việt Nam
thank you for this great work 🌟⭐☀
You are so welcome
Thank you brother ❤
You are welcome!
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
Không có chi! Cảm ơn vì đã xem!
@@LearnitTraining 1:03:02
Good Job Man ... Thank you !!
You're welcome!
thanks for all
Most welcome
Great Presentation...
Glad you liked it!
Thanks very much we really appreciate your effort
Our pleasure!
@@LearnitTraining 58:40
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?
GREAT WAY TO EXPLAIN
Thanks!
thankyou very much
You are most welcome
Thank you so much I want to be data analyst that's why I'm learning excel and I hope to master Excel ❤
You will be there soon!
thank you so much sir to teach as soo much
You are most welcome
thank you so much sir . this helped me a lot
Most welcome!
@@LearnitTraining 57:32
thank you 🤗
You're welcome 😊
Thanks a lot !!!!
You are welcome!
Thanks for this video man
No problem!
@@LearnitTraining 1:03:54
Thank you Faz Karim
You are welcome!
thank you!
1:03:39
Thank you so much!.
You're welcome!
@@LearnitTraining 1:04:00
Muito bom. Obrigado! Sou do Brasil e entendi tudo perfeitamente.
Você é muito bem-vindo!
You are born to teach mate. ❤
Thanks!
@@LearnitTraining 52:46
Great tutorial
Thank you! Cheers!
This is Great!!!!
Thanks!
this guy is bob ross of excel training videos, thanks man I learned a lot!
Wow, thanks!
@@LearnitTraining 53:41
Thank You I just finished this beginner course 🥰
You are welcome!
@@LearnitTraining 56:36
Very Great Work....! Big Thank you... Form India
Our pleasure!
@@LearnitTraining 1:03:02
great class - thanks
Glad you enjoyed it!
@@LearnitTraining 58:03
This is perfect
Thank you!
Gold Mine in a word❤
Thanks!
@@LearnitTraining 1:03:02
Thanks a lot for your efforts
Our pleasure!
@@LearnitTraining 1:03:07
Thank you.. I just finish this section.
Great job!
@@LearnitTraining 1:03:02
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.
The Advanced class is the next video. Sorry for the confusing titling. We have since fixed that.
Great help! Thanks
You are welcome!
@@LearnitTraining 1:03:16
Ur voice is so relaxing
Glad you think so!
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?
Here is the video: ua-cam.com/video/UeJWCqJysKI/v-deo.html
@@LearnitTraining 55:12
Good Morning and thank you
Good morning!
@@LearnitTraining 1:11:49