Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel and VBA. Beyond the tech stuff, catch her lost in books, explore new places during travels, and enjoy movies and TV series in her downtime.
Looking for ways to create Yes No InputBox with Excel VBA? Then, this is the right place for you. Excel has InputBox and MsgBox for inserting values/ text ...
The ComboBox is a special feature of Excel. If we ever need to choose from multiple options, VBA ComboBox is there for the job. Not only that, but we can also ...
In this article, I will discuss how you can calculate the Sortino Ratio in Excel. I will calculate this using Excel formulas and VBA. Before starting the ...
This article will discuss how you can open multiple Excel files in one window. Often working with Microsoft Excel, we may need to open and view multiple ...
This article will discuss how you can protect formulas in Microsoft Excel. Sometimes, when you share spreadsheets with other people, you might want no one to ...
In this article, I will discuss how to recover an unsaved Excel file after a crash. A crash can happen for several reasons. For example, your PC can crash or a ...
In this article, I will discuss how you can hide the toolbar (ribbon) in Excel. The Excel toolbar is located on the top of the Excel window and contains a ...
While working in Microsoft Excel, we often have to calculate the difference between two times. Calculating time differences is a very common operation in ...
In this article, I will discuss how you can create a client database in Microsoft Excel. Usually, a traditional database has tables, fields, records, primary ...
In this article, I will discuss how you can convert a mailing list in Excel into MS Word mailing labels by applying the Mail Merge feature. Often when we have ...
In this article, I will discuss how you can convert CSV files into Excel files with multiple columns (.xlsx format). As CSV files are easy to operate and open ...
While working with Microsoft Excel, often we have to make the workbook read only with a password for the sake of data integrity. We protect workbooks with ...
This article will discuss methods to subtract excel data based on different criteria. While working with Microsoft Excel, we subtract cell values using the ...
In this article, I will discuss how you can separate the date from text strings in Microsoft Excel. While working with excel, often we receive spreadsheets ...
In this article, I will discuss how you can open two Excel files separately in different windows. People using updated versions of Excel won't face ...
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