Microsoft Excel Tutorial - Advanced Formula Tricks in Office 365 That Nobody Knows

Learn Microsoft Excel Office 365 advanced formula tricks that most people don't know.

00:00 Initial Spreadsheet Data Setup
01:50 UNIQUE, VALUETOTEXT, FILTER functions
03:50 SUMIFS with Dynamic Arrays
07:35 SORT, LET, CHOOSE
11:40 INDEX Dynamic Arrays
13:20 XLOOKUP with Dynamic Arrays
15:20 TRANSFORM
16:20 SUMIFS with 2 Dimensional Dynamic Arrays

#excel #advanced #tutorial

[agroasesor]

Thanks for your efforts, time and PATIENCE to make this interesting video!!!! Clear voice.
No o background music.
Concrete.
Not hours.
Gracias mil desde COLOMBIA !!!!

[limqhpg]

One of the best channels in YouTube thank you!

[elricho]

What good videos you make, they really are very helpful. thanks for sharing

[sandip_bettereveryday]

Watching this one video is enough to revisit what's there in Excel Dynamic Array functions, that we must know. Thanks a ton.

[s.s.malagi]

Very good illustration of formula and tricks.

[mo-brifs-infos]

well done for your useful information, please I want this practice file.

[mariecourlier]

Thanks !!!! I love the function combining the sort + unique + sumifs. How would you do it with a sumifs based on two columns (in your case Sales Rep plus let’s say region)?

[youngistanrocks]

Hello There,

thanks for providing such a wonderful information regarding the dynamic array in excel. I hope this will apply in both online and offline version of excel.

I have one query regarding the online vesio n of excel might be many of us have. I have two different workbook saved on onedrive and i want to apply vlookup between them by using online version of excel. Is it possible?? Because while doing the same i find my self difficult while selecting the array of the other workbook. Would you be able to give me a solution for that?

Thanks..😊

[IanDobson-D]

One can probably do this a lot easier in Google Sheets using the Query function, could it also be done using Power Query in Excel?

[relaxationparadise]

Brilliant! can you please share the working file sir? Thank you!

[mohrmm]

How can i delete sharing file in excel 365 online web

[findthetruth]

I have an Excel sheet and I have a complicated question in which I couldn't solve by myself for such a long time. so how can I get in touch with you and explain to you so that you can help me on that. Thanks in advance.

[dwarfusinterruptus]

I signed up to get practice files, but never received a link or file to download. Are you just collecting email addresses?

[Leyla]

Why is the formula giving an error?
👇
=SUMIFS((B6:B80/3)^2, C6:C80, "Table")

[Mr.KundanThakur]

Sir please speak most popular language "Hindi"