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.

Designation

Excel and VBA content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

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

Expertise

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

Experience

  • 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

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

Method 1 - Calculating Per Installment Payment for 30 Years Fixed Mortgage Using PMT Formula Steps: Select the Cell where you want to Calculate your per ...

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

Dataset Overview 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, ...

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

Dataset Overview We have a dataset with columns for State Name (Column B), Budget Allocation (Column C), and Region (Column D). We'll identify the first value ...

0
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 ...

0
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 ...

0
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 ...

1
How to Count Characters in a Cell Including Spaces in Excel – 3 Methods

The dataset showcases movie names. Method 1 - Using the LEN Function Select a cell to show the count. Enter the formula in the cell: ...

Browsing All Comments By: Asif Khan Pranto

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo