Excel 2020 Best Tips and Tricks

This is a recap of the best Excel tips and tricks released for most users in 2020. You’ll have all these features if you use the subscription-based version of Microsoft 365 Excel and have updated it to the latest release. I also introduce the LAMBDA function.

For more detail of the topics mentioned please refer to these specific videos:

Contents 0:00
1. XLOOKUP 0:29
2. LET 2:03
3. Dynamic Array Functions 3:35
4. Linked Data Types 4:55
5. Analyze Data 6:32
6. Premium Content 7:50
7. LAMBDA 8:42

#seletraining #excel #tipsandtricks

[TylerStanczak]

Really helpful tips! Thank you Sele :)

[cogwheelLearning]

Sele Training with another classic for 2021. Nice video!

[vijayarjunwadkar]

Great Video! Love your deep voice and the explanation with simple examples to help understand concepts quickly! Keep up the great work!

[falmaskari]

Thanks for the well presented tips for the new features.

[akaBagManden]

Thx for great videos.
When viewing on a phone it's hard to see what you are typing in many of the formulas.
Just a little hint. :)
In general your videos are a great source of knowledge and inspiration. I have learned many things that I didn't know the programs could.
Thanks again.

[thokozilecollis]

Thank you so much for this useful tutorial

[BurntToast-]

Very nice and to the point. Thanks for the content, subscription earned.

[wayneedmondson]

Hi Jason. Thanks.. awesome review of Best Tips and Tricks for 2020! Looking forward to more in 2021 :)) Thumbs up and Happy New Year!!

[theadventuresofembrunguy]

This is amazing. Thank you for enhancing my skills with Excel. Wishing you a Happy 2021.

[kiankarimi]

Thanks dear. These tricks are very helpful

[tsawbthoj]

Very good and I want download link of MS 2020 full version

[gajabathiarjuntg]

Thank you sir for this amazing and new features :) Is X LOOKUP and LAMBDA functions available in office 2019?

[leorc]

Hola, en el caso de Data Types, en mi Excel 365 veo solamente 2 categorías: Stocks and Geography, how can i get those other show in your Excel? saludos Mr. Sele

[dannylee]

Does anyone here know why adding a number to a date doesn’t work in Excel? i.e, A2(01/19/2021)+14=#VALUE

[ubaidillahmuhammad]

useful knowledge. but please put all excel files in the description as a souvenir in new year...thanks