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

3 Ways to Compare Excel Sheets : Including the Method Most Skip

Stop checking spreadsheets manually. Discover how to find mismatched cells, hidden spaces, and deleted rows in Excel using ...
How-To Geek on MSN

How to use the RANK.EQ function in Microsoft Excel

Ditch manual sorting for live formulas that rank top performers, fastest times, and equal scores as data changes.
PC Magazine

I Ditched Password Generators and Made a Better One in Excel. Here's How

Because many password generators aren't as random as they seem, I built an improved one in Excel—and I'll show you exactly how you can, too. When the IBM PC was new, I served as the president of the ...