This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.

Microsoft Excel is incredibly versatile, but there are a lot of functions you might not even know about. These are some of the best ones.