Microsoft took the vastly improved Equation Editor from Word 2007 and added it to Excel 2010.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 28 - The Equation Editor!
Well 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 out here on the Insert tab, in the Symbols group you'll see the Equation Editor, I moved it up here to the Quick Access Toolbar, 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 the big shape there.
Let’s change this, that way it's not filled in.
Alright, now that we have that, we go to our Equation Editor, at the bottom choose Insert New Equation, and we now have 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.
Letter-Like Symbols, so all sorts of different options here.
The interesting one is over in Structures, Fractionals, Scripts, Radicals, Integrals, any kind of mathematical symbols that you 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, we go back to Basic Math, and look for infinity, there it is, right there.
And then, here we might want to go from 0, simply just type a 0, and here I have our equation.
I didn't actually pay attention in math class, this one's not really going to pick up 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, do a /5, and then change it back to a Professional equation, that will actually put everything, not a Linear form, but the fractions above and below.
Alright so the Equation Editor, certainly if you're trying to show equations, you know, doesn't do any calculations or anything like that, but it allows you to actually show the equation that's there.
This was originally added to Word 2007, they added it to Excel 2010 as well.
So glad to see that Equation Editor has been added, very powerful, very cool set of drawing tools that should make the scientists and engineers and mathematicians happy to have… (unclear) Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel In Depth chapter 28 - The Equation Editor!
Well 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 out here on the Insert tab, in the Symbols group you'll see the Equation Editor, I moved it up here to the Quick Access Toolbar, 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 the big shape there.
Let’s change this, that way it's not filled in.
Alright, now that we have that, we go to our Equation Editor, at the bottom choose Insert New Equation, and we now have 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.
Letter-Like Symbols, so all sorts of different options here.
The interesting one is over in Structures, Fractionals, Scripts, Radicals, Integrals, any kind of mathematical symbols that you 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, we go back to Basic Math, and look for infinity, there it is, right there.
And then, here we might want to go from 0, simply just type a 0, and here I have our equation.
I didn't actually pay attention in math class, this one's not really going to pick up 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, do a /5, and then change it back to a Professional equation, that will actually put everything, not a Linear form, but the fractions above and below.
Alright so the Equation Editor, certainly if you're trying to show equations, you know, doesn't do any calculations or anything like that, but it allows you to actually show the equation that's there.
This was originally added to Word 2007, they added it to Excel 2010 as well.
So glad to see that Equation Editor has been added, very powerful, very cool set of drawing tools that should make the scientists and engineers and mathematicians happy to have… (unclear) Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
