Officeinstructor

Пікірлер

@sscire 10 сағат бұрын

Thank you! Yes, certainly a good explanation that promotes the use of AI in Office 365. Too bad that its use is extremely limited to only 60 "credits." I found Copilot rather limited in interacting with the worksheet. Many tasks have to be done manually, such as copy/pasting the example. In any case, even externally-and perhaps for the moment in a better way-Copilot allows you to tackle the subject by creating fairly complex VBA code with few syntactical and/or logical errors. I would say that for an amateur, with a medium/low knowledge of the VBA language, Copilot is a valuable "assistant." In my tests, Copilot's functionalities within Office 365 are less efficient than externally and, in any case, it is not efficient in generating correct code for LAMDA, LET, and other helper functions. Have a good job.

@IvanCortinas_ES 10 сағат бұрын

Copilot is certainly a tool that can help improve certain processes and should be taken into account. Thanks for sharing, my friend.

@padrickscar 5 күн бұрын

You have no idea how long I've been looking for this 😭 THANK YOU!

@marknugent5406 5 күн бұрын

Easily the most useful demonstration of the LET and LAMBDA functions in combination with the usual everyday functions most of us use. Very well presented Nabil, I was able to follow the flow and logic of the LET function. Thank you for posting this tutorial.

@brianxyz 6 күн бұрын

Thank God for Power Query!

@kebincui 8 күн бұрын

👍❤

@kebincui 8 күн бұрын

👍❤

@zarmeza1 9 күн бұрын

awesome

@RICHIEG25 14 күн бұрын

Anyone know if you can use this for creating folders on OneDrive?

@khanabdussabur8604 19 күн бұрын

Great! Thanks s lot Nabil.

@abbottgirl82 21 күн бұрын

THIS IS AWSOME AND LOVE HOW YOU EXPLAINED IT ALL. I was looking forward to creating this but my version of Office doesn’t have VLOOKUP. Would you happen to know how to do the same in GoogleSheet?

@havizarga8457 23 күн бұрын

when i pressed f6, i didn't move to the sheets tab but it went to the ribbon or went to bottom of excel like for zoom or macros. how to move to the sheet tab?

@mlb333mlb 26 күн бұрын

I get the error message "The server application, source file, or item can't be found, or returned an unknown error. You may need to reinstall the server application." when trying to embed the pivot table.

@TMPFounder Ай бұрын

Thank you so much, man. (The best is yet to come, as you said (y) )

@clarke6814 Ай бұрын

I really enjoyed this, but I'm sad that I won't be able to click the slicers and have the charts change while presenting.

@ameliabatiancila Ай бұрын

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

@nadermounir8228 Ай бұрын

Very nice one. Happy new year Mourad :)

@michaeldingee743 Ай бұрын

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 Ай бұрын

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 Ай бұрын

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 Ай бұрын

Wonderful, always brilliant and creative

@IvanCortinas_ES Ай бұрын

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

@Officeinstructor Ай бұрын

You are most welcome. Thanks for watching

@yousrymaarouf2931 Ай бұрын

Fantastic

@Officeinstructor Ай бұрын

Thanks for watching!

@adin6429 Ай бұрын

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

@Officeinstructor Ай бұрын

I assume it's the simplest solution

@kebincui Ай бұрын

Great video. Thanks Nabil 👍❤

@Officeinstructor Ай бұрын

Glad you liked it

@tamersalem7542 Ай бұрын

Fantastic ❤ thank you for your help 😃

@Officeinstructor Ай бұрын

You're most welcome. Glad you liked it!

@IvanCortinas_ES Ай бұрын

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

@IvanCortinas_ES Ай бұрын

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

@SanjeevKumar-nm2ty Ай бұрын

Outstanding! Very much informative and easy to follow.

@generalengineersengineerin1475 Ай бұрын

thanks sir

@Tsr2412 Ай бұрын

Thank you so much 👌👍

@AkioAsahi-b6w Ай бұрын

Nice information thank you Mr. Nabil💯

@ramywilliam7132 Ай бұрын

Very insightful, thank you!

@redhaakhund1271 Ай бұрын

👍👍👍👍👍🙏

@IvanCortinas_ES Ай бұрын

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 Ай бұрын

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

@Officeinstructor Ай бұрын

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

@Maximo_Centurion Ай бұрын

@@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 Ай бұрын

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

@abdollahwahd5202 Ай бұрын

Thank You So Much

@hocdarasne5100 2 ай бұрын

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

@nsanch0181 2 ай бұрын

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

@kebincui 2 ай бұрын

Very creative 👍

@kebincui 2 ай бұрын

Excellent video. Thanks Nabil 👍❤🌹

@kevincecchini 2 ай бұрын

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

@kevincecchini 2 ай бұрын

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 2 ай бұрын

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

@Officeinstructor 2 ай бұрын

Thanks for visiting, my friend