Adnan Masruf

About author

Adnan Masruf, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. His deep passion for research and innovation seamlessly aligns with his dedication to Excel. In this capacity, Masruf not only skillfully addresses challenging issues but also exhibits enthusiasm and expertise in gracefully navigating intricate situations, underscoring his steadfast commitment to consistently delivering exceptional content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


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


C++, Python, Microsoft Suite, AutoCAD, Adobe Illustrator, ANSYS


  • Technical Content Writing
  • Undergraduate Projects
    • Design of a Stern Trawler for the Coastal Region of Bangladesh
    • A Comparative Linear Buckling Analysis of Different Isotropic Plates with and without Stiffeners for Different Boundary Conditions.


  • “The Science Behind Swing and Reverse swing” at annual magazine of ASME Student Regional Board, Asia Pacific Region

Latest Posts From Adnan Masruf

How to Clear Pivot Cache in Excel (3 Effective Ways)

In this article, we will discuss how to clear Pivot Cache in Excel. Pivot Cache is a replica of the source data that Excel creates as soon as the PivotTable is ...

How to Calculate Uncertainty in Excel (3 Effective Ways)

Today, we will show how to calculate uncertainty in Excel. Uncertainty is a part of any random dataset. It is often referred to as the doubt surrounding the ...

How to Get All Combinations of 2 Columns in Excel (4 Easy Ways)

Method 1 - Using Excel Power Query Editor to Combine 2 Columns Steps: Select cell B5 in the Gender column. Go to the Insert tab. Select Table. A ...

How to Apply UTF 8 Encoding on CSV File in Excel

In this article, we will talk about how to apply UTF 8 encoding on a CSV file in Excel. Thus, users will be able to encode the CSV file and transfer it to the ...

How to Export File Metadata to Excel (3 Effective Methods)

In this article, we will discuss how to export file metadata to Excel. The metadata of the file contains the necessary information regarding the file, e.g.: ...

How to Create Data Table with 3 Variables (2 Quick Tricks)

In this article, we will show how to create a data table with 3 variables. Users often have to deal with a data table with 2 variables. However, there are many ...

How to Use Conditional Formatting in Data Labels in Excel

In this article, we will show 3 examples of how to use conditional formatting in data labels in Excel. In these methods, users can apply conditions in data and ...

How to Get Data Points from a Graph in Excel (2 Easy Ways)

In this article, we will show how to get data points from a graph in Excel in two effective ways. Graphs are a powerful medium to present data. However, we ...

How to Get Exchange Rate by Date in Excel (2 Suitable Methods)

Exchange rate is very crucial to businessmen, especially those who are dealing with foreign currencies. The rate of exchange varies with time. So, it is very ...

How to Create a Table with Subcategories in Excel

We often need multi-dimensional tables to present our data. For this reason, we need to create sub-categories to our data table. Excel offers some great ...

How to Use the Combination of COUNTIF and SUMIF in Excel

Method 1 - Determining Average Price Steps: Select the F5 cell and write down the following formula, ...

How to Translate English to Hindi in Excel

The default language in Excel is English. This default language setup sometimes becomes difficult to comprehend for non-English users. Excel provides ways to ...

[Fixed!] Excel Hyperlink Formula Not Working

The hyperlink is a great way to connect different files i.g. Excel, Word, and Web files to an Excel file. This helps users to deal with different files ...

How to Perform Double Click Cell Jump in Excel

We often need to find out which dataset consists of our formula. However, when we double-click on the formula cell, we see the formula in the cell. Excel does ...

How to Paste a List of Emails into Excel: 2 Easy Ways

Method 1 - Using Combination of Text to Columns and Paste Special Commands Steps: Select the email addresses that you want to paste and press Ctrl+C. ...

Browsing All Comments By: Adnan Masruf
  1. Dear Nirmal,
    Could you please provide me with your Excel file that you have mentioned or some screen shots from your dataset? That would help me to understand your dataset and answer your query accordingly.
    Thanks for your query.
    Team ExcelDemy

  2. Dear Raman,
    1. First, make sure you are using MS Office 365 as they are only available in that version.
    2. Secondly, make sure you are logged into your MS Excel account.
    3. Thirdly, make sure to have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
    If these do not work then,
    -Go to File > Options > Trust Center > Trust center Settings > External Content > Security settings for “Linked data types” > Activate “Enable all Linked Data Types”
    – Go to Options>Customize Ribbon> All Commands
    – Then, choose the Datatype Command
    -Add the command to a “New Group”
    -Finally, restart your Excel Application.

    *Also, make sure to keep your internet connection ON; as this data type is linked datatype.
    *You should also see if this datatype is available in your geopolitical locaton.

  3. Dear K,
    Thanks for your query. If we add replies to the comments (Like the first picture), we can find the replies by simply looking at the initials without changing the macros (Like the second picture)

Advanced Excel Exercises with Solutions PDF