Microsoft Excel Blog: Tutorials and How-Tos

Vlookup vs Index and Match in Excel

Vlookup vs Index and Match in Excel

Calculate weekly revenue using PivotTables or Vlookup

Calculate weekly revenue using PivotTables or Vlookup

Vertical analysis of an Income Statement in Excel

Vertical analysis of an Income Statement in Excel

Correct data imported into Excel from a database

Correct data imported into Excel from a database

Five examples of using named ranges in Excel

Five examples of using named ranges in Excel

Create a break even analysis chart in Excel by Chris Menard

Create a break even analysis chart in Excel by Chris Menard

Import Contacts from Excel into Outlook / People

Import Contacts from Excel into Outlook / People

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

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

Use the text function in Excel to add leading zeros

Use the text function in Excel to add leading zeros

Conditional Formatting with two criteria using AND function in Excel

Conditional Formatting with two criteria using AND function in Excel

Create a data validation drop down list in Excel by Chris Menard

Create a data validation drop down list in Excel by Chris Menard