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

I made Excel’s doughnut chart change color automatically to track progress, here’s how

In the Format Data Point pane, click the "Fill and Line" paint pot, and in the Fill section, check "Solid fill," and change ...