Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course. and this video is uploaded by Simon Sez IT at 2022-07-19T08:00:14-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [PlPgYOFJROI]
| Name | Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course |
| Video Uploader | Video From Simon Sez IT |
| Upload Date | This Video Uploaded At 19-07-2022 15:00:14 |
| Video Discription | ✅ Download to follow along and complete the exercises ➡️ https://www.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. ✅ https://www.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 ⏩ https://www.simonsezit.com/courses/ 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU ✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 ✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc ✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j 💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ FaceBook: https://www.facebook.com/SimonSezIT 🔔 Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a thumbs up 👍🏽 ;-) ❤️ We appreciate your support! [PlPgYOFJROI] |
| Category | Science & Technology |
| Tags | Excel 2021 | Excel 365 | Advanced Excel | Excel Advanced | excel tutorial | excel 2021 new features | excel tips and tricks | excel 2021 xlookup | advanced excel tricks | excel online course | excel dynamic array | randarray | randbetween | sortby | xlookup | xmatch | countblank | median and mode | excel statistics | excel mode | excel median | excel switch | excel choose | aggregate function | excel | office 2021 | office 365 | dynamic arrays | dynamic array function | xmatch function | simon sez it | median |
