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

Excel can quickly calculate amortization. Microsoft Excel is a widely used spreadsheet program that can use formulas to compute and display values.

If you have a recent pay stub, you can use Microsoft Excel to calculate your annual salary, as well as estimate how much a raise will affect your.

How to Calculate How Much You Can Borrow Using Excel. How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest ...

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

The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.

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.