In this Excel functions tutorial you'll learn how to use the NEW Excel formulas and functions. These Excel functions are available in Excel for the Web (for free) and also Excel Desktop if you have a Microsoft 365 subscription. I've rounded up the most useful Excel functions you'll need as an Excel beginner, accountant or if you need the right Excel functions for data analysis. GET ACCESS TO THE COMPLETE COURSE to MASTER Excel Functions in Microsoft 365: https://courses.xelplus.com/p/excel-dynamic-array-formulas You’ll master the new Excel functions through multiple exercises and challenges so you can use the FILTER Function instead of a complex combination of INDEX & MATCH. Not only will these save you from headaches but also from wasting time doing things the long way. Time Stamps 00:00 The Most Important Excel Functions in 2021 00:32 SORT Function (SORTBY) 03:16 UNIQUE Function in Excel 05:41 XLOOKUP 07:43 FILTER Function 09:29 SEQUENCE Function in Excel DOWNLOAD the Excel Workbook from here: https://www.xelplus.com/excel-functions-office-365 LINKS to more Excel 365 tutorials: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP My Online Excel Courses https://www.xelplus.com/courses/ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Microsoft 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel