IF

=IF(LogicalTest,[ValueIfTrue],[ValueIfFalse])

SUM IF

=SUMIF(Range,Criteria,[sum_range])

COUNT IF

=COUNTIF(Range,Criteria)

RANK

=RANK(Number,Array,[Order])

VLOOKUP

=VLOOKUP(Value,Table,Column_Index,[Range_Lookup])

Most people started the data analysis with Microsoft Excel. Everybody knows that Excel very common and useful software. Also its consist of some functions, pivot tables, data cleaning etc. So every business need an excel spreadsheets for productivity. In this article we will discuss most practical excel function that you can use in your data analysis.

Please don’t forget that real life data is always messy and huge so formulas are very important.

Table of Contents

IF

This function is very useful logical function when it comes to condition. The function return as a True or False. You can use this function with And logic or you can use with Nested If. Here is the syntax :

=IF(LogicalTest,[ValueIfTrue],[ValueIfFalse])

SUMIF

This is alike if but plus you can choose a range and you can return sum of all data. Here is the syntax :

=SUMIF(Range,Criteria,[sum_range])

COUNTIF

This a cell count function that you can numbers the datas. Its very useful for find a specific range of numbers. Here is the sytntax:

=COUNTIF(Range,Criteria)

RANK

This is order function that shows us the numbers compared with in list. Here is the syntax :

=RANK(Number,Array,[Order])

VLOOKUP

This is the eligible for counting in vertical tables. You can browse around the tables. But the values must be in the first column. Here is the syntax:

=VLOOKUP(Value,Table,Column_Index,[Range_Lookup])

Initially typing functions could be bored but i assure you that is very easy and useful. So get out there , open an excel spreadsheet and begin to use those functions. Do you need any idea ? Just start with the count your exam’s score .