Future Value Function in Excel
Posted by Chris Menard on 02/10/2020
The Future Value Function will give you the answer to the future value on investment. Compound interest is interest on interest vs. simple interest that interest only on the principal.
Annual Percentage Yield (APY) vs. Interest Rate
Posted by Chris Menard on 01/17/2020
The annual percentage yield takes the interest rate and compounding periods to show what your money could earn in a year. The Future Value (FV) and EFFECT functions are shown.
XLOOKUP function in Excel
Posted by Chris Menard on 09/01/2019
XLOOKUP is the latest function in Excel for Office 365. If you use VLOOKUP or INDEX/MATCH, you are going to love XLOOKUP.
SUMIFS Function in Excel
Posted by Chris Menard on 08/25/2019
The SUMIFS function will sum numbers based on one or more criteria. It is superior to the SUMIF function.
Getting Started with IF functions in Excel
Posted by Chris Menard on 04/23/2019
The IF function is one of the most useful and popular functions in Excel. We will use IF with absolute cell reference in this exercise.