Excel’s concatenate function is used to combine character strings from multiple cells. This function can be extremely useful if you need to perform a manual task on a large list of data.

VLOOKUP in excel stands for vertical lookup.

There are various methods used to count cells in Excel. We will be utilizing the COUNT function.

The IF statement is excel is very useful, but can become a little complicated. The following explanation will explain how to easily and properly use this function.

This tutorial will show you how to create a dependent list on Excel. This technique is extremely useful when categorizing data. In the example below, the user will select the State in cell A3. Cell B3 (City) will pull a city based off of the users selection.