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.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

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

Expertise

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

Experience

  • 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.

Achievement

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

Latest Posts From Adnan Masruf

0
How to Find Unknown Value on Excel Graph (4 Easy Ways)

While plotting graphs, users often need to find out or predict an unknown value relative to the present values. This allows them to forecast a result based on ...

0
How to Plot Graph in Excel with Multiple Y Axis (3 Handy Ways)

Excel users often need to plot their data against multiple Y axes. This allows them to visualize data properly. In this article, we will show you how to plot a ...

0
How to Merge Two Columns in Excel With a Space

Users often need to merge data from two columns in Excel. Often they merge data without space. That creates obscurity in the presentation of the data. So, in ...

0
How to Go to Last Non Empty Cell in Column in Excel (9 Easy Ways)

Users often need to find the last non-empty cell of a column. In a long dataset, it is quite time-consuming to find the last non-empty cell or the value of ...

0
How to Paste in Reverse Order in Excel (7 Handy Ways)

Microsoft Excel does not have a default function to reverse the order of the dataset. But we often need to reverse the order of our data for various data ...

0
How to Rename Column in Excel (3 Easy Ways)

The default column name in Excel, denoted by the alphabet, does not represent the actual data that the column contains. So we need to change the column name ...

0
How to Find Missing Values in Excel (3 Easy Ways)

In Excel, we often need to look for the presence of a value in a particular dataset so that we can know if a particular value is missing and re-enter it into ...

0
How to Calculate Square Root in Excel (6 Suitable Ways)

In analyzing datasets in Excel, we often need to find the square roots of the numerical data. The square root of any number is nothing but the application of ...

0
How to Create a Data Model in Excel (3 Handy Ways)

A data model is an essential feature in data analysis. Using the data model, you can load data (such as tables) into Excel's memory. Then, you can tell Excel ...

0
Excel VBA to Save Workbook in Specific Folder with Date

We often need a distinct name to save our Excel files. This allows us to find our desired file among many other files. What could be more distinct than a ...

0
How to Create Hierarchy in Excel (3 Easy Ways)

In Excel, the term “hierarchy” has two distinct meanings. The first, and simpler definition refers to a particular kind of chart that aids in visualizing a ...

0
How to Randomly Select Participants in Excel (4 Easy Ways)

We often need to randomly select data from our Excel sheet, especially text data. Microsoft Excel does not offer any dedicated function to select random data. ...

0
[Fixed!] Excel Sheet Not Visible When Opened (6 Solutions)

Excel users are sometimes faced with the problem of invisible Excel sheets. Despite their best efforts, they can not figure out this confounding problem. They ...

0
How to Insert Tab in Excel Cell (4 Easy Ways)

Inserting tabs is simple in word processing programs like Microsoft Word. Typically, five spaces equal one tab. The goal of tabs is to make a document easier ...

0
How to Calculate Total Score in Excel (4 Easy Ways)

Users of Excel frequently need to calculate the sum of various scores. This allows them to compare the performances of the different individuals. In this ...

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.
    Regards,
    Adnan
    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”
    or
    – 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

 

 

ExcelDemy
Logo