Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Q. I get a detailed revenue transaction export from the client, and then I get it again, revised, usually after I’ve already filtered, sorted, and documented my selections. I’m tired of reapplying ...

To make it easier to pull a .csv or .txt file directly into Excel without having to deal with Power Query, Microsoft is introducing two new import functions. Microsoft is making two new Import ...

It’s been a while since the new version of Outlook overtook the old classic version, but users are still unhappy with it. The latest issue? Certain Excel attachments aren’t opening in Outlook anymore, ...

Q. I work with large spreadsheets. These spreadsheets have hundreds or even thousands of rows and often 10 or more columns. It’s so much to process that I become confused and make mistakes. Does Excel ...

Anthropic on Tuesday announced a new Claude feature that some users should appreciate. The chatbot can now create files for you based on the instructions you provide in a prompt. Claude can generate ...

There's a new AI agent on the block for people who spend their waking hours inside spreadsheets. Navigate to Shortcut AI's website, and you'll find a page that looks almost exactly like an empty ...

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...

Microsoft has announced an update for Copilot in Excel that allows it to reference files from Word, PowerPoint, and other apps. Microsoft has announced in its Microsoft 365 Insider blog that Copilot ...