14 New Excel Functions: TEXTSPLIT, VSTACK, TAKE and More

14 Excel functions for text and arrays: TEXTSPLIT, TOCOL, VSTACK, TAKE, CHOOSECOLS and more. 📥 Download the practice file: 🎓 500,000+ enrolled in our courses. Learn these and the other modern functions in Master Excel's Essential Modern Functions 👉 TOCOL and TOROW turn a range into a single...

Intermediate - 11 min - AI & Data - Leila Gharani

The full course: Learn Excel & Sheets free

What you'll need

• Laptop stand: Screen at eye level for long study sessions.
• Noise-cancelling headphones: Focus through long video lessons.
• Second monitor: Video on one screen, practice on the other.
• Wireless keyboard and mouse: Comfortable for hours of typing.

Books

1. Excel Formulas and Functions for Dummies by Ken Bluttman - View on Amazon
2. Storytelling with Data by Cole Nussbaumer Knaflic - View on Amazon
3. Excel VBA Programming For Dummies by John Walkenbach - View on Amazon
4. Interactive Computing Series by Kenneth C. Laudon - View on Amazon

Next lessons

• 3 Cool Effects You Did NOT Think are Possible in PowerPoint | Morph (11 min, Leila Gharani, Intermediate)
• Excel for Data Analytics - Full Course for Beginners (660 min, Luke Barousse, Beginner)
• Stop Writing Huge Excel Formulas. (Use ONE DOT Instead) (10 min, Leila Gharani, Intermediate)
• Pictogram Charts in Excel: Add Icons to Bars [Rounded + Dynamic] (16 min, Leila Gharani, Intermediate)
• The Excel Timeline chart you'll actually keep using (free template included) (11 min, Leila Gharani, Intermediate)
• Microsoft PowerToys Tutorial: Free Tools for Windows 11 (13 min, Leila Gharani, Intermediate)
• TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included (13 min, Leila Gharani, Intermediate)
• 7 Excel Mistakes You Must Stop Making (15 min, Leila Gharani, Intermediate)