How-To Geek
Wall-mounted Home Assistant displays are cool, but you don’t need one
Why is everyone suddenly obsessed with wall-mounted dashboards and control panels in their smart homes? These displays can take the form of touchscreens with controls or E-Ink panels that just display information about your home. For most, the usefulness of such a project is severely limited.
How to use the FORMULATEXT function in Excel
The FORMULATEXT function is often dismissed because it merely transforms a formula into text. However, that raw text is exactly what makes it so valuable. So, stop thinking of it as a one-trick pony—it's the perfect tool for auditing, input control, and logic validation.
Here's how I encrypt my Windows PC without BitLocker
BitLocker is the most common way to encrypt your Windows PC to protect it against data theft in the event that someone steals your PC, but it isn't the only option. If your PC doesn't have BitLocker and you want something more fully-featured than Device Encryption, VeraCrypt is probably the tool for you.
4 New dark patterns added to Windows 11 in 2025
Another year, another long list of changes to Windows that "nudge" you into making choices or adopting behaviors that aren't in your interest. At some point, it really feels like Windows stopped existing to make the actual users of PCs happier, and now serve a different master. I think these changes are the most worrying.
5 open-source projects that secretly power your favorite apps
You've heard that the world's infrastructure runs on Linux, and how important Free and Open Source (FOSS) software is to just about all the technology we enjoy every day, but there are some (to bring out the old cliché) unsung heroes of FOSS without which your stuff just wouldn't work—and you should at least know their names.
Don't set up Linux from scratch, these Turnkey distros do it for you
Self-hosting your own services is one of the best ways to save money on subscriptions and increase your privacy. Since you're running the services on your local network, no one else ever sees the data.
Don't set up Linux from scratch, these Turnkey distros do it for you
Self-hosting your own services is one of the best ways to save money on subscriptions and increase your privacy. Since you're running the services on your local network, no one else ever sees the data.
Windows 11's newest bug just made signing in so much harder
Windows 11 users are getting a frustrating new bug that completely hides the password sign-in option on the lock screen, making it incredibly difficult to log into their PCs. This isn't a total lockout, but it's certainly a massive headache if you use a real password.
Windows 11's newest bug just made signing in so much harder
Windows 11 users are getting a frustrating new bug that completely hides the password sign-in option on the lock screen, making it incredibly difficult to log into their PCs. This isn't a total lockout, but it's certainly a massive headache if you use a real password.
Why do some phones use these weird fast-charging USB cables?
For the longest time, smartphone battery life was a real issue. I remember my first few smartphones basically traveling with me from charger to charger. They would charge at my desk, charge in my car, and charge next to my couch. While phone battery life is now much better, the real revolution has come from fast-charging.
Why do some phones use these weird fast-charging USB cables?
For the longest time, smartphone battery life was a real issue. I remember my first few smartphones basically traveling with me from charger to charger. They would charge at my desk, charge in my car, and charge next to my couch. While phone battery life is now much better, the real revolution has come from fast-charging.
The weird world of Kindle page-turner remotes
So you buy a Kindle and you think to yourself, "I sure would like to turn the pages from way over here, surely there's a solution for that?" Well, to my personal surprise, I have recently learned both that people who want to turn eReader pages at a distance exist (it makes sense when you think about it) and that Kindles in particular have no elegant way of achieving this goal. Hence, the existence of weird and wacky "Kindle page turners."
Please stop using Amazon and Google to run your smart home
Google and Amazon are particularly good at selling the smart home vision, but these platforms have some big drawbacks, too. Consider switching to or starting out with a more capable and reliable alternative, which will save you money and frustration in the long run.
Stop trusting hotel Wi-Fi: Build this Raspberry Pi travel router instead
I use all sorts of software when I travel: a VPN, streaming music apps, cloud storage, and more. I turned my Raspberry Pi into a one-stop-shop travel router that combines all of those uses into one device, so I don't have to worry about them individually on my phone, laptop, or console.
5 Home Assistant integrations you're probably not using—but should be
Home Assistant includes a large number of native integrations that can do everything from allowing you to connect specific smart home devices to tracking daylight hours from sunrise to sunset, so your lighting automations know when to turn on and off. Here are some lesser-known Home Assistant integrations that are worth exploring if you're not already using them.
Used Mazda offering performance comparable to a new BMW 330i for $20k
If you’re chasing performance on a budget, the used car market holds some hidden gems. One $20,000 used Japanese sports sedan delivers acceleration that can rival, and in some cases surpass, a brand-new luxury competitor, offering surprising thrills without the sticker shock.
Everyone wants Toyota's $10,000 truck, but nobody would actually buy it
You might have seen some noise on the internet among car enthusiasts about the Toyota Hilux Champ, a simple bare-bones pickup that many US customers clearly want.
3 unique RSS reader apps for Windows to try this weekend
RSS feeds used to be the premiere way to get personalized news delivered directly to you from your favorite websites prior to the rise of personalized algorithms on social media. Despite the fact that RSS feeds aren't quite as popular as they used to be, they are still my favorite way to keep up to speed on topics I'm interested in. Here are three RSS Feed apps from Windows.
3 reasons you should buy an energy-efficient ARM NAS (and 1 reason you shouldn't)
Are you in the market for a new NAS, but can’t decide between ARM and Intel/AMD? There are several reasons why you should go with ARM—most notably, it's way more power efficient. But traditional x86 does have one advantage you’ll want to consider.
Want to fix your own PC? These cheap tools are essential in my toolbox
Do you wish you didn't have to take your PC to computer technicians? I'm regularly opening my PC to replace parts, clean dust out, and check for lose connections, and I can tell you the most important aspect is having the right tools for the job.


