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
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.
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
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
How to Make a Combo Chart in 2 Minutes
In this short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a
Learn the LEFT, RIGHT, and MID Functions in Excel
Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings