Basic Excel Functions Guide
Master the foundational Excel functions every beginner needs. Learn syntax, real-world examples, and copy-paste ready formulas for daily work.
🧮Math & Trig Basic Functions
3 functionsAdds all numbers in a range of cells.
=SUM(number1, [number2], ...)=SUM(A2:A100)Returns a random integer number between the numbers you specify.
=RANDBETWEEN(bottom, top)=RANDBETWEEN(1, 100)Generates an array of sequential numbers, such as 1, 2, 3, 4.
=SEQUENCE(rows, [columns], [start], [step])=SEQUENCE(10, 1, 100, 10)🔎Lookup & Reference Basic Functions
5 functionsFlips the orientation of a range or array from horizontal to vertical, or vice versa.
=TRANSPOSE(array)=TRANSPOSE(A1:D1)Looks up a value in a single-row or single-column range and returns a value from the same position in another range.
=LOOKUP(lookup_value, lookup_vector, [result_vector])=LOOKUP(A2, D2:D10, E2:E10)Returns a value from a list of arguments based on an index number.
=CHOOSE(index_num, value1, [value2], ...)=ROW(A5)Returns the column number of a cell reference.
=COLUMN([reference])=COLUMN(C1)Sorts the contents of a range or array based on the values in a corresponding range or array.
=SORTBY(array, by_array1, [sort_order1], ...)=SORTBY(A2:B10, B2:B10, -1)⚖️Logical Basic Functions
2 functionsChecks whether a cell contains a numeric value.
=ISNUMBER(value)=NOT(A2>50)Returns a value you specify if a formula evaluates to the #N/A error value; otherwise returns the result of the formula.
=IFNA(value, value_if_na)=RANDARRAY(5, 2, 1, 100, TRUE)Master Advanced Excel Functions
Learn XLOOKUP, INDEX & MATCH, SUMIFS, FILTER, UNIQUE, SORT, and dynamic array formulas.