How-To Geek on MSN

The simple Excel function that decides if your formula spills or returns one value

For decades, Excel worked on a simple principle: you enter a formula into one cell, and it returns a single result into that ...

The Best New Excel Update for Faster Reports and Fewer Errors

Explore Excel’s latest new features such as Translate and the Formula-by-Examples tool, so multilingual reports update automatically and save ...
How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells.

I discovered a hidden Excel trick that turned my spreadsheet into Christmas magic

Here's how to create your own animated Christmas tree in Excel: Open up a new spreadsheet. Click the triangle button in the ...