Excel has hundreds of built-in functions that will let you analyze, manipulate, and model data in any way you can imagine, but the key is knowing which functions exist and how to use them. Read through the following functions, shortcuts, and tips so that you are familiar with Excel's functionality.
The COUNTIFS Function is similar to the COUNTIF function, but it returns the number of cells in a specified range which meet
multiple criteria. COUNTIFS Function →
The FIND Function in Excel searches for a case-specific substring within a string of text and returns the substring's position.
FIND Function →
The IF Function in Excel lets you add logical decisions to your Excel spreadsheet, and return different values based on whether a condition is true or false.
IF Function →
The LEFT Function in Excel returns a string of text consisting of the specified number of the leftmost characters of another string of text.
LEFT Function →
LEN, LEFT, RIGHT, MID Functions
The LEN, LEFT, RIGHT, and MID Functions in Excel return different sections of a string of text, such as the leftmost 5 characters, or other slices of text.
LEN, LEFT, RIGHT, MID Functions →
Logical Operators in Excel (greater than, less than, equal to, and others) compare two values and return true or false depending on the values and the operator used. They form the foundation of logical functions.
Logical Operators →
The MATCH Function in Excel returns the position of a specified value in a list. MATCH is often paired with INDEX to create a lookup more flexible than VLOOKUP.
MATCH Function →
The MID Function in Excel returns a substring of text from within the middle of a larger string of text.
MID Function →
The TEXTJOIN Function in Excel combines multiple strings of text into a single string with a common delimiter or separator between each original string of text.
TEXTJOIN Function →
Wildcard characters serve as a placeholder for characters when searching for text in Excel. Combine them with functions when searching for partial text matches.
Wildcard Characters →