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
Merge and Center Text Across Cells (Video)
Today’s video is about how to merge and center text across cells. This is easy to do with the mouse but did you also
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
How to use Paste Special in Excel
Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values
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()