Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.

Aaron Swan shows how you can use the apps already on your school-issued devices to make the task of giving student feedback ...

The Sophia Script is an open-source PowerShell module designed to debloat and fine-tune Windows 11 (and Windows 10). It is ...

In a world where anyone with the means can walk into any one of Chevrolet’s nearly 2,900 U.S. dealerships and purchase 1,250 hp, it’s only reasonable we reconsider the question as to whether there’s ...

The AI hardware boom is sending memory prices sky-high, so knowing exactly how much you need is more critical than ever. I've worked out the most realistic RAM goals for every type of PC.

Select winners in Excel using classic INDEX formulas or modern CHOOSEROWS and TAKE combinations.

It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number combinations. This makes it friendlier to read and understand. For example, ...

Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get around Excel and make it do what you want it to do? Formulas are one of the ...

Q. I currently keep a static to-do list, and I would like to update it to be more dynamic. Do you have any advice? A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Have you ever stared at a tangled web of Excel formulas, wondering if there’s a better way to make sense of it all? For many, Excel’s LAMBDA function feels like a cryptic puzzle—powerful but ...

Q. You released an article about using ChatGPT-4o in September 2024. Could you show us more ideas about how to use ChatGPT-4o with Excel? A. In today’s fast-paced accounting world, being efficient and ...