Mahbubur Rahman

About author

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.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.



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


  • Technical Content Writing
  • Project Management
  • Machinery and Tools

Latest Posts From Mahbubur Rahman

How to Replace Text in Selected Cells in Excel (4 Simple Methods)

While working with Excel, you may feel the need to find particular text within a selected cell, or even feel the need to replace that text. Microsoft Excel ...

How to Reverse Transpose in Excel (3 Simple Methods)

We all know about transposing in Excel. What about reverse transpose? It is slightly a different concept. In this web post, we will see How to Reverse ...

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)

There are numerous ways to split text in Excel. In this article, we will see several methods for Excel split text by space formula. We have a sample dataset ...

Random Selection Based on Criteria in Excel (3 Cases)

Suppose we have a list of Name, Profession, Age, and Region. From the list, we want to get random Names but based on specific criteria. How should we do that? ...

How to Space Down in Excel (3 Methods)

In most office applications adding a new line, paragraph or space down is not a problem. But Microsoft Excel is different in this case. We will see how to ...

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 get the value between two points on a graph or curve line. It is used to detect or anticipate the future value that lies ...

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

While dealing with a huge amount of data, we often encounter duplicate entry problems in Excel. The most used methods to find duplicates in Excel are the ...

How to Hyperlink Multiple Cells in Excel (3 Ways)

In Microsoft Excel, hyperlinks are used as a link to certain web pages. It can also be a handy tool to link another file, Excel sheet, or cell. By clicking ...

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 Picture in Excel Cell Automatically (3 Ways)

While Microsoft Excel is usually used for calculations, you may wish to save images with data in some cases and correlate an image with a specific piece of ...

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 * Character Not as Wildcard in Excel (2 Methods)

The wildcard is a special character that helps us to match texts in Excel. This is a very handy tool. Excel has three characters as wildcards to use in ...

Browsing All Comments By: Mahbubur Rahman

Advanced Excel Exercises with Solutions PDF