# Hosne Ara

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.

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Education

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

## Expertise

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

## Experience

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

## Random 5 Digit Number Generator in Excel (7 Examples)

While working in Microsoft Excel, sometimes we require a random 5 digit number generator. Especially while doing statistical analysis we might need to generate ...

## How to Move Filtered Cells in Excel (3 Easy Methods)

In this article, I will discuss how you can move filtered cells in Microsoft Excel. When we want to copy filtered cells to move to another location, ...

## Excel Formula to Insert Rows between Data (2 Simple Examples)

In this article, I will discuss how you can use an Excel formula to insert rows between data. Often working with Microsoft Excel, we need to insert single or ...

## How to Sum Columns by Color in Excel (6 Easy Methods)

In this article, I will discuss how you can get the sum of cells in Excel columns by color. Often, while working with Microsoft Excel, we use different fill ...

## How to Sort Data by Value in Excel (5 Easy Methods)

In this article, I will discuss how you can sort data by value in Microsoft Excel. While working with a large amount of data in Excel, often we need to ...

## How to Make Grid Lines Bold in Excel (With Easy Steps)

In this article, I will discuss how you can make grid lines bold in Excel. By default, Microsoft Excel uses black thin lines as gridlines. However, for a ...

## How to Filter Multiple Columns by Color in Excel (2 Methods)

In this article, I will discuss how you can filter multiple columns by color in Microsoft Excel. Usually, when we filter a certain column, other columns ...

## How to Find Duplicates in Excel and Copy to Another SheetÂ (5 Methods)

In this article, I will discuss how you can find duplicates in Excel and copy them to another sheet. While working with a large number of data in Microsoft ...

## How to Extract Data from Image into Excel (With Quick Steps)

In this article, I will discuss how you can extract data from an image into an Excel worksheet. This data extraction from images is very effective and saves a ...

## How to Trim Part of Text in Excel (9 Easy Methods)

While working in Microsoft Excel, you may need to trim part of a text string. For example, you might require removing a certain part of a text string. Besides ...

## How to Make a Comparison Table in Excel (2 Methods)

While working with Microsoft Excel, often we need to make a comparison table. Most of the time, Excel tables contain a lot of random data which might not make ...

## How to Split Comma Separated Values into Rows or Columns in Excel

Sometimes, while working inÂ Excel, we need to split comma-separated continuous values of one column into different columns or rows. When we import data ...

## How to Link Multiple Cells from Another Worksheet in Excel (5 Easy Ways)

In this tutorial, I will show you how you can link multiple cells from another worksheet in Microsoft Excel. Linking cells between worksheets has a great ...

## How to Use Formula for Mortgage Principal and Interest in Excel?

In this article, I will discuss how you can calculate the principal and interest for a mortgage using a formula in Microsoft Excel. Suppose a \$90,000 home at ...

## How to Merge Multiple Cells without Losing Data in Excel (6 Methods)

In this article, I will discuss how you can merge multiple Excel cells without losing data. While working in Microsoft Excel, you may want to join several for ...

Browsing All Comments By: Hosne Ara

Advanced Excel Exercises with Solutions PDF