MAX – Excel Function
What it does: The MAX() function returns the largest value in a list of numbers. Plain English: You may be working with a
SUM – Excel Function
What it does: The SUM() Function adds values together. You can select a list of values or an array. Plain English: This
TRIM – Excel Function
What it does: The TRIM() function removes extra spaces from a text string, whether at the beginning, middle, or end. It will
TEXT – Excel Function
What it does: The TEXT() function takes a text input and formats the text according to format you select. Plain English: Many
SUBSTITUTE – Excel Function
What it Does: The SUBSTITUTE() function in Excel substitutes one or more instances of a string (or number) for something
SEARCH – Excel Function
What it Does: The SEARCH() function in excel locates the position of a string inside of a cell. When searching for text
MATCH – Excel Function
What it Does – Locate the position (often the row number) of an item in an array. Arguments: MATCH(lookup_value,
FIND – Excel Function
What it Does: The FIND() function in excel locates the position of a string inside of a cell. When searching for text
REMOVE DUPLICATES in Excel
How to Remove Duplicates in excel in a few clicks
13
Sep