Breaking News! We FINALLY get the New Excel functions we've been Wanting!

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/new-functions-file (requires Office 365)

[@gvinodnair]

Leila, any clue how to separate individual characters in the words to different columns? Which technique/ formula can be used?

[@Hamza-yv6uy]

Really appreciate all your contents , i would just to know how can i found them ? my version : Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20278) 64-bit

[@rudiansyahsyah9738]

classroom speak extention basic symbol room commonecation software quality utility year 2022 / 2023 🏛🌍🌎🌏

[@rudiansyahsyah9738]

classroom speak motivation presentasi sys data com master extention room commonecation software speak english 🏛🌍🌎🌏🏛🏪🏬🏭🏯🏰💒🏩🏨🏧🏦🏥🏤🏣

[@rudiansyahsyah9738]

classroom speak basic symbol room speak english quality utility desktop end laptop motivation presentasi year 2022 / 2023 quality in sys data com master ecosystem personal classroom good presentasi you commonecation software microsoft logo end hardware the internet.com master parent Xxelplus label in diskcover desktop end laptop the txt generation monitoring windos |"m FTK studyn school computer index presentasi in speak english ok 🏛🌍🌎🌏

[@MrSupernova111]

For those of us who have been using Excel for many years and were forced to learn long and complicated functions, including array formulas, these new functions are mindboggling! Thanks!

[@stenionet]

I am using Excel since 1997 and now I am using office 2007. I hope to upgrade soon.

[@bxyhxyh]

@@stenionet wow.

[@JJ_TheGreat]

@@stenionet I was using Excel 2007 for a long time. When Office 2021 came out, I finally upgraded. I am happy I have some of the new dynamic array formulas - but I will probably get jealous of these new formulas. At least I still have Power Query to be able to manipulate data - which is a lot better than using the old, long formulas - especially the old array formulas.

[@MrSupernova111]

@@stenionet . Bruh...! lol

[@mattschoular8844]

@@stenionet Please confirm Office 2007 will run on my Commodore 64.... Just kidding... For $129 USD, we share an MS365 subscription within our company. It is so worth the annual spend

[@gvinodnair]

These functions were just introduced yesterday by the great Excel development team to the Office insider community. Although I have seen a few other early bird MVPs introduce this function to the audience, I haven't seen anyone who explained it in an easy-to-understand way like you Leila. As always you have presented outstandingly well and concisely. Keep it up!

[@juanrsosa]

Totaly agree!

[@saberarami123]

what do I do to include them in my office 2021?

[@Hamza-yv6uy]

How can i found them ?

[@leechrec]

Daaaaaayyyyyuuuuuummmm bruh! Never in my life did I ever think I would be excited about Excel functions but these are dope!

[@LeilaGharani]

That they are 😁

[@electroone8281]

I totally concur with this. I took up learning VBA due to a lot of these types of formulas missing from Excel. Glad to see them continuing to add to the collection of Formulas in Excel.

[@ericm9305]

😂

[@jg9353]

You ain’t lying!

[@ivanvukovic5108]

This is how you know you grew up

[@kickthesky]

The CHOOSECOLS function is going to be awesome! This makes doing FILTER SORT tables even better because I won't have to create staging tables that only include the data I want to show in the filtered and sorted table. I can easily create a subset of the original data and display only what I want to display. Such a game changer!

[@ktalwandi]

You are amazing, Leila. Your course on VBA made me fall in love with programming and I nailed two interviews yesterday. Python was super easy to learn after VBA and now I can finally see some hope in my life. Thank you so much.

[@LeilaGharani]

That's great to hear!

[@Sekoleyte]

Where is her vba course? Are there any video in youtube. If you can share it, i will be thankful

[@LeilaGharani]

Right here: courses.xelplus.com/p/excel-vba-excel-macros

[@stuartkay1393]

Out of curiosity, how long did it take you to learn VBA? And then subsequently Python? It's something I've avoided up until recently but it would be good to put into perspective the time frame I'm looking at

[@ktalwandi]

@@stuartkay1393 depends on how much time you're willing to spend. I don't have a life and enjoy pace learning and I was able to complete VBA in less than three weeks. As for Python, I am still learning it and it has been about two months and I can say that I am at intermediate level. If you have never done any sort of programming, it might take you more time. Don't tell Leila but I've skipped the capstone projects in her VBA course lol. 😂

[@keijo456]

I've been waiting for these Textbefore and Textafter functions! No more tedious left, right and mid! Thank you Leila for letting us know!

[@mmohon]

Can we get a textbetween too?

[@jayholm9504]

Thank you for presenting these new time saving functions. As always, you explained them so well with real world examples of how we might apply them. You are a Master!! Thank you

[@LeilaGharani]

You're very welcome!

[@JimFikes]

I agree, at first glace, TEXTSPLIT will be the first new function that I can easily integrate into my regular routine. Thanks, Leila, I heard about these new functions but waited for your video. You always do a great job of adding simplicity and clarity to everything related to Excel.

[@Bill_Woo]

You are once again awesome. What a great site this is, and as a pro I have spent an enormous amount of time on webpages for Excel. And had you not published this, I would not have learned this - because other informational sources have too much *unimportant* info. The thing about this channel's videos is that IT SHOWS ONLY USEFUL AND PRACTICAL INFORMATION. And very, very well explained, simply enough to not leave me confused, but rapidly and efficiently delivered.

[@RonDoh202]

WOW! - in a lot of our reports the emphasis in on text, names, organisation etc., top choice TEXTSPLIT, but also CHOOSECOLS - amazing - Liela does it again! Thanks Leila

[@Shiffo]

My favorite is also Textsplit. Using Left, Right, MID, LEN usually was a bit tricky to write. This saves a lot of complexity.

[@jasonbb2010]

So the text split function cannot split single word like only first 3 digs?

[@Shiffo]

@@jasonbb2010 i think you will need to wrap LEFT(,3) into text split.

[@aemero7477]

All are amazing! I would say the TOROW AND TOCOLUMN functions are what I was looking for recently. Thank you so much!

[@catatoa]

Thanks

[@knotingo]

I’ve made a table a few days before and i even thought “this have to be done much easier” and now there it is! :-) Hope the update will be installed soon on my business devices. Thanks for this “breaking”! 👍

[@MrSupernova111]

You can already do much of these tasks without functions in Excel using the options in the Data tab and Power Query. Also, as Leila mentioned, some of these functions are just replacing older functions which can also get the job done but aren't always as flexible. Depending on your level of expertise most of these new functions are just a niche.

[@devonbradford9217]

A bit arrogant to call these niche. Most Excel users dont work in power query but their business needs would value these new formulas, without having to have expert excel/BI skills.

[@hockeyfightjudge1]

Excel's recent(ish) developments have been AMAZING. Xlookups, dynamic arrays like unique/filter, upcoming searchable auto-completing lists. And now text split and choose cols, which will have many use cases! Super exciting. Please Excel team: dependent dropdowns / multiple dependent dropdowns??

[@learningtechie2964]

Waiting for google sheets to bring these in too .. had used excel formulas for over 15 years , but just 2 years back realised how much more powerful google sheets is ..

[@Sehvan.]

Thanks!

[@LeilaGharani]

Thank you!

[@vijayarjunwadkar]

OMG! What an amazing "array" of array functions! Can't wait to have them generally available! BTW, difficult to choose a favourite yet, because for now all seem to be equally useful! Thank you Leila for this nice demo with clear explanation!👌👍

[@hidayatkhan4453]

You are not only beautiful but your way of teaching goes deep in heart. I feel like soon I'm going to be expert in excel. Im a big big duffer when it comes to technology. Being an accountant I have to use excel almost everyday. Credits goes to you Leila.

[@LeilaGharani]

You are so welcome.

[@matthiasheuer]

Perfectly explained, Leila Gharani simply has it down, I always enjoy watching her videos.

[@alcoolbc]

all of them... been programming for 35 years. Love your work on arrays. I'd about given up on excel but now see why 365 is fantastic. The way it handles dynamic arrays and indirect addressing is awesome. Thanks for your videos...

[@LeilaGharani]

Great to hear!

[@harshitsharma7998]

Amazing 😍😍and Great functions and always your great explanation

[@LeilaGharani]

Thank you so much 😀

[@scateam9087]

Hi mam, I had no ideas about excel, 3 months back when I joined my new work. Thanks to you mam . Now IAM confident to work on Excel. God bless u.

[@pwerda]

Fantastic developments, but there still remains the challenge of having spill natured formulas to function within a table. Thanks Leila for the great explanation of underlying principles. Can't wait to use them.

[@AbhaySingh-vc2fk]

Wow, everyone was wonderful! I have been doing this with long long formula.... My heart goes to say THANKS TEAM EXCEL only after *Thank You Excel Queen Leila* !!!!

[@donald-parker]

I get the value of the new functions, especially targeted at non programmers, but it would be nice if they added formal regex support. I've had my own UDFs for regex for several decades, but it would be nice if it came "out of the box"

[@mariamardon4084]

TEXTSPLIT is my favourite! Thank you for sharing. You are my favourite go-to for all Excel tips.

[@omotossso]

Looks like we are having an SQL class. Thanks for the tips, I am updating my Microsoft already... I love this and you got much of my respect Leila Gharani ❤❤❤❤ I love the TextSplit, Expand, are so dope, I have used similar functions onTextBefore and TextAfter are in PQuerry before. Nonetheless, having them in Excel is so much cool RN..... WOOOOW

[@j.etl.h4362]

Leila, your videos have become a reference in our company. Thank you for your brilliant work.

[@AzulonKaiba]

I love this new functions. They behave like many properties with a Pandas dataframe in Python. In others words an Excel user will get use to Python easier.

[@LeilaGharani]

👍

[@AzulonKaiba]

@@LeeMbarrett Something I would want to see, it's the integration of Regex without VBA that's a powerful feature of Google sheets.

[@dixonstroi]

So exciting. This is a huge trove of functions that replace writing complicated nesting fcns and custom fcns. TEXTSPLIT/BEFORE/AFTER are huge! No more RIGHT LEFT LEN FIND nesting! And then WRAPROWS/COLS replacing the OFFSET(,ROW()*wrap_count+COL()... or weird Power Query workarounds to reorganize sloppy pasted data! LET made all of that a lot easier, but now being able to cut down on LET lines is another game changer. If only these fcns were around 5-10 years ago, I'd have had weeks more productivity! So many exclamation points, but this is so exciting for a nerd like me. I know I'm in the right place to share that. Thanks for breaking these down, Leila! Glad we can count on you to bring us the latest Excel developments.

[@sammucai8462]

Great new functions! Especially the TEXTSPLIT ! Thanks Leila.

[@Nonas63]

Favorite? The TOCOL function. In the past it was a nightmare to add several coloums into one. There are some workarounds to get this done, but they are very time consuming. Thank you Leila for these great news and for the very nice video!

[@JJ_TheGreat]

Yes, I totally agree with you!

[@equestathon9618]

Powerquery was always the answer.

[@Nonas63]

@@equestathon9618 Yes and no. I have used PowerQuery for those tasks. But you have to press always the button to get it done. Then it dose not work if you open your Excel from a Sharepoint and other user are not familiar with PowerQuery and simply forget to press the button. It works but is not so convenient ass this new formular (and it is much easier to extend the area).

[@SustainaBIT]

Do You Have any idea how much I was striving for such group of equations?!!!,, I have been doing these same functions the completely hard way, this is a life savior and THANKS A TON for posting this video, I never regret watching any of your videos

[@JesseHardesty]

I created a very complex dashboard in Excel to use for my job as a Training Supervisor, tracking training schedules, tracking documents, staff lists, a matrix and so on. This will eliminate so many of the confusing formulas I had to come up with and make it easier to add/remove people from certain parts when staff changes.

[@jeffogren9953]

I remember 20 years ago learning the manual way to do some of these functions. I still have to look up old notes that I can now toss - huge time saver!

[@fadamarcus4457]

Leila, just come across your channel and i have learned a lot of insightful useful things on excel. Good job!

[@EnlightenedOne90]

I wish I could find someone who gets excited to see me the way Leila gets excited to see new excel functions.

[@thaer_me]

I don't understand why some people disliked this video! Thanks a lot, Leila. My favorite of these new functions are textsplit and take

[@spoondi1]

textsplit is a very good one which I was looking out for a long time to replace many other formulas.

[@VelosoDiecast]

This is one of the most useful videos I have ever watched!!!! Thank you

[@majdyazigi8185]

Thank you Liela, for me chose column is the favorite

[@mundonemesis]

Thank you Leila. New functions to make life easier. Now let's use them! :)

[@roaranddance9832]

I was trying to press 'like' every minute of yhe video, sooooo cool and love the way you explain it! Thank you so much.

[@alfredtomiamubiaya3330]

All the new functions are cool for me. Thanks for the heads up Leila and kudos.

[@McKaySavage]

WOW WOW WOW! Those new arrays solve 90% of my complex workarounds from my spreadsheets and replace most of the top 5 custom lambdas I built and use. It also catches up finally with some key Sheets functions. Once these are fully available, these will be daily uses for me. Super impressed with Excel’s development team this last few years. Thanks for sharing this!

[@LeilaGharani]

You're very welcome!

[@trufflehunter58]

Mind blown! The Excel Team is on fire! Thanks, Leila, for your impeccable presentation.

[@fabio2680]

Absolutely fantastic! It took me a lot of work to pile up tables of diferent sizes. Now it´s just... H/Vstack ?!? No word can express how I´m happy. Thanks for bring this up in such an easy way to understand. You´re simply the best !!

[@rkrajeev2357]

Leila excellent video. Keep it up and help everyone with these simple but useful functions.

[@MinnieGreenie]

Hah! We need these functions yesterday! Thanks Leila for this good excel news!

[@sachinrv1]

These functions are so simple to use. No text to column, no transpose, no offset. This is more than one can expect. Time for everyone to switch to Office 365. Thanks Leila :)

[@kristinamelnichenko4372]

It's the CHOOSECOLS and CHOOSEROWS for me. Thank you for another great video!

[@9762342538]

Thank you Leila for sharing these amazing Excel function to ease our day to day activities at work.

[@LeilaGharani]

You're so welcome!

[@vitruvian_man]

I'm pumped about TEXTSPLIT!

[@chrissears9912]

These formulae will be so useful in so many ways. I have so many worksheets where I've had to write these the long way!! I'm glad to see Microsoft investing in Excel capability -- it is becoming so much faster & easier to create powerful workbooks, which are readable. Thanks for sharing these!

[@hrleif8994]

Yes, Textsplit is it.! But think i still need Right. The names example. I want column with 1.Names, 2.empty or middlenames, and then 3.last Names. Found your channel a few weeks ago. Love Excel, and now this channel.

[@samuelanane-kyei4822]

Wow, I'm so happy to hear about TEXTSPLIT, TEXTBEFORE and TEXTAFTER because of what I normally do with Excel. I think Excel is becoming more powerful each year. Thanks for this video.

[@cesarprieto395]

CHOOSECOLS is definitely my favorite. Thank you Leila 🙌

[@LeilaGharani]

👍

[@SL-og1qf]

Thank you so much, you’ve turned my tedious job into something I enjoy. It’s so insane that we have all these people in data/admin jobs that are never trained to use it to its full potential.

[@angeiring]

OMG, finally! Some of those functions I was waiting for years, literally. Nice vídeo, as always!

[@hassanraza-vb5ss]

My fvt function is choose column. Thanks alot Leila!! :)

[@PradeepKumar-mh5ht]

Really amazing formulas, hats off to you Mam for introducing hidden gems of Excel !

[@growth2509]

I like CHOOSECOLS! I'm thinking of a lot of possibilities with that one. Thanks for sharing!

[@jscomputergenius3834]

Hello Leila, I really appreciate you very much for your superb presentations. The level of discernment that God bestowed upon you is beyond imagination. Thanks a million!!🙏🙏🙏🙏🙏🙏

[@pegmolter3542]

My favorite - TEXTAFTER - I've been doing this with a convoluted formula that requires two helper columns for years. Can't wait to see these rolll out!

[@jasonipfatsiong2062]

FAVOURITE…VSTACK…thanks update Leila..take care

[@Shantanu_Dam]

You are always awesome ma'm. Thanks for introducing us with the new functions. Lots of love from India...

[@LeilaGharani]

My pleasure 😊

[@sadinbangla747]

Thanks Sister for teaching.

[@moodrow1497]

Your videos are awesome. I didn't realize how much I DIDN"T know about Excel until I started spending time on your channel. Thank you for the great videos and the hard work you put into them.

[@LeilaGharani]

Glad to have you aboard, Robert!

[@bulliethepirate]

Amazing new functions. Seriously Excel is such an amazing software. And Leila you are such a good educator !

[@dougcx6]

I’m excited about combining the new functions Torow/tocol,vstack and text functions!!

[@nnaku3444]

Thank you for being a leader in expanding the limited horizon of our knowledge leading to a great future. Awesome.

[@lisahochhauser5176]

Ok... these are all amazing... the end was something I'll start using right away. Vstack + Expand - This will really help me with all the dirty data I get!

[@danielsandovalarias6192]

I like all of them! lol. I didn't know the Text functions. Yesterday I had to use =Left(x,find(x)) to substract a word before the first comma. These text functions seem easier to use.

[@markpodesta4605]

Thank you Leila. Hopefully the new functions are rolled out very soon.

[@LeilaGharani]

I hope so too!

[@georgewhite3379]

Look at the excitement in Leila's face! :) I feel you! Can't wait to take advantage of these. About time! Not sure about WRAPROW and WRAPCOLS. Don't think I ever had a need for those. Thanks for making this vid. You're awesome as always. xoxo

[@yogeshsali]

Leila you are awesome, You make our work so easy.

[@sachinrv1]

My favorite are, all functions taught by Leila. SUPER EXCELLENT VIDEO. Many thanks :)

[@MrBuzzing]

WOW! Excel is very much alive and doesnt stop growing. NICE!

[@GhazaliConsulting]

Thanks Ms. Leila you're my inspiration

[@SpotlightImpact]

Love TOCOL!! Have already used it a few times!

[@shahbazraza8605]

Such an insightful video, My favourite formulas are Text split, tocol, torow and Vstake

[@rocqitmon]

the text split before and after are grep functionalities that needed to be on Excel since everrrrr!

[@CortezLu84]

Beautiful formulas! Some are game changers because of the simplicity. Thanks !!!

[@ishaq79]

i'm as exited as you to see this new functions, thank you! bless you!

[@endysagita31]

Thank you for sharing, Ms. Gharani. I have tried some of these functions, and it was awesome

[@ankursharma6157]

@Endy Sangita How were You able to try these new functions? I also have an Office 365 Subscription . . but I don't have access to these yet.

[@matthiaskublenz4764]

Amazing News! Thats exactly what i have been searching for. Textsplit and VStack will be used from now on Thank you for this video

[@LyleStacpoole]

unbelievable the code that must go behind these functions - textsplit is definitely the one I would use to separate single columns into multiple columns of data ... thanks Leila ...

[@LeilaGharani]

Yes, the knowledge required to do this. Just brilliant minds at work.

[@abaniahmadbani]

THIS IS DOPE!!! Kudos to whoever working this new Excel features, and of course to you too for this very insightful video!

[@LeilaGharani]

Glad you enjoyed it!

[@DavidGarcia-ph8rs]

Thank you for sharing, functions explained so well. Greetings from Mexico

[@jakobkrygersrensen74]

This is amazing! I've been looking for good ways of doing exactly these things for years!!

[@vijay00001]

You're really more than excel dictionary.. Thanks for your efforts

[@georgekiplagat9251]

VSTACK/HSTACK & choosecols are my favorite. thanks for the video

[@epca_aq6511]

Fantastic! Thank you Leila!

[@johnj2041]

Thanks Leila, very useful stuff. I will check these out further

[@niclasmogensen7560]

TOCOL, VSTACK and the TEXT-funktions made me hyperventilating for one hour! Many thanks for an energizing and sharp demo!

[@christomashofski9160]

I agree these are great additions to Excel, and boy would they have saved me a lot of laborious hours on a large consulting job I recently finished. I gotta say to the Excel development team, great works guys, but what took you so long? You're about 60 years late to the party! The basic concepts behind these functions, including the meaning of the arguments and what they accomplish, were first introduced in the mid-1960's by a guy named Dr. Kenneth Iverson as a part of his Ph.D. thesis before he joined then-giant IBM. They appeared in his programming language known as APL but used a much simpler form wherein, rather than writeout the words "take," "drop," etc., they were summoned with concise symbols known as "primitive functions." It's great to see Dr. Iverson's way-ahead-of-its time concepts appear in a popular usage form. Now, Excel team, you've only got about 25 to 30 more such clever function primitives to create to catch up to where Iverson was in 1965. I eagerly await! 😊

[@awesh1986]

Awesome I also loved the text split function. More power to ask those excel power users

[@dlep9221]

Wow, wonderful! I often dreamed of functions like these. Thanks a lot Leila for this presentation and M$ for these innovations. I agree TEXTSPLIT !

[@wayneedmondson1065]

Awesome Leila! TEXTSPLIT looks great. No more FILTERXML/SUBSTITUTE complexity. TOCOL, TOROW, VSTACK and HSTACK look super useful. Hope they get released sometime soon. Thanks for demonstrating. Thumbs up!!

[@LeilaGharani]

I hope so too, Wayne!