Microsoft Excel Blog: Tutorials and How-Tos

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.

Keyboard shortcuts for Paste Values in Excel

Paste Values in Excel is an excellent feature. It copies only the value of a cell, not the formula. When you copy a cell with a formula and paste, the formula gets pasted. Frequently, you want just the value.

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.

Snap a picture of an Excel table with your smart phone and edit the spreadsheet

Excel on Android has a new feature where you can take a picture of a table and edit it in Excel.