Microsoft Excel Blog: Tutorials and How-Tos

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

Use Icon Set in Excel - just two arrows by Chris Menard

Use Icon Set in Excel - just two arrows by Chris Menard

Use Sparklines in Microsoft Excel

Use Sparklines in Microsoft Excel

Excel - make accounting, currency, and number style zero decimal places by default

Excel - make accounting, currency, and number style zero decimal places by default

Outlook mail merge - personalize email messages

Outlook mail merge - personalize email messages

Use the COUNTIF function in Microsoft Excel

Use the COUNTIF function in Microsoft Excel