1.

What According To You Are The Top 5 Functions In Excel?

Answer»

While there are 450+ functions in Excel and there is no SET criterion to SELECT the top FIVE, here are the ones I believe are worthy:

  • VLOOKUP
  • COUNTIF
  • SUMIF
  • IFERROR
  • INDEX / MATCH

I have CHOSEN the above functions as these are not very basic and are quite useful for someone who does analysis in Excel. You can also consider the following functions - SUMPRODUCT, TEXT, SUM, AVERAGE, and LEN/LEFT/RIGHT/MID. 

Again, there is no right or wrong answer to this. Just make sure you know the functions that you mention.

While there are 450+ functions in Excel and there is no set criterion to select the top five, here are the ones I believe are worthy:

I have chosen the above functions as these are not very basic and are quite useful for someone who does analysis in Excel. You can also consider the following functions - SUMPRODUCT, TEXT, SUM, AVERAGE, and LEN/LEFT/RIGHT/MID. 

Again, there is no right or wrong answer to this. Just make sure you know the functions that you mention.



Discussion

No Comment Found