How-To Geek

Android's NFC reader does more than tap to pay. Held against the right tag or accessory, it can do a ton of stuff. Here are just some things you can do that will immediately improve your experience.

We ask our smart home devices to do a lot for us, and rarely spare a moment to think about what life might be like for them. I decided to give some smart home devices personalities and let them loose in their own Discord chat to see what they would say if they could.

As we wait patiently for more of Netflix's September crop of TV series to make their way to your algorithm, here's this weekend's lineup of bingable shows to settle in with—my top pick is still hoping for Emmy gold on Monday, and two are great shows, regardless of their age.

Buying used enterprise storage is one of those things that makes perfect sense when you look at the price and becomes more complicated once you actually put the hardware into a machine. Enterprise HDDs that originally cost a small fortune can appear on the used market for surprisingly little money. For a homelab, where storage capacity is always useful and budgets are rarely unlimited, it is difficult to ignore those prices.

For longer than I care to remember, I've written Excel formulas, dragged them down hundreds of rows, copied calculations across columns, and built running totals one cell at a time. This works, but I always find I'm doing too much work, especially when some of those jobs can be handled by a single formula sitting in a single cell.

Unless you own a Google Pixel phone with the built-in Now Playing feature, you have to use Shazam to recognize songs playing around you, right? Well, actually, no. Many Android phones have access to Google's built-in Song Search feature, which is almost as good as Now Playing and Shazam.

I've been an Arch user for five years, and it's been a love-hate relationship. I love having access to the AUR (Arch User Repository) and the hundreds of thousands of packages it brings with it, along with access to bleeding-edge updates as soon as they drop. But at the same time, I hate it when a buggy update just wrecks my system, not to mention the current malware mess with the AUR and all the headaches that come with it.

I don’t currently have any visible clocks on display in my house. I’m never without my watch or phone, and I decided that if I were to sacrifice some space for a dedicated timepiece, it would need to be something special, different, or interesting.

Occasionally rebooting your router and modem is pretty normal, and some routers even have a reboot schedule function that can take care of this for you. Though problematic network equipment should be replaced, adding a smart plug to your setup can save you effort and even automate the entire process.

So, you're wanting to get started with Ubiquiti's UniFi networking gear, huh? I love my UniFi setup, but I definitely made some mistakes. Here are the four biggest mistakes I see people make all the time in the UniFi community, and how you can avoid them.

Some weeks, the easiest way to find something good on Netflix is to skip over the newest releases and instead look into its library. The platform's diverse catalog has a lot to offer, especially when it comes to movies that have swept award shows during their respective runs.

Any time I recommend software to a friend, there is always an inevitable question: How much does it cost? The quality isn't necessarily the discerning factor—no one wants to pay for something if it isn't necessary. That makes free, open-source tools very easy to recommend to most people without a moment's hesitation.

“Can it run DOOM?” It’s the question people love to half-jokingly ask about every gadget with a screen. Android, of course, can run DOOM — but what about Android Auto? That’s an entirely different beast.

Microsoft's PowerToys suite of Windows utilities, which you can download from GitHub or install through the Microsoft Store, has earned a reputation as a tool designed for — and used exclusively by — Windows power users. But the reality is more nuanced.

Smart bulbs are one of the most common entries into the world of smart home devices, but they're not without their problems. If your internet goes down, you may find that you lose features or simply can't control your bulbs at all. There are several ways to stop this from happening.

Physical media is having a bit of a revival at the moment, and vinyl is getting a lot of attention with claims about its supposed superiority over digital audio. Music CDs, on the other hand, have received a more muted revival.

Back when I used the Steam Deck as my main PC handheld, I forgot the sudo password I'd created the first time around. Naturally, I started to panic and thought I'd need to reflash my Deck and lose all my data, but then I found a solution that let me reset my Steam Deck's sudo password in just a few minutes. All you need for this is a wired keyboard (or a wireless keyboard with a dongle and a USB dock) and some focus, because there's some typing involved.

Documentaries continue to thrive on Netflix this month, as evidenced by the solid stance of the true-crime three-parter Death of the Pastor's Wife that's been holding strong in the top spot on the streamer's Top 10, as of this writing. But the hits keep on coming, with two of this weekend's picks below also occupying space on that chart, proving that Netflix knows how to doc.

I've spent a frankly unreasonable amount of time in Excel, so I've had plenty of opportunities to find out which habits make my life easier—and which ones come back to haunt me later. Over the years, I've gradually ditched a handful of things that seemed harmless at the time but made my spreadsheets harder to sort, filter, update, or understand. Here are five things I stopped doing in Excel, and why my spreadsheets have become much more reliable as a result.

Stop letting old devices rot in a drawer and bring them back to life with the help of an inexpensive microcontroller and some code. The ESP32 is perfect for this task.