Posts

Quick Links Summary To use the SUBTOTAL function, create a formula using the syntax: SUBTOTAL(function_number, reference 1, reference 2,…). You can also use the Subtotal feature by selecting your rows, then clicking the “Data” tab. In the Outline drop-down menu, select “Subtotal.” Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal feature, whichever works best....

Quick Links We expect phones to get better and faster at doing what they already do—but when companies experiment with changing the physical functions of a phone, they’re often dismissed as gimmicks. I love these so-called gimmicks, and they’re a big reason why I use Android instead of an iPhone. I ask you, can your phone do this? Fold and Bend (on Purpose) When I first read about folding phones, I didn’t see the point (andI wasn’t alone in my skepticism)....

Quick Links Summary For most of the past year, I took a break from Linux to experiment with using other form factors as my primary work device. First it was a BOOX Tab Ultra. Then it was a Moto Edge+ with Motorola’s desktop mode. Then it was a Galaxy Z Fold 5 with DeX. Here’s what draws me back to Linux time and time again. Being Forced to Replace Things Sucks You may have noticed that I have a thing for Android devices....

Quick Links Summary While the Metro UI wasn’t the best way of interacting with your desktop or laptop computer, it could be the best way to interact with Windows on your handheld PC. Instead of trying to reinvent the wheel, Microsoft should unretire Metro and unleash it on handheld PCs, here’s why. The Windows Struggle on Gaming Handhelds Is Real Windows gaming handhelds are mostly great, but they all share one major issue: Windows itself....

Summary Apple rarely makes a misstep with its iPhone product line. To that point, the iPhone 14 Pro has proved to be reliable and capable over the last year. As Apple prepares to debut its new iPhone 15 series onSeptember 12, 2023, it’s worth looking back at how the premium phone performed over the past 12 months and what it means for the upcoming mobile phones. Apple iPhone 14 Pro From the Dynamic Island to the new 48-megapixel primary shooter, the 14 Pro offers the best of Apple’s iPhone technology....

Summary Outdoor string lights always seem like a good idea for a backyard patio until you forget to use them regularly. TheNanoleaf Essentials Matter Outdoor String Lightswon’t solve any headaches of actually installing them, but their universal Wi-Fi connection did solve my “use them” problem, and they’ve been great. Nanoleaf Essentials Matter Outdoor String Lights Illuminate your outdoor spaces with these Smart Matter-enabled Multicolor Outdoor String Lights. Set the mood with these uniquely shaped addressable LED bulbs with a single color, or multiple colors at once for dynamic flowing gradients....

Ubuntu’s popularity often makes it the default choice for new Linux users. But there are tons of other Linux operating systems that deserve your attention. As such, I’ve highlighted some Ubuntu alternatives so you can choose based on your needs and requirements—because conformity is boring. Why Look Beyond Ubuntu? Ubuntuwas one of the first Linux-based operating systems, a.k.a. Linux distributions (distros) targeted at regular desktop users. It provided an intuitive GUI (Graphic User Interface), making it as easy to install and set up as Windows and Mac....

Summary YouTube is an endless well of entertainment, education, and inspiration. At least it is when your recommendations don’t suck. Here’s how to reset and train YouTube to be better. Deciphering YouTube’s Algorithm OnlyYouTubereally knows how YouTube works. There are a few basic rules we can apply to the algorithm formula, but there are many factors at play and it’s impossible to understand exactly what’s going on. The same is true for content producers, even those who seem to have cracked it....

Summary For years, Soundpeats has been known for two things: generally good budget earbuds and headphones, and incremental updates. TheSoundpeats Air4 Proare both, as they’re an upgrade to the earlier Soundpeats Air4 and also quite good sounding and full-featured for the price. The Soundpeats Air4 Pro are to the Air4 model as the AirPods Pro are to the AirPods. These are more expensive than the previous model but offer more and better features....

Quick Links Summary If Spotify Wrapped is not showing up for you, ensure you’re in the region where it’s supported and you meet the minimum requirements. Then, update the Spotify app, update your Android version, log out and back into your account in the app, delete Spotify’s cache, or uninstall and reinstall Spotify. Spotify Wrapped gives you your listening statsfor the year, but for some users, it doesn’t seem to appear in their apps....

Quick Links Linux benefits from the strongly-principled ethos of Unix design. Programs communicate via text, you’re able to combine them via pipelines, and they do one thing well. Beyond that, though, programs can act very differently and exhibit many different behaviors. Background Processes A multitasking operating system, like Linux, runs many different programs simultaneously. Those that run without the user directly controlling them are known as background processes. There’s only really one type of background process, commonly known as a “daemon....

Since the launch of the Apple Watch, wearers have received constant notifications on their wrists—and sometimes, it feels like they never stop. While it’s convenient to view and react to notifications directly from your wrist, it still requires using your other hand. However, Apple is expanding the list of hands-free gestures you can use to manage notifications on your watch, and the latest addition is Wrist Flick. While many may see it as just another minor feature, I believe it’s long overdue for the Apple Watch to have a function activated by that specific motion....

MacBook Air 13-inch (M2) Writers don’t need the most powerful computers, but portability is key, and the MacBook Air 13-inch (M2) has that in spades, alongside a comfortable, responsive backlit keyboard. The MacBook Air with an M2 chip is a fantastic laptop for all-day productivity, basic photo and video editing, some software development, and most other laptop tasks. Now you can get the model with 16GB unified memory and 256GB SSD storage for $699, a discount of $300 from the original MSRP and (seemingly) a new all-time low price....