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 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!
Top 5 Things to Know in Excel
I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how
06
Oct
RANDBETWEEN – Excel Function
What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than
RAND – Excel Function
What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother
Dates in Excel – Part 1
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the
30
Sep
AVERAGE – Excel Function
The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be
SMALL – Excel Function
What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()
LARGE – Excel Function
What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function