Microsoft Tutorials

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

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.

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.