How-To Geek on MSN

Why I'm swapping my PivotTables for the PIVOTBY function in Excel

PivotTables are static relics; PIVOTBY is the responsive, resilient, and fully auditable future of the modern Excel professional.
Geeky Gadgets

How to write Excel formulas using the Advanced Formula Environment (AFE)

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 ...
How-To Geek on MSN

How to use the ISOMITTED function in Microsoft Excel

Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.
Computerworld

How to use Excel formulas and functions

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...
The Verge

Microsoft’s making Excel’s formulas even easier

The company is adding some handy automation features to its web-based spreadsheet software. The company is adding some handy automation features to its web-based spreadsheet software. Microsoft has ...