Lutful Hamid

About author

LUTFUL HAMID is an outstanding marine engineer who finds joy in navigating the realms of Excel and diving into VBA programming. To him, programming is like saving time when dealing with data, files, and the internet. His skills extend beyond the basics, covering Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he's shifted gears and now serves as a content developer. In this role, he crafts techy content centred around Excel and VBA. Outside the tech world, catch him engrossed in books, exploring new places during his travels, and indulging in movies and TV series during his downtime.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Naval Architecture & Marine Engineering, BUET.


MS Office, Rhino3D, Maxsurf C++, AutoCAD, Excel & VBA.


  • Technical Content Writing
  • Ship Design and Construction
  • Marine Maintenance and Repair
  • Machinery and Tools

Latest Posts From Lutful Hamid

How to Convert Text Date and Time to Date Format in Excel (7 Easy Ways)

Very often we find time and date in text format in a worksheet. This may be a result of the wrong input format. This may also occur when we copy data from ...

How to Freeze First 3 Columns in Excel (4 Quick Ways)

Method 1 - Freeze First 3 Columns Using Freeze Panes The Freeze Panes option of Excel is available in the View tab. We can use the Freeze Panes option to ...

How to Auto Number or Renumber after Filter in Excel (7 Easy Ways)

Suppose a company has employee records in a worksheet. The worksheet has four columns: Serial, Name, Department, and Joining Date. The company might need to ...

How to Subtract Date and Time in Excel – 6 Methods

The datasheet contains start and end time. To calculate the duration of each project:   Method 1 - Getting Days, Hours, and Minutes between Dates ...

How to Calculate the Interest Between Two Dates in Excel (3 Ways)

Method 1 –  Using the IPMT Function Steps: Enter the following formula in cell C12: =IPMT(C5/12,1,C6*C7,C4) Formula Breakdown ...

How to Calculate a 5 Star Rating Average in Excel (3 Easy Ways)

Method 1 - Calculate a 5 Star Rating Average Using SUM Function STEPS:  In cell E5, enter the following formula: =C5*D5 Press ENTER to get ...

How to Group Rows in Excel – 5 Easy Methods

The dataset showcases data of a company that operates in 3 regions and sells 3 different products- TV, Heater, and Fan. Method 1 - Grouping Rows Using ...

How to Remove Space in Excel after Text (6 Quick ways)

We have a list of names with unwanted spaces after text. We want to remove those spaces to perform further operations. We have included two columns, Normal ...

Browsing All Comments By: Lutful Hamid

Advanced Excel Exercises with Solutions PDF