Excel 2021 Full Course Tutorial (3+ Hours)

Learnit Training
Learnit Training
830,999
0
Published 2023-04-26
Excel 2021 Full Course Tutorial (3+ Hours)

Get Ad-Free Training by becoming a member today!
youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: learnitanytime.com/p/exercise-files-excel-2021-ful…

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-classes-workshops

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
Introduction 1:23:59
Formatting Lists as Tables 1:25:19
Flash Fill 1:34:16
Custom Sorting 1:37:03
Subtotals 1:41:15
QA Tool 1:45:55
Data Charts 1:49:01
Sparklines 1:56:29
Introduction to Pivot Tables 2:01:26
Advanced Pivot Tables Options 2:13:32
Data Validation 2:21:01
Conditional Formats 2:27:34
Comments and Notes 2:34:05
Linking Data 2:36:40
Privacy and Protection 2:39:41
Conclusion 2:43:16
Introduction 2:43:41
Nesting Functions 2:46:48
Database Functions 2:54:40
XLOOKUP 3:03:11
UNIQUE 3:11:03
SORT and SORTBY 3:16:54
FILTER 3:22:48
LET 3:29:18
Consolidate 3:34:42
Introduction to Macros 3:39:27
Recording and Playing Macros 3:42:02
Conclusion 3:47:27

#excel #excel2021 #exceltutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.
All Comments (21)
  • @galitcohentrab3965
    Thanks bro! your a freaking legend I honestly don't know what I would've done without you a huge thanks!
  • @Ochookenneth
    You are a God sent. Taking time to help strangers is a hearty thing
  • @krisatkins6106
    An excellent course well structured with plenty of prompts to give things a try. Thank you very much Faz!
  • @tien0521
    Thank you for this awesome tutorial! You are a phenomenal teacher; everything is so clear and nicely paced, and it feels you thought to go over functions more than once, but in different scenarios, which really helped me to remember them! I’m starting new work soon which will require good MS command. And your teaching really helps me be more confident. A big thank you for your awesome work!!
  • @ArzoCanada
    I can't say THANK YOU enough!! You're one AMAZING teacher. <3
  • @ryuren2363
    thanks! simple and understandable guide!
  • @Debbie_obasi
    Thank you so much for the tutorials(beginners to advanced) i understood everything. Great work Faz and Learnit.
  • @Mary.151
    thanks i never think that will work so good job!
  • @srinivaskr1290
    Awesome .... Thank you for helping in finding out the solution for my issue 😊
  • @DanielG10_20
    Excellent video, I am brand new to Excel and this video is one of the better ones with all the keyboard shortcuts. One funny thing that happened when I was typing in "todays date" around the 42:10 mark, was that today is actually 2 years to the day (October 27) it showed on the video 🤣
  • @BerieBini
    You are awesome teacher. Thank You so much. I have a Big respect for you.