Mastering Excel in 2024 - New Functions!
ฝัง
- เผยแพร่เมื่อ 2 ก.ค. 2024
- 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.
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
Mastering Excel in 2024 - Best Time-Saving Tips: • Mastering Excel in 202...
50 Ultimate Excel Tips and Tricks: • 50 Ultimate Excel Tips...
20 Essential Excel Functions Video: • 20 Essential Excel Fun...
Introduction to Excel Video: • Introduction to Excel
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.
Amazing as always
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!!
Awesome information
your videos are always informative👏👏
Useful functions. And you explained them very clearly. Well done 👍
Very nice video 📹 👍 Thank you for sharing your knowledge
I love this
Thanks
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
Will these functions replace the Excel Power Query function when working with CSV type files? Excellent video, thanks!
Just posted on my LinkedIn =)
The text functions are literally the only useful ones in this video. The others seems almost useless unless your data is straight up crazy.
So Sele, 1 video every 3 months?
It has been slow. Stay tuned!
pretty useless formulas tbh but thx for video
Exactly, the useful ones stay the same or else everyone will face problems. The AI addons are useful though.