Microsoft Office Blog by Chris Menard

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.

Share your real time location with Google Maps

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

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

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.

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.

Use a virtual background with Zoom Meetings or RingCentral Meetings

Virtual backgrounds are easy to use with Zoom Meetings. The virtual background feature allows you to display an image as your background during a Zoom Meeting.