Toptube Video Search Engine



Title:Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course
Duration:03:43:41
Viewed:1,613,300
Published:19-07-2022
Source:Youtube

βœ… 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!



SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :