formatting Archives - Excel Nerds

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

One of the easiest formatting improvements you can make is to merge cells in Excel. This is very commonly done when creating

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

Excel

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

Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values

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()