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,...
