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

You don’t need more effort; you need better formulas.

As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

NotebookLM has always been about helping users make sense of scattered notes, PDFs, and documents using AI. Data Tables builds on this idea by handling one of the most time-consuming parts of research ...

Save hours on data entry and formula writing with my game-changing AI tips. From the laptops on your desk to satellites in space and AI that seems to be everywhere, I cover many topics at PCMag. I've ...

Google is expanding Gemini’s capabilities in Sheets. The AI can now understand and analyze multiple tables. Users will be able to get Gemini to generate formulas based on several tables, generate ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...