Mastering Excel in 2024 - New Functions!

Ғылым және технология

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

Пікірлер: 19

  • @graemegourlay2850
    @graemegourlay28504 ай бұрын

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

  • @jonr6680
    @jonr66804 ай бұрын

    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!!

  • @deepk82
    @deepk824 ай бұрын

    Amazing as always

  • @vikaasb2016
    @vikaasb20164 ай бұрын

    your videos are always informative👏👏

  • @vinothkumarmanoharan2317
    @vinothkumarmanoharan23174 ай бұрын

    Awesome information

  • @fireworxz
    @fireworxz4 ай бұрын

    Thanks

  • @LSN8072
    @LSN80724 ай бұрын

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

  • @nadermounir8228
    @nadermounir82284 ай бұрын

    Very nice video 📹 👍 Thank you for sharing your knowledge

  • @KnowledgeNwankwo
    @KnowledgeNwankwo4 ай бұрын

    I love this

  • @financnifitness2583
    @financnifitness2583Ай бұрын

    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

  • @augustussnodgrass8975
    @augustussnodgrass89754 ай бұрын

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

  • @diuliogrings
    @diuliogrings4 ай бұрын

    Just posted on my LinkedIn =)

  • @watchingyoutalk6539
    @watchingyoutalk65394 ай бұрын

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

  • @lydethful
    @lydethful4 ай бұрын

    So Sele, 1 video every 3 months?

  • @SeleTraining

    @SeleTraining

    4 ай бұрын

    It has been slow. Stay tuned!

  • @GrizzlyDaniel
    @GrizzlyDaniel4 ай бұрын

    pretty useless formulas tbh but thx for video

  • @MichaelScott69

    @MichaelScott69

    4 ай бұрын

    Exactly, the useful ones stay the same or else everyone will face problems. The AI addons are useful though.

Келесі