How-To Geek
Don't underestimate the power of the $ sign in Excel formulas
Microsoft Excel usually thinks in directions: "look one cell to the left." That's fine until you move the formula and the reference gets lost. By knowing how to use the dollar ($) sign, you can tell Excel when to look at a permanent address and when to look at a moving target, meaning you're building sturdier formulas.
10 features that make the Cadillac Vistiq a true luxury SUV
Electric vehicles used to be limited to a small handful of choices, but that’s changed quickly over the past few years. Today, you’ll find everything from compact city EVs to electric pickups and high-performance supercars hitting the market.
10 features that make the Cadillac Vistiq a true luxury SUV
Electric vehicles used to be limited to a small handful of choices, but that’s changed quickly over the past few years. Today, you’ll find everything from compact city EVs to electric pickups and high-performance supercars hitting the market.
Fake x16 slots and hidden lane sharing: Why your PCIe NVMe adapter is running at half speed
PCIe adapters are the ultimate solution for adding anything from extra M.2 SSDs and SATA drives to 10-Gigabit networking adapters and Wi-Fi cards. While they are the fastest form of expansion on your motherboard, they are not as foolproof as they might look. If you don't match the right adapter to the right slot, you could be severely limiting your hardware's performance.
Fake x16 slots and hidden lane sharing: Why your PCIe NVMe adapter is running at half speed
PCIe adapters are the ultimate solution for adding anything from extra M.2 SSDs and SATA drives to 10-Gigabit networking adapters and Wi-Fi cards. While they are the fastest form of expansion on your motherboard, they are not as foolproof as they might look. If you don't match the right adapter to the right slot, you could be severely limiting your hardware's performance.
Why I'm learning to code in Kate instead of VS Code
Recently I decided to get back into programming. I'm not following the convention of getting started in Visual Studio Code, though. Instead, I'm starting from scratch with the Kate advanced text editor.
Why I'm learning to code in Kate instead of VS Code
Recently I decided to get back into programming. I'm not following the convention of getting started in Visual Studio Code, though. Instead, I'm starting from scratch with the Kate advanced text editor.
How to get over “printer’s block” and get more out of your 3D printer
So you’ve bought a 3D printer, made the usual assortment of fidget toys and Benchy models, and now you’re looking for something else to print. Though some people have trouble leaving their 3D printers idle, others experience “printer’s block” and run out of ideas completely.
How to get over “printer’s block” and get more out of your 3D printer
So you’ve bought a 3D printer, made the usual assortment of fidget toys and Benchy models, and now you’re looking for something else to print. Though some people have trouble leaving their 3D printers idle, others experience “printer’s block” and run out of ideas completely.
J.D. Powers' dependability study shows vehicle reliability is in freefall
Modern vehicles are more advanced than ever, packed with large infotainment screens, over-the-air software updates, and increasingly complex driver-assistance systems. While these innovations promise convenience and capability, they may also be creating new reliability challenges. Recent industry data suggests that as cars become more technologically sophisticated, the number of reported problems is beginning to climb.
J.D. Powers' dependability study shows vehicle reliability is in freefall
Modern vehicles are more advanced than ever, packed with large infotainment screens, over-the-air software updates, and increasingly complex driver-assistance systems. While these innovations promise convenience and capability, they may also be creating new reliability challenges. Recent industry data suggests that as cars become more technologically sophisticated, the number of reported problems is beginning to climb.
Passkeys were supposed to replace passwords, but they're failing for the most predictable reason
Passwords are a problem. Not only have they reached a point where a "strong" password is one no human can remember (much less remember dozens of them), but they simply aren't as secure as they need to be. Passkeys combine a public and private cryptographic key pair with local authentication such as a fingerprint or facial scan. The device can prove its identity beyond doubt, and the assumption is that only you can unlock it.
Passkeys were supposed to replace passwords, but they're failing for the most predictable reason
Passwords are a problem. Not only have they reached a point where a "strong" password is one no human can remember (much less remember dozens of them), but they simply aren't as secure as they need to be. Passkeys combine a public and private cryptographic key pair with local authentication such as a fingerprint or facial scan. The device can prove its identity beyond doubt, and the assumption is that only you can unlock it.
Spend your money on books, not a new Kindle
Feeling the itch to upgrade your eReader? Don't yet have a Kindle and eyeing up a brand new model? Your money is better spent on things to read than the latest and greatest device.
Spend your money on books, not a new Kindle
Feeling the itch to upgrade your eReader? Don't yet have a Kindle and eyeing up a brand new model? Your money is better spent on things to read than the latest and greatest device.
Why de-googling my life was a complete waste of my time
Are you thinking about de-googling your life? Worried that Google knows too much about you? Well, I tried it—and here’s why it was a complete waste of my time.
Why de-googling my life was a complete waste of my time
Are you thinking about de-googling your life? Worried that Google knows too much about you? Well, I tried it—and here’s why it was a complete waste of my time.
6 things I've learned after a decade of using rooftop solar
I first had solar panels installed on my rooftop nearly a decade ago. I've moved since then and have had them installed on my new home as well. At this point, I'm now familiar with having panels installed and what it's like using them. Here's what I've learned along the way.
All-new 2026 Subaru Outback delivers big SUV capability without the $50K price
The Subaru Outback has been a staple of the brand for three decades, with sales exceeding three million units. Now in its seventh generation, the 2026 model represents the most comprehensive makeover for the Outback yet, characterized by a boxy new exterior design and a more optimized infotainment system that offers faster response times.
3 great Plex movies to watch for free this weekend (March 6-8)
Did you know that Plex has free movies on demand? I'm sure many customers use Plex as a personal media server, and rightfully so. It's an effective platform where users essentially create their personal streaming services. For those who love customization, Plex is the server for you.


