## How to Use CONCAT in Excel

In addition to the very popular CONCATENATE function, you’ll find it very useful to learn how to use CONCAT in excel.

In addition to the very popular CONCATENATE function, you’ll find it very useful to learn how to use CONCAT in excel.

Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding

The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.

Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more!

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

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

Copyright ©2022 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis

Developed by WOWLayers.com