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
The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.
In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but
INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place
This is a crash in Microsoft Excel for total beginners. We’ll start by introducing ourselves to the workbook, slowly
In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero
In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in
In this short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a