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

Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.

Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating each of these components, use Excel ...

Excel Financial functions are used to assist Financial Analysts and Investment Brokers to make calculations and create graphs. Here are the useful ones!

Earlier, we had seen how the RATE function can be used to calculate the return on investments, whether lump-sum or periodic. This can come in handy in the calculation of SIP returns, too.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

Understanding the Excel PMT Function At its core, the PMT function calculates the payment amount for a loan based on a series of constant payments and a fixed interest rate.

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.