Видео

guys stuff that has slashes in them like / or even anything with things that windows does not let you name a folder the MD will not make a folder those characters are ( \ / : * ? " < > | ). Also, if there is spaces in between words then it will turn them into seperate folders. Hope this helps

Thank you kind sir!

Doesn't work for windows 11 no bit locker in drop down menu when right clicking drive.

What if present name and changing name of some sheets are same. I am facing this problem getting debug message that try other method present name is same

Thank you

This chart is not dynamic , right? When i Change some data, it won't change the triangle ... right ?

Be aware that you can still copy paste content into these cells if you start your paste outside the range. ie, if a user copies cells A5:D5, they can paste that range into A6:D6.

Super easy! Thank you

can we do sumproduct on text (strings)? If not then which function to use?

Would this work for a shared document?

Wow

Thank you sir!!

Still possible to paste from different file😮

hahaha

FINALLY a useful video! Thank you so much!

Hi , I love your tutorials, the 2nd method with m code is difficult if you dont master it, the first way with pivot table and array functions is a very nice classic solution with excel , greetings from Turkey Bodrum

Great, thanks for sharing

Excellent explanation Nabil. Thank you my friend!!!

BitLocker encryption is only available on Windows 11 Pro, Enterprise. What to do when you only have win11?

Playbill for the win!

thank you

this was great. works without requiring admin rights.

Backwards compatibility with the venerable Lotus -1-2-3 more likely to lure or poach. Back when the two locked horns, MS for some reason didn't add the function or did, but didn't document it. Something else not generally in MS Excel is the equivalent of @CELL("backgroundcolor", B2..B2"), where, say, the formula is in A1. If the colored cell is white, thenreturned value is 0. For any other color, its Lotus Color number value is displayed. (There is another function that does the basic, lazy reporting of whether the cell named is formatted FOR color, but, as with stock Excel, it doesn't say WHAT color nor does it allow coloring.) Something else not by default in Excel (nor in 1-2-3, but is made up for by way of an add-in written in LotusScript, back before 2002): @SETSTYLE(B2..B2,"backgroundcolor", 38). Alternative to value 38, a number manually entered, an @INDEX-@MATCH can be used so that a hunted-for parameter or criteria can "drive" cinditional formatting of a cell - in this example, B2. This add-in makes up for the woeful stock-absence of in-the-GUI conditional formatting in 1-2-3. Those who needed on-the-fly CF had to learn LotusScript or hire a contractor/dev to do it. Tragic, horrid misstep on the part of Lotus. Back in the 90s, the non-Lotus employee developers of the @SETSTYLE add-in said to use it sparingly. I have 10s of thousands in use in any given 1-2-3 workbook, in my 48 GB laptop. (Yes, I still use old, venerable 1-2-3.) It's used offline, never online, so, security is never an issue.

Nice work. Thank you Nabil! 👍

Perfect video Nabil Thank you for your hard work and great explanation :):):)

The OfficeInstructor Training Centre specialises in delivering Corporate Training to companies and organizations of All Sizes, anywhere in the world. For course details and to book a training session, check our website: www.OfficeInstructor.com

fuck useless video

Very helpful thank you

❤

your voice

❤ give the files

Don't Forget ► CHAR(67)

The video is great but how can one download?

reg add HKLM\Software\Policies\Microsoft\office\16.0\common\officeupdate /v updatebranch /t REG_SZ /d BetaChannel Thank it is work. Thank you alot

thank you so much, this is awesome

Thank you Nabil. Useful information.

You the best sir.

Should being on the Beta Channel allow you to the Edit Calendar ribbon? I'm on the beta channel but that is option is still not there.

Thanks for this, but the file still allows a text copied from outside to paste in the protected sheets.... how do we stop this ?

Thank YOU! 💙

Can we run this dynamic pivot table and slicer in slide show mode as well?

your the best dude, i dont like the old ui on 365 office and always send me to stable channel, beta channel deserve more loveee

SPEAK ENGLISH!!!!!!!!!!!!!!

Great video. Question, how would you add the Header row to the final output.

again - great video!

Thanx

Thanx

Excellent information, Nabil. Thank you very much for sharing this Power Point matter.

A very useful video.

The OfficeInstructor Training Centre offers Corporate Training in Computer Applications: 1-At Client Site (North America) 2- Remotely (Anywhere in the world) 3-In Our State of Art Classrooms (in Toronto Canada) To check our course catalog or Book a Corporate Training visit: www.OfficeInstructor.com