Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.

How to Calculate an Interquartile Mean in Excel. The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your data set already entered into the software. Once you have your data, you can choose your formula based ...

Do you know how much your mutual fund scheme has generated till now? Here is how to calculate CAGR in Excel One may use CAGR to calculate returns from mutual funds schemes by taking into account ...