Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

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

Learn how to use Excel Solver and MATLAB linprog to implement the simplex method for solving linear optimization problems. Get tips for problem formulation and solution interpretation.