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