SUM SUMIF SUMIFS |
AVERAGE AVERAGEIF AVERAGEIFS |
COUNT COUNTIF COUNTIFS |
COUNTA |
IF Nested IF Conditional IF |
IFERROR error Handling |
CLEAN TRIM |
LENGTH |
LEFT RIGHT |
MID and Text to Columns |
LOWER and UPPER CASE |
PROPER CASE |
TEXT |
ROUND |
ROUNDUP |
ROUNDDOWN |
ABS Absolute |
POWER |
SQRT Square Root |
RAND |
RANDBETWEEN |
CEILING and FLOOR |
MOD |
SUBSTITUTE |
REPT |
SEARCH and FIND |
CHOOSE |
AND Operator |
OR Operator |
NOT Operator |
XOR Operator |
IFNA |
IFS |
VLOOKUP |
HLOOKUP |
XLOOKUP |
MATCH |
INDEX with MATCH |
OFFSET |
INDIRECT |
ROW and COLUMN |
ADDRESS |
ROWS and COLUMNS |
DATE TODAY |
DATETIME NOW |
DATEDIF |
EDATE |
EOMONTH |
WORKDAY |
NETWORKDAYS |
EXTRACT DAY MONTH YEAR |
EXTRACT HOUR MINUTES SECONDS |
EXTRACT WEEKDAY WEEKNUM |
CONCAT |
TEXTJOIN |
CHAR |
CODE |
VALUE |
T |
Normal Filter and FILTER Formula |
SORT formula vs Manual sort |
UNIQUE Formula vs Remove Duplicates Vs Highlight Duplicates |
Multiple Sorts vs SORTBY |
SEQUENCE |
ARRAYFORMULA in Google Sheets |
TRANSPOSE |
MMULT |
ISFORMULA |
ISERROR |
ISNA |
ISBLANK |
ISNUMBER |
ISTEXT |
ISLOGICAL |
TYPE |
SHEET vs SHEETS |
SPARKLINE |
HYPERLINK |
Convert Data into Table Format |
Table Slicers |
PIVOT Table |
Sort data, highlight duplicates and text to columns |
Insert Blank Rows by GROUPING |