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.
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 ...
For the purpose of easy navigation, we may be required to freeze some of the rows or columns of a worksheet. Freezing columns in a worksheet is a fairly simple ...
We often use Filters in Excel to sort data. Sometimes we may need to arrange data from smaller to bigger or vice versa. It is tiresome to arrange rows manually ...
Very often we need to subtract two dates in our day-to-day operation. When we calculate age or duration, typically, we subtract two dates. In this article, we ...
Very often we need to calculate interest between two dates. Manual calculation of interest can be lengthy and tiresome. Using Excel we can do these ...
Very often we persuade others to rate products. We get different ratings from different customers. We need to calculate the average to get an overview of how ...
Very often we need to group similar data to quickly get an overview of the data. Also, we may need to group similar kinds of information to get an idea about ...
Spaces can occur for different reasons in a worksheet. There may be mistakes during data input or data import from different sources. Manually removing those ...
Rows run horizontally along the worksheet. In Excel rows are denoted by numerical values like 1,2,3,4 etc. In this tutorial we will see 6 methods to insert new ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS