Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed ...

When Andrew Grigolyunovich first started using Excel more than two decades ago, he never imagined the spreadsheet program would land him in Las Vegas or on ESPN. The Latvian financial consultant ...

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

If you’re working on an Excel file and want to keep some data or sheets out of sight without deleting them, hiding the worksheet is a useful option. This helps organize your workbook, reduce clutter, ...

The agency’s commissioner has implied that some of their ingredients may be harmful. Is that true? By Alice Callahan and Teddy Rosenbluth Last week, the Food and Drug Administration convened a panel ...

Corrections & Clarifications: Consumer Reports incorrectly named the baby formula with the highest lead levels in its testing. That product was Enfamil's Nutramigen. Most infant formulas tested by ...

A new Consumer Reports investigation found lead, arsenic, BPA, and PFAS in popular brands. But there are steps you can take to mitigate risk. Andi Breitowich works across digital and print magazines ...

When working with large datasets in Excel, the performance of formulas plays a critical role in determining calculation speed and overall efficiency. Understanding which formulas perform best and how ...

I have a script that pulls data from a mongo database, and then creates 13 different sheets in an excel file based on the pulled data. The script was functioning correctly up until I added a single ...