Asif Khan Pranto

About author

Md. Asif Khan Pranto worked as an Excel and VBA Content Developer in Exceldemy for over two years and published some articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical Engineering from the Islamic University of Technology. Now, he is pursuing a Master of Development Studies to experience a new spectrum of knowledge. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, Python Web Scraping, and Report Writing.


Excel and VBA content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


BSc in Mechanical Engineering, Islamic University of Technology (IUT).


C, C++, ETABS, AutoCAD, SAP, SketchUp, Microsoft PowerPoint, Microsoft Excel, Microsoft Word, MATLAB


  • Intern at Public Procurement Management Training Central Procurement Technical Unit (Ministry of Planning)
  • Inert at Industrial Engineering Training Kodda 150 MW Power Plant Gazipur

Latest Posts From Asif Khan Pranto

How to Use Formula for 30 Year Fixed Mortgage in Excel?

In this article, we will learn about the Excel Formula for a 30-Year Fixed Mortgage. Here we will use several formulas related to 30 Year Fixed Mortgage. We ...

How to Find and Replace in Excel Column (6 Methods)

Let’s assume we have a dataset of a company’s sales with columns A to G representing Delivery Date, Region, Sales Person, Product Category, Product, and Sales ...

How to Find the First Value Greater Than in Excel (4 Methods)

In this article, we’ll explore four methods to find the first value greater than a specified amount in an Excel dataset. Suppose we have a dataset with columns ...

How to Use Pivot Table to Filter Date Range in Excel (5 Ways)

Suppose we have a dataset of a company's sales having Delivery Date, Region, Salesperson, Product Category, Product and Sales Amounts. We'll use a pivot table ...

How to Convert Date to Month and Year in Excel (4 Ways)

  Suppose we have a dataset of several employees with DoB (date of birth) in column C. We want to convert the date to month and year only for our ...

How to Use Data Validation in Excel with Color (4 Ways)

We have a dataset containing five columns: Serial Number, Candidate Name, Acquired Number, DoB, and Candidate’s Code. We will use different Columns of our ...

3 Ways to Count Characters in Cell Including Spaces in Excel

To count characters in a cell including spaces follow the steps below: Select any cell to show the count. Insert the formula in the cell: ...

Browsing All Comments By: Asif Khan Pranto

Advanced Excel Exercises with Solutions PDF