How-To Geek

Excel's UNIQUE function is a game-changer for cleaning data, but it has a frustrating limitation: it only works with adjacent columns. But by nesting additional functions inside it, you can create a dynamic, custom list that ignores the columns you don't want to include.

Love doesn’t always arrive with fireworks. Sometimes it shows up quietly, when you catch a familiar shape in traffic and realize you’re smiling for no real reason.

Flash drives are a convenient way to temporarily store files, or a fast way to move things between two PCs. Unless you've got very fast internet, or have invested heavily in your home network, a flash drive is almost always faster.

Raspberry Pi has sold the AI HAT+ board for over a year now, giving Pi boards the ability to run lightweight machine learning models for object detection, file tagging, and other tasks. Now, there's a Raspberry Pi AI HAT+ 2, and it's powerful enough to run large language models (LLMs).

Spotify is hitting its Premium subscribers with yet another cost increase. This marks the third time in four years that the music streaming giant has raised its subscription prices. The company announced the expected hike early Thursday, affecting users in the US, Estonia, and Latvia.

Amazon might be the most popular online storefront, but it's far from perfect. Knock-off products are frustratingly common, especially when ordering one particular product: SD cards.

Do you waste the first 10 minutes of every work session figuring out what you need to do? Does Alt+Tabbing between apps leave you feeling mentally scattered? These were common problems in my workflow until I started using widgets and transformed my desktop into a productivity dashboard.

Are you wanting to play retro games on a tiny computer? The bad news is that the classic choice, Raspberry Pi devices, have been going up in price lately (again). The good news is there's a cheaper alternative: RISC-V.

The compact SUV segment has long been dominated by familiar imports, with models like the Toyota RAV4 and Honda CR-V leading sales year after year. But in 2025, one American SUV is closing the gap fast, attracting buyers with a compelling mix of practicality, value, and everyday usability. Its improved refinement and broad appeal suggest it could soon rival those segment heavyweights in total sales.

Do you have multiple Linux PCs that you work with? Do you ever find yourself annoyed by switching between keyboards and mice? You're in luck thanks to this free and open source app.

You may think that when you buy an SSD, the only two specs to be mindful of are its read/write speeds and its capacity. However, there's one more spec that plays a big part in how your SSD will perform. It can be the factor between your new SSD being a waste of money and a sound investment.

I love GitHub, and have used it for many, many years. GitHub isn’t always the best choice for code revisioning though. When I started building some private apps, I decided to look into alternatives and ended up self-hosting my own private git-based server instead.

Bust out your best flat caps and leather jackets, because the Peaky Blinders are back, baby ... well, almost. After six insanely successful seasons, the epic Netflix Original gangster saga from creator Steven Knight is set to wrap up its story of the Shelby clan with a highly anticipated movie.

I’ve got a handful of wireless remotes for my small, Home Assistant-powered smart home, and I’m constantly coming up with more ways to use them. Designing a smart home that anticipates your next move is the ultimate goal, but sometimes the best solution to a problem is to just hit a button.

We all know the standard copy-paste, but pressing Ctrl+V in Excel often carries lots of baggage—leading to workbook lag and broken data. By mastering Paste as Values, you're activating the safety switch that freezes your results and secures your data. Here's why it's the most important tool you're ignoring.

When you think of Paramount+, the first name that comes to mind is Taylor Sheridan. The Yellowstone architect is behind some of the most popular shows for the streamer. Considering he writes, directs, and produces the majority of the episodes, Sheridan is Paramount’s most prolific creator.

Are you frustrated that your network isn’t running as fast as you think it should? The cause could be as simple as an old Ethernet cable or as complex as the way your NAS is set up. Here are some common problems you could run into with network speed and how to fix them.

If you are looking for a different vehicle, it seems like right now is the worst possible time. Everything is more expensive, and new automobiles are among the most affected consumer products. According to Kelley Blue Book, the average price of a new vehicle exceeded $50,000 for the first time in history in September 2025.

A smart home is more than a smart speaker that controls a few devices. You should aim to automate as much functionality as possible, and lighting is the best place to start.

Don't wait until the last minute to start learning a new skill for the new year. Skillshare is offering a free month to kickstart your goal.