Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course

In this Microsoft Excel 2021 Advanced training course, fast-track your Excel skills to expert level. We introduce you to new dynamic array functions, how to deal with spills in arrays, and use advanced Excel formulas and functions like XLOOKUP and XMATCH.

We also discuss the difference between Unique and Distinct, how to use different sort functions, and advanced filtering. You will learn to create advanced and flexible lookup formulas, use statistical functions to rank data, calculate the MEDIAN and MODE, and so much more!

We've even included downloadable exercise and instructor files from our paid-for course so you can follow along and complete the exercises in this Advanced Excel 2021/365 Tutorial. This will help you put what you are learning into practice and master Excel.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - Introduction
0:03:09 - Exercise 01
0:05:15 - Dynamic Arrays
0:07:31 - Spill and Arrays
0:18:23 - Extract and Count Unique Entries
0:24:38 - Unique vs. Distinct
0:28:02 - Unique with Multiple Criteria
0:31:13 - Unique Values by Column
0:35:37 - SORT Function
0:44:30 - Horizontal Sort
0:50:38 - SORTBY Function
0:56:47 - Horizontal SORTBY
0:59:52 - Sequence and Unstacking Records
1:10:02 - Filter Function
1:16:59 - Using Filter with Logic Plus Operator
1:21:47 - Using Filter with Logic Asterisk Operator
1:27:27 - Using Filter with Logic Equals Operator
1:31:40 - Using Filter with Logic Minus Operator
1:36:29 - RANDARRAY and RANDBETWEEN
1:46:11 - XLookUp
1:58:34 - XMatch
2:04:55 - Exercise 02
2:18:04 - Two-way Lookups
2:26:29 - CHOOSE Function
2:36:33 - SWITCH Function
2:41:03 - Exercise 03
2:48:11 - Median and Mode
2:54:25 - Using LARGE and SMALL
3:01:58 - Ranking Data
3:09:39 - COUNTBLANK Function
3:14:25 - Exercise 04
3:21:31 - Rounding Values
3:28:29 - Specialized Rounding
3:33:00 - Aggregate Function
3:37:31 - Exercise 05

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
❤️ We appreciate your support!

[SimonSezIT]

🔥Check out our FREE 300+ hour training course playlist here ➡️

🚀 Boost your Excel skills with these free Excel playlists 👉🏼

[faissalloussaief]

Fabulous ❤course, thanks for sharing your knowledge with us. The explanation is super clear and easy to understand. ❤❤❤❤❤

[XxKingfisherxX]

Thanks to Deb for knowledge you are spreading and thanks to Simon for ensuring it, i wish getting the follow along files download would 've been straight forward.

[devramharak]

Excellent tutorial.Well presented. The manner in which the tutorials are presented could be applied in the real world. I am addicted to learning and from most of the tutorials and videos this is one of the best that I have watched.

[mariag]

Thank you so much for this. This is amazing for anyone, but if you are unemployed and cannot afford to take a course, this really helps employment prospects. You can walk into a job role with more confidence knowing you have this knowledge. The downloadable files really help with practice too.

[exptfof]

The best tutorials I have ever watched .Well presented.thank you

[tatipamulaashok]

Excellent and simplified explanation with more useful examples by using advanced functions... Thank u so much 🥰

[Get.YouTube.Views.]

Your video had me captivated from start to finish. The storytelling was engaging and compelling.

[daniellukaobidakpasham]

Honstly am really enjoying the Advanced Excel Training course

[dansmith]

Thank you so much for posting this course and a link to the files!! I bought an Excel learning bundle with the 2021 beginner and intermediate but the bundle didn't have 2021 advanced. Very much appreciated and Deb- you're amazing!

[jackmuscovich]

I have to say I almost never comment on YouTube videos I watch. But this course is flawless. Everywhere from the concepts covered to the files you can use to follow along... I'm blown away by how perfect this was. Thanks so much!!!

[ussama]

i started your course from beginners course 7days ago, now i'm in the advanced course
it's really a super course, the way you explain ... thank you so much deb

[sanimunir]

The problem with the downloading file is that the software demands for email and after entering email, it says thanks and then you have to wait. How much no one knows then.

[umeshkhatri]

Brilliant tutorial. Explained with very calmness and clarity.

[andrehenry]

Thanks for sharing this precious training.

[terrylee]

Brilliant tutorial as always. Such calmness and clarity in the presentation

[dannguyen]

Thank you so much! This is super helpfull!!!

[zhangmr]

Dab is the best teacher I ever met. I attend some classes on the other platform. Excellent!

[johnravi]

Hi Simon,

It was a great share! I have been very disorganized lately, so I am paying my younger nephew to help me organize my data with Excel. He is new to this, and he doesn’t understand all the features. I am sure this video will help him a lot, and he will be able to complete the task much faster. It was a very in-depth tutorial, and I am sure learning how to use Excel will help him later in life as well. Thanks for sharing this, it was a great watch.

[spreadknowledgeknowledge]

Hi Dab your every video is incredible for excel learner. Thank you so much💌