Text Functions – LEFT, RIGHT, CONCATENATE, UPPER, LOWER, TRIM, LEN, FIND, SEARCH, SUBSTITUTE, REPLACE
Datetime – DATE, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, NOW, and TODAY
Logical functions – IF, SWITCH
Lookup functions – VLOOKUP, HLOOKUP, INDEX, MATCH, and INDEX/MATCH combination
ALL, ALLSELECTED, CALCULATETABLE, SELECTEDVALUE, ROWNUMBER, ORDERBY