Proper

Use the PROPER function to capitalize names

Vlookup

 Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify… Basically, you define a value (the lookup_value) for the formula to look for. It looks for this value in the leftmost column of a table (the table_array).

Sumif

The SUM function in Excel allows you to add up the values in a range of cells. However, sometimes you only want to add up the cells that meet certain criteria. That’s where the SUMIF function comes in handy, along with the more capable SUMIFS function

You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula:

=SUMIF(B2:B25,”>5″)

You want to add up all the cells in a range where the cells in another range meet a certain criteria, e.g. add up all cells in a column (e.g. Salesperson name) where the cells in another column (e.g. Quantity Sold) is 5 or more.

=SUMIF(range, criteria, [sum_range])

Text to columns

To separate the contents of one Excel cell into separate columns

Count (for duplicates on mobile #, email)

The count formula counts the number of cells in a range that have numbers in them

Sort

Process of arranging objects in a certain sequence or sort order according to specific rules

Concatenate (&)

Combine data in 2 (or more) different cells into one cell

Mid, Right, Left

These formulas return the specified number of characters from a text string. RIGHT gives you the number of characters from the right of the text string, LEFT gives you the number of characters from the left, and MID gives you the specified number of characters from the middle of the word. You tell the MID formula where to start with the start_number and then it grabs the specified number of characters to the right of the start_number.

Len

The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.

Trim

Gets rid of any space in a cell, except for single spaces between words.