How-To Geek

I've started purchasing physical media and digitizing it to build my own media library. I could put this all on a Plex or Jellyfin server, but I decided to purchase an Open Source Media Center box instead—and this has been the single best TV upgrade I've ever made.

I'm a self-hosting machine, running over half a dozen servers with dozens of virtual machines and over 100TB of local storage. However, even with all that hardware and storage, I stopped self-hosting three services and pushed them back to the cloud—here's why.

As governments and companies around the world seem to be on a bit of an internet censorship binge, many people are turning to VPNs (Virtual Private Networks) to get around these restrictions—only to be caught out!

When you're using Home Assistant, it's easy to fall into the trap of assuming that you need to create an automation for everything. Automations aren't the only option, however. Sometimes using a script or a scene can be a better choice.

What are the 10 greatest movies of all time? For a movie lover like myself, it's an impossible question. Could I name 10 movies that I believe to be great? Absolutely. The only problem is that I will regret my answers within five minutes of posting this article. I'll forget about an all-time movie that deserves to be on this list and get mad at myself for not putting it on. I feel the same anxiety when ordering at a restaurant — as soon as the waiter walks away, I want to change my selection.

For years, named ranges were the "pro" way to structure Excel data. But modern spreadsheets have moved on. Tables now handle what named ranges only simulate—without the manual upkeep or hidden breakpoints waiting to surface.

Microsoft Excel still rules on the desktop, but the mobile app (iOS and Android) has quietly developed a few advantages of its own. From scanning tables with your camera to touch-friendly data entry, some Excel tasks are genuinely faster and easier on your phone. Here are five workflows to start using today.

Self-hosting had always sounded appealing; the idea of running my own services and keeping control of my data was music to my ears. Despite running a Home Assistant server for several years, however, I'd never gotten beyond that point until I bought a relatively cheap mini PC.

Have you ever wondered just how much it costs to run your homelab? The answer might shock you—it did for me. Here's how I started measuring the power draw of my homelab, and why it's important to do so.

I never leave the house without a few essentials. Those include my phone, wallet, keys, and my daily carry pocket knife and flashlight. And if you're still using your phone as a flashlight, I have the perfect upgrade for you.

For months, I thought my favorite pair of earbuds, which I used a lot for podcasts and long workdays, was just wearing out as electronics do. The sound had become dull, the vocals seemed distant, the bass muddy, and the cymbals sounded indistinct. I blamed software updates, battery degradation, or just normal wear from daily use. I was already browsing for replacement models when I thought about cleaning them. This led to a serious look at how I take care of my earbuds. Basically, the jump in sound quality was immediate and embarrassing because it's so simple. If you, like me, believe your earbuds are worn out and ready to throw away, you might be surprised to learn that their best days are still ahead.

Google Gemini can be a genuinely useful assistant in your day-to-day life. It can also be a completely pointless, nonsense machine for your own enjoyment. I decided to combine those two very different approaches—practical and silly—and I wish I’d done it sooner.

Pipes are a very powerful core feature of Linux. By chaining programs together, you can carry out complex tasks with a small set of tools. But piping isn’t always the best solution; when it’s not needed, it can increase complexity and lead to less efficient options.

Home Assistant has so many features that you’re bound to have missed a few. Though you can get by with the basics, some of the things you never touch can make your server more efficient and your smart home even smarter.

Paramount+ subscribers might be deeply invested in Yellowstone's sequel series, Dutton Ranch, which premieres tonight, or maybe even hunkered down with a South Park binge session. Either way, when the credits roll and the algorithm runs dry, finding your next watch can be a part-time job. I will be the first to recommend a good documentary to shake up your brain.

Family SUVs are changing fast, and buyers in 2026 are getting a lot pickier about what actually works day to day. Bigger engines and brute force used to be the default, but that thinking is starting to fade.

When the time comes to buy a portable external battery, you have to choose between the largest one you can afford or going for a smaller one. I'm here to argue that smaller is better.

The Outback has long stood apart from the sea of mainstream crossovers by offering something buyers could no longer find anywhere else: a rugged wagon that blended SUV practicality with a more car-like driving experience. For decades, that formula helped it become one of Subaru’s most recognizable and successful models. However, the redesigned 2026 version takes the nameplate in a very different direction, and not everyone is happy about it.

Phone hardware has been stagnating over the last few years. Unlike the 2010s, during which we saw gigantic steps forward with each phone generation, the 2020s are all about software, at least when it comes to Western phone brands, including Samsung.

Google has set steep requirements for Android 17's marquee Gemini Intelligence feature. They rule out most existing phones, to the point where some of the company's own Pixel 9 devices might not support the agentic AI.