Excel Dynamic Arrays (How they will change EVERYTHING!)

[@LeilaGharani]

These life-changing updates are available in Excel for Office 2021 and 365. If you'd like to learn by following a structured course: www.xelplus.com/course/new-excel-functions-course/

[@alexkim7270]

I must agree. Life changing!

[@MahmoudHafez]

WOW! This is amazing, the life is definitely a better place now. Thanks Leila, I'm already a participant in insider fast channel but had absolutely no idea abou that untill I watch your video. 👏🏻👏🏻👏🏻👍🏻

[@Ottmar555]

What really caught my eye is the wonderful huichol art you have in your room.

[@Brushoi]

Wooooooow!! OMG

[@kaisarbhat5432]

It is totally something new for my For me it is very useful I love it

[@chipturner495]

This is an incredible leap forward in working with arrays! Thanks for continuing to provide real time-saving, efficient excel tips!

[@LeilaGharani]

You're very welcome. Yes it's definitely an incredible leap forward. Can't wait until dynamic arrays are fully rolled out....

[@ironhandcreative5603]

I never expected to say "OH MY GOD" out loud while watching a video about Excel, but here I am.

[@Rijzvr3226]

😂😂😂😂😂

[@lakecharles6]

🤣 me too

[@taimoorkhan8203]

I was always afraid of index and match functions till you came around and with help of your videos, now I am known as excel expert in my office.

[@mmc9305]

Very impressive! Can't wait for MS to make it available to everyone in Excel.

[@millerodin3498]

I know Im asking randomly but does anyone know a trick to log back into an instagram account..? I stupidly lost my account password. I would love any assistance you can offer me.

[@josephalaguna]

wow, I was about to do it the old way and then I got distracted by something and then this video rolled up and I was astonished!!!! You are amazing Leila. You have such an eloquent way of delivering the content in a meaningful and practical way. This saved my butt.

[@LeilaGharani]

Thank you, Joseph! I'm glad it was helpful.

[@robertflynn7416]

Thanks for sharing Leila, this will be a huge time saver for those of us who regularly work with complex Excel spreadsheets (which need to remain user friendly)!

[@paulmcdevitt2450]

Yet another fabulous video from Leila. You speak and explain incredibly well. There are a lot of other excel 'wizards' out there but they get into so much over the top commentary instead of simply focusing on making it simpler and easier to understand. Thanks

[@LeilaGharani]

Thanks for the kind words Paul! I'm really glad you find it useful.

[@miguelencanarias]

WOW!! This is a "Thank you Jesus!" moment! That was fantastic. I cannot wait! Too bad my customers are not likely to update to a new version if there is licensing money involved.

[@kreedur]

BRILLIANT. I saw so many examples of Index, Small, If, functions but were for ranged data not for actual tabled data. This was wayyy simpler. TYVM.

[@dasrotrad]

Another game changer. Thanks to Microsoft for continuous improvements to the products. And thank you Leila for bringing all this to us, as always, in very clear understandable tutorials.

[@soniccheese01]

Going to give intermediate users of Excel a whole new World of Fun! Thanks Lelia for the usual clear and professional video.

[@alexh.4842]

Well, when u're thanking MS team for introducing the incredible functions, I want to thank u Leila -- the goddess of excel -- very much appreciated for your videos, and I'm going through them one by one.

[@tiyu3504]

Thanks Leila. Been following you for more than a year and feel privileged by subscribing your channel as you always keep me up to date with all the trend happening in excel world.

[@LeilaGharani]

Thank you for being a continuous supporter! I will do my best in 2019 to keep you updated.

[@CarmenGonzalez-oh9pt]

Wow, I'm not surprised you say that is a life-changing , is phenomenal, thanks for sharing !!!

[@UjangBoyor]

That dynamic data validating dropdown is the one i have been seek for years!!

[@OzduSoleilDATA]

WOAH!!!!!!!!!!!!!! 😍 Incredible! Dependent Drop Downs!

[@Rathna_Embroidery]

Not even paid tutors can not teach like this. Thank you

[@gerrp]

Great! Thanks for sharing with so simple explanation!

[@davegoodo3603]

Hi Leila, I discovered I had Dynamic Arrays today! I was trying to get the Frequency function to work, I was using CSE. Almost by accident I put in the formula again and hit Enter and Shaazam! It finally worked perfectly, so there it is, Dynamic Arrays. Thanks for your reminders over recent months! Great video.

[@ExcelForFreelancers]

Great Job Leila, Looking forward to working with these for sure.

[@LeilaGharani]

Thank you! I can't wait to get some time on my hands to experiment more with them.

[@bperez8656]

@@LeilaGharani Yes more example videos of these !

[@SergioAlejandroCampos]

Whoohoo! These new functions change all the way we have worked with arrays. Thanks Leila.

[@LeilaGharani]

Yes :) no more control shift enter needed.

[@wmfexcel]

Great examples of demonstrating the power of dynamic arrays. :) @Mike, no worry, your expertise in Excel is always needed. We know that... for whatever reason, the pick up rate of new features of Excel is super slow in workplace. In a recently in-house training, none of the participants know about Excel Table, which was introduced since Excel 2007. Given that I guess 90% of regular Excel users still have no idea on dynamic arrays in 2028. :P

[@avsimmons72]

Yup....2023 and just became aware today. Honestly.... I was just peachy without it. If I had my way, I'd go back a few versions but have no control over that in my job. Created a big headache for me today, taking several hours to wrap my pea brain around why what worked just 3 months ago for 2+ years suddenly no longer functions as designed. I think they should have 2 Excel products. One for pros where you can get all your bells and whistles and a basic ass version for the casual user. 😂

[@tonyutchannel]

Wow! Thanks to all the people who made this possible and thanks to You Leila for these video lessons. Excel completely changed my working life!

[@jadlteif8143]

WowwwwwwwwwwwwwwW!!!!!!! EDIT: I agree with others that python solves this problem very quickly. However, in many big companies, it's hard to get access to python if you're not in the IT team, so Excel saves the day.

[@andreacazzaniga8488]

Python is open source

[@jadlteif8143]

@@andreacazzaniga8488 What I meant is that it's not always possible to download a shell in which to write and execute code. I'm not talking about modules that you can download. Even that, I'm pretty sure that if you had access to PyCharm for example, you might still need admin rights to download a module and use it. I hope it's clearer!

[@voxorox]

"Free" doesn't matter in a company where dev tools are tightly controlled. It's not about cost. It's about risk.

[@dillmon1]

If you are in the windows environment you can down any version of python using win python a portable python that runs anywhere you place it

[@javierRC82857]

I understand what you mean. With anaconda you can install Python without privilege, pandas can do the job. But if you want share the results with yours co-workers is more effective use this new features of Excel.

[@saurabhrathi2057]

Thank You Leila, You are making life easier for corporate employees around the world

[@qaqcfiles5483]

Hi Leila, I just want to thank you for all that you do in excel. I do have trouble figuring out with my count. For example, I have the below table and I need to count how many A’s, B’s and so on. S. No. Variable Variable Code 1 X1 A 2 X2 B 3 X3 C 4 X4 A 5 X2 B 6 X1 A 7 X4 A 8 X4 A 9 X1 A 10 X1 A Basically, I have 7 A’s, 2 B’s and 1 C. What if I need to count A, B and C excluding duplicate variables and what if I have several variable and code columns. Looking forward for your assistance. Thanks!

[@wolfmanbfg7334]

Each single video you upload deserves thumbs up ... Thanks for Sharing.

[@jeroendekk1]

I am getting a bit annoyed these functions are not available to everybody 6 months later...

[@ibrahimkhayat8046]

Imagine 2 years later...

[@EhabMonther]

It's 2020 and they are not available yet !

[@StockSpotlightPodcast]

2021 and still nothing. As great as this video is, it doesn’t really help even the average corporate employee 😭

[@GrainneDuggan_Excel]

Unique is something I could use almost daily! I hope it comes available very very soon. Thanks for the video Leila

[@Project_88]

Bravo Microsoft- now you're copying google sheets! Excel should hav had these 5 years ago. What a shame!

[@thearchibaldtuttle]

Well, it‘s a different story when you can build something new and learn from all the mistakes others have made.

[@Project_88]

That's what you call new, yes.

[@innosanto]

@@Project_88 new is google sheets I think he means.

[@fahadgilani630]

I am awarding you the title of "Miss Excel"..., You are making excel more excel for me.

[@trucid2]

The hashtag sign? Jesus Christ.

[@alokkumar1189]

Obviously this is amazing feature....we waited long for it. In between the way you explain Excel is marvelous!!! Keep it up... Your are super rocking instructor

[@TheGLGibson]

Stop using a spreadsheet as a database. Use a database.

[@robinw77]

That would change everything

[@andali555]

Agree that databases are better for developers but not for end users. They struggle so much using DBS

[@gumbilicious1]

For some reason I like making relational databases in excel complete with a GUI front end. I get bored at work. I also made a version of asteroids in excel, so it’s not about the efficiency or even using appropriate programs for your work. I just wanna see if I can do it Besides everyone I work with is too tarded for databases

[@Naitsabes68]

@@andali555 SQL Is easier than excel formulas

[@andali555]

@@Naitsabes68 yeah for developers like us. But the product we design is for end users. If they can't use it easily it's a waste of time

[@مقدادحديد]

My appreciation is increasing for you every day You make Excel interesting and easy. Thank you

[@JNelson_]

Use python. Please.

[@nosuchthing8]

You dont have to program every thing

[@JNelson_]

@@nosuchthing8 Yes.

[@priyobrata2]

your slow but steady way of talking helps us very much to understand.

[@lazalazarevic6192]

We already have these formulas in Google sheets so it is nothing new. And of course every serious data analyst would never use Excel but rather Python or R for their analysis. Thanks anyway. Good luck with promoting expensive ways to do this.

[@theghostmachine]

You don't know how precious these small formulas are. Not every company uses Python, but almost everyone uses Excel

[@sirraymondluxuryyacht8131]

Finally a title by a KZbinr that isn't clickbait! Nice video ;-)

[@moscalej]

looks sad learn python

[@misterwill3625]

I followed along and it worked out great. These dropdowns are so handy. Thank you.

[@cafeta]

Excel should be taught in school, this is one o the most important tool you ever use in the enterprise world.

[@himanshunagpalca]

Game changer, Excel is evolving... changes we have seen in last 5 to 10 years is mind blowing... thanks a lot for sharing these details..when it is expected to launch..

[@LeilaGharani]

Agree - lots of great changes so far and a lot more to come soon - I believe changes are currently in beta for half the people on insider fast - once testing is finalized there, roll out will start.

[@vijayarjunwadkar]

Just this week, got the latest upgrade of Excel, supporting all the dynamic array functions and this video helped me get a hang of them! Clear concise explanation and leading through each step is what makes you an EXCELlent teacher! :-)

[@ckokse]

This is what I call a significant improvement! Thanks for the heads up but now of course I cannot wait to get my hands on it.

[@igwejustus386]

Thank you, Leila, for bringing this to us, you're indeed a lifesaver and a life changer.

[@LeilaGharani]

My pleasure. I'm glad it's useful.

[@michaeloloishuro6915]

Years of Excel have been achieved in this new features. Just Great.

[@connorhaiflich8380]

You Don't know how long I have been looking for this. Helped so much!!!

[@LeilaGharani]

Glad it was helpful, Connor!

[@omnipop4936]

Well sure, but the longer videos do have one distinct advantage: namely, that since they take us on a longer journey, we get to be accompanied by your lovely countenance and wonderful, soothing voice for _thirty-five minutes straight._ That's a big win in my opinion. Cheers!

[@LeilaGharani]

😘

[@assamiyou]

Best Excel instructor in the world today

[@LeilaGharani]

You're very kind Jonas! I'm glad you like the videos :)

[@70pjsmith]

OMG, that was brilliant. Thank you thank you thank you Leila for another great video. My only regret is I came across it after I learned the longer/older way of doing it (successfully, but very challenging to get it correct). I cannot believe how much simpler this is. You are my Excel hero!

[@LeilaGharani]

You're so welcome!

[@williamschneider7093]

I have been working with excel since it was first introduced. I have done the complicated for so long. This is excellent tool. Thanks Leila

[@LeilaGharani]

It really is William. I hope Microsoft will roll it out soon to everyone on Office 365.

[@rakeshkumarmadella7955]

Thanks!

[@damilolaoguntula231]

This is the best news ever. I use lots of nested formulas and this will go a long way to make my work very easy. Thanks

[@DiegoZaccariotto]

WOW! That is awesome! I really hope this gets rolled out very, very quickly!!!

[@awesh1986]

I have watched this in Mr. Excel's Channel - Bill Helen but I learned something new that is how to refence dynamic arrays in formulae using the hash key. It's just awesome.

[@harishramesh1351]

It is't working on 2013 version. What version ur using?

[@bigpapa112998]

This is the first video that I have seen from you and mind blown. I am subscribing to your channel. Thank you

[@Sundevil1996_]

Leila, thank you so much for evangelizing this new benefit. Ironically, my short stint using Google sheets had me already using Unique, Sort and Filter functions..I look forward to using them in Excel. And I hope I can. As a Mac user, I can vouch for the fact that MacOS experience is dramatically neutered vs the Windows version. I beseech you to lobby for these changes for that platform as well, Given your client list, I am sure you could quickly prioritize the half dozen or so functions to complement formula evaluator, fast-fill and the old "add zero" to or multiple by 1" to convert numbers stored as text to numbers. Those are the tradeoffs that create an un-level playing field IMHO. Thanks again, Leila!

[@psvinaybabu1]

Excellent simple formula not ever thought of making so simple. Thanks for sharing such beautiful updates.

[@alexcastas8405]

Just found this video and it’s really good. I just used filter and unique recently to generate a list of the last 5 numbers in a column always being added to, this allows me to find the average of those last 5 for something else I was generating. Super good. Loving these new excel functions 👌

[@egottschalk]

Impressive! I'm glad I watched this video, since I didn't really care for dynamic arrays, they were too complicated. Complements to the Excel Team for developing this new easy way to deal with arrays formulas and thanks Leila for making it easy to understand and apply these new functionality. All the best!

[@LeilaGharani]

Glad you enjoyed it, Eduard!

[@cadarshakmrathod]

LEILA, we are very thankful to you. actually I often get praised by my boss & colleagues but I pass on this to you. thank you very much.

[@LeilaGharani]

Thank you Darshak for your support. The hard work is implementing what you've learnt - so well done to you :)

[@TamraShorts]

Super advanced and super complicated formula are super easy now. Thanks Leila for this video.

[@leopickard7090]

I have finally got dynamic arrays!!!! Yes so stoked. Been waiting so long!!

[@LeilaGharani]

Excellent! Now the fun begins :)

[@Luciano_mp]

Sensational ..... Unbelievable .... Ball show will make things much easier everyday. Excel is a fantastic tool. Leila, thank you for this excellent class.

[@jatin5607]

Thank you Leila finally my search for a perfect excel teacher has ended. I have to say its extremely interesting and you make it so easy to learn.

[@LeilaGharani]

Thank you very much for the kind words! I'm happy you find the tutorials helpful.

[@jatin5607]

@@LeilaGharani It's my favourite helpline out there on Excel. Hope to see some stuff on PowerBI too.

[@grosner]

Fantastic! Been using filter(). I must of missed Excel’s documentation about using the hashtag. Very helpful. Thank you. Please bring us more videos like this one, showing ways to use the new dynamic hooray! array functions in charts!

[@AccessToPower]

That is going to save so much time. Thanks Leila for sharing this example of how we will be able to use this in the (hopefully) near future.

[@JimFikes]

Old dogs love learning new tricks like this! Thanks, Leila. I love your videos (and so do my students).

[@LeilaGharani]

Thank you Jim for your support and sharing the videos with your students. What topics do you teach?

[@JimFikes]

@@LeilaGharani I retired from teaching business computing classes in a university for several years. While I'm waiting for my wife to retire, I've started teaching in a local high school. I take students through the Microsoft Office certification courses (Excel, Word, Word Expert, Excel Expert, PowerPoint, Access, and Outlook) and help many of them achieve the MOS Master level certification.

[@LeilaGharani]

That's amazing Jim! So many people at universities here have very basic Excel knowledge after graduation. It's great that you're teaching Office classes at high school level. These are the skills for the real world.

[@JHatLpool]

I know this video was made in 2018 but these new functions that are described, they are really good. Back in the 2003 era, we used to create formulae that were so long, they exceeded the size of the buffer in Excel. These formulae were almost impossible to test. OK, I went off and taught myself some VBA. But, yes, the demonstration in this video is a really nice one.

[@muhammadsadiq8885]

Excel 365 new functions are awesome.

[@LeilaGharani]

Absolutely! And they keep coming. 😊

[@muhammadhaneefattari5314]

Everytime when I watch your tutorial I get to learn something new, Thank You Leila..!!

[@BrandonMiller-ce9yl]

Its 2023 and my mind and world HAS changed. Why have I not been aware of these until now. This solves so many struggles I have had.

[@pjdacs72]

Wow, I just spend two days trying to do this and then stumbled on your video. Thank you this is exactly what I needed!!!!

[@LeilaGharani]

Glad I could help!

[@pjdacs72]

@Leila Gharani By any chance do you have a video on getting part of my spreadsheet shared online somehow? I know there's a bunch of videos and ads for products. But after the success with your last video I should save myself some time. Essentially I created an inventory list managed by my office manager. There are two pages that are filtered lists for the two buyers to use.

[@ebenezeraffulenu2752]

You are so amazing. Following you has really changed my career

[@LeilaGharani]

I'm happy to hear that!

[@ahmedeldorry]

The best excel instructor , thank you so much for your super easy explanation

[@DPaquette]

This is awesome, thanks for sharing. Thanks Microsoft for listening to what we have been asking for .... a long time.

Extraordinaire! WoW! Finally they did it. This was a nightmare. Now accessible to dummies.

[@barrychristie921]

All those tricks I have made over the years to achieve this using hidden sheets and columns will just poof into thin air. Amazing.

[@RizkyRamdhonaPutraBasandid]

as i watch this, the formulas is already release, these formulas are crazy.. very useful, thanks for explaining to us about the difference

[@ExcelID]

The tutorial is very good and easy to understand, thanks

[@Prophet1022]

You are a public servant and true hero.

[@pbalakrishnan7210]

OMG. . . OMG. . . It change everything about the way the spreadsheet is used. Mr Mike Girvin's "ctrl+shift+enter" book is now antique. The older way of finding unique list is frustrating, as one has to refresh everything time and again to use the old array formula function combinations. Now are the gone days. Coming generations won't bother at all to see back and to know about how all started. Thanks to MS team. Leila, hope you give more insights into the new group of functions and its explorations on various backdrops

[@glenroy1410]

Great as usual. Its amazing to see how users have shaded what Microsoft does and respond. Someone probably saw your video and took on the challenge. Good Show!

[@kironmona]

Dynamic Array Formulas Really phenomenal. Life will become super smooth once these will be officially released.

[@anton9004]

That was a great demo. Had no idea excel could to that. Cheers

[@simoncox4788]

Excellent once again - have now used this to great effect in quite large data to return the contents of an account, and from there, a journal

[@kenmcmillan2637]

Totally awesome! This time changer will be a lifesaver!!! Thanks so much for sharing this exciting new feature(s) Leila!We really appreciate all you do!!Kenny Mc

[@damianlerma1334]

OMG! this is so cool, i been teaching excel for a couple of years and i have always wonderer why they just dont go with easy ways, because is difficult to teach and learn all formulas interactions and manipulations, but with this, we have a new world coming!

[@a.achirou6547]

That's awesome. Mind blowing huge productivity gain !!

[@amitdidwania3714]

You are superb... The way you explain Excel is really praiseworthy. Thanks a lot for all your videos.

[@yoliedepaz3340]

Wow! Thank you again, Leila! That was super fast and easy. You’re a big help in my job. God bless you!

[@LeilaGharani]

I'm glad it's helpful for your work.

[@PBlas01]

I am taking one of your (paid) courses and noticed the link to this video. WOW! This is great information... thank you for sharing and explaining how to use and apply the new formulas. I have Office 365 and happy to see that I have it. Awesome! -- BTW: I thoroughly enjoy your online courses. Thank you so much.

[@LeilaGharani]

Awesome, thank you!

[@chuckb.4627]

These new formulas are a game changer. Cant wait to make use of them.

[@LeilaGharani]

Yes, really great changes. I'm very excited too.

[@markboulton954]

I had never been aware of these updates to Excel until today - I've landed on your videos and found that, unbeknownst to me, MS have finally written built-in functions that I've been using almost identical VBA functions for, for all these years!

[@bakthapuri]

Simply Awesome I can say... Thank you leila for being updated us..

[@MrNuranga]

This is not the first time I watched this video. Can't wait to get the new set of functions and formulae in Mid July. Thank Leila!

[@rn_ain]

i almost cried watching this. 😂😂😂😂 i try very hard to follow those two video. Now seeing this make me wanna flip my table. 😂😂😂😂 BTW thanks for this video and other video too. Very helpful.

[@sdsa007]

Wow! so much productivity! Thanks for the speed up!

[@LeilaGharani]

You bet!