When we are working with Excel, we often need to find first occurrence of a value from a large dataset range to list out individual products or entries. In ...

When we are handling a large spreadsheet in Excel, we need to hide and unhide columns to get relevant information easily. In this article, we will talk about ...

We often need to remove certain data from a dataset and replace those data with new ones and while removing such data, we often want to delete a column or ...

We often need to calculate the centered moving average values for prediction and forecasting in the real world. This article will introduce you with two basic ...

When we convert numbers to text in Excel, Excel automatically removes the trailing zeros after the decimal point of a number. There are various ways to keep ...

When working with spreadsheets of large volumes, we often need to find and sort things properly. A drop down list is an efficient way of doing so and has lots ...

Often in a dataset, we want to estimate duplicate values once to actually determine the different entries and their number. In a large dataset, counting ...

In a long dataset, we often need to look up values with multiple criteria. In this article, we will utilize VLOOKUP Function with two lookup values to filter ...

While working with Excel, we often need to multiply a column by a constant. Although this is a straightforward approach, there isn’t only one way of doing ...

Numbers, alphabets, and non-alphanumeric characters often get mixed up in huge volume of data and we often need to remove non-alphanumeric characters in Excel. ...