# Mahbubur Rahman

MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel and VBA. Outside work, catch him reading books, exploring new places during travels, and watching movies.

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Expertise

MS Word, MS Excel, MS PowerPoint, VBA, PowerQuery, PowerPivot, SPSS and STATA

## Experience

• Technical Content Writing
• Project Management
• Machinery and Tools

## How to Replace Text in Selected Cells in Excel: 4 Simple Methods

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 ...

## How to Reverse Transpose in Excel (3 Methods)

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

## How to Convert Excel to a Text File with Pipe Delimiter (2 Ways)

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 ...

## How to Split Text by Space with Formula in Excel (5 Ways)

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 ...

## Random Selection Based on Criteria in Excel: 3 Methods

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

## How to Space Down in Excel: 3 Methods

Method 1 - Using Shortcut to Space Down in Excel Steps: Double-click on Cell C5 and click before the text 1994 as we want to space it down, and press ...

## How to Remove Print Titles in Excel (3 Methods)

We occasionally need to print exported files or files that we have received from others. In that case, we may face difficulties with print titles that come as ...

## How to Filter by List in Another Sheet in Excel – 2 Methods

This is the sample dataset. and a list for filtering in the List for Filter sheet.   Method 1 - Filter by List in Another Sheet Using the ...

## How to Interpolate in Excel Graph (6 Methods)

In Excel, interpolation allows us to determine the value between two points on a graph or curve. It helps us anticipate future values that lie between existing ...

## How to Find Duplicates without Deleting in Excel (7 Methods)

Method 1 - Use the COUNTIF Function to Find Duplicates in Excel without Deleting Steps: Enter the following formula in cell F5: ...

## How to Hyperlink Multiple Cells in Excel (3 Ways)

In this article, we will describe how to hyperlink multiple cells in Excel using 3 different methods. We'll use the following sample dataset containing ...

## How to Remove Currency Symbol in Excel (6 Ways)

Excel automatically includes a Dollar symbol for the cells formatted as currency. We will show you how to remove the currency sign from the cells. We will use ...

## How to Insert a Picture in a Cell Automatically – 3 Methods

The sample dataset showcases Car Models. To add pictures:   Method 1 - Insert a Picture in an Excel Cell Automatically Using the Insert ...

## If Cell Contains Text Then Add Text in Another Cell in Excel: 6 Ways

To explain detecting and adding text to cells, let's use a sample dataset containing ID, Product Name, and Size.   Method 1 - If Cell ...

## How to Find the * Character (Not used as a Wildcard) in Excel – 2 Methods

This is an overview: Press CTRL+F and enter asterisk (*) in the search box. If you click Find Next, no results will be displayed. ...

Browsing All Comments By: Mahbubur Rahman

Advanced Excel Exercises with Solutions PDF