How to enter equations in Excel

You can watch a video tutorial here.

Excel is primarily used for its spreadsheet functions but it also supports several textual functions.  When evaluating an equation, for example, the area of a circle, you can do so by typing the formula in the cell using the equal sign (=). The problem arises when you want to include the equation itself. It becomes a complex process to include the Pi character or numerators and denominators within the cell. To solve this problem, Excel has some preset equations that can be used or you can write your own equation.

Option 1 – Use a preset equation 

Step 1 – Find the equation

• Go to Insert > Symbols > Equation 
• Select Binomial Theorem 

Step 2 – Move the equation to an appropriate location

• The equation will be inserted into the file as an image
• Move the equation image to the desired location

Option 2 – Write the equation

Step 1 – Open the Math Input Control box

• Go to Insert > Symbols > Equation 
• Select Ink Equation

Step 2 – Write the equation

• Write the equation using the mouse
• Check the preview to see if the characters are displayed correctly
• Click Insert

Step 3 – Check the result

• The equation is inserted as an image