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
How to Add Number to Existing Cell Value in Excel

In this article, we will learn how to add number to existing cell value in Excel. Often we see that we need to add a particular number to all the cells in a ...

0
How to Remove Automatic Page Break in Excel (3 Easy Ways)

Automatic page breaks are dotted vertical and horizontal lines that separate the spreadsheet into portions while working with a large amount of data in Excel. ...

0
How to Hide and Unhide Status Bar in Excel (2 Easy Methods)

The status bar in Excel serves as a dynamic interface element located at the bottom of the application window. It functions as a communication hub. The bar ...

0
How to Create Column Headers in Excel (3 Easy Methods)

Spreadsheets are used in many jobs to keep track of, organize, and look at data. By adding column headers to your data in Excel, you can organize it and make ...

0
How to Convert Number to Words in Excel Without VBA

We often need to convert a number to words in Excel for various purposes. We can use it frequently in shops, educational institutes, banks, etc. A popular way ...

0
How to Explode Pie Chart in Excel (2 Easy Methods)

Pie Chart Explosion in Excel is a very useful and popular feature. It is often used to show the portion of different things while representing the whole as a ...

0
How to Change X-Axis Values in Excel (with Easy Steps)

Excel is a tool that everyone should know how to use, whether they are in school, run a business, or just like to look at charts and graphs. One of the most ...

0
How to Make Scatter Plot in Excel (with Easy Steps)

Excel has a number of useful chart types that can be used to show analysis and plot data.  Putting X and Y values on an Excel chart to show how they relate to ...

0
How to Extrapolate a Graph in Excel (2 Easy Methods)

Extrapolation is a way to use math to predict data that goes beyond what is already known. This is done through programming. So it's a way to evaluate and ...

0
How to Refresh Formulas in Excel (2 Easy Methods)

Excel usually automatically refreshes the formulas used in any workbook or worksheet. But if the formulas are not refreshing automatically we need to do it ...

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