✅ Download to follow along and complete the exercises ➡️ simonsezit.com/excel-2021-advanced-instructorexercise-files/
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.
✅ simonsezit.com/excel-2021-advanced-instructorexercise-files/
📝 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 ⏩ 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! ➡️ simonsezit.lpages.co/ssit-14-day-free/
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅ Check out our free video playlist for Excel beginners 👉 youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
✅ Excel 2021 Tutorials for Intermediate Users here 👉 youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Microsoft Excel Tips and Tricks 👉 youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉 youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com/
LinkedIn: linkedin.com/company/simon-sez-it/
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
❤️ We appreciate your support!
- Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course ( Download)
- Microsoft Excel 365 Tutorial: 3+ Hours of Advanced Excel Training ( Download)
- The Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours! ( Download)
- Microsoft Excel Intermediate Training (2021/365): 5-Hour Excel Tutorial Class ( Download)
- Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners! ( Download)
- Microsoft Excel Tutorial (2021/365): 4.5+ Hours of Getting Started in Microsoft Excel 2021 ( Download)
- Excel 2021 Full Course Tutorial (3+ Hours) ( Download)
- Excel Tutorial Beginner to Advanced - 12-Hour Excel Course ( Download)
- Advanced Excel Full Course 2024 | Excel Tutorial For Beginners | Excel Training | Simplilearn ( Download)
- Microsoft Excel Tutorial for Beginners - Full Course ( Download)
- Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours! ( Download)
- 🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn ( Download)
- Excel Formulas and Functions | Full Course ( Download)
- 🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn ( Download)
- Advanced Excel Full Course 2023 | Excel Tutorial For Beginners | Excel Training | Simplilearn ( Download)