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 (6 Methods)

We'll use a dataset that contains information about some clothing products. It has four columns, the name of the product, the Color, the Size, and the Price as ...

How to Assign a Value If a Cell Contains a Word in Excel – 4 Methods

  This is the sample dataset. Method 1 - Combining the IF and the COUNTIF Functions Use a combination of the  IF and the  COUNTIF functions ...

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

  Let's use the following sample dataset to show how you can use these functions together. Method 1 - Combine INDEX and MATCH Functions in ...

How to Sum Cells with Text and Numbers in Excel

  Method 1 - Using the SUBSTITUTE Function to SUM Cells with Text and Numbers The SUBSTITUTE function can separate the text from the numeric values. ...

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 Methods

Method 1. Using the Multiplication Operator to Multiply by Percentage For Increment: Use the following formula: Amount * (1 + Percentage %) It ...

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

Each of the methods in this tutorial use the following sample data set: Method 1 - Change the Style of Numbers to Add Percentage to Number in Excel ...

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