Mastering Excel in 2024 - New Functions!

preview_player
Показать описание
See the newest functions available in recent releases of Excel. Microsoft created several new functions for rearranging data, manipulating text, and selectively pulling data from arrays. Here are 14 new functions to help you master Excel in 2024.

00:00 Contents:
00:08 CHOOSECOLS, CHOOSEROWS
02:48 DROP, EXPAND
04:31 TAKE
05:52 HSTACK, VSTACK
07:42 TOCOL, TOROW
09:02 WRAPCOLS, WRAPROWS
10:26 TEXTAFTER, TEXTBEFORE, TEXTSPLIT

#seletraining #excel #masterexcel
Рекомендации по теме
Комментарии
Автор

Great tutorial to get a quick and concise overview of array functions.

graemegourlay
Автор

TEXTSPLIT is my second killer, essentially parsing a string by delimiter - so replicating the data parsing menu options in a function. Fantastic.

Kudos to Sele, but Excel devs are the real MVP!!

jonr
Автор

Useful functions. And you explained them very clearly. Well done 👍

LSN
Автор

Very nice video 📹 👍 Thank you for sharing your knowledge

nadermounir
Автор

Hi, good job! I ould like to know, is thee a way to exract with the take function some rows from the middle or just another row other starting row from beginning/end

financnifitness
Автор

Will these functions replace the Excel Power Query function when working with CSV type files? Excellent video, thanks!

augustussnodgrass
Автор

The text functions are literally the only useful ones in this video. The others seems almost useless unless your data is straight up crazy.

watchingyoutalk
Автор

pretty useless formulas tbh but thx for video

GrizzlyDaniel