How-To Geek on MSN

Excel's newest functions are flashy, but these classics are still the best

Old-school Excel functions like SUMPRODUCT, INDEX/MATCH, and IFERROR remain essential for stable, readable, and maintainable ...
Geeky Gadgets

10 Excel Functions You Should Know According to Harvard :

What if mastering a handful of Excel functions could save you hours each week, eliminate frustrating errors, and even make you the go-to problem solver in your office? It’s not just a bold claim—it’s ...
MUO on MSN

These 5 Excel functions are silently slowing down your spreadsheets — use these instead

They may look harmless, but they're certainly capable of turning your spreadsheets into traffic jams.
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...
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 ...
PC World

Excel formulas: The most popular functions and tools, with examples

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...