Officeinstructor

Пікірлер

@ameliabatiancila Күн бұрын

this is amazing. thanks for sharing. can i apply those codes in google sheet?

@nadermounir8228 3 күн бұрын

Very nice one. Happy new year Mourad :)

@michaeldingee743 9 күн бұрын

Here is a formula that doesn't eliminates the need for a Helper Column =PIVOTBY(Data[Region],Data[Customer],Data[Sales],SUM,0,1,1,1,1,BYROW(Data[Region],LAMBDA(r, SUBTOTAL(103,r))))

@Officeinstructor 9 күн бұрын

Yeah, this is the one I mentioned in my intro calling it complex for average user (compared to my solution). There is another one even more complex (not talking about myself for sure) but I have an absolute preference to my solution. Nothing wrong with a helper column that you can even hide.

@GeertDelmulle 8 күн бұрын

I’ve been using the helper column technique demonstrated in this video for a long time now (inside the FILTER function). Now, if you only have to calculate this “vis(bile?)” attribute once, your internal filter criterion calculation is the most elegant & efficient, IMO. OTOH, calculations like these rarely stand alone: if you need this dependency in 2 calculations (e.g. reports or aggregations) then your method requires the implicit helper column to be calculated every time. That makes it less efficient. I think I’ll stick to the calculated helper column technique demonstrated by Nabil - as he mentioned: you can always hide it (I know I do).

@tamersalem7542 7 күн бұрын

Wonderful, always brilliant and creative

@IvanCortinas_ES 9 күн бұрын

Great solution Nabil. Available to all users. Thank you for sharing it.

@Officeinstructor 9 күн бұрын

You are most welcome. Thanks for watching

@yousrymaarouf2931 9 күн бұрын

Fantastic

@Officeinstructor 9 күн бұрын

Thanks for watching!

@adin6429 9 күн бұрын

Such a genius and yet simple solution to a seemingly impossible problem to be solved

@Officeinstructor 9 күн бұрын

I assume it's the simplest solution

@kebincui 9 күн бұрын

Great video. Thanks Nabil 👍❤

@Officeinstructor 9 күн бұрын

Glad you liked it

@tamersalem7542 9 күн бұрын

Fantastic ❤ thank you for your help 😃

@Officeinstructor 9 күн бұрын

You're most welcome. Glad you liked it!

@IvanCortinas_ES 13 күн бұрын

The whole process was spectacular. The presentation was absolutely professional, as always. Thank you, my friend, for this great job. Happy holidays!

@IvanCortinas_ES 13 күн бұрын

Great form!!! All the tutorial processes should be familiar to Excel users. Excellent proposal, Nabil.

@SanjeevKumar-nm2ty 13 күн бұрын

Outstanding! Very much informative and easy to follow.

@generalengineersengineerin1475 13 күн бұрын

thanks sir

@Tsr2412 15 күн бұрын

Thank you so much 👌👍

@AkioAsahi-b6w 17 күн бұрын

Nice information thank you Mr. Nabil💯

@ramywilliam7132 17 күн бұрын

Very insightful, thank you!

@redhaakhund1271 18 күн бұрын

👍👍👍👍👍🙏

@IvanCortinas_ES 18 күн бұрын

Another great tutorial, Nabil. The entire calendar project is excellent, including flags, holidays, conditional formatting and forms-scrollbar-controls. Very complete and professional, a trademark of the house, my friend. Thank you.

@robertlohman8947 19 күн бұрын

Sorry, but I do not see a link to download the file.

@Officeinstructor 19 күн бұрын

I said "Coming Soon"... Please be patient

@maximocenturion1297 4 күн бұрын

@@Officeinstructor estaría bueno que subieras pronto el archivo, ya que a algunos nos hace falta saber como hacer alguna de las funciones mencionadas en el video.. muchas gracias

@souravgupta3145 19 күн бұрын

How to remove or hide filter icon in heading in ppt.

@abdollahwahd5202 19 күн бұрын

Thank You So Much

@hocdarasne5100 25 күн бұрын

what happen when i copy the graph to power point does it still work?

@nsanch0181 29 күн бұрын

Beautiful formula. Little advanced for me but I can still follow along and learn thank you.

@kebincui Ай бұрын

Very creative 👍

@kebincui Ай бұрын

Excellent video. Thanks Nabil 👍❤🌹

@kevincecchini Ай бұрын

I have an issue, it gets stuck on a tab name. maybe I will figure it out. ok thank you. great instructions.

@kevincecchini Ай бұрын

I got it. I see that each time it is used, the original tabs must be renamed. so I will have to save my template with unique names for the tabs that will be renamed the same, over and over. which is fine, this helps on big jobs. thank you.

@IvanCortinas_ES Ай бұрын

The solution using the old interface method for pivot tables is always spectacular, even if you've seen it many times. Thanks Nabil, for showing this great material as always!!!