## How to Merge Cells in Excel (with Video)

Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to

## 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

## Using SUMIFS in Excel to Analyze a Budget

Creating a budget in Excel can be a painstaking process. Auditing what you spend on groceries, entertainment, rent,

## 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

## XLOOKUP vs. INDEX & MATCH

The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.

## 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

## 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

## Excel Tutorial for Beginners (Run Time ~30 Minutes)

This is a crash in Microsoft Excel for total beginners. We’ll start by introducing ourselves to the workbook, slowly

## 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