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.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

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.

Latest Posts From Hosne Ara

0
Statistical Comparison of Two Data Sets in Excel

In this article, I will discuss the statistical comparison of two data sets in Excel. At times, while working with spreadsheets, we have to compare data ...

0
Excel Find Matching Values in Two Columns

In this article, we will discuss several easy methods in Excel to find matching values in two columns. Sometimes, while working in Excel, we need to find ...

0
How to Highlight Row If Cell Contains Any Text in Excel

In this article, we will discuss how to highlight a row if any cell contains any text. Sometimes highlighting only the cells that contain text is not enough. ...

0
How to Remove Everything After a Character in Excel (7 Methods)

In this tutorial, we will discuss some easy-to-use methods to remove everything after a character in Excel. Often, we work with spreadsheets with a long list ...

0
How to Count Occurrences of a Character in String in Excel

Counting character occurrences in Excel is vital for data validation, error correction, and text analysis. It ensures data accuracy, supports formatting, and ...

0
If Value Exists in Column Then TRUE in Excel

In this article, we will discuss receiving ‘TRUE’ as output if one cell value in Excel exists in another column. Basically, when we work with spreadsheets, it ...

0
How to Find Links in Excel ( 8 Suitable Approaches)

In this article, we will discuss 8 suitable approaches to find links in Excel. Excel has tremendous available options to link your working workbook to several ...

0
How to Remove Subtotals in Excel (2 Easy Tricks)

In this article, we will discuss two easiest methods to remove subtotals in Excel. Basically, we use the subtotal option in excel to organize and group data. ...

0
How to Remove Carriage Returns in Excel: 3 Easy Ways

In this article, we will discuss some methods to remove carriage returns in Excel; including VBA. Often, we copy data from web pages or other workbooks, which ...

0
How to Use Left Trim Function in Excel (7 Easy Ways)

Fortunately, we will discuss doing left trim in Excel using both functions and VBA. Left trim can be of various types. For example, you can remove a character ...

0
How to Remove Formulas in Excel (8 Easy Ways)

Usually, you can remove formulas from an Excel cell just by pressing the delete button. Unfortunately, this way of deletion removes the values from the cell. ...

0
How to Rename Sheet in Excel (6 Suitable Ways)

While working in Excel, often we have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. In this ...

0
How to Calculate Date Range in Excel (4 Ideal Methods)

In this article, I will discuss how to calculate a date range in Excel. Usually, calculating the date range is quite more complex than other operations in ...

0
How to Compare Cells in Excel (10 Easy Methods)

There are many ways to compare cells in Excel. You can compare two cells and find matches, differences, and some other operations using Excel. In this article, ...

Browsing All Comments By: Hosne Ara

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo