Conditional

Create conditional formulas


Display or hide zero values


Hide error values and error indicators in cells



Lookup

Look up values in a list of data

Date and Time

Add or subtract dates


Add or subtract units of time


Calculate the difference between two dates


Calculate the difference between two times


Count days before a date


Show dates as days of the week


Insert the current date and time in a cell


Insert Julian dates

Financial

Calculate a running balance


Calculate a compound annual growth rate (CAGR)

Statistical

Calculate the average of a group of numbers


Calculate the median of a group of numbers


Find the most frequent number in a group of numbers

Math

Add numbers


Subtract numbers


Multiply numbers


Divide numbers


Calculate percentages


Round a number


Raise a number to a power


Calculate the smallest or largest number in a range


Calculate the factorial or permutation of a number


Create a multiplication table

Counting

Count nonblank cells


Count how often a value occurs


Count unique values among duplicates


Count numbers greater than or less than a number


Calculate a running total

Conversion

Convert times


Convert dates stored as text to dates


Convert numbers stored as text to numbers


Convert measurements


Convert numbers to different number systems

Text

Change the case of text


Check if a cell contains text (caseinsensitive)


Check if a cell contains text (casesensitive)


Combine text and numbers


Combine text with a date or time


Combine first and last names


Combine two or more columns by using a function


Repeat a character in a cell


Display only the last four digits of identification numbers


Remove spaces and nonprinting characters from text


Remove characters from text


Insert the current Excel file name, path, or worksheet in a cell


Split names by using the Convert Text to Columns Wizard


Split text among columns by using functions
