10 Excel functions everyone should know (A must for an Excel user).
This video covers some of the most common functions used in Microsoft Excel. The Sum function, Average function, IF and And functions, SumIF, CountIF, Vlookup, Index and Match and finally two count funtions, Count and Counta. Some great 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.
Courses are available via Teams email: [email protected] for more info.
#itseasytraining
#10ExcelFunctions
#Excelcourses
#exceltraining
Training at http://www.itseasy.co.uk/
Online courses at http://www.itseasytraining.co.uk/
Check out the ebook for Microsoft Excel https://payhip.com/b/IE4x
Tags
itseasytraining1st,#10 Excel functions you should know,10 Excel functions everyone should know.,how to use functions in excel,how to use spinners in excel,what are the best functions in Excel,What should I know in Excel,IF function,How do i use the IF and And functions,Vlookup function,How does the index function work,how does the match function work,Excel Tutorial,excel formulas and functions,learn excel,10 most used excel formula
#seletraining
/ @seletraining
• 10 Most Used Excel Formula ☑️
Watch video 10 Excel functions everyone should know (A must for an Excel user). online without registration, duration hours minute second in high quality. This video was added by user ITsEasyTraining1st 20 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,255 once and liked it 15 people.