Microsoft Office Blog by Chris Menard

You can use the Google Wallet to quickly send and request money. You can either use Gmail, the app, or the website for Google Wallet. It is fast and free.

Google Calendar - 3 Lab features you need to use

The Google calendar is great. There are three features you may not know about. You can hide time, view the entire year, all twelve months, and jump to any

Break-even analysis in Excel with multiple products

Create a break-even analysis with multiple products in Excel. Create a contribution margin income statement using a product mix.

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.