Chinmoy Mondol

About author

Chinmoy Mondol is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new places during travels, and enjoying movies and TV series in his downtime.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc. in Computer Science and Engineering, American International University-Bangladesh.


Data Analysis, Content Writing, C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office.


  • Teaching Assistant at American International University-Bangladesh.
  • Software Engineer (QA) at TigerIT Bangladesh Ltd.

Latest Posts From Chinmoy Mondol

How to Match Multiple Criteria from Different Arrays in Excel

You have come to the right place if you are looking for the answer or some unique tips to match multiple criteria from different arrays in Excel. There are ...

How to Assign Value If Cell Contains Word in Excel (4 Easy Ways)

If you want to assign a value to a cell based on a certain word in another cell, then you’ll need to build a formula because Excel doesn’t provide a simple way ...

How to Return Value in Excel If Cell Contains Text from List

If you have a list of text and want to search cells and return values based on the list, you'll need to build a formula because Excel doesn't provide a simple ...

How to Convert Number to Words in Excel (4 Suitable Ways)

Spreadsheets are used by many people in their daily jobs, making them an important element of their office. While the majority of people use spreadsheets in a ...

INDEX, MATCH, and COUNTIF Functions with Multiple Criteria

Finding cells that satisfy multiple criteria is a typical task in Excel. There are many ways to accomplish this task. In this article, I will show you how to ...

How to Sum Cells with Text and Numbers in Excel

If you are looking for Excel SUM cells with text and numbers, then you are in the right place. Adding cells in Excel is a simple yet powerful task. There are ...

Excel Conditional Formatting Based on Date (9 Examples)

Conditional formatting has been used in Excel for quite a long time. But what is conditional formatting, and how can it benefit you? The process of putting up ...

Conditional Formatting Based on Date in Another Cell in Excel

Conditional formatting is a useful Excel feature that allows you to show data in a more organized fashion. It is extremely helpful for displaying date ...

How to Add Years to a Date in Excel (3 Easy Ways)

In MS Excel, working with date-type values is a necessary requirement. It involves tasks like adding days, months, or years to existing dates. In this article, ...

How to Multiply by Percentage in Excel (4 Easy Ways)

In Microsoft Excel, calculating changes in percentages or increasing/decreasing percentages are everyday activities. These activities can be completed using ...

How to Add a Percentage to a Number in Excel (3 Easy Methods)

Adding a percentage to a number in MS Excel generally means two things. One is that you want to convert a number to a certain percentage, and the other is that ...

How to Sum Random Cells in Excel

In this free Excel tutorial, you will learn how to sum random cells in Excel. Summing random cells is a frequent need when working with Excel. It is very much ...

How to Move Rows in Excel Without Replacing (5 Easy Methods)

This tutorial will demonstrate how to move rows in Excel without replacing them. While dealing with lots of data, we have to move rows without replacing the ...

Browsing All Comments By: Chinmoy Mondol

Advanced Excel Exercises with Solutions PDF