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 Calculate Sortino Ratio in Excel (2 Methods)

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

How to Open Multiple Excel Files in One Window: 4 Easy Methods

Method 1 - Use Windows and Arrow Keys to Open Multiple Excel Files in Single Window Steps: Open the files separately. The first Excel workbook, press ...

How to Protect Formulas in Excel (With Easy Steps)

Suppose you have a dataset containing sales data, and you’ve used formulas to calculate revenues. Now, let’s protect the cells with formulas by following these ...

How to Recover Excel File after Crash (4 Methods)

  Method 1 - Recovering Unsaved Excel File after Crash or Restart   Steps: Open Microsoft Excel and go to Open > Recent. Click ...

How to Hide Toolbar in Excel (3 Quick Methods)

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

How to Calculate Difference Between Two Times in Excel: 8 Suitable Methods

While calculating time differences in Excel, you have to be careful about the Number formats of individual time values. Before starting the calculation, make ...

How to Create a Client Database in Excel – Easy Steps

  Step 1 - Create a Column or Field Headers Enter the name of the fields that you want to include in the client database. Here, Client’s Name, ...

How to Convert Excel Data into Word Labels (With Easy Steps)

Step 1: Prepare Excel File with Labels Data Begin by organizing the data for your mailing labels in an Excel spreadsheet. For instance, include fields ...

How to Convert CSV to Excel with Columns (5 Methods)

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

How to Make Excel Workbook Read Only with Password (With Easy Steps)

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

How to Subtract in Excel Based on Criteria (3 Suitable Examples)

This article will discuss methods to subtract excel data based on different criteria. While working with Microsoft Excel, we subtract cell values using the ...

How to Separate Date from Text in Excel (4 Methods)

  Method 1 - Combining MID, SEARCH & DATEVALUE Functions to Separate Date from Text in Excel Let’s consider the following dataset with dates inside ...

How to Open Two Excel Files Separately (5 Easy Methods)

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

[Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)

Reason 1 - Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel Let’s assume we have a dataset containing several fruits and their order ...

How to Adjust Row Height to Fit Text in Excel (6 Suitable Methods)

In this article, I will discuss how you can adjust the row height to fit text in Microsoft Excel. By default, Excel has a certain row height. So, when you type ...

Browsing All Comments By: Hosne Ara

Advanced Excel Exercises with Solutions PDF