Channel: ExcelIsFun

Category: Education

Tags: dropformulas and functionsexcel magic trick 1780highline collegemike girvinemttextsplittextbeforeemt 1780excel is funexcel magicchooserowshstackexcel functionsctrl shift enterexcel funbeta functionsmarch 16 2022torow14 new functionswrapcolschoosecolsexcel array formulasexceltaketextafterexpandtocolvstack14 microsoft 365 excel functionsmicrosoft 365 excelexcel 365excel formulaswraprowsdynamic spilled array formulasexcelisfun

Description: Download Excel File: 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