Adnan Khan

Adnan Khan

how to remove grid line from excel sheet

How to remove grid line from excel sheet  Look at the data below. In this data, you can see gridlines in the background. We want to remove these gridlines. First, we need to go to the View tab. After going…

How to apply sumifs() formula or function

I have sales data, and I’ll show you how to apply the SUMIFS formula on it. I have the data below, please take a look. Type sumifs Formula. And select sum_range And then after that, select Criteria Range 1. Then…

Data cleansing In Excel

I have the given sales data  I’ll show you how we can clean this ten-thousand row data. I have input sale data below I want to clean this data  it has duplicates and spelling mistakes I will do it. Steps…