Learn Excel new functions 2021 - Lambda, Unique, Let, Dynamic Arrays, ArrayToText and more

Опубликовано: 29 Сентябрь 2024
на канале: Efficiency 365 by Dr Nitin
2,790
60

Learn the new and powerful functions recently introduced in Excel. Lambda is the latest, but there are more - Let, Sort, Filter, ArrayToText, ValueToText, MaxIfs, Xlookup, Xmatch, and more.

Each function is explained by Dr. Nitin in an easy to understand way and with examples.
------------------------------------------------------------
Contents
------------------------------------------------------------
00:00 - Intro
02:02 - New Functions
03:25 - FORMULATEXT function
04:18 - Structured Formulas
09:45 - CONCAT and TEXTJOIN
15:20 - ARRAYTOTEXT and VALUETOTEXT
16:55 - SEQUENCE
19:00 - RANDARRAY
22:18 - UNIQUE
26:02 - SORT
30:10 - FILTER
38:28 - LET function
42:28 - SWITCH and IFS
47:38 - XLOOKUP
53:28 - XMATCH
56:50 - MAXIFS MINIFS and AVERAGEIFS
01:01:33 - LAMBDA function
01:11:35 - Summary


--------------------------------------------------------------
Learn more from 1000+ blog articles by Dr Nitin Paranjape
https://efficiency365.com/blog

Linkedin :   / nitinparanjape  
Twitter :   / drnitinp