Microsoft Tutorials

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.

Import Contacts from Excel into Outlook / People

Need to import your Excel file into Outlook People / Contacts? First, make your Excel file a CSV file. Next, make sure your data is correct.

Fix missing Excel data using Go To and Ctrl + Enter by Chris Menard

If you download Excel data from a database or a csv file, occasionally critical missing data will be missing. You can fix it with Go To and Ctrl + Enter.

Create odd and even headers/footers in Word for duplex printing

If you need to print two-sided or duplex printing, in Microsoft Word you should use Odd and Even Headers to align your page numbers.

Many to One Mail Merge in Microsoft Word

By default, Microsoft Word performs a mail merge and One to One, but you can use Graham Mayor's add-in to make Word perform a Many to One mail merge.