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

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.

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

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.