How to Use the SUMIF Function

The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the

How to Use CONCATENATE in Microsoft Excel

There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT

DATE vs. DATEDIF Functions

It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a

How to Select and Remove Blank Rows (Video)

In this video we go over how to quickly remove blank rows from an Excel sheet and clean up some free space on our workbook

How to Compare Lists in Excel (Video)

In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but

Pivot Tables (Video)

A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.

How to Use Index & Match (Video)

INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place

Common Errors in Excel (Video)

In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero

Tips for Better Pivot Tables with a Large Data Set (Video)

In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in