Browsing Category

Guides

Do things you didn’t know were possible. Do regular things better, quicker.

Excel – Force Uppercase Text in a Column

Forcing uppercase text in a column is sometimes useful if multiple users work on the same file and you want to make this condition by default. Either show an error when they don't insert UPPERCASE text, either make the text UPPERCASE regardless of how they enter it.

Excel – Create a PERSONAL.XLSB File to Store Macros

If you are using Excel VBA you might know this already. Storing macros that work in any Excel file can be done in 2 ways: Creating a macro enabled binary file (PERSONAL.XLSB) that loads when you open any Excel file. Normally Excel doesn't create that file. Creating an Excel add-in (.XLAM, .XLA for older Excel). This is good when you want to personalize existing Ribbons or create a special Ribbon for yourself. In this tutorial we are going to cover the first way since it's the easiest. I might cover the 2nd in…

How To Improve Your Battery Life on Windows 11

The last thing you want is for your laptop to die in the middle of a crucial work project or a Zoom video chat, yet it does happen, despite your best intentions. It's ideal to keep your computer plugged in all the time, but if you don't have your charger, you'll have to come up with another strategy to extend your battery life.

Portable Hasleo Windows ISO Downloader 1.0

Hasleo Windows ISO Downloader is a small application that can help us to download Windows installation 8.1/10/11 ISO from Microsoft's official website. It's completely free, small and doesn't require us to install it, such a small and handy piece of freeware should be put in your toolbox.