Microsoft Excel Blog: Tutorials and How-Tos

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

Break-even analysis in Excel with multiple products

Break-even analysis in Excel with multiple products

Use array functions in Excel to perform multiple calculations in one cell

Use array functions in Excel to perform multiple calculations in one cell

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