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
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
Common Errors in Excel (Video)
In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero
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
How to Delete Extra Columns and Rows (Video)
In this video we’ll cover how to delete extra columns and rows in Excel using the keyboard shortcuts! View this post on