How-To Geek on MSN

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

If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled range. Simply reference the first cell of the spilled range with a # ...

Calculate Cost of Equity with Excel Using CAPM

Master calculating cost of equity in Excel using CAPM. Discover step-by-step guidance on market return, risk-free rate, and ...

Understanding Add-On Interest: Definition, Formula, and Comparison

Learn how add-on interest increases loan costs compared to simple interest. Discover the formula, examples, and its ...

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

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

This Ridiculously Detailed Spreadsheet Has Helped Me Stick to My New Year’s Resolutions for Five Years

From the most thorough travel plans to your fitness journey, if you have a goal, that goal needs a spreadsheet tab. It’s a ...