Nasir Muhammad Munim

Cells property in Excel VBA (Visual Basic for Applications) is used for interacting with and modifying cells in Microsoft Excel. In simpler terms, it can read ...

While working on Excel, we often need to use a very common term called Standard Deviation. We can use the standard deviation based on conditions. This leads to ...

In this article, with some simple techniques, we’ll learn how to create a reverse EMI calculator in Excel. The EMI refers to the Equated Monthly Installment. ...

Radio button in Excel is very common for creating forms and multiple-choice questions. Unlike checkboxes, radio buttons allow you to select only one option at ...

Excel is now widely used to track records of inventories such as supply chains or libraries for book collection management. One of the most common usages is to ...

When we import data in Excel, we may often encounter some Inverted Comma in data that creates problems while calculating data because it may change the data ...

While working on Excel, we often face such scenarios where we need a table repeatedly in multiple sheets for calculation and analysis. Copying the entire table ...

One of the core features of Excel is to make tables with given data. But sometimes, we need to undo the table in Excel to make necessary changes or rebuild the ...

One of the core features of Excel is to show the sum of numbers. It is widely used in different sectors. Summing positive numbers is fairly easy but if there ...

We often need to convert large XML files to Excel for better understanding or readability of data. In this tutorial, we will learn how to convert large XML to ...

One of the core uses of Excel is to insert data to analyze or visualize. For a large amount of data, there can be a lot of columns and rows. Sometimes we may ...

In this article, we'll learn simple steps to create XML mapping in Excel. We often need to change the type of a file so that it can be used with different ...

In this article, we will learn how to make General Ledger in Excel very easily and analyze it. A ledger is used to keep track of things like business, banking, ...

For better readability of data and visibility in Excel, we often enter full-screen mode. But after the job is done, we need to exit the full-screen mode to ...

Often, we want to show Dash (-) instead of 0 in Excel due to the absence of any data. This article shows all the possible methods to do so. We will show all ...