# Asif Khan Pranto

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.

## 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

## 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 Ways)

In this article, we will learn about Excel Find and Replace in Column following a few easy methods. To make our task easier we can use the Find and Replace ...

## How to Find First Value Greater Than in Excel (4 Ways)

In this article, we will learn about Excel Find First Value Greater Than any specified Value using a few easy formulas. Suppose we have a dataset of fund ...

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

In this article, we will learn about Excel Pivot Table filter date range. Pivot Table is an amazing tool in Excel to summarize our data in a few seconds & ...

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

In this article, we will learn how to convert date to month and year in Excel. Sometimes we need to eradicate the day count from the date & use only month ...

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

In this article, we will learn how to Use Data Validation in Excel with Color. Data Validation is an element in Excel that is utilized to control what users ...

## How to Select Cells in Excel Using Keyboard (9 Ways)

Sometimes you need to Select Cells in Excel using Keyboard Shortcuts When working with a large dataset. Keyboard Shortcuts make it easier to Navigate a Cell. ...

## 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: ...

## How to Use Flash Fill in Excel to Split Data (4 Quick Ways)

In this article, we will learn how to use Flash Fill in Excel to Split Data. There are several ways to Split data into several columns in Excel like using the ...

## How to Delete Rows in Excel without Affecting Formulas?

Sometimes you need to delete rows in Excel but want to keep the formulas. In this article, we will discuss how to delete rows in Excel without affecting the ...

Browsing All Comments By: Asif Khan Pranto

Advanced Excel Exercises with Solutions PDF