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 show all formulas in Excel? We are here for you. In this article, we will extensively describe 5 easy ways to do the task smoothly. In ...
Sometimes we need to find the max value in a range using an Excel formula. Luckily Microsoft Excel has several functions which we can use to calculate the ...
Sometimes, you may want to include a blank option in the drop-down list in Excel. In Microsoft Excel, there are some easy methods available to add empty cells ...
When you enter a date in Microsoft Excel, Excel automatically recognizes the inserted data and stores it as a date. Besides, you can change the date format ...
In this article, I will discuss how you can filter Excel data using a Data Validation drop-down list. Usually, in Microsoft Excel, we use the Filter option to ...
This article will guide you to count rows from a data group using Pivot Table. If you have a large dataset containing values in groups, you may be required to ...
While working in Microsoft Excel, often we need to compare two cells. This is a basic operation we do in Excel and luckily, Excel has several options to ...
In this article, I will discuss how you can select all cells with data in Excel. When a large dataset contains data in discontinuous cells, it is tough to ...
While working with a large range of datasets, we might see some unnecessary blank cells which are pretty annoying. Luckily, in Excel, there are several options ...
Sometimes, in Excel, large datasets contain blank cells randomly located, which may be required to be deleted later. However, it might seem time-consuming to ...
In this tutorial, I will explain the details of reference (#REF!) errors and guide you on how to find the errors in excel. Besides, I will mention possible ...
Sometimes, while updating data, we have to delete Excel rows from a list based on another list. Luckily, we can do this row deletion using Excel functions. ...
Often while subtracting date or time in Excel, excel returns #VALUE! error. Usually, the #VALUE error appears when the time value provided to the formula is ...
Usually, we can use the COUNTA function to get the count of existing rows in a dataset. However, when rows are hidden manually or through applying the Filter ...
Most of the time, in Excel, when we copy data from one workbook and paste it into another workbook, it is expected that data will be copied along with ...
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