How to Use the SUMIF Function
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT
If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:
I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how
What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than
What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the
The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be
What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()