Advanced Microsoft Excel tutorials

Future Value Function in Excel

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

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.

Excel for Office 365: Fuzzy Matches with the Power Query Editor by Chris Menard

Power Query in Excel will now handle to do approximate matches (fuzzy matches). This is handy since you can't use VLOOKUP or XLOOKUP since you don't have exact matches.

Create a dynamic two color column chart in Excel to show increases and decreases

A dynamic column chart in Excel will allow you to show increases and decreases in two colors. This is great for showing the monthly trends for one year of sales data.

Excel: Get & Transform Data - Unpivot Columns

Use Excel's Power Query Editor to unpivot columns and transform your data. It is called Get & Transform data in Excel 2016.

SORTBY Function in Excel - Dynamic Array Function

The SORTBY Function in Excel allows you to Sort by a range based on another corresponding range.

XLOOKUP function in Excel

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

The SUMIFS function will sum numbers based on one or more criteria. It is superior to the SUMIF function.

Find the lowest / highest values for rows or columns with conditional formatting in Excel

You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting with the MIN and MAX Functions.

Break-even in Accounting - Cost Volume Profit Analysis

In Accounting, Cost Volume Profit (CVP) is used to find a company's Break-even point. Revenues cover expenses and there is zero net profit.

Getting Started with IF functions in Excel

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.

The Rule of 72 answers "When will my investment double?"

The rule of 72 is an easy way to determine when will my investment will double at a given interest rate. Divide 72 by the annual rate of return.