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.
Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533
For more detail of the topics mentioned please refer to these specific videos:
Link to Excel XLOOKUP Video: https://youtu.be/xxX8XiuKFEY
Link to Excel Dynamic Array Formulas Video: https://youtu.be/xwTUfU8PqCU
Link to Excel Linked Data Types Video: https://youtu.be/o3_-DnlfHkY
Link to Excel Natural Language Query Video: https://youtu.be/Wt-r9XRuxV4
Link to Excel LAMBDA Function Video: https://youtu.be/Ayc7QOadBa4
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
