As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.

Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex ...

Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.

In the 1990s some computer games had a "boss key" that allowed staff to call up an Excel spreadsheet if they needed to look like they were working. Now bosses might frown upon a worker caught ...

Everywhere you look, business leaders are trying to stay ahead of the AI curve and find ways to use these new technologies to drive real impact for their business. But they’re finding that it’s ...

Spreadsheet apps like Microsoft Excel and Google Sheets are used worldwide to organize and analyze data, but getting the right information into them isn’t always straightforward. Businesses often need ...

Working with large datasets in Excel often presents challenges, particularly when clarity and organization are essential. Dynamically inserting blank rows between items is a highly effective method to ...

The original version of this story appeared in Quanta Magazine. Sometime in the fall of 2021, Andrew Krapivin, an undergraduate at Rutgers University, encountered a paper that would change his life.