Microsoft Excel 365 Tutorial: 3+ Hours of Advanced Excel Training

✅Download the free course files and follow along here: ➡️https://www.simonsezit.com/excel-365-advanced-3-hours-course-and-exercise-files/ Welcome to the Microsoft Excel 365 Advanced Tutorial, designed to boost your data analysis and productivity skills with advanced Excel 365 features. Delve into dynamic array formulas like SORT, FILTER, and XLOOKUP to manipulate data efficiently. Learn complex lookups and reference functions, even with multiple criteria. Discover how to create custom functions with LET and LAMBDA, tailoring formulas to your needs. Master Power Pivot and Power Query for effortless data management and analysis. 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 00:00:00 - Course Introduction 00:03:59 - Exercise 01 00:05:01 - What are Dynamic Array Functions? 00:07:26 - Introduction to Spills and Arrays 00:13:35 - Extract and Count Unique Entries 00:17:16 - Unique vs Distinct 00:21:26 - Extract Multiple Unique Columns 00:23:47 - Extract Unique Values by Column 00:27:23 - The SORT Function 00:33:12 - The SORT Function - Horizontal Sort 00:39:18 - The SORTBY Function 00:43:39 - The SORTBY Function - Horizontal SORTBY 00:47:38 - The SEQUENCE Function 00:52:29 - The FILTER Function 00:58:34 - FILTER with Logic: + Operator (OR) 01:03:48 - FILTER with Logic: * Operator (AND) 01:07:47 - FILTER with Logic: = Operator (Both or Neither Criteria) 01:10:56 - FILTER with Logic: - Operator (One or the Other but Not Both) 01:14:21 - RANDARRAY and RANDBETWEEN 01:23:43 - Use XLOOKUP to Perform Complex Lookups 01:31:11 - The XMATCH Function 01:35:20 - Exercise 02 01:36:47 - Lookups with Multiple Criteria 01:43:05 - Lookups with Duplicate Values 01:48:44 - Exercise 03 01:50:32 - The LET Function 02:00:06 - Create Your Own Formulas with LAMBDA 02:11:33 - Exercise 04 02:13:33 - Create a Data Model in Power Pivot 02:20:10 - Create Relationships Between Tables 02:24:34 - Add Calculated Columns 02:30:32 - Build a PivotTable from Multiple Sources 02:34:24 - Exercise 05 02:35:38 - Import Data Using Power Query 02:41:03 - Clean Data with Power Query 02:50:21 - Combine Files from a Folder 02:56:49 - Add More Files to the Data Model and Refresh 03:03:29 - Exercise 06 🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 400+ 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 👍🏽 ;-)