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.

Leave a Reply

You must be logged in to post a comment.


“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA