In Microsoft Excel, the order of operations is the same as in traditional mathematics. The name “PEMDAS” or “BEDMAS” is used to describe it.
- Parentheses or Brackets
- Exponent
- Multiplication
- Division
- Addition
- Subtraction
Here is a Certification Course from BI to help you gain knowledge and learn about MS Excel as a tool of Data Science.