Microsoft Excel Blog: Tutorials and How-Tos

Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.

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

Use Conditional Formatting with groups in Excel

Use Conditional Formatting with groups in Excel

Protect a worksheet range in Excel

Protect a worksheet range in Excel