AGGREGATE was built to handle messy data from the start.

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

Managing your company's finances helps you assure that you know the state of your accounts receivable and payable, as well as the other costs and credits you engender in the course of doing business.

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

When your spreadsheet has formulas piled on top of formulas, tracking and repairing errors would be agony if it weren’t for Excel’s Precedents and Dependents: cells that are referred to by a formula ...