Microsoft Office Blog by Chris Menard

Quick tutorials, how-tos, articles, guides and resources on everything Microsoft Office 365, Word, Excel, PowerPoint, Outlook and more!

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

5 ways Microsoft OneNote works great with Outlook and other Office apps
Posted by Chris Menard on 10/23/2019

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

Keyboard shortcuts for Paste Values in Excel
Posted by Chris Menard on 09/28/2019

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

Excel: Get & Transform Data - Unpivot Columns

Posted by Chris Menard on 09/21/2019

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

SORTBY Function in Excel - Dynamic Array Function
Posted by Chris Menard on 09/14/2019

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

XLOOKUP function in Excel

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

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.

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

Find the lowest / highest values for rows or columns with conditional formatting in Excel
Posted by Chris Menard on 08/04/2019

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

Break-even in Accounting - Cost Volume Profit Analysis
Posted by Chris Menard on 07/15/2019

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.

Share your real time location with Google Maps

Share your real time location with Google Maps
Posted by Chris Menard on 06/02/2019

You can share your destination, estimated arrival time (ETA) and ask for someone's location with Google Maps. This works on both the iPhone and Android.

Send Confidential Emails with Gmail

Send Confidential Emails with Gmail
Posted by Chris Menard on 05/10/2019

Gmail allows you to send confidential emails for free. You can send to both Gmail users and non-Gmail users. Outlook users as an example.

Covert bullets to SmartArt graphics in PowerPoint

Covert bullets to SmartArt graphics in PowerPoint
Posted by Chris Menard on 05/05/2019

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

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.