Excel 2021 Advanced Tutorial

Excel 2021 Advanced 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
Formatting Lists as Tables 2:03
Flash Fill 10:59
Custom Sorting 13:46
Subtotals 17:59
QA Tool 22:38
Data Charts 25:45
Sparklines 33:13
Introduction to Pivot Tables 38:10
Advanced Pivot Tables Options 50:16
Data Validation 57:45
Conditional Formats 1:04:18
Comments and Notes 1:10:49
Linking Data 1:13:24
Privacy and Protection 1:16:25
Conclusion 1:20:00

#excel #excel2021 #exceltutorial

(C) 2022 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[PearlBasnet]

Very well spoken/narrated and illustrated. I really appreciate how easy to follow the speaker made these examples and illustrations. The right method of teaching is to speak slowly and effectively instead of rushing through the examples fast and the presenter here did just that. Thank you!!!!

[maryharvey]

Very fine tutorial. The presenter demonstrates the tools expertly. His narration is in a clear pleasant voice. Save this for your professional development courses.

[truthfulpenguin]

Great Course! My brain is absolutely fried since I did this and the Beginner tutorial all in basically one sitting, but I definitely fell 100x more confident using Excel now than I did at the beginning. I am probably going to try to do the Expert tutorial Monday when I come into the office again, and honestly, I am looking forward to it. Never thought that an Excel tutorial would be actually fun to just sit down and follow but here we are.

[RogerClubv]

As someone dedicated to continuous learning, I've explored numerous tutorials across various subjects throughout the years. Without a doubt, Faz Karim's Excel 2021 Advanced tutorial stands out as an exceptional resource in my learning journey.

Karim's mastery of the subject matter and his engaging teaching style combine to create an educational experience that is nothing short of delightful. His explanations are not just informative but meticulously crafted, ensuring that even the most intricate topics are presented in a way that's easy to grasp. No matter your prior Excel knowledge, Karim's talent for breaking down complex concepts into manageable pieces makes this tutorial accessible to learners of all backgrounds.

Without reservation, I wholeheartedly recommend Karim's tutorial to anyone seeking to elevate their Excel proficiency. It's a learning experience that promises growth and mastery in a user-friendly and enjoyable format. I can't wait to watch his next course, Excel 2021 Expert.

#excelmastery
#learnexcel
#exceltutorial

[paasha]

Preparing for data analytics, never worked much on excel before and now got a lot from this course.

[vivek]

For some reason, they table option at 4:47 is greyed out for me and the shortcut option also does not seem to work. Any idea why this is occurring? Thank you.

NVM, i got it. For some reason when you download the exercise file, the first 4 sheets are grouped, you need to ungroup them.

[gugulethukunene-hctj]

just aced my exam today because of you, GOD bless you man. One love:)

[Sidra_Shahbaz]

Learnit Training you are doing a great job by proving such valuable lectures in free. May God give you rewards for this. Thank you Faz!

[milinkabarnak]

This excellent tutorial provides a comprehensive overview of Excel. With its step-by-step instructions, it's easy to follow and understand even for those less familiar with the software. The clear language and illustrative examples make it even easier to grasp the concepts. This tutorial is a valuable resource for anyone looking to enhance their Excel skills.

[maomama]

Faz is the best instructor who has interesting and dramatic voice to make learning boring stuff much fun and engaging. 👨‍🏫

[AhmedGamal-mins]

This was a great one-hour and half hands-on practice course. Thanks, Faz.

[pennyworsfold]

I just had the same trouble with the greyed out table menu options. At the very bottom of the page, it said Accessibility: Investigate. So I clicked on that and it added an Accessibility tab. I clicked Accessibility Checker under the tab and then it brought up an error box to the right. Once I fixed the (3 minor) errors, everything was fine.

[RaniaAdeoye]

Thank you so much for the course. The presentation was off the charts.

[KrishnaPatel-cfuz]

i have learned a lot and It may help me pass my ICT test for my secondary school so thank you

[TanviD-ed]

When I am trying to access the exercise file and trying to do the same task along with the video it shows insert option fully grayed out. any solution for this?

[thaonghiquan]

cam on ban nhieu lam luon a, ne va thuc quy nhung nguoi gioi ma con sẵn sang chia se kien thuc va kinh nghiem cua ban than cho nguoi khac, chuc ban luon thanh cong nhe

[kevinsidika]

fantastic i loved the grouping technique

[pharmedic]

I think you are the best teacher I have ever seen

[lailabenosmane]

You are the best instructor. Great job and verry helpful. Thank you!

[ashhyd]

This tutorial is top notch! Very focussed and practical aligned to scenarios that could potentially crop up in day today work!!😀