10 Most Used Excel Functions

These are the 10 most used Excel functions. This video covers the following Excel functions: Sum, SumIF, Count, CountA, CountIF, IF, AND, Vlookup, Index and Match.

10 Most Used Excel Functions

These are the 10 most used Excel functions: Use the Sum function to add up lists. The average function can be used to work out averages within lists. The SumIF function is used to add up a list that has a conditional element. The CountIF function is used to count a data set by category. The IF and AND are used in conjunction to process logical test results. Vlookup, Match and Index function are used to analysis data sets. The Count and CountA functions are used to count ether numbers or non blank cells.


You can buy the training manual on all things Excel from here. You can also complete any Excel course via video here. If you would like an online course these are available via Teams, email: steve@itseasy.co.uk for more info. Classroom based courses are available from this website here.


The Sum, Count, Average functions are covered on the Introduction course. IF and Vlookup functions are covered on the Intermediate course all the other functions are covered on the Advanced course. These functions are all common functions used everyday in Excel. If you understand how these work it will help you in your day to day job. Excel is still the market leader around the World. I recommend that you enhance your skills with one of our courses.