Excel In Depth -- Formula Entry: Podcast #1228

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Aug 23, 2010.
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.
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top