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.
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 ...
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 ...
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. ...
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 ...
Counting character occurrences in Excel is vital for data validation, error correction, and text analysis. It ensures data accuracy, supports formatting, and ...
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 ...
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 ...
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. ...
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 ...
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 ...
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. ...
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 ...
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 ...
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, ...
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