PivotTables are great for quick analysis, but they break down when you rely on them for serious reporting workflows.

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

Anthropic is embedding AI more deeply in popular work software tools. Claude AI now integrates with Excel, PowerPoint, and Slack, enhancing enterprise productivity. Anthropic challenges Microsoft, ...

New laptops with ARM processors (such as some Surface models) run older software through an emulation layer, which can cause Power Query to crash. Installing the native ARM64 version of Office allows ...

I have been called the LeBron James of spreadsheets, but I try not to take myself too seriously Growing up in Waterford, south-east Ireland, I was always good at maths. I first used Excel at ...

Microsoft has restarted its monthly feature round-up, detailing how Excel changed during January 2026 across Windows, Mac, and the web. The headline upgrade is Agent ...

Microsoft has woven its generative AI technology throughout Microsoft 365, the company’s productivity suite. Its Copilot AI assistant is most often used in M365 apps for text-oriented actions, such as ...

Power Query used to be quite limited in Excel for the web, but Microsoft has now rolled out an update that brings the full experience to certain subscribers. Microsoft, in a recent announcement, said ...

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 ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...