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.
Learn the Count Functions (Video)
There are several COUNT functions in Excel. The video below will help you understand three of the most important ones.
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
How to Use Vlookup (Video)
Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more!
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
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