Al Arafat Siddique

This article illustrates how we can calculate a centered moving average in Excel with 2 step-by-step examples. The centered moving average is heavily used in ...

The Scroll Lock feature in Excel allows us to control the way of navigation through the worksheet. In this article, we’ll learn how to check the scroll lock ...

This article illustrates 4 different solutions to being unable to unhide rows in Excel. We need to hide rows while working on a large dataset for easy ...

How to Show Percentages in an Excel Pie Chart: 3 Methods Below, we have the population percentages by major ethnic groups in Southern California. We have ...

This article illustrates 2 well-explained examples to VLOOKUP a value that fulfills multiple criteria including a date range in Excel. We frequently use the ...

This article illustrates how to sort merged cells in Excel with step-by-step examples. The default sorting feature prevents sorting merged cells in a dataset. ...

In this article, we’ll learn how to extract hyperlink from URL in Excel using three different methods. We often work with data from various sources that ...

Knowing how to sort range using VBA in Excel is time and effort-saving in our daily calculations. Although Excel provides a sorting facility by default. By ...

This article explains how to remove negative sign in Excel using 7 different methods explained with examples. It happens to many calculations where we need to ...

This article explains three methods to filter horizontal data in Excel. Filtering data vertically is easier with the default Filter feature, pivot table, and ...

The VBA MkDir function can create a new directory or folder to a given drive location in your system. It is a convenient way to make necessary directories ...

To illustrate how to refresh an Excel pivot table, we created two pivot tables for a dataset. The dataset shows a list of sale data with all required details ...

This article illustrates 2 convenient ways to get the sheet name in Excel. The sheet name is a name property of the worksheet Object in Excel. We can ...

In this article, we’ll illustrate how to use the COUNTIF function with the SUBTOTAL function in Excel to count filtered data using two convenience methods. ...

The use of cell references in an Excel formula is very important when formulas are copied and pasted to other cells. Excel worksheet is made of cells and we ...