Microsoft took the vastly improved Equation Editor from Word 2007 and added it to Excel as a brand new feature for Excel 2010. Versatile, dimensional and very functional - in Episode #1245, Bill previews the Equation Editor and a few of its features.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in Ddepth, chapter 28.
The Equation Editor.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
One brand new feature in excel 2010 is, the equation editor.
Now, that's usually either on the insert tab, in the symbols group.
You'll see the equation editor.
I, moved it up here to the quick access tool bar, so you can see the various items in the menu.
When you open that they offer a few equations that are pre-built.
But at the very bottom of this list is, the insert new equation.
Now, insert new equation is only valid, if you have a drawing object, on the sheet.
So, let's go back to insert and we'll choose shapes, and we'll draw a big shape there.
Let's change this anyway, it's not filled in.
All right! Now, that we have that!
There is equation editor at the bottom, choose insert new equation.
And we now have the equation tools.
Okay! So, the equation tools first of all.
You'll see that we have a whole bunch of different symbols here and in this gallery, we can choose from basic math Greek letters.
I don't like symbols.
So, all sorts of different options, here.
The interesting one is over in structures fractions, scripts, radicals, integrals.
Any kind of mathematical symbols to do, and you see that we have like three little boxes here.
So, if we want to insert this double integral, then three boxes are highlighted.
You have to click inside the box, in order to type something.
So, if I want to put, an infinity symbol in there.
Go back to basic math, find infinity.
This, right there and then.
Here, we might want to go from zero.
So, type '0' (zero).
And then, here I have our equation.
I didn't pay attention in math class.
So, this one's not really gonna make a lot of sense.
Sorry about that, and then you can go on.
Now, a couple of things I've seen here.
Especially if you're doing fractions, they have a couple of different varieties, the professional and the linear.
It might help, if you build the equation as a linear equation.
I'm going to, divided by 5 and then change it back to a professional equation, that will actually put the...
You know, everything not in a linear form, but the fractions above and below.
All right! So, the equation editor has certainly allowed you.
Trying to show equations.
You know it doesn't do any calculations or anything like that.
But it allows you actually show the equation.
That's there, this was originally added a word 2007.
They added it to Excel 2010, as well.
So I'm glad to see that equation editor has been added very powerful, very cool.
So drawing tools that should make the scientists and engineers and mathematicians.
I want to thank you for stopping by.
Will see you next time for another netcast, from MrExcel.
Excel in Ddepth, chapter 28.
The Equation Editor.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
One brand new feature in excel 2010 is, the equation editor.
Now, that's usually either on the insert tab, in the symbols group.
You'll see the equation editor.
I, moved it up here to the quick access tool bar, so you can see the various items in the menu.
When you open that they offer a few equations that are pre-built.
But at the very bottom of this list is, the insert new equation.
Now, insert new equation is only valid, if you have a drawing object, on the sheet.
So, let's go back to insert and we'll choose shapes, and we'll draw a big shape there.
Let's change this anyway, it's not filled in.
All right! Now, that we have that!
There is equation editor at the bottom, choose insert new equation.
And we now have the equation tools.
Okay! So, the equation tools first of all.
You'll see that we have a whole bunch of different symbols here and in this gallery, we can choose from basic math Greek letters.
I don't like symbols.
So, all sorts of different options, here.
The interesting one is over in structures fractions, scripts, radicals, integrals.
Any kind of mathematical symbols to do, and you see that we have like three little boxes here.
So, if we want to insert this double integral, then three boxes are highlighted.
You have to click inside the box, in order to type something.
So, if I want to put, an infinity symbol in there.
Go back to basic math, find infinity.
This, right there and then.
Here, we might want to go from zero.
So, type '0' (zero).
And then, here I have our equation.
I didn't pay attention in math class.
So, this one's not really gonna make a lot of sense.
Sorry about that, and then you can go on.
Now, a couple of things I've seen here.
Especially if you're doing fractions, they have a couple of different varieties, the professional and the linear.
It might help, if you build the equation as a linear equation.
I'm going to, divided by 5 and then change it back to a professional equation, that will actually put the...
You know, everything not in a linear form, but the fractions above and below.
All right! So, the equation editor has certainly allowed you.
Trying to show equations.
You know it doesn't do any calculations or anything like that.
But it allows you actually show the equation.
That's there, this was originally added a word 2007.
They added it to Excel 2010, as well.
So I'm glad to see that equation editor has been added very powerful, very cool.
So drawing tools that should make the scientists and engineers and mathematicians.
I want to thank you for stopping by.
Will see you next time for another netcast, from MrExcel.
