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

  Рет қаралды 34,445

Learn Google Sheets & Excel Spreadsheets

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 49
@agroasesor1
@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 !!!!
@ΣυμεώνΠαπαδόπουλος-λ4ο
@ΣυμεώνΠαπαδόπουλος-λ4ο 3 жыл бұрын
One of the best channels in KZbin thank you!
@ExcelGoogleSheets
@ExcelGoogleSheets 3 жыл бұрын
Thank you!
@sandip_bettereveryday
@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
@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.
@s.s.malagi275
@s.s.malagi275 3 жыл бұрын
Very good illustration of formula and tricks.
@ExcelGoogleSheets
@ExcelGoogleSheets 3 жыл бұрын
Thanks!
@relaxationparadise4466
@relaxationparadise4466 Жыл бұрын
Brilliant! can you please share the working file sir? Thank you!
@mariecourlier3332
@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
@ExcelGoogleSheets 2 жыл бұрын
SUMIFS(numbersrange,salesreprange,"Olivia",regionrange,"midwest")
@mariecourlier3332
@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
@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
@mariecourlier3332 2 жыл бұрын
let me know if you have access. Thanks again for your great video and help
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
There is no link
@mo-brifs-infos6631
@mo-brifs-infos6631 2 жыл бұрын
well done for your useful information, please I want this practice file.
@joshuamanampiu6489
@joshuamanampiu6489 Жыл бұрын
Excellent!
@patrickschardt7724
@patrickschardt7724 3 жыл бұрын
Great in depth tutorial
@elricho72
@elricho72 3 жыл бұрын
What good videos you make, they really are very helpful. thanks for sharing
@avenewconsulting1118
@avenewconsulting1118 2 жыл бұрын
why dont you use pivot tables?
@frankcklin
@frankcklin 3 жыл бұрын
perfect demonstration
@khanabdussabur8604
@khanabdussabur8604 Жыл бұрын
Awesome! Thanks a lot.
@jamesepace
@jamesepace 2 жыл бұрын
Really well done explanation of this!
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
Thank you!
@masoon3373
@masoon3373 3 жыл бұрын
Thanks!
@youngistanrocks2146
@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
@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
@youngistanrocks2146 3 жыл бұрын
@@ExcelGoogleSheets Thank you so much..
@IanDobson-D360
@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
@ExcelGoogleSheets 3 жыл бұрын
Power Pivot could do it, but that's not really the point of the video.
@cric8482
@cric8482 3 жыл бұрын
So clever !!!
@vbarchild
@vbarchild 3 жыл бұрын
Excellent
@ExcelGoogleSheets
@ExcelGoogleSheets 3 жыл бұрын
Thank you! Cheers!
@findthetruth3021
@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
@bogdanescu86 3 жыл бұрын
You can always try r/excel on reddit
@findthetruth3021
@findthetruth3021 3 жыл бұрын
@@bogdanescu86 could you please share the link of it with me?
@cric8482
@cric8482 3 жыл бұрын
Often, when the solution is difficult to find the reason is the data are badly formated. (Personnal experience)
@ngdzung6284
@ngdzung6284 3 жыл бұрын
Thanks
@ronyjoseph529
@ronyjoseph529 3 жыл бұрын
How to create the dashboard a table?
@dwarfusinterruptus9314
@dwarfusinterruptus9314 Жыл бұрын
I signed up to get practice files, but never received a link or file to download. Are you just collecting email addresses?
@ExcelGoogleSheets
@ExcelGoogleSheets Жыл бұрын
Those go out for new videos only. Sorry for the confusion.
@mohrmm6046
@mohrmm6046 2 жыл бұрын
How can i delete sharing file in excel 365 online web
@Leyla72
@Leyla72 2 жыл бұрын
Why is the formula giving an error? 👇 =SUMIFS((B6:B80/3)^2,C6:C80,"Table")
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
sumrange must be a range, can't be a calculation.
@Leyla72
@Leyla72 2 жыл бұрын
@@ExcelGoogleSheets Thank you
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
@@Leyla72 Just add this formula in a separate column and then use that range in SUMIFS =(B6:B80/3)^2
@Mr.KundanThakur
@Mr.KundanThakur 2 жыл бұрын
Sir please speak most popular language "Hindi"
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Leila Gharani
Рет қаралды 714 М.
10 awesome Power Query tricks you NEED to know! | Excel Off The Grid
15:44
Excel Off The Grid
Рет қаралды 47 М.
Seja Gentil com os Pequenos Animais 😿
00:20
Los Wagners
Рет қаралды 66 МЛН
ПРЯМОЙ ЭФИР. Золотой мяч France Football 2024
4:41:06
When mom gets home, but you're in rollerblades.
00:40
Daniel LaBelle
Рет қаралды 98 МЛН
Excel Formulas and Functions | Full Course
52:40
Kevin Stratvert
Рет қаралды 1,5 МЛН
10 Excel Settings You Must CHANGE! | Efficiency 365
12:28
Efficiency 365 by Dr Nitin
Рет қаралды 4,5 М.
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
Top 20 Microsoft Excel Tips & Tricks
25:38
Kevin Stratvert
Рет қаралды 775 М.
Excel Settings That ACTUALLY Make a Difference
12:27
Excel Campus - Jon
Рет қаралды 39 М.
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
10:20
Leila Gharani
Рет қаралды 107 М.
When You Should Use the New Excel LET Function
17:18
Leila Gharani
Рет қаралды 766 М.
8 Awesome New Excel Formulas for 2024 | Do you know them?
11:44
Kenji Explains
Рет қаралды 352 М.