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

No video

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

Рет қаралды 33,816

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 49

@agroasesor1 Жыл бұрын

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

@user-li7mq5hp9g 3 жыл бұрын

One of the best channels in KZfaq thank you!

@ExcelGoogleSheets 3 жыл бұрын

Thank you!

@sandip_bettereveryday 3 жыл бұрын

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

@ExcelGoogleSheets 3 жыл бұрын

What's really annoying is that after adding all these great features they didn't add a way to combine arrays on top of each other or next to each other. That's one things that's still missing to have a killer spreadsheet app.

@khanabdussabur8604 10 ай бұрын

Awesome! Thanks a lot.

@elricho72 3 жыл бұрын

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

@s.s.malagi275 3 жыл бұрын

Very good illustration of formula and tricks.

@ExcelGoogleSheets 3 жыл бұрын

Thanks!

@frankcklin 3 жыл бұрын

perfect demonstration

@patrickschardt7724 3 жыл бұрын

Great in depth tutorial

@avenewconsulting1118 2 жыл бұрын

why dont you use pivot tables?

@masoon3373 3 жыл бұрын

Thanks!

@joshuamanampiu6489 Жыл бұрын

Excellent!

@jamesepace 2 жыл бұрын

Really well done explanation of this!

@ExcelGoogleSheets 2 жыл бұрын

Thank you!

@mo-brifs-infos6631 2 жыл бұрын

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

@relaxationparadise4466 Жыл бұрын

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

@IanDobson-D360 3 жыл бұрын

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?

@ExcelGoogleSheets 3 жыл бұрын

Power Pivot could do it, but that's not really the point of the video.

@mariecourlier3332 2 жыл бұрын

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)?

@ExcelGoogleSheets 2 жыл бұрын

SUMIFS(numbersrange,salesreprange,"Olivia",regionrange,"midwest")

@mariecourlier3332 2 жыл бұрын

Thanks for your reply. However, that won’t work as I want the region to appear in the array next to the sales people Column A> sales people Column B> region of the sales people Column C > sumifs of the sales people for each region

@ExcelGoogleSheets 2 жыл бұрын

@@mariecourlier3332 I'm not sure about your layout. Please make an example in Excel online and share with edit permissions here. www.office.com/launch/excel

@mariecourlier3332 2 жыл бұрын

let me know if you have access. Thanks again for your great video and help

@ExcelGoogleSheets 2 жыл бұрын

There is no link

@cric8482 3 жыл бұрын

So clever !!!

@youngistanrocks2146 3 жыл бұрын

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..😊

@ExcelGoogleSheets 3 жыл бұрын

There is new feature recently released that allows this, but it doesn't work well yet. I'll try to do a video on this.

@youngistanrocks2146 3 жыл бұрын

@@ExcelGoogleSheets Thank you so much..

@ngdzung6284 3 жыл бұрын

Thanks

@vbarchild 2 жыл бұрын

Excellent

@ExcelGoogleSheets 2 жыл бұрын

Thank you! Cheers!

@findthetruth3021 3 жыл бұрын

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.

@bogdanescu86 3 жыл бұрын

You can always try r/excel on reddit

@findthetruth3021 3 жыл бұрын

@@bogdanescu86 could you please share the link of it with me?

@cric8482 3 жыл бұрын

Often, when the solution is difficult to find the reason is the data are badly formated. (Personnal experience)