There is more than one way to enter a formula in Excel. Episode #1228 shows three (3) ways to successfully enter a formula in Excel.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel 2010 in Depth, chapter 8.
Formulas 3 Ways.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
In this chapter, we're talking about how to enter formulas, and there's three ways to enter formulas.
If I want to create a gross profit percent over here, in column 'I'.
The formula is going to be =H2/F2.
So, the first way, the easiest way maybe it is just to type the formula =H2/F2.
And as I travel around the country doing seminars, I find about now maybe 10% of the people use that method, they just type the formulas.
But, I think the most common method of them all, are the people who use the mouse.
So, they might type the equal sign (=), and then use the mouse to click on profit and then the divide sign (/), on the keyboard and then use the mouse to click on revenue and you have the formula.
Another way to go, and these are the people who have been around since the days of Lotus 1-2-3, in general.
Back in lotus, we didn't have a mouse.
So, the way to navigate was to use the arrow key.
So, you type an equal sign (=) and then the [ left arrow key ], wants to point to H4, the divide sign (/) and now focus has returned back to column 'I'.
So, I have to press [ left ] 1, 2, 3 times.
Press the [ left arrow key ] three times to go to column F and Press [ enter ].
So, three different ways to get there.
Now, I think the arrow key method is the fastest way to go I always say if there's an Excel Olympics, I want people on my team who use the arrow key method because we can really enter formulas faster.
But, if you're a mouse person, here's a cool tip for you.
Let's go to the quick access toolbar, right click, customize quick access toolbar and under all commands.
There are four good commands that you could consider adding to your toolbar.
Now, I've already added plus, minus multiply.
So, I'm going to find divide, it's down here in the D's.
These all used to be together back in Excel 2003, but now since they're alphabetical, they're spread.
You know alphabetically...
So, division sign, click [ add ].
Alright! Down here, I'll click [ OK ].
So, now you see that we have the four balanced enabled icons.
So, we can... You know, basically start a formula pick up.
So, we can basically start a formula, click on profit, click on divide, click on revenue.
And never have to reach back to the keyboard.
So, theoretically a faster way to go, if you want to use the mouse.
I want to thank you for stopping by.
We’ll see you next time for another netcast, from MrExcel.
Excel 2010 in Depth, chapter 8.
Formulas 3 Ways.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
In this chapter, we're talking about how to enter formulas, and there's three ways to enter formulas.
If I want to create a gross profit percent over here, in column 'I'.
The formula is going to be =H2/F2.
So, the first way, the easiest way maybe it is just to type the formula =H2/F2.
And as I travel around the country doing seminars, I find about now maybe 10% of the people use that method, they just type the formulas.
But, I think the most common method of them all, are the people who use the mouse.
So, they might type the equal sign (=), and then use the mouse to click on profit and then the divide sign (/), on the keyboard and then use the mouse to click on revenue and you have the formula.
Another way to go, and these are the people who have been around since the days of Lotus 1-2-3, in general.
Back in lotus, we didn't have a mouse.
So, the way to navigate was to use the arrow key.
So, you type an equal sign (=) and then the [ left arrow key ], wants to point to H4, the divide sign (/) and now focus has returned back to column 'I'.
So, I have to press [ left ] 1, 2, 3 times.
Press the [ left arrow key ] three times to go to column F and Press [ enter ].
So, three different ways to get there.
Now, I think the arrow key method is the fastest way to go I always say if there's an Excel Olympics, I want people on my team who use the arrow key method because we can really enter formulas faster.
But, if you're a mouse person, here's a cool tip for you.
Let's go to the quick access toolbar, right click, customize quick access toolbar and under all commands.
There are four good commands that you could consider adding to your toolbar.
Now, I've already added plus, minus multiply.
So, I'm going to find divide, it's down here in the D's.
These all used to be together back in Excel 2003, but now since they're alphabetical, they're spread.
You know alphabetically...
So, division sign, click [ add ].
Alright! Down here, I'll click [ OK ].
So, now you see that we have the four balanced enabled icons.
So, we can... You know, basically start a formula pick up.
So, we can basically start a formula, click on profit, click on divide, click on revenue.
And never have to reach back to the keyboard.
So, theoretically a faster way to go, if you want to use the mouse.
I want to thank you for stopping by.
We’ll see you next time for another netcast, from MrExcel.
