ASM Arman

About author

Abu Saleh Arman is a Marine engineer and Excel & VBA expert. He loves programming with VBA. He finds VBA programming a time-saving tool to manipulate data, handle files, and interact with the internet. He is very interested in Python, MATLAB, PHP, Deep Neural Networks, and Machine Learning, showcasing his diverse skill set. Arman holds a B.Sc in Naval Architecture & Marine Engineering from BUET, Bangladesh. However, he switched to a content developer, where he writes technical content about Excel and VBA.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Naval Architecture & Marine Engineering, BUET.


Python, MATLAB, PHP, Deep Neural Network, Machine Learning, Excel & VBA


  • Extension Officer at Managing B.SCIC Industry Stimulus Center (B.SCIC), Habiganj.

Latest Posts From ASM Arman

[Fixed!]: Excel Formula Not Showing Correct Result (8 Methods)

While using formulas in Excel, you might not get the result you expect the formula will return, or sometimes the formula will even throw an error. Getting such ...

How to Create a Drop Down List with Unique Values in Excel (4 Methods)

While working with categorical information in Excel i.e., products of different categories, you might need to create a drop-down list with unique values from ...

How to Calculate First Day of Previous Month in Excel (2 Methods)

If you are working with dates in Excel, you might need to find out the first day of the month before the current month you are working with. In Excel, you can ...

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

Imagine we have an Excel file containing data about various fruits exported by a businessman to different European countries. The dataset includes two columns: ...

How to Convert Number to Text and Keep Trailing Zeros in Excel

While converting numbers to text in Excel, you will find that Excel removes the trailing zeros after the decimal point of a number. There is a simple solution ...

How to Group Cells with Same Value in Excel (3 Methods)

Let’s assume a scenario where we have an Excel file that contains information about the products that a country exports to different countries in Europe. We ...

How to Select a Range of Cells in Excel Formula (4 Methods)

Let’s consider an Excel worksheet that contains information about various outlets of a chain restaurant across the United States. The worksheet includes sales ...

Excel VBA: Getting the Cell Value from Another Workbook without Opening it – 2 Examples

How to Launch the VBA Editor in Excel Go to the Developer tab. Select Visual Basic. A new window will open. Select Insert, Choose ...

How to Remove Blanks from List Using Formula in Excel (4 Methods)

Let’s consider a scenario where we have an Excel worksheet containing a list of various computer hardware and accessories. Unfortunately, this list contains ...

Excel Advanced Filter: Apply “Does Not Contain” (2 Methods)

The sample dataset contains the Product Name, Product Category, and the shipping Address of customers. We will use Excel Advanced Filters does not contain ...

How to Undo Delete Sheet in Excel – 3 Methods

  Your Excel file contains information about the Annual Salary and Tax Rate of the employees of a company. Method 1. Making a Copy of an ...

How to Calculate Remaining Days in Excel (5 Methods)

While working on a project in Excel that has a deadline to meet, you might want to find out how many days from today are left until the deadline. You might ...

How to Count Colored Cells In Excel Without VBA (3 Methods)

Oftentimes while working with categorical information in Excel, you might need to color all the cells under a specific category in the same color to ...

How to Use Excel VBA to Paste Range into Email Body (3 Methods)

If you are working with an Excel worksheet that you need to update and share with other people via email on a frequent basis, VBA macro in Excel can reduce the ...

How to Concatenate and Keep Currency Format in Excel (3 Methods)

While concatenating two or more pieces of text in Excel, you will find that the different number formats like currency, decimal format, and percentage format ...

Browsing All Comments By: ASM Arman

Advanced Excel Exercises with Solutions PDF