The above worksheet is a pretty simple basic travel expense report, let me show you some editing techniques before talking about order of operations in excel.
By now, you should know how to use the auto fill handle to fill months and numbers swiftly, if not here is a lesson for you on how to use the auto fill handle.
You should focus on understanding order of operations in excel in this tutorial, you’ll notice some missing data in your travel expenses report, if you want to fill in the missing numbers fairly quickly.
Select the whole range of numbers just like above, excluding the months in your selection.
Now in this selected area, you’ll notice the cell in the upper left corner is a little bit different, hit the enter key to see the active cell moving downward to the next cell within the selected area.
So, there is always one active cell no matter what you’ve selected.
All you have to do is hit the ‘Enter’ key to swiftly move to the next cell and fill in your missing data.
Selecting an area of your worksheet containing range of numbers like that makes it easy to fill in missing data very quickly and efficiently.
If your keyboard is a full-sized keyboard that have a numeric keypad on the right-hand side, then you can type in missing data using this selection techniques and get your work done very quickly because it’s a lot faster than using the numbers across the top of the keyboard.
Before we start adding and using formulas and functions, lets talk about order of operations in excel.
ORDER OF OPERATIONS IN EXCEL
When evaluating a formula, Excel uses a standard mathematics protocol called “order of operations”.
Excel evaluates expressions in parentheses first. Next, excel solve for exponents, after exponents, excel will perform multiplication and division then addition and subtraction.
If there is any formula containing concatenation, it will happen after the mathematics operations. Lastly, excel will evaluate logical operators, if available.
Here is a simple test for you:
What is the correct answer to?
2+3*4? Or (2+3) *4?
20? Or 14? 20? Or 14?
I’ll leave you to answer that, using the standard protocol called “Order of Operations”.
You can watch the video below for visual explanation. Thanks, sharing is caring.
Download Resource for practice