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.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

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