How to Calculate Excel Data in MS Word (Video in Khmer)

Hello everyone! Welcome back to word.rean.me by Rean Computer 101!

Do you know you can calculate numbers and use Excel formulas (like SUM, AVERAGE, or multiplication) directly inside Microsoft Word?

Normally, Word tables cannot do complex calculations easily like Excel. But if you insert Excel Worksheet Object into Word, you get full Excel calculation power right inside your Word document!

Today I show you step-by-step how to insert Excel table object into MS Word and calculate data easy easy!

📺 Video Tutorial: How to Calculate Excel Data in MS Word

Watch this short video tutorial in Khmer to see how to insert Excel object into Word directly:

🛠️ Method 1: Insert Excel Worksheet Object into Word

Using Excel object allows you to use full Excel ribbon, functions, and cell formulas right inside Word!

Step-by-Step Instructions:

1. Open your document in MS Word.
2. Go to Insert tab on top menu.
3. Click Table button => select Excel Spreadsheet (or go to Insert => Object => Microsoft Excel Worksheet).
4. A mini Excel window will open inside your Word page with green Excel ribbon header!
5. Type your data numbers in cells (e.g., Price, Quantity).
6. Type formulas just like Excel:

• Total Sum: =SUM(A1:A5)
• Multiply Total: =B2*C2

1. When finished, click outside the Excel box anywhere on your Word page.
2. The Excel ribbon closes and your formatted table stays clean in Word!

> 💡 Tip: Need to update numbers later? Just double-click on the table box! It opens Excel editing mode again immediately.

🛠️ Method 2: Use Built-in Word Table Formula (=SUM(ABOVE))

If you already have a normal Word table, you can calculate totals without inserting Excel object!

Step-by-Step Instructions:

1. Click inside the empty cell where you want total answer.
2. Go to Layout tab (under Table Tools).
3. Click Formula button (fx icon on right side).
4. In formula box, Word auto-detects formula like =SUM(ABOVE) or =SUM(LEFT).
5. Choose Number format (e.g., $#,##0.00) => click OK.

💡 Short & Clear Tips Summary

• ⚡ Double-Click to Edit: Double-click embedded Excel object anytime to change formulas or add new rows live!
• 🧮 Auto-Update Word Table (F9): If you change numbers in normal Word table, select total number and press F9 key to refresh total!
• 📐 Crop Extra Rows: Drag corner handles of Excel object box inward so blank grid rows are hidden.
• 🔗 Link Real File: Use Insert => Object => Create from File => Link to File if you want Word table to sync with an external .xlsx file on your computer!

🔗 Related Resources & Tips:

• 📊 Copy Excel Data to Word & Use Paste Special
• 📋 Working with Tables in Microsoft Word
• 🔀 How to Sort Data in Microsoft Word

Hope this quick tip help you calculate Excel data in MS Word fast and easy! Happy typing!