How-To Geek on MSN

How to use the MAP function in Microsoft Excel

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...
How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

17 New Excel Features for 2026 to Speed up Your Work

Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...
Geeky Gadgets

You’re ONE DOT Away from Cleaner Excel Reports : Trim Refs

Have you ever found yourself wrestling with messy Excel datasets, trying to clean up those pesky empty cells that throw off your calculations? It’s a small annoyance that can quickly snowball into ...
JournalofAccountancy

Quickly clean data with Excel’s TRIMRANGE and trim references

Q. How do the TRIMRANGE function and trim references in Excel work? A. Excel’s TRIMRANGE function and trim references help users quickly tidy up datasets. This makes for a cleaner, easier-to-follow, ...
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 ...