Nuraida Kashmin

Sometimes we need to find and highlight duplicate rows based on multiple columns in Excel. It makes the huge dataset attractive and easy to calculate. In this ...

Sometimes for easy calculation, we need to split an Excel sheet into multiple sheets based on rows. In this article, we are going to learn how to do that by ...

Sometimes we input an Excel formula in a worksheet but it’s not working for some reason. It shows a warning prompt instead which mentions Circular Reference. ...

Sometimes we need to trim space or character from an entire text in Excel to make the dataset attractive. We can use different Excel functions like TRIM ...

Sometimes we need to remove a table from the worksheet in Excel, although it makes the worksheet dynamic. We can also remove the table formatting style. In ...

Sometimes we need to count if the date is within 7 days from the dataset for quick calculation. In this case, we need to use some Excel formulas with the ...

We can split a cell, a text string, or a column using an Excel formula. This makes the dataset more readable and easily accessible to the correct information. ...

Excel formulas help us to find value from a long column by splitting one column into multiple columns. These make the dataset more readable and easily ...

Sometimes it becomes difficult to find value from a long Excel column. So we need to split one column into multiple columns in Excel. It makes the dataset more ...

Sometimes in Excel, we input the date but it returns it as a bunch of numbers as it stores the date value as a number. This makes the dataset very difficult to ...

Date Range in Excel helps us to do a calculation on date values. In this article, we are going to know more about the Excel Formula for the date range with ...

To add space between rows, we need to insert blank cells between them. We can do it manually by right-clicking, pressing the keyboard shortcut, or using the ...

Sometimes we need to sum identical ranges across the different worksheets. We can use a formula based on SUMIF, INDIRECT & SUMPRODUCT functions for this ...

Sometimes we need to color our Excel cell to make the dataset unique, highlighted, beautiful, and easy to visualize. In this article, we will know how to color ...

If the cell contains the text we can use the combination of INDEX & MATCH functions to perform a smart and advanced lookup. It’s a very popular used ...