Excel Tailor: Insert Excel formulas in Word and Outlook

Have you ever wondered how we can insert excel formulas in MS Word or Outlook.

See below image, we need a total and average of the numbers in 5th row and 4th column

To apply the formula, we need to convert the full range to a table format like above.

Once the data in table format, we can apply formula in it.

1st Way

Select the cell where we want to apply the formula.

Press "Ctrl" and "F9" key. We will get two braces like below image.

We have to insert our formula in between these braces.

As, we want a sum here, so we will write "=sum(above)" in between the braces, as we require the sum for all cells above.

Press "F9" key

and the result will be displayed in the cell.

Similarly for Average we will perform the same steps by inserting the formula "=average(left)", as we require the average for all cells from left.

2nd Way

Select the cell where we want to apply the formula.

Go to "Layout" tab and select formula

Insert formula from the drop down list.

These formula cant update if there are any changes in the data.

To Edit them / update them , Select the formula

and Press "Shift" and "F9" and press "F9" to update.

Add-ins