Microsoft Office Blog by Chris Menard

Excel – lose subtotal within subtotals in a PivotTable

Excel’s PivotTables are great, but sometimes we get subtotals within subtotals and you want to lose only the 2nd subtotal.

Extract email addresses from a text string in Excel

Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses.

Ten reasons to use Tables in Excel

There are over 10 reasons to use Tables in Excel instead of a data range. Here are five reasons along with a training video. There is part of the free course I created for the GSCPAs.

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.