TOP FUNCTIONS FOR DATA ANALYSIS AND FINANCIAL MODELLING
Here is a comprehensive list of advanced Excel formulas and functions, categorized for convenience: --- Lookup and Reference VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) HLOOKUP: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) INDEX: =INDEX(array, row_num, [column_num]) MATCH: =MATCH(lookup_value, lookup_array, [match_type]) OFFSET: =OFFSET(reference, rows, cols, [height], [width]) XLOOKUP (Excel 365/2021): =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) CHOOSE: =CHOOSE(index_num, value1, [value2], ...) --- Logical IF: =IF(logical_test, value_if_true, value_if_false) IFS: =IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...) AND: =AND(logical1, [logical2], ...) OR: =OR(logical1, [logical2], ...) NOT: =NOT(logical) --- Text CONCATENATE (or CONCAT in newer versions): =CONCATENATE(text1, [text2], ...) TEXT: =TEXT(value, format_text) TRIM: =TRIM(text) LEN: =LEN(text) LEFT: ...