Excel 2021 Beginner Tutorial
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 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
wonderful lectures, learnt a lot. In addition, my favorite feature was pane freezing.
Glad you like them!
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!
I would like to express my gratitude to Faz. While I have encountered numerous courses on TH-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 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
My favorite aspect of this course is your clarity of communication, Faz. Thank you.
Happy to hear that!
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!
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
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
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
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 TH-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!
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!
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!
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
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!
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
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
Whaw 👍👏This is amazing, not rushed and very easy to understand. Keep it up !!
Thank you! 😃
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!
Amazing course! Very detailed and easy to follow. Thank you so much.
You're very welcome!
@@LearnitTraining 46:45
Love Mr Karin’s voice and training.
We will let him know!
@@LearnitTraining 1:03:02
WAW amazing! I've just discovered your channel. Thank you so much. It's really helpful
You're so welcome!
Thank you for sharing this wonderful course! Loved it..
You are so 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!
Thank you, Faz! I learned a lot from this course.
Glad it was helpful!
@@LearnitTraining 50:26
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!
Fantastic training!! Your voice is so soothing and encouraging. Thank you
Thank you for watching!
@@LearnitTraining 57:19
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!
This video has really been helpful. It's awesome.
Thanks!
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!
Awesome video! SAving templates and grouping sheets rock!!
Thanks!
@@LearnitTraining 51:09
Never learned these things in 4 years of BS(IT).
Thanks, FAZ JAN
You are very welcome!
Thanks bro, It was very interesting and your explanation methodology was great! very clean and simple.
You're welcome!
Great video!!! Helped me a lot. Thanks buddy.
No problem 👍
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!
Fantastic course...was easy to follow and understand. Thank you!
You're very welcome!
@@LearnitTraining 47:06
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
The favourite feature is definitely the Freeze Panes, it can be really useful when analysing data.
Good work.. Easy to learn with you
Glad to hear that!
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
Used Excel many years but only just discover(Absolute Referencing + the Auto Date) useful. Thank you. :)
You are very welcome!
@@LearnitTraining 53:19
Wonderful tutorial, definitely gonna watch the rest of the excel tutorial videos. Thanks a lot Faz.
You're very welcome!
@@LearnitTraining 50:44
huge thanks to you man! thank you very much. love you from Azerbaijan!
You're welcome!
@@LearnitTraining 1:03:02
wow, personally it was really amazing one and half hour to learn excel for beginners. Thanks brother
You are most welcome
Thanks a lot for this video. Very useful!
You are very welcome!
Good Job Man ... Thank you !!
You're 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
Well articulated with right pace & navigation . My fav part is Custom views. Thanks a lot!
You're most welcome!
@@LearnitTraining 52:56
Thanks a lot... I like the formula adding part...
You are welcome 😊
THANK YOU!
You are welcome!
THANKS FOR THIS GREAT CLASS.
You're 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!
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 Presentation...
Glad you liked it!
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
Thank you Faz Karim
You are welcome!
thankyou very much
You are most welcome
Great tutorial
Thank you! Cheers!
Cảm ơn bạn từ Việt Nam
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
Thanks for the great video! My favorite feature is Freeze Panes.
You are welcome! Thank you so much for watching!
@@LearnitTraining 55:43
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?
thanks for all
Most welcome
Thanks a lot !!!!
You are welcome!
Thanks for this video man
No problem!
@@LearnitTraining 1:03:54
thank you 🤗
You're welcome 😊
Thank you brother ❤
You are welcome!
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.
This is Great!!!!
Thanks!
Thank you Faz for this tutorial. I have searched a lot on TH-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
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.
thank you so much sir to teach as soo much
You are most 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
GREAT WAY TO EXPLAIN
Thanks!
Thank You I just finished this beginner course 🥰
You are welcome!
@@LearnitTraining 56:36
Thanks very much we really appreciate your effort
Our pleasure!
@@LearnitTraining 58:40
Very Great Work....! Big Thank you... Form India
Our pleasure!
@@LearnitTraining 1:03:02
Thank you.. I just finish this section.
Great job!
@@LearnitTraining 1:03:02
Thanks!
You are welcome!
@@LearnitTraining 1:09:58
thank you so much sir . this helped me a lot
Most welcome!
@@LearnitTraining 57:32
Thank you Faz!
You are welcome!
شكرا لك , تعلمت الكثير منك
53:30
This is perfect
Thank you!
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: th-cam.com/video/UeJWCqJysKI/w-d-xo.html
@@LearnitTraining 55:12
You are born to teach mate. ❤
Thanks!
@@LearnitTraining 52:46
this guy is bob ross of excel training videos, thanks man I learned a lot!
Wow, thanks!
@@LearnitTraining 53:41
great class - thanks
Glad you enjoyed it!
@@LearnitTraining 58:03
Great help! Thanks
You are welcome!
@@LearnitTraining 1:03:16
Thanks a lot for your efforts
Our pleasure!
@@LearnitTraining 1:03:07
Thank you so much!.
You're welcome!
@@LearnitTraining 1:04:00
Gold Mine in a word❤
Thanks!
@@LearnitTraining 1:03:02
perfect
Thanks!
thank you ... great guy
You're welcome!
@@LearnitTraining 1:04:52
GREAT
Thanks!
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) ??
Hello Ahmad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
yeah same thing happened with me too. Only the word "internal" was their, but not the font,size and color.
thank you!
1:03:39
Wow thanks a million.
Would you please consider making such for R ?
We will look into it Nura!
Will appreciate big time, thanks
@@nurawario1235 1:00:16