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.
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 ...
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 ...
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 ...
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 & ...
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 ...
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 ...
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. ...
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: ...
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 ...
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 ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS