❌

Reading view

There are new articles available, click to refresh the page.

How to use the TAKE function in Excel

Ever found yourself copying a few rows from an Excel spreadsheet into another part of your workbook, only to repeat the whole process when your data changes? There's a better way. Excel's TAKE function lets you extract the rows and columns you need, so you can build focused reports that update automatically.

Microsoft didn't build these 5 apps, but they changed Windows forever anyway

Windows is Microsoft's operating system, but that doesn't mean Microsoft gets all the credit for shaping the PC experience. Over the years, independent developers created apps that changed how people browsed the web, listened to music, watched videos, played games, and even interacted with Windows itself. These five did more than add another program to your PC: they changed what Windows users came to expect from it.

Windows 11 is finally letting you fix one of its most annoying menus

Windows 11’s right-click menu has been cluttered for a long time now. There are delays when opening a file menu and an overload of options added by Windows and installed applications. Now, Microsoft is finally fixing this by rolling out a redesigned context menu and giving users greater control over which commands appear. The update also brings layout choices that make the menu adaptable to individual preferences.

How to use the TRIMRANGE function in Excel

Excel has hundreds of functions, and nobody needs to know them all. But a few are worth keeping in your back pocket because they save you headaches as your data changes. TRIMRANGE is a great example. When you build a spreadsheet that's going to grow, you usually leave room for data you haven't entered yet. Those empty cells can turn dynamic array results into a mess, but TRIMRANGE quietly trims the blank edges off a range and keeps things tidy.

Windows 11 is finally giving you more control over which apps can access your camera and microphone

For years, Windows 11 has handled camera and microphone access for desktop apps like a master keyβ€”flip the switch and every program gets in, or none do. Microsoft is finally working on a solution for the latest Windows 11 Insider build. The new privacy controls allow you to decide which desktop apps get to use your camera and microphone, one at a time. If you use an Android phone, you'll find the per-app permission settings feel familiar. This matters because camera and microphone access can reveal more than you might expect across varied software.

I've always recommended naming Excel tables, and Microsoft just removed the annoying part

Microsoft has spent what feels like years pushing Copilot updates into Excel, but for me, it's the little usability improvements that make the biggest difference when you use the app every day. A small change to a dialog box can save you a few clicks, remove an annoying extra step, or make a good habit easier to stick to. One recent change to the way Excel creates tables is a good example, and it's something I've wanted for years.

❌