David Benaim

Пікірлер

@svetozaryolov235 11 сағат бұрын

I am new in Excel Power Query. Just found out how it is powerful. I wondered how cell parameters a list like features. I thought that it is query. Thank to your video, I found out that they are simple cell parameters with list Data Validation. Many thanks and good luck!

@michaellee9609 Күн бұрын

Hi David, this is a great video. I'm stuck with producing a stacked column chart. Am I able to do it direct from the data source like how you did with the other charts? My dashboard is on another sheet, by the way.

@michaellee9609 22 сағат бұрын

Or is pivot tables the only way to do a stacked column chart

@TheManMshow1 5 күн бұрын

How do I do this

@learnspreadsheets 5 күн бұрын

Hi the video shows how to do it. It assumes you already know how xlookup works, if you are new to xlookup then another video might be helpful

@TheManMshow1 5 күн бұрын

@ I am new to xlookup do you have a video for that please send link if so

@TheManMshow1 5 күн бұрын

Is their a way I can speak to you one on one about all of this and what I’m actually trying to do

@TheJuiceSurachai 6 күн бұрын

Google sheets Useful content ever, Thank you from Thailand

@learnspreadsheets 5 күн бұрын

Thank you!! I really appreciate that 😃

@alissamelsopp5025 9 күн бұрын

Amazing tutorial! Will be visiting your channel for all my sheets needs :)

@learnspreadsheets 5 күн бұрын

Good to know! We will be here for when you need us 🙃

@surfboard32 10 күн бұрын

Just found this. This is great. Thanks!

@learnspreadsheets 5 күн бұрын

Glad you like it yay!

@agelee89 11 күн бұрын

I wonder how you did that you can see in drilled page all Provinces available in slicer. In my case when I use drill through it automatically narrows down the elements in slicer to just one.

@NzStudio00 11 күн бұрын

Impressive, but I don't like using slicer instead I use other functions and dropdowns.

@learnspreadsheets 11 күн бұрын

Thanks! Fair enough, dropdowns can also work but linked to a Pivot in another way, or via formulas

@xyclos 12 күн бұрын

Excellent video, Thanks a lot

@learnspreadsheets 11 күн бұрын

Nice!

@ssivasmr 12 күн бұрын

I have 3 columns headers, any examples?

@learnspreadsheets 11 күн бұрын

This same logic should work, but with a few extra steps

@kennethstephani692 13 күн бұрын

Great video!

@learnspreadsheets 11 күн бұрын

Glad you enjoyed it :)

@rafikalsaoub8709 13 күн бұрын

please, can you put your word document .then we can prctice on it thanks a lot

@learnspreadsheets 11 күн бұрын

Yes you can get it via the link in the description: Example files can be found here: www.xlconsulting-asia.com/youtube-files its one of the only word docs there

@IvanCortinas_ES 13 күн бұрын

Great video. I love that LAMBDA inside GROUPBY. It opens up a lot of scenarios... Thanks Ben!!

@learnspreadsheets 11 күн бұрын

Yes so many possibilities! Love it too :)

@DavidWhite-ci2tc 17 күн бұрын

A great run through David, 👍

@learnspreadsheets 11 күн бұрын

thankssss

@Minerbium62 18 күн бұрын

JUST CRAZY. The part that assigns the column types without referencing the column names FLOORED me. Original, effective and not overly complex. Kudos.

@learnspreadsheets 11 күн бұрын

Glad you like it! Power Query is so powerful, you really can do some cool things with it!

@InnKogNeeto 18 күн бұрын

Hi where is the link to download this ppt file please? I don’t see it in the description. Thank you

@learnspreadsheets 11 күн бұрын

Download the demo file here (it is called Timer): www.xlconsulting-asia.com/youtube-files.html I updated the description too sorry!

@InnKogNeeto 11 күн бұрын

@ thank you so much. I did recreate it and it was amazing tool to use in my trivia work game. 10000000 props to you!!! You saved our game event!

@IvanCortinas_ES 19 күн бұрын

Great tutorial David. I imagine that this year, when Excel celebrates its 40th anniversary, they will surprise us with something big. We'll have to wait and see.

@learnspreadsheets 19 күн бұрын

Ooh yes! Excel is one year younger than me, turning 40 soon! 🙃

@IvanCortinas_ES 19 күн бұрын

@learnspreadsheets You're a baby. I am 51, but always learning...

@asvathi7868 20 күн бұрын

Really great ❤

@learnspreadsheets 19 күн бұрын

Thanks for saying!

@IFIM247 22 күн бұрын

You helped me so much

@learnspreadsheets 19 күн бұрын

Glad it did!

@tommyharris5817 23 күн бұрын

Fantastic video

@learnspreadsheets 22 күн бұрын

Thanks! Glad you like it!

@GoneSailing78 24 күн бұрын

Great video, thanks.

@learnspreadsheets 22 күн бұрын

Glad you liked it! Yay

@geotojo 25 күн бұрын

Double click drill down functionality not working

@learnspreadsheets 19 күн бұрын

Strange I just rechecked & it works for me

@AlanAnderson-ai 26 күн бұрын

I love how you cover so much content so quickly. All of these were very valuable learnings. I am trying to use the brackets to aggregate filtered data across multiple tabs, like this: =query({tab1; tab2; tab3}, "Select * where col1 = 'test' "). It is working great, but the issue I am seeing is that the dynamic data is not sortable in the new sheet. Is there a way to make these dynamic arrays sortable using an interactable table (Not by changing the query by adding sort and filter arguments)?

@learnspreadsheets 19 күн бұрын

Thanks for saying, happy to help! Hmmm if you want to autosort them you’d need to use a function, =SORT could work if you don’t want to use the QUERY parameters, I have another video on the query parameters!

@mrjuaco 26 күн бұрын

Thank you very much, I learned a lot with your lesson, very good video.

@learnspreadsheets 19 күн бұрын

Glad you did!

@ebenezerasare9934 29 күн бұрын

you are the king of Groupby, pivotby

@learnspreadsheets 19 күн бұрын

Hehe thanks so much! Another vid coming soon 😃

@ecfraser 29 күн бұрын

Thats awesome

@learnspreadsheets 19 күн бұрын

Glad you like it!

@EhabGheidan Ай бұрын

Thank you so much for the efforts in doing this video, it is really amazing

@learnspreadsheets 22 күн бұрын

Thanks!! Glad it’s useful for you

@kebincui Ай бұрын

Brilliant, Thanks David 👍

@learnspreadsheets 22 күн бұрын

Glad Koh like it!

@AnisurRahman-h9k Ай бұрын

Same Problem, In my admin portal showing only 3 option: Capacity setting Refresh summary Help + Support So how to get this tenant setting. Help please

@learnspreadsheets 22 күн бұрын

It seems like you don’t have access & someone else in your organisation either needs to do it themselves or give you admin access to PowerBI

@IvanCortinas_ES Ай бұрын

Excellent tutorial, David. These features have been a considerable improvement over pivot tables. Thanks for sharing.

@learnspreadsheets Ай бұрын

Glad you like it! Check out my other videos on GROUPBY! I've got a whole series of them :)

@DJ-pn9te Ай бұрын

so bad......RIP Excel

@learnspreadsheets Ай бұрын

I don't think Office Scripts in its current iteration is the strongest, I love Power Query and that is very underutilised, but I'm pretty sure that Excel will live on for many more decades!

@siddhantbhuwania8982 Ай бұрын

How to get this in matrix format like in a normal pivot table we can add two fields in rows?

@learnspreadsheets Ай бұрын

Hello, the example you ask for is mentioned in the video, using PIVOTBY and then HSTACK in the "row fields" to combine two columns. This article explains in text format with a downloadable workbook too: www.icaew.com/technical/technology/excel-community/excel-community-articles/2024/excels-groupby-and-pivotby-functions

@siddhantbhuwania8982 Ай бұрын

@learnspreadsheets Thanks a lot for sharing. I will check & see if it works as per my requirement

@sabinamartin220 Ай бұрын

I am using the employee attendance record template in Excel. I want to add some extra leave types. How do I make the new leave types color the days on the calendar view?

@learnspreadsheets Ай бұрын

Hi, I'm not familiar with the attendance record template sorry, but conditional formatting > Highlight cell rules > Text that contains should work. You need to add a new rule for each text entry

@IvanCortinas_ES Ай бұрын

Great tutorial, David. Thank you!!!

@learnspreadsheets Ай бұрын

Yay! Glad its helpful, check my series on GROUPBY / PIVOTBY for more tips on them!

@kebincui Ай бұрын

Brilliant! Thanks David 👍

@learnspreadsheets Ай бұрын

Glad you like it!

@joyce1551 Ай бұрын

You're awesome David! The way you have made this video is just the mind of a genius! This helps me a lot. The video that I understood the most about query builder!!! Please continue to make more videos!

@learnspreadsheets Ай бұрын

What a lovely comment to read! I'm glad it was helpful, its one of my favourite spreadsheet techniques, I use it regularly! I made a similar video for an Excel version, but the formulas a bit more advanced.

@joyce1551 Ай бұрын

@@learnspreadsheets I'll surely recommend your channel. You are the best, David! You are excelling way and beyond!

@thebesttechnical3608 Ай бұрын

Thanks a lot for this simple yet powerful explanatory tutorial

@learnspreadsheets Ай бұрын

Thanks so much for the comment! I'm glad you like it

@AurélieNathalie-x9r Ай бұрын

Thank you for this video! it interested me a lot and helped me too

@learnspreadsheets Ай бұрын

Im glad you liked it!

@BigChief31290 Ай бұрын

No syntax errors, but I don't see the new column...

@learnspreadsheets Ай бұрын

I'm sorry, its hard to say without seeing it, you can email me on [email protected] if you'd like more help

@kebincui Ай бұрын

Brilliant👍❤, thanks David

@learnspreadsheets Ай бұрын

I'm glad you enjoyed it :)

@larsenmoura2427 Ай бұрын

This is some of the worst instructions I’ve ever seen in my life please find a new job

@learnspreadsheets Ай бұрын

I'm sorry you feel that way but many, many other comments seem to say the opposite, so I think for the most part, people find it helpful.

@oscarsuka6510 Ай бұрын

Hi David. Please share this spreadsheet

@learnspreadsheets Ай бұрын

Hi, the link to download my files is in the video description, please let me know if you cannot find it.

@jerrydellasala7643 Ай бұрын

Link to file still missing. 😠

@learnspreadsheets Ай бұрын

Apologies, the link is there now. Let me know if you have any issues

@IvanCortinas_ES Ай бұрын

Thank you for this video, David!! Great functions for all levels.

@learnspreadsheets Ай бұрын

Glad you like it! There are more videos coming about it!

@jonathanroy6258 Ай бұрын

Thank you so much, great info. I would advice to slow down a bit for us non-professionnals, besides that, awesome work

@learnspreadsheets Ай бұрын

Thanks, I'm sorry it's a bit fast, my newer videos are a bit slower, but also remember you can change the speed at which you watch them

@kassiowifried Ай бұрын

Good job 😊😊😊

@learnspreadsheets Ай бұрын

Thanks glad you like it!

@tamersalem7542 Ай бұрын

Fantastic ❤Please send an Excel sheet to benefit from the wonderful content in all your videos. 🎉

@learnspreadsheets Ай бұрын

Thanks! I can't share a sheet, but there are workbook examples on my website, link is in the description

@tamersalem7542 Ай бұрын

Fantastic ❤

@learnspreadsheets Ай бұрын

Thank you! Cheers!

@anthonyarjona5323 Ай бұрын

Hello, Following your training on Tuesday, December 3 at 4:30 p.m., I have a question: I have an Excel cell that contains: 20 / 5. When I use the formula =TRIM(NUMBERVALUE()) it gives me the result: 45432 while I want the result to be 4. For another cell containing: 105 / 6, using the same formula, we get: #Value! while I want the result to be 17.5. Is there a solution? Thank you

@learnspreadsheets Ай бұрын

Hi, a few things are happening. 1. It converts 20 / 5 into a date this year so 20/5/2024. TRIM and NUMBERVALUE won't help. You must enter =20/5 to return 4, I think starting with = in the 2nd example should work too, but let meknow if you have issues

@hichamhadj9640 Ай бұрын

Brilliant

@learnspreadsheets Ай бұрын

Thanks!

Ең жақсы KZbin

Пікірлер