Basic Excel Functions

MODE

Calculate the most frequently occurring number within a range, hence the mode

PMT

Calculates the annuity payment

AVERAGE

Calculates the average of a range of cells

AVERAGEIF

Calculates the average of a range of cells based on one criteria

FV

Calculates the future value

RATE

Calculates the interest rate

NPER

Calculates the number of periods required to pay off a loan for a constant period payment and a constant interest rate

PV

Calculates the present value

VLOOKUP

Looks for a value in the leftmost column of a table, and then returns a value in the same row from another column you specify

HLOOKUP

Looks for a value in the topmost row of a table, and then returns a value in the same column from another row you specify

{}

Notation used in excel when working with arrays

AND

Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false. Usually used within expression of IF function.

OR

Returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false. Usually used within expression of IF function.

INDEX

Returns a specific value in a two-dimensional or one-dimensional range

CHOOSE

Returns a value from a list of values based on a position number

MATCH

Returns the position of a value in a given range

STEDV

TO calculate the standard deviation within a range

TIME

To add a number of hours, minutes, and/or seconds to a time in an existing cell

DATE

To add a number of years, months, and/or days to a date in an existing cell

IF

To check whether a condition is met. Returns one value if TRUE and another value if FALSE.

COUNTIFS

To count cells based on multiple criteria

COUNTIF

To count cells based on one criteria

COUNT

To count the number of cells that contain numbers

MID

To extract a substring that starts in the middle of a string

LEFT

To extract the leftmost characters from a string

RIGHT

To extract the rightmost characters from a string

LARGE

To find the largest number within a range

MAX

To find the maximum value within a range

MEDIAN

To find the median (or middle number) within a range

MIN

To find the minimum value within a range

FIND

To find the position of a substring within a string

SMALL

To find the smallest number within a range

ROUNDUP

To found a number up

NOW

To get the current date and time

DAY

To get the day of a date in an existing cell

HOUR

To get the hour of a time in an existing cell

LEN

To get the length of a string

MINUTE

To get the minute of a time in an existing cell

MONTH

To get the month of a date in an existing cell

SECOND

To get the second of a time in an existing cell

YEAR

To get the year of a date in an existing cell

& " " &

To join strings

SUBSTITUTE

To replace existing text with new text in a string

ROUND

To round a number

ROUNDDOWN

To round a number down

SUM

To sum a range of cells

SUMIFS

To sum a range of cells based on multiple criteria

SUMIF

To sum a range of cells based on one criteria