Lookup values in vertical or horizontal ranges

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Returns the character specified by a number

CHAR(number)

Return the absolute value of a number

=ABS(number)

Return a list of unique values in an array or range

=UNIQUE(array,[by_col],[exactly_once])

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])

Return a filtered range of data based on defined criteria

=FILTER (array, include, [if_empty])

Return the smallest value in a range of values

MIN(number1, [number2], ...)

Return a custom result when a formula generates a #N/A error

=IFNA(value, value_if_na)

Extract characters from the beginning or end of a string.

LEFT(text, [num_chars]), LEFTB(text, [num_bytes])

RIGHT(text, [num_chars]), RIGHTB(text, [num_bytes])

Return the logical value TRUE for any error type.

=ISERROR(value)

Format numbers as text by applying format codes.

TEXT(value, format_text)

Return the logical value TRUE if the cell contains either a TRUE or FALSE statement.

=ISLOGICAL(value)

Count values in a range that meet a single criteria.

COUNTIF(range,criteria)

Convert text into lowercase, uppercase or capitalize the first letter in a string.

LOWER(text), UPPER(text), PROPER(text)