Nasir Muhammad Munim

About author

Nasir Muhammad Munim has been an Excel and VBA Content Developer for over a year in Exceldemy and published more than 30 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Electrical and Electronic Engineering from the Islamic University of Technology. Apart from creating Excel tutorials, he is interested in developing PostgreSQL, MySQL, and Android applications. He is fascinated by CAD-based designing systems and building 3D models.

Designation

Excel and VBA content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc. in Electrical and Electronic Engineering, Islamic University of Technology

Expertise

Excel, Content Writing, MySQL, Microsoft Office.

Experience

  • Technical Content Writing
  • Undergraduate Projects
    • Brain Tumor detection using Machine Learning
    • RDBMS - Sales
    • IoT based weather monitoring and alarming system

Latest Posts From Nasir Muhammad Munim

0
VBA Cells in Excel: Select, Get, Count, Format, Copy-Paste, etc.

What Is VBA Cells Property? Cells property refers to a cell for any operation in VBA. It can access or modify cells based on row and column indexing. Cells ...

0
How to Calculate Standard Deviation with IF Conditions in Excel

While working on Excel, we often need to use a very common term called Standard Deviation. We can use the standard deviation based on conditions. This leads to ...

1
How to Create Reverse EMI Calculator in Excel (2 Easy Methods)

In this article, with some simple techniques, we’ll learn how to create a reverse EMI calculator in Excel. The EMI refers to the Equated Monthly Installment. ...

0
Radio Button in Excel Without Macro (Insert, Copy, Group & Delete)

Radio button in Excel is very common for creating forms and multiple-choice questions. Unlike checkboxes, radio buttons allow you to select only one option at ...

0
How to Catalog Books in Excel – 2 Methods

  Method 1 - Creating a Custom Catalog for Books To create a catalog in Excel: Steps: Select the headings. Separate the columns with a ...

0
How to Remove Inverted Comma in Excel (7 Easy Methods)

When we import data in Excel, we may often encounter some Inverted Comma in data that creates problems while calculating data because it may change the data ...

0
How to Mirror Table on Another Sheet in Excel (4 Easy Methods)

We often need to use the same table in multiple sheets for calculation and analysis. Copying the entire table and pasting it wherever we need is a very ...

0
How to Undo a Table in Excel: 2 Easy Methods

Method 1 - Undo a Table by Converting to Range Steps: Select any of the cells in the table. In the ribbon, a tab named Design or Table Design will ...

0
How to Sum Negative and Positive Numbers in Excel – 2 Methods

  To sum positive and negative numbers in the dataset: Method 1 - Sum Only Positive Numbers 1.1 Using SUMIF Function Sum all numbers above ...

0
How to Convert Large XML to Excel (2 Effective Ways)

We often need to convert large XML files to Excel for better understanding or readability of data. In this tutorial, we will learn how to convert large XML to ...

0
How to Group and Hide Columns in Excel (3 Easy Methods)

One of the core uses of Excel is to insert data to analyze or visualize. For a large amount of data, there can be a lot of columns and rows. Sometimes we may ...

0
How to Create an XML Mapping in Excel – 3 Easy Steps

    Step 1 - Choosing an XML File The XML file code attached in the below image will be used. The structure is needed to create ...

0
How to Create a General Ledger in Excel – 4 Steps

  Step 1 - Input Fields and Choose the Range Select data to input into the General Ledger. A typical ledger has 5 fields: Serial no., Date, Description, ...

0
How to Exit Full Screen in Excel (3 Easy Methods)

For better readability of data and visibility in Excel, we often enter full-screen mode. But after the job is done, we need to exit the full-screen mode to ...

0
How to Show Dash Instead of Zero in Excel (4 Easy Methods)

We will consider this example below. Here, the dataset contains the number of different products sold over three days and their Product IDs. Method ...

Browsing All Comments By: Nasir Muhammad Munim
  1. Reply Nasir Muhammad Munim
    Nasir Muhammad Munim Jan 16, 2024 at 10:48 AM

    Dear KAREN CAYANAS,
    Thanks for reaching out to us with your problem.
    This problem occurs when you do not have enough view area on the monitor. While there is no particular fix to your problem, if you want to keep the cell styles in the Ribbon, you may consider removing some unnecessary groups from the Home tab.

    To do so follow these steps:
    1. Right-click on the empty area of the Ribbon.
    2. Select “Customize the Ribbon“.
    customize the ribbon
    3. From the Home tab dropdown, select and remove unnecessary groups one by one.
    4. Click on OK to finish the process.
    removing groups from the home tab

    After removing the groups, cell styles will be visible without the “Cell Styles” drop-down if there is enough room in the Ribbon.

    Regards,
    Exceldemy

  2. Reply Nasir Muhammad Munim
    Nasir Muhammad Munim Oct 18, 2023 at 10:43 AM

    Hi Arthur,
    Thank you for finding out about this issue. We have updated the VBA code to avoid the “Sub or Function Not Defined” error. Please try again with this new code and let us know if this problem still exists or not.
    Regards,
    Team Exceldemy

  3. Reply Nasir Muhammad Munim
    Nasir Muhammad Munim Aug 28, 2023 at 1:35 PM

    Dear AVI,
    We can assure you that if you followed the steps correctly, everything should be fine with the tutorial. Moreover, both of these formulas are single-cell output formula. So, the procedure for the array formula implementation or pressing CTRL+SHIFT+ENTER is not required here.
    If you want to take all the data to find out the standard deviation without conditions or avoid taking the false as 0, you should have a look at our article How to Calculate Average and Standard Deviation in Excel.
    Regards,
    Exceldemy

  4. Reply Nasir Muhammad Munim
    Nasir Muhammad Munim Aug 21, 2023 at 1:57 PM

    Dear Fardeen,

    The profit margin is the percentage you get from the selling price. The formula for profit margin is: (Selling Price-Cost Price)/Selling Price or, Net Profit/Selling Price

    The profit margin is calculated in the worksheet with the formula: =(F5-E5)/F5
    calculating profit margin in Excel
    On the other hand, the profit percentage is calculated based on the Cost Price. The formula for profit percentage is: (Selling Price-Cost Price)/Cost Price or, Net Profit/Cost Price

    The profit percentage is calculated in the worksheet with the formula: =(F5-E5)/E5
    calculating profit percentage in Excel
    Regards
    Exceldemy

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo