Microsoft Excel Blog: Tutorials and How-Tos

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

Use absolute reference in Excel to keep a cell constant when you copy or autofill

Use absolute reference in Excel to keep a cell constant when you copy or autofill

Create your own custom sort in Excel

Create your own custom sort in Excel

Create a combo or two-axis chart in Excel 2016 by Chris Menard

Create a combo or two-axis chart in Excel 2016 by Chris Menard

How to calculate the weighted average in Excel

How to calculate the weighted average in Excel

Create a treemap in Excel to spot patterns

Create a treemap in Excel to spot patterns