The Equation Editor is new in Excel 2010 and designed to create a mathematical equation as a graphical object. I didn’t find it in Excel 2011 for Mac, but ran across an showing they put it inside Word 2011. How very strange. Here I’ll review the Excel 2010 version of Equation Editor first, then briefly compare, and come back to the Word 2011 version of Equation Editor.

Excel 2010 Equation Editor The Equation Editor in Excel 2010 is difficult to navigate at first. The second time I tried creating an equation it got slightly easier, and the third time with the same equation (shown below) I seemed to almost get the hang of it. The trick I learned was to just type the equation in and let the Editor do its thing in rearranging what you’re typing. On the Equation Tools Ribbon are two helpful selections: Professional and Linear (shown below). Playing around with these helped me understand how the Editor can manipulate simple equations. Having said that, equations will take some time to figure out, but this editor should handle most anything you can throw at it.

Let's look at some Excel LINEST function examples and explore how to use the LINEST function as a worksheet function in Microsoft Excel: This first example we have entered the y values in column A (cells A2 through A6) and the x values in column B (cells B2 through B6). Jan 4, 2013 - Equation writer option is not under insert/object/equation writer. I have 2011 Microsoft excel for mac. Can i use an xbox controller for fortnite on a mac. I tried to ask support, and when asked for.

Entering an Equation To enter an equation with the Equation Editor go to the Insert tab on the Ribbon, and click Equation. This gives you a text box with the words “Type equation here.” You’ll also notice two additional menu tabs on the Ribbon: Equation Tools, which becomes active, and Drawing Tools.

Right Side of Equation Tools Ribbon Clicking the Equation drop-down arrow will reveal several predefined equations that can be inserted as starting point for your equation. This how I started my first equation, which did me no favors. I fared much better just typing in the formula and letting the Equation Editor move things around. One Annoyance One of the problems with the Equation Editor is that if you stray to far outside the equation, yet still inside the text box, the Equation Tools tab disappears and you’re stuck with the Drawing Tools tab only. Google Docs Mathematical Equations I looked at the new and it seemed easier to learn, but is not nearly as powerful as the Equation Editor.

For example, the equation I created above was done in a Google Docs document with Mathematical Equations. I wasn’t able to do a strikethrough for the min text, like this: min. And there wasn’t a good way to export this object out of Google Docs. Equation Editor in Word 2011 for Mac The Equation Editor in Word 2011 for Mac looks to be identical to the one in Excel 2010. You start an equation from the Document Elements tab on the Ribbon, by clicking Equation or the drop-down menu arrow and selecting a built-in equation.

The Equation Tools tab immediately becomes visible and active after starting an equation. I created the same formula with relative ease. I kind of like the feel of this Word 2011 version better than what’s in Excel 2010. 17 thoughts on “ Equation Editors in Excel 2010 and Word 2011” • Eric I’m not so sure that the equation editor is all so new I’ve been using Microsoft Equation 3.0 as part of the 2003 Office Pack at work for quite a while. I haven’t started to use 2010 yet, so I can’t fully compare.