TOP 5 Most Used Formulas In Excel | Video #12
This video will help you understand the TOP 5 most used formulas in excel -(Sum, Autosum, If, Vlookup, Countif, Sumif & Concatenate functions). With these formulas you will be able to do most of the excel tasks
The Top 1 on my list is SUM function 0:30
Sum function is the most common and widely used formula. Excel is a complex calculator, which can do multiple complex calculations and Sum function is one of the simplest and most effective one's of those
The shortcut formula for the Sum function is the Auto sum
Auto sum function helps reduce time of inputting the sum function and it is needed the most because the sum function is used very often
and one thing is to be noted is that Auto sum auto detects the values above it and calculates them, however if it finds any space and text in the cells above, it will stop itself at that point.
Top 2 on my list is IF function 4:29
IF function is the one of the most used logical function because of its easy to understand syntax. IF function tests a logic and if the logic is true or false you can give some command to the IF function to do
Top 3 on my list is VLOOKUP function 6:34
Vlookup is mostly used because of its application. Often you want to extra some values based on a lookup criteria. It can be in same spreadsheet or different spreadsheet or different work. Vlookup will do the job in all cases
Top 4 on my list is COUNTIF function 8:43
COUNTIF function is used to count based on a condition, like in the video we have counted the number of students who have passed the exam so, here Count function gives you the count of students and IF function takes the condition of "Pass" and result is the number
Bonus : SUMIF function 9:54
SUMIF function is used to count based on a condition, like in the video we have summed the number of students who have passed the exam so, here SUM function gives you the SUM of students and IF function takes the condition of "Pass" and result is the total students who have passed the exam
Top 5 on my list is CONCATENATE Function 11:31
Concatenate function is very powerful function it joins two text strings. it is widely used in places where you have first name and last name and you need to join them or concatenate them so, that you have a unique name and often it is used in conjunction to Vlookup function to create a unique lookup criteria
You can also check the individual videos for in depth understanding
Learn the IF function in detail from the below link:
• IF formula in Excel | Video #3
Learn the VLOOKUP function in detail from the below link:
• VLOOKUP Tutorial in Excel | Video #8
Learn the COUNTIF function in detail from the below link:
• The COUNTIF formula in Excel | Video #5
Learn the CONCATENATE function in detail from the below link:
• How to combine two text in Excel | Video #7
Learn Excel from beginner to Intermediate level within 60 minutes from below playlist:
• Getting started with Excel - The Beginners...
Hope you like the video, Thank you for watching
Subscribe to my channel Excelbykumar for more videos and updates:
/ @excelwithkumar
#MicrosoftExcel
#ExcelwithKumar