How to use Excel VLOOKUP
 Enter ‘=VLOOKUP(‘
 Select the cell containing the value you want to look for and enter a comma
 Select the table containing your data
 Enter the column index containing the data you want to retrieve
How to use Excel VLOOKUP

This article teaches you how to calculate the NPV (Net Present Value) using Excel. The Excel function to calculate the NPV is “NPV”. 
The NPV formula in Excel is counterintuitive at first. When I first used it, I made a simple mistake by selecting all the cash flow, including the initial investment. I learned that Excel requires you to select only the future flows and then discount the initial investment from the result, to get the accurate NPV value. 
The cash flow statement shows the inflows and outflows of cash generated and used by an organization in a given period of time. 
This article teaches you how to calculate the IRR (Internal Return Rate) using Excel. The Excel function to calculate the IRR is “IRR” and it’s really simple, since it only takes the range that contains the flow of funds, including the initial investment. 