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

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

[thebhaskarjoshi]

Learnt so many things. Thank you for making this video.

[thebhaskarjoshi]

Takeways- 10:10 If we provide a range to a formula that accepts only a single cell reference, it will always spill.

[thebhaskarjoshi]

41:29 I think, It should be Count(t) => Counta(t).

[thebhaskarjoshi]

27:45 Instead of this {2, 4}, Can we use Formula.

[jkumar]

Pl combine all your excel videos and convert into a course with modification as required here and there, if not u can create a course from ground up

[dontown]

I have been using Excel since 1993 ver. 5.0 and am still learning as Microsoft keeps adding new things nearly every week thanks to the Beta channel. Your explanations in this video were very easy to understand. Thank you

[tamersalem]

thank you for your interest in spreading the flag please help me get a sheet excel for the costs of a furniture factory