excelisfun | 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782 @excelisfun | Uploaded 2 years ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1782.xlsx
These two functions were released in March 16, 2022 and are in Beta at that time in Microsoft 365 Excel.
Learn about the 14 new functions in Microsoft 365 Excel.
Topics:
1. (00:00) Introduction
2. (00:31) TEXTSPLIT
3. (02:55) TEXTBEFORE
4. (03:14) TEXTAFTER
5. (04:31) TOCOL
6. (05:52) TOROW
7. (06:00) CHOOSECOLS
8. (06:38) CHOOSECOLS and XMATCH rather than FILTER function to dynamically choose columns from a table.
9. (08:38) CHOOSEROWS
10. (08:55) VSTACK
11. (08:55) Append Excel Tables in a dynamic way.
12. (09:50) HSTACK
13. (09:50) HSTACK and VSTACK to create a single cell report
14. (11:55) WRAPCOLS
15. (11:55) Worksheet formula to Pivot a data set.
16. (13:26) WRAPROWS
17. (14:31) DROP
18. (15:51) TAKE
19. (16:05) EXPAND
20. (16:39) EXPAND to create column in proper data set from column or row headers in a cross tabulated table.
21. (17:52) Summary
22. (18:21) Closing and Video Links