————————————————————————————–
EXCEL DATE FUNCTIONS
————————————————————————————–

TODAY() – Returns the current date.

NOW() – Returns the current date and time.

DATE(year, month, day) – Creates a date from individual year, month, and day values.

YEAR(serial_number) – Extracts the year from a date.

MONTH(serial_number) – Extracts the month from a date.

DAY(serial_number) – Extracts the day of the month from a date.

HOUR(serial_number) – Extracts the hour from a time.

MINUTE(serial_number) – Extracts the minute from a time.

SECOND(serial_number) – Extracts the second from a time.

WEEKDAY(serial_number, [return_type]) – Returns the day of the week for a given date.

WEEKNUM(serial_number, [return_type]) – Returns the week number of a date.

DATEDIF(start_date, end_date, unit) – Calculates the difference between two dates in years, months, or days.

NETWORKDAYS(start_date, end_date, [holidays]) – Calculates the number of working days between two dates.

WORKDAY(start_date, days, [holidays]) – Returns the date before or after a specified number of working days.

EDATE(start_date, months) – Returns the date that is the specified number of months before or after a start date.

EOMONTH(start_date, months) – Returns the last day of the month before or after a specified number of months.

YEARFRAC(start_date, end_date, [basis]) – Returns the fraction of the year between two dates.

DATEVALUE(date_text) – Converts a date in text format to a serial number.

TIMEVALUE(time_text) – Converts a time in text format to a serial number.

DAYS(end_date, start_date) – Returns the number of days between two dates.

ISOWEEKNUM(date) – Returns the ISO week number of the year for a given date.

TEXT(serial_number, format_text) – Converts a date to text in a specified number format.

CHOOSE(WEEKDAY(serial_number), value1, value2, …) – Returns a value from a list based on the day of the week.

SEQUENCE(rows, columns, start, step) – Generates a sequence of dates.

FLOOR(date, significance) – Rounds a date down to the nearest multiple of significance.

————————————————————————————–
EXCEL STRING FUNCTIONS
————————————————————————————–

LEFT(text, [num_chars]) – Extracts the leftmost characters from a string.

RIGHT(text, [num_chars]) – Extracts the rightmost characters from a string.

MID(text, start_num, num_chars) – Extracts a substring from a string, starting at a specified position.

LEN(text) – Returns the length of a string.

TRIM(text) – Removes extra spaces from a string, leaving single spaces between words.

CONCATENATE(text1, text2, …) – Joins multiple strings into one (use & operator or CONCAT in newer versions).

UPPER(text) – Converts a string to uppercase.

LOWER(text) – Converts a string to lowercase.

PROPER(text) – Converts the first letter of each word in a string to uppercase.

FIND(find_text, within_text, [start_num]) – Finds the starting position of one string within another (case-sensitive).

SEARCH(find_text, within_text, [start_num]) – Finds the starting position of one string within another (not case-sensitive).

REPLACE(old_text, start_num, num_chars, new_text) – Replaces part of a string with another string.

SUBSTITUTE(text, old_text, new_text, [instance_num]) – Replaces occurrences of a specified string with another string.

TEXT(value, format_text) – Converts a value to text in a specified format.

VALUE(text) – Converts a text string that represents a number to a numeric value.

EXACT(text1, text2) – Checks if two strings are exactly the same (case-sensitive).

REPT(text, number_times) – Repeats a text string a specified number of times.

T(value) – Returns the text part of a value.

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) – Joins multiple strings with a delimiter.

CHAR(number) – Returns the character specified by a number (ASCII value).

CODE(text) – Returns the numeric code for the first character in a text string (ASCII value).

UNICHAR(number) – Returns the Unicode character specified by a number.

UNICODE(text) – Returns the Unicode value for the first character in a text string.

————————————————————————————–
EXCEL LOOKUP FUNCTIONS
————————————————————————————–
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) – Searches for a value in the first column of a range and returns a value in the same row from a specified column.

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) – Searches for a value in the first row of a range and returns a value in the same column from a specified row.

LOOKUP(lookup_value, lookup_vector, [result_vector]) – Searches for a value in a range and returns a corresponding value from another range.

INDEX(array, row_num, [column_num]) – Returns the value of an element in a table or array, selected by the row and column number indexes.

MATCH(lookup_value, lookup_array, [match_type]) – Searches for a specified item in a range of cells and returns the relative position of that item.

OFFSET(reference, rows, cols, [height], [width]) – Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

CHOOSE(index_num, value1, [value2], …) – Chooses a value or action to perform from a list of values, based on an index number.

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) – Searches a range or array and returns the relative position of the item, allowing for exact matches, wildcard
matches, or binary searches.

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) – Searches a range or array and returns an item corresponding to the first match it finds, with various match and search modes.

GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], …) – Extracts data stored in a PivotTable report.

FORMULATEXT(reference) – Returns the formula at a specified reference as text.

FILTER(array, include, [if_empty]) – Filters a range or array based on criteria.

UNIQUE(array, [by_col], [exactly_once]) – Returns a list of unique values from a range or array.

SORT(array, [sort_index], [sort_order], [by_col]) – Sorts the contents of a range or array.

SORTBY(array, by_array1, [sort_order1], …) – Sorts the contents of a range or array based on the values in a corresponding range or array.

TRANSPOSE(array) – Transposes the rows and columns of an array or range.

INDEX(array, row_num, [column_num]) with MATCH(lookup_value, lookup_array, [match_type]) – A combination often used for more flexible lookups.

SUMIF(range, criteria, [sum_range]) – Adds the cells specified by a given condition or criteria.

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) – Adds the cells specified by multiple conditions or criteria.

AVERAGEIF(range, criteria, [average_range]) – Returns the average of the cells specified by a given condition or criteria.

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) – Returns the average of the cells specified by multiple conditions or criteria.

COUNTIF(range, criteria) – Counts the number of cells that meet a specified condition or criteria.

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …) – Counts the number of cells that meet multiple conditions or criteria.

HYPERLINK(link_location, [friendly_name]) – Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet.
INDIRECT(ref_text, [a1]) – Returns the reference specified by a text string.

————————————————————————————–
EXCEL CELL PROPERTIES FUNCTIONS
————————————————————————————–
ISNUMBER(A1) – Is the value in the cell a number.

ISTEXT(A1) – Is the value in the cell text.

ISBLANK(A1) – Is the value in the cell blank.

ISERROR(A1) – Is the calculation in the cell an error.

————————————————————————————–
EXCEL LOGICAL FUNCTIONS
————————————————————————————–

IF(logical_test, value_if_true, value_if_false) – Return a value if the logical_test is true or false.

AND(A1 > 10, B1 < 5) – Test multiple conditions simultaneously, and it returns TRUE if all conditions are met, and FALSE otherwise.

OR(A1 > 10, B1 < 5) – Test multiple conditions simultaneously, and it returns TRUE if at least one condition is met, and FALSE otherwise.

————————————————————————————–
EXCEL RANGE PROPERTIES FUNCTIONS
————————————————————————————–

SUM(A1:A10) – Add up all the numbers in the range.

AVERAGE(A1:A10) – Calculate the average of the numbers in the range.

VLOOKUP(25, A1:C10, 3, FALSE) – Searches for a value in the first column of a range and returns a value in the same row from a specified column

HLOOKUP(“John”, A1:C10, 3, FALSE) – Searches for a value in the first row of a range and returns a value in the same column from a specified row.

COUNT(A1:A10) – Count the number of numeric values in the range.

COUNTA(A1:A10) – Count the number of non-empty cells in the range.

MIN(A1:A10) – Find the smallest number in the range.

MAX(A1:A10) – Find the largest number in the range.

SUMIF(A1:A10, “>5”) – Add the cells specified by the condition.

SUMIFS(A1:A10, B1:B10, “>5”, C1:C10, “<10”) – Adds the cells specified by multiple conditions.

AVERAGEIF(A1:A10, “>5”) – Calculate the average of the cells specified by the condition.

AVERAGEIFS(A1:A10, B1:B10, “>5”, C1:C10, “<10”) – Calculate the average of the cells specified by multiple conditions.

COUNTIF(A1:A10, “>=5”) – Count the number of cells that meet the specified condition.

COUNTIFS(A1:A10, “>=5”, B1:B10, “<10”) – Count the number of cells that meet the specified conditions.

LARGE(A1:A10, 2) – Return the k-th largest value in a range.

SMALL(A1:A10, 3) – Return the k-th smallest value in a range.

RANK(A1, A1:A10, 0) – Returns the rank of a number in a range.

MEDIAN(A1:A10) – Returns the median of the numbers in a range. 

MODE(A1:A10) – Returns the most frequently occurring value in a range. 

FREQUENCY(A1:A10, B1:B5) – Returns the frequency distribution of a range of values.