Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Simon Sez IT
658K subscribers
<__slot-el>
<__slot-el>
1.8M views 2 years ago 1 product
✅ Download to follow along and complete the exercises ➡️ https://www.simonsezit.com/excel-2021... 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  …...more
...more

Introduction

0:00

Exercise 01

3:09

Dynamic Arrays

5:15

Spill and Arrays

7:31

Extract and Count Unique Entries

18:23

Unique vs. Distinct

24:38

Unique with Multiple Criteria

28:02

Unique Values by Column

31:13

SORT Function

35:37

Horizontal Sort

44:30

SORTBY Function

50:38

Horizontal SORTBY

56:47

Sequence and Unstacking Records

59:52

Filter Function

1:10:02

Using Filter with Logic Plus Operator

1:16:59

Using Filter with Logic Asterisk Operator

1:21:47

Using Filter with Logic Equals Operator

1:27:27

Using Filter with Logic Minus Operator

1:31:40

RANDARRAY and RANDBETWEEN

1:36:29

XLookUp

1:46:11

XMatch

1:58:34

Exercise 02

2:04:55

Two-way Lookups

2:18:04

CHOOSE Function

2:26:29

SWITCH Function

2:36:33

Exercise 03

2:41:03

Median and Mode

2:48:11

Using LARGE and SMALL

2:54:25

Ranking Data

3:01:58

COUNTBLANK Function

3:09:39

Exercise 04

3:14:25

Rounding Values

3:21:31

Specialized Rounding

3:28:29

Aggregate Function

3:33:00

Exercise 05

3:37:31
Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course
✅ Download to follow along and complete the exercises ➡️ https://www.simonsezit.com/excel-2021... 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. ✅ https://www.simonsezit.com/excel-2021... 📝 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 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-... 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️    • Simon Sez IT Long Training Courses   ✅ Check out our free video playlist for Excel beginners 👉   • Microsoft Excel Beginner's Training T...   ✅ Excel 2021 Tutorials for Intermediate Users here 👉   • Excel 2021 Tutorials for Intermediate...   ✅ Microsoft Excel Tips and Tricks 👉   • Microsoft Excel Tips and Tricks   ✅ Microsoft Office 2021 and Office 365 Training here 👉   • Microsoft Office 2021 and Office 365 ...   💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn:   / simon-sez-it   FaceBook:   / simonsezit   🔔 Subscribe to our channel: https://www.youtube.com/simonsezittra... If you enjoyed the video, please give a thumbs up 👍🏽 ;-) ❤️ We appreciate your support!

Follow along using the transcript.

Simon Sez IT

658K subscribers