A spreadsheet application, designed by Microsoft, Ms-Excel is one of the most popular applications with features like pivot tables, graph, and calculations. It also supports a macro programming language called VBA (Visual Basic for Applications).
There are different ways to calculate a person’s age in Excel using different types of data. In most cases you will be given a Date from which you’ll need to get or calculate the age. Here in this ...
The Replace function in Excel is an inbuilt function or a pre-defined function, which you can use in your Macro to replace a set of characters in a string with another set of characters. You can ...
You know there are two ways to create Pie charts in Excel. One, create a Pie chart on your own using the tools available or you can use VBA to create Pie charts automatically with the click of a ...
A chart shows data in a graphical format. A Pie chart is a circular chart where it divides the data into slices. Each slice represents a part of the data. Here in this post I’ll show you how to create ...
I have previously shared a post with an example on how to read data from a closed workbook without opening it. I am extending that example, and here in this post I’ll show you how to read multiple ...
In Excel, you can name a cell or a range of cells. Giving a meaningful name to a cell or a range helps understand the data or the set of data it holds. However, named cells have other useful benefits ...
If you are still actively investing in the stock market and use Ms-Excel, then here’s an example on how to get current stock quotes, every few seconds, in your Excel file from a Web page using VBA ...
UserForms in Excel usually have many controls specially used for data entry purpose and in that case, the form might have many textbox controls. While submitting the data, you realized that you have ...
If you are using Excel extensively, then I am sure you have come across this situation or a similar situation at least once. Here in this article, I am going to share a simple method or code in Excel ...
Excel VBA provides many in-built functions, which helps programmers accomplish a task. I am creating a simple scenario to use one of the in-built functions called “IsNumeric()” to check if a ...
