Object Linking and Embedding pada Word - TIK-K10-04

Summary

In this tutorial, Zainal Abidin demonstrates how to use Object Linking and Embedding (OLE) to integrate Excel data into Word documents. He explains the difference between embedding and linking data and shows how linking ensures that any changes made in Excel are automatically reflected in Word. The session covers the step-by-step process of creating an Excel table, applying basic formatting, and then linking or embedding the data into a Word document. Zainal also discusses different paste options and provides tips for table design, ultimately simplifying the task of integrating and managing data across applications.

Takeaways

• 😀 Create a sales data table in Excel, including columns for item numbers, names, prices, quantities, and totals.
• 😀 Use Excel formulas (e.g., multiplication for totals) to automate calculations.
• 😀 Format the Excel table for clarity by adjusting column widths and applying currency formatting.
• 😀 Save the Excel file to a specific folder for later use in Word.
• 😀 Open Microsoft Word and prepare to paste data from Excel using the 'Paste Special' function.
• 😀 Choose between two linking options in Word: 'Link and Keep Source Formatting' and 'Link and Use Destination Style'.
• 😀 'Link and Keep Source Formatting' keeps the Excel table’s format while linking it to Word.
• 😀 'Link and Use Destination Style' adapts the Excel data to the Word document’s format while keeping it linked.
• 😀 When data is updated in Excel, the linked data in Word also updates automatically.
• 😀 Customize the table design in Word by adjusting the layout and applying a preferred table style.
• 😀 Save the Word document with the linked Excel data to ensure it remains updated when the Excel file is changed.

Q & A

What is the main topic covered in the tutorial?

The tutorial focuses on demonstrating Object Linking and Embedding (OLE) between Microsoft Excel and Word, showing how to link data from Excel into a Word document while ensuring that any changes in Excel are reflected in the Word document.

What are the key steps in creating the Excel data for linking to Word?

First, create a sales data table in Excel with columns like 'No', 'Item Name', 'Unit Price', 'Quantity', and 'Total'. Then, apply a formula to calculate the 'Total', format the table for neatness, and save the Excel file.

What is the difference between the 'Link and Keep Source Formatting' and 'Link and Use Destination Style' options when pasting data into Word?

'Link and Keep Source Formatting' retains the original Excel formatting, while 'Link and Use Destination Style' adapts the Excel data formatting to match the style of the Word document.

Why is it important to use the 'Accounting' format for currency in Excel?

The 'Accounting' format ensures that the currency symbol (Rp) is aligned to the left of the numbers, making the data presentation more consistent and readable.

How can you ensure that the table in Word appears neat after pasting Excel data?

You can use the 'AutoFit' option in Word's Table Layout menu to automatically adjust the table’s width and ensure that it fits properly within the document.

What happens when you change the data in Excel after linking it to Word?

If the data is linked, any changes made in Excel (like modifying the 'Quantity' in the sales data) will automatically update in the Word document, ensuring the data remains synchronized.

What are some common formatting adjustments made in Excel before linking to Word?

In Excel, common adjustments include setting appropriate column widths, applying currency formatting (Accounting style), and adding borders to make the table visually clear and organized.

What is the purpose of using 'Merge and Center' in Excel?

The 'Merge and Center' feature in Excel is used to combine multiple cells into one and center the text within that merged cell, improving the table’s overall alignment and readability.

Why is it recommended to use the 'Paste Special' option when linking Excel data to Word?

The 'Paste Special' option is recommended because it allows you to choose whether to embed or link the data, ensuring that the pasted content is dynamically updated when the source Excel file changes.

How can you change the design of a table in Word after pasting data from Excel?

You can modify the table's design by selecting the table and using the 'Table Design' menu in Word to choose from various styles and adjust the layout according to your preferences.