Category: Excel Functions

In this lesson we will learn the usage of COUNTIF function in Excel. The COUNTIF function returns a number that represents the number of cells …

In this lesson we will learn the usage of COUNTIFS function in Excel. The COUNTIFS function returns the count of the cells that meet a …

In this lesson we will learn how the COUNTA function works in Excel. The COUNTA function is used to count the number of non-blank cells …

In this lesson we will learn the use of MATCH function in Excel. The MATCH function is used to get the position of a specific …

In this lesson we will learn how the NOT function works in Excel. The NOT function is used when you want to reverse the value …

In this lesson we will learn about the REPT function in Excel. The REPT function is used when you want to repeat a specified text …

In this lesson we will learn how the MID function works in Excel. The MID function is used to extract a specified number of characters …

In this lesson we will learn the usage of LEFT function in Excel. LEFT function is used to extract specified number of characters from left …

In this lesson we will learn the usage of RIGHT function in Excel. The RIGHT function is used to extract specified number of characters from …

In this lesson we will learn the NOW function in Excel. NOW function is used to get the current date and time value, provided the …