Microsoft Tutorials

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.

Covert bullets to SmartArt graphics in PowerPoint

Death by PowerPoint is often caused by the overuse of bullets. To avoid this, covert your bullets to SmartArt.

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.

Word: use Insert Text from File to combine multiple Word documents

To combine multiple Word documents, use Insert > Text from File.