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.
15
Apr
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