Find the Difference Between Two DateTimes in Excel
Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding
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.
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
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
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
COUNTIFS – Excel Function
What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English: