Shakil Ahmed

For this article, we'll use the List of Movies dataset ranging from B4 to D24 and containing the name of the Movie, Actor, and Release Year. The goal is to ...

Dataset Overview The dataset comprises several authors, some of their books, and the respective release years of the books. With this dataset, we'll ...

We have a table with movie information in the sheet called Details. We will pull values from this table to the other worksheets. Method 1 - Use a ...

The image below is the dataset example. Note that this is a basic dataset to keep things simple. In a practical scenario, you may encounter a larger and ...

  We have included some famous Athlete names in the Athlete Profile. We will hyperlink to a cell with this dataset. Method 1 - Using the ...

Let's use a table that contains several actors from different film industries with one of their popular movies. We'll find different values based on movie or ...

Today we are going to show you how to find and replace using wildcards. While dealing with data in Excel you may need to eradicate errors or modify your data ...

We have a table that contains student information and their grades. We will check if a cell contains specific text. Method 1 - Using the IF Function ...

Let’s consider the Employee Information dataset shown in the B4:E10 cells which contains the “First Name”, “Last Name”, “Country Code” and “Area Code” columns ...

The sample dataset has a listing of products. We'll combine the products from the two columns into the fourth column, separating the values by a comma. ...

This article will cover many essential methods to merge rows in Excel. We'll walk you through applying features and VBA for merging rows. You will also learn ...

This is the sample dataset.   To concatenate the First Name and Last Name:   Method 1. Combine Names in Two Columns with ...

In Excel, you may come across repetitive tasks often. To number rows is one of these tasks which can be a time-consuming one. There are several ways of ...

In this article, we will describe various techniques to autocomplete cells or columns from a list in Excel. We used Excel 2019 here, but the techniques apply ...

Inserting dates in Excel can be used for a variety of purposes, including data tracking and date-time calculations. In this article, we are going to show you ...