Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

Enter the “ Column Column Chart ” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...