January 19, 2021

## TRIM function in Google Sheet

In this lesson we will learn how the TRIM function works in Google Sheet. The TRIM function is used to remove leading/trailing/consecutive multiple spaces between …

## LEN function in Google Sheet

In this lesson we will learn how to use LEN function in Google Sheet. LEN function is used when you want to get the total …

## How to Merge cells in Excel

Please follow the below process to merge the cells in Excel. Step 1 : In the below example we will be merging the cells A1, …

## How to remove blank rows from a table in Excel

If you want to delete the blank rows from a table in excel then below are the simple steps to be followed. Step 1 : …

## How to Convert Row to Column and vice versa in Excel

To convert the rows of a table into columns and the columns to rows in excel use Transpose functionality available in Excel. Step 1 : …

## How to calculate Percentage in Excel

If you need to calculate the given value as how much percentage of a total value then do as follows. Step 1 : In the …

## MATCH function in Google Sheet

MATCH function used to get the position of a specific value provided by the user in both excel & Google Sheet. In below example we …

## INDEX Function in Google Sheet

The Index function is used to find the any value in the known position of a table in both excel and Google sheet. Below is …

## How to Create Drop Down in Excel

First create a list which you want to show in the drop down. The list can be created in the same sheet or different sheet. …

## How to remove duplicate values in Excel

If you want to remove all duplicate values from a table in excel please follow the below steps. Step 1 : In the following example …