5 Excel Functions YOU NEED in 2021
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
Видео 5 Excel Functions YOU NEED in 2021 канала Leila Gharani
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
Видео 5 Excel Functions YOU NEED in 2021 канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Cash Flow Statement Basics ExplainedExcel LAMBDA FunctionWhen Should you Use the Hash Sign (#) in Excel Formulas?FREE Options to Sign PDF | Make an Electronic SignaturePROPERLY Share Your Screen in a Microsoft Teams Meeting (For BEST Experience!)Excel Calendar with Just ONE Formula!15 Amazing Shortcuts You Aren't Using10 Excel formatting tricks *ONLY* experts knowSearchable Drop Down List in Excel (Very Easy with FILTER Function)10 Amazing (Less Known) Excel Tricks You Should KnowExcel LAMBDA - HOW & WHEN you Should use itAdvanced PivotTable Techniques: Combine Data from Multiple Sheets in Excel6 FREE Add-Ins for Excel to Start Using NowDrop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)Return Multiple Match Results in Excel (2 methods)Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)How to Use OneNote Effectively (Stay organized with little effort!)Excel VBA Beginner Tutorial