Question: what are excel advanced functions?
Answer: VLOOKUP. The function is used to look up for a piece of information in a large segment of data and pull that data to your newly formed table. ... 
Sum Function. ... 
MAX MIN function. ... 
IF Function. ... 
SUMIF Function. ... 
COUNTIF Function. ... 
AND Function. ... 
OR function.