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.
00:00 The Most Important Excel Functions in 2021
00:32 SORT Function (SORTBY)
03:16 UNIQUE Function in Excel
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
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
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
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!