Excel Functions Overview

These flashcards cover essential Excel functions for math, text manipulation, date handling, and data analysis.

SUM

Adds values.

AVERAGE

Calculates the mean.

MIN

Finds the smallest value in a range.

MAX

Finds the largest value in a range.

COUNT

Counts numerical values in a range.

COUNTA

Counts all non-empty cells (text & numbers).

COUNTBLANK

Counts empty cells in a range.

IF

Returns one value if a condition is TRUE and another if FALSE.

IFERROR

Returns a custom value if an error occurs.

LEFT

Extracts a specific number of characters from the start of a text string.

RIGHT

Extracts a specific number of characters from the end of a text string.

MID

Extracts a portion of text from a string.

LEN

Counts the number of characters in a cell.

TRIM

Removes extra spaces from text.

CLEAN

Removes non-printable characters.

PROPER

Capitalizes the first letter of each word.

TODAY

Returns the current date.

NOW

Returns the current date and time.

YEAR

Extracts the year from a date.

MONTH

Extracts the month from a date.

DAY

Extracts the day from a date.

VLOOKUP

Searches for a value in the first column of a range and returns a value from a specified column.

COUNTIFS

Counts the number of cells that meet one or more conditions.

HLOOKUP

Searches in rows instead of columns.

INDEX

Returns a value from a specific row and column in a range.

MATCH

Returns the position of a value in a range.

TEXT

Formats numbers as text.

CONCATENATE (or CONCAT)

Joins multiple text strings into one.

DATEDIF

Calculates the difference between two dates.

ROUND

Rounds a number to a specified number of digits.

INT

Rounds down to the nearest whole number.

SUMIFS

Sums values in a range that meet one or more conditions.

AVERAGEIFS

Returns the average of values in a range that meet specified conditions.

MINIFS

Returns the minimum value in a range that meets specified conditions.

MAXIFS

Returns the maximum value in a range that meets specified conditions.

UNIQUE

Returns a list of unique values from a specified range.

SORT

Sorts an array of values in ascending or descending order.

TEXTBEFORE

Extracts text before a specified character.

TEXTAFTER

Extracts text after a specified character.

TEXTSPLIT

Splits text into multiple cells based on a delimiter.

AND

All conditions inside must be TRUE.

OR

At least one condition inside must be TRUE.