January 19, 2021

## REPT function in Excel

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 …

## MID function in Excel

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 …

## LEFT function in Excel

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 …

## RIGHT function in Excel

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 …

## NOW function in Excel

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 …

## HLOOKUP Function in Excel

In this lesson we will learn about HLOOKUP function in Excel. HLOOKUP allows us to search the approximate and exact matching, wildcards (* ?) for …

## VLOOKUP Function in Excel

In this lesson we will learn the ins and outs about the VLOOKUP function in Excel. This is one of the most commonly used functions …

## COLUMN function in Excel

In this lesson we will learn how the COLUMN function works in Excel. The COLUMN Function is used to get the column number of a …

## ROW function in Excel

In this lesson we will learn how the ROW function works in Excel. The ROW Function is used to get the row number of a …

## COLUMNS function in Excel

In this lesson we will learn how the COLUMNS function works in Excel. We use COLUMNS function to count the number of columns in a …