Question: what is the best formula in excel?
Answer: CONCATENATE. =CONCATENATE is one of the easiest to learn but most powerful formulas when conducting data analysis. ... 
LEN. =LEN quickly provides the number of characters in a given cell. ... 
COUNTA. =COUNTA identifies whether a cell is empty or not. ... 
DAYS/NETWORKDAYS. ... 
SUMIFS. ... 
AVERAGEIFS. ... 
VLOOKUP. ... 
FIND/SEARCH.