How to Put Excel Formulas in a Word Document

In this video I demonstrate how to use Excel formulas in a Microsoft Word document. I explore two methods:

1) Copy and Paste Special from Excel
2) Insert Excel Spreadsheet within Microsoft Word

Both methods give you access to all the formula functionality in Excel.
------------------------

[aqwsxzM]

Pretty good. I hadn't thought of putting excel into a word doc before but now I wonder why I ever went through the effort of making tables in word when I could have just inserted an excel object. Thanks for the insight, I look forward to trying it.

[ballinwes]

Quick and to the point, great vid thank you!

[steve]

This morning I didn't know you could insert excel formulas into word.

Now I know of two ways of doing it.

[Titos]

Thank you sir !! greetings from Greece !

[bridgestreetamechurch]

This was much easier than learning how to input formulas in Word tables.

[dmitriykarlov]

Quick and informative tutorial. Thank you very much!

[asokaranjan]

Very gentle explanation made by you. Good presentation. Well done Good job.

[sofier.schmahl]

When I double click on the table, it opens the excel workbook instead of editing directly in word.

I googled how to fix it without any luck ...

Do you know how to fix it?

[IvanCortinas_ES]

Thank you Chester. Good tutorial. Increasing knowledge!

[marihambasta]

Thank you Chester, exactly what I was looking for.

[karinapatino]

What about if your inserted table is referencing a linked workbook, will it update the data?

[krishnav]

Really a useful video..worth watching!! thanks for all these valuable information.. :)

[georges]

Any way to use formulas like IF without connecting or opening an excel style in Word?

[GraceBautista]

After pasting the excel lines is still showing is there away to remove?

[Lulu-kjom]

I wanted to do this because the person who needs to receive this excel spreadsheet as an order form, does not have the ability to use excel on her laptop. Question: If I send this word doc, with all the excel formulas in tact, via email to the recipient with the laptop, will she be able to use the form with the formulas, insert quantities, etc and email it back as a word document that I can double click on and make it reveal as an excel again?

[MidnightIsolde]

When I use the first method and double click, mine opens an Excel file separate of the Word document rather than opening as a spreadsheet within the Word document.

[TheLazyHermit]

My "Insert Table" Doesn't have an "Excel SpreadSheet" how do I make it show.