Channel: Excel Campus - Jon

Category: Education

Tags: excelarray functionsexcel functionsexcel campusexcel formulastextsplit

Description: Microsoft just released 14 new text and array functions for Excel. Join me for this live training where I explain what the new functions are and how to use them in formulas. Click the Set Reminder button above to get notified when the event starts. You will also be able to ask questions through the chat. The most useful and popular functions will likely be TEXTSPLIT, TEXTBEFORE, and TEXTAFTER. I'll explain how they replace some existing formulas that require multiple nested functions and make life much easier! The 14 new functions are: 1. TEXTSPLIT 2. TEXTBEFORE 3. TEXTAFTER 4. VSTACK 5. HSTACK 6. TOROW 7. TOCOL 8. WRAPROWS 9. WRAPCOLS 10. TAKE 11. DROP 12. EXPAND 13. CHOOSEROWS 14. CHOOSECOLS Join me at 11:00AM Pacific Time on Friday to learn some new functions that will save time with your everyday Excel tasks. Download the file I used during the event: excelcampus.com/wp-content/uploads/2022/03/14-New-Functions-Text-and-Array-Live.xlsx March 23, 2022 Update: The functions should now be available to EVERYONE that is on the Insiders Beta channel for Microsoft 365. The flighting can take a while to roll out and you might need to restart Excel to see get the updates. Here's a link where you can learn more about the Office Insiders program. insider.office.com Get our Excel Pro Tips eBook and weekly newsletter with Excel tips at: excelcampus.com/free Learn how to use pivot tables, dashboards, Power Query, Power Pivot, macros, and more on our Free Excel Training Webinar at: excelcampus.com/webinar