Microsoft Office Blog by Chris Menard

Deselect with the CTRL key in Excel

The CTRL key is used to select non-adjacent ranges which is a handy feature for charts and summing ranges. You can now deselect with the CTRL key. Huge improvement in Excel.

Excel Functions for HR Professionals

HR Professionals have a lot going on. Recruitment, benefits, compensation, and retention just to name a few. Here are Excel functions you should know. SHRM

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.