TRIM function in Google Sheet
by 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 …
Author: abhraisraja
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 …