Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content all about Excel and VBA. You'll find him reading books, travelling, and enjoying movies and TV series outside work.
If you are looking for a way in Excel to auto-format fractions in a way that they shrink to smaller characters when you type them in the cells, as we do in MS ...
If you don’t need irrelevant decimal places in cells as they produce ##### symbols to show, or you don’t want to precision down to the microscopic level, then ...
Excel is an outstanding well-developed worksheet tool that has been programmed to maximize its effectiveness. However, in some cases, it can be a bit ...
The creation of reports indicates collecting and presenting information in a single Excel worksheet. If you want to create a report in Excel as a table, then a ...
Slicer imparts buttons that you can press to filter Excel tables or pivot tables. If you don’t like the visual properties of the slicer, you can change the ...
If you wish to protect your Excel worksheet but at the same time allow data entry into your Worksheet, MS Excel provides this facility to do this. In this ...
Sometimes you may need to know how many months have passed between two dates. There are multiple ways to find the difference between two dates in months in ...
Suppose you have a large Excel dataset that consists of numerous blank cells. Now, you wish to fill these blank cells with text. If you want to fill it out ...
Sometimes, while working with data in Excel, we often need to copy from Excel to Word without losing formatting. Although there is no built-in function in ...
If you have a table in PDF format that you want to copy to your Excel worksheet, you may get jumbled and non-formatting results. As PDFs and Excel don’t share ...
Adding and subtracting are the two most frequent mathematical operations that we do in our regular day-to-day life. If you are facing problems adding and ...
If your Excel worksheet contains full names in a column and you want to split the names into two columns, then you are in the right place. In this article, you ...
You may have a table in your Excel worksheet where several kinds of data are kept in a cell and separated by commas. If you want to split them into several ...
Excel has a row limit that is 1,048,576 according to Microsoft Tech Community. If it is not enough for you, if your data exceeds the limit, then your file will ...
If you use Microsoft Excel, you may have a problem with having more text than fit into a normal cell. To get rid of this issue, you need to put multiple lines ...
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