Millionaire Calculator NPER- Excel

f you're got a mutual fund or some kind of investment vehicle that lets you put in an initial investment and give you the chance to put in additional investments, how long will it take to get to a million bucks? Use the NPER function to find out.

Sort Column by Cell Color

Sorting columns are a common occurrence and usually done via ascending or descending based on A to Z or Z to A with text or number values. But did you know you can sort by color? The use case maybe that you've done some conditional formatting for the cell color and you want to sort on blue, yellow and green in that order. It can be done with the custom sort feature.

Calculate Cumulative Principal & Interest

When you've got a loan or mortgage and you're the analytical type, maybe you'd want to know how much you're paying in principal and interest for a giving time period. For example for the first year, how much is that payment for the principal (hint: it's not much) and how much of the payment is interest going to the bank (it might surprise you). You can figure this out with Excel.