Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

If, for example, you wanted to calculate your returns after taxes, you could input the amount of taxes due in the table as a negative number to recalculate an after-tax return.

Learn how to calculate the cost of equity in Microsoft Excel using the capital asset pricing model, or CAPM, including brief definitions of each component.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier. You may be investing through SIP or making lump sum investments ...