Microsoft Tutorials

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.

Use the Command Box to master Microsoft Teams

The command box in Microsoft Teams is always at the top of the screen. Use slashes to access shortcuts in Teams.

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.

Send an email to a channel in Microsoft Teams

Send an email to a channel in Microsoft Teams by using the channel's email address.

5 ways Microsoft OneNote works great with Outlook and other Office apps

I share 5 great productivity tips for OneNote and Outlook that show the tighter integration Microsoft has built into the Office apps ecosystem.

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.