Important Excel Formulas and Commands we need to know

Some of the important Excel formulas and commands are as follows: Column to comma-separated values =TEXTJOIN(",", TRUE, A:A) Select entire column Ctrl + Space Look for value from a column in table or list =VLOOKUP($A1, list2, 2, false) =VLOOKUP(A2,...