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

Most analysts use Excel to calculate NPV. You can input the present value formula, apply it to each year's cash flows, and then add together each year's discounted cash flows, minus expenditures ...

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel ...

The next time you cover this topic, consider teaching students how to calculate the issue price by using the net present value function (NPV) in Excel. Here’s an example: Suppose a company issues a $1 ...

Learn how to how to increment numbers when value changes in another column. You can automatically fill increment cells in Excel such that the increment value across each cell remains constant.

Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.

Tables offer a lot, but my favorite feature is the formula auto-fill. Normally, you enter a formula and use the fill handle to copy the formula as needed. For example, using the data range shown ...

Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.