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
In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but
A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.
There are several COUNT functions in Excel. The video below will help you understand three of the most important ones.
INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place
Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more!
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