Mahbubur Rahman

The Microsoft Excel ribbon is a row of tabs and icons at the top of the Excel window that lets you rapidly identify, understand, and utilize commands to ...

Method 1 - Replace the Text in Selected Cells Using Find and Replace Steps: Select the range of cells we want to perform find and replace it. Go to ...

The absolute reference comes in very handy when we want to fix a cell. An absolute reference contains a dollar sign ($).In this article, we will see different ...

Dataset Overview We’ll work with a sample dataset containing columns for Name, Age, Gender, and Monthly Income. Method 1 - Reverse Transpose Using ...

Excel offers some cool features to import txt, csv, etc. files in the worksheet. Suppose, we have a sample text file containing Text and commas as delimiters. ...

The dataset below contains 4 columns. The first column displays the full names of individuals. The following three columns have divided these names into First ...

We have a sample dataset containing Names. Space is used as a delimiter here. Let's split the text using formulas in Excel. Method 1 - Combining ...

Sometimes, we may feel the need to open multiple Excel files in one workbook for better presentation and ease of moving from one file to another. In this ...

Sometimes, while working in Microsoft Excel we may feel the need to rearrange rows according to our convenience. Suppose, we have a dataset like the image ...

Sometimes, when we group rows in Excel, the plus sign that appears as an outline can be confusing to use. We can change this by moving it on top for a better ...

Calculating a simple average and a weighted average are two different things. For example, if you take Quizzes and all of them have the same weight, the ...

Method 1 - Random Selection Based on Criteria Using INDEX Function Steps: Type the following formula in cell G8. ...

Assume you have a set of dates in a spreadsheet and want to know what percentage of the year or month has passed or remains based on the given date. In this ...

Hyperlinks in an Excel file can relate to the location of a file on the computer or a place inside the same worksheet. Furthermore, hyperlinks might lead to a ...

To make your dataset cool and presentable Sorting alphabetically is one of the most used functions in Excel. Throughout this article, we will learn how to make ...