Microsoft Office Blog by Chris Menard

Word - remove the blank page after inserting an envelope

When you insert an envelope in Word, you end up with page 2 being a blank page. Page 1 is the envelope. Here are the steps for removing the blank page.

Use array functions in Excel to perform multiple calculations in one cell

To master Microsoft Excel, you must know how to use array formulas. Array formulas can perform calculations that you can't do by using non-array formulas.

Vlookup vs Index and Match in Excel

Vlookup is a powerful function but even better but less frequently used is Index and Match. Explained are two reasons to use Index and Match over Vlookup.

Calculate weekly revenue using PivotTables or Vlookup

Need to calculate weekly revenue or orders in Excel? You either Vlookup or PivotTables. PivotTables have a grouping features that will calculate it.

Vertical analysis of an Income Statement in Excel

To perform vertical analysis of an income statement in Excel, take all line items and divide by the Sales. One of my MBA students asked this question.

Correct data imported into Excel from a database

When you import data into Excel from a database, often dates and numbers will import as text. The issue is you can't analyze the data.

Create an Index in a Microsoft Word document

An index is a great way to lists the terms and topics that are discussed in a document, along with the pages that they appear on.

Five examples of using named ranges in Excel

You can use named ranges in formulas in Excel, to create a bookmark to a worksheet, and use for data validation in Excel. Chris Menard shows five examples.

Create a break even analysis chart in Excel by Chris Menard

Break Even is when you making neither a profit nor a loss. This was a question from one of my MBA students. We will use the contribution margin

Delay Delivery of all messages sent in Microsoft Outlook

Delay delivery of all messages in Outlook by writing a simple rule. This rule will allow messages to be delayed between 1 and 120 minutes.

Always lock your computer when you are away

Most companies have confidential communication and documents. Always lock your computer when you get up from your desk. Here are four reasons to lock it.