Hosne Ara

About author

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.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology.


MS Office, AutoCAD, Raspberry Pi, MS SQL/MySQL, Server installation and configuration, Agile practitioner, DevOps


  • Project Manager at 2RA Technology Ltd. in Dhaka, Bangladesh.
  • Junior Consultant at Murshed Associates Ltd. in Dhaka, Bangladesh.
  • Senior Executive Engineer at Versatile International Ltd. in Dhaka, Bangladesh.

Latest Posts From Hosne Ara

How to Show All Formulas in Excel (5 Easy Methods)

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 ...

How to Find Max Value in Range with Excel Formula (5 Easy Methods)

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 ...

How to Add Blank Option to Drop Down List in Excel (2 Methods)

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 ...

How to Convert Date to Year in Excel (3 Quick Ways)

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 ...

Excel Data Validation Drop Down List with Filter (2 Examples)

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 ...

Count Rows in Group with Pivot Table in Excel (Step-by-Step Guideline)

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 ...

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

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 ...

Select All Cells with Data in Excel (5 Easy Methods)

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 ...

How to Remove Blank Cells from a Range in Excel (9 Methods)

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 ...

How to Use Advanced Filter to Exclude Blank Cells in Excel (3 Easy Tricks)

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 ...

How to Find Reference Errors in Excel (3 Easy Methods)

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 ...

How to Delete Rows Based on Another List in Excel?

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. ...

[Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel

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 ...

How to Count Only Visible Cells in Excel (5 Tricks)

Sometimes, in Excel, we need to count only visible cells. For instance, when you apply a Filter to Excel data, certain rows become hidden. Besides, while ...

How to Copy and Paste Formulas from One Workbook to Another in Excel

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 ...

Browsing All Comments By: Hosne Ara

Advanced Excel Exercises with Solutions PDF