Excel 2021 Beginner Tutorial

Excel 2021 Beginner Tutorial

Get Ad-Free Training by becoming a member today!

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:

For Private Group Trainings please visit:

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.

[amirrezaax]

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

[syedimad]

I would like to express my gratitude to Faz. While I have encountered numerous courses on YouTube, 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 :)

[courtneyskeels]

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.

[kathleenbrown]

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

[andyfernandez]

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!

[franciselcano]

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!

[ruedizzle]

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.

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

[JoywithLastNames]

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.

[paularitztabinas]

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.

[ozbdzbn]

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

[queenrahma]

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 😊

[edreesalimy]

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

[uctrbdn]

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

[jesusreyes]

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.

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

[suzieogeto]

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

[guntherpleml]

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.

[bzolssb]

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

[mnurullahh]

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