cara object linking and embedding | integrasi office
Summary
TLDRThis tutorial demonstrates how to integrate Microsoft Excel data into Microsoft Word using object linking. The presenter walks through the steps, starting with preparing and saving an Excel file, then linking it to Word via the 'Insert Object' feature. The video highlights how changes in the Excel file dynamically update in Word, ensuring data consistency. This method also applies to PowerPoint. The tutorial is designed to help users seamlessly link and sync data between these Microsoft Office applications. Viewers are encouraged to like, subscribe, and comment if they find the tutorial helpful.
Takeaways
- đ The tutorial demonstrates integrating Microsoft Excel data into Microsoft Word.
- đ First, prepare the Excel data you want to link to Word.
- đŸ Save the Excel file with an appropriate name for future use.
- đ Open Microsoft Word to start the linking process.
- đ Use the 'Insert' tab and choose 'Object' to link the Excel data.
- đ Find the saved Excel file and insert it into the Word document.
- âïž Ensure the 'Link to File' option is checked before inserting.
- đ Changes made in Excel will automatically update in the linked Word document.
- đ The tutorial shows modifying data in Excel and seeing the update reflected in Word.
- đ Linking Excel data with Word makes it easier to maintain consistency across documents.
Q & A
What is the main topic of the tutorial?
-The tutorial focuses on integrating data from Microsoft Excel into Microsoft Word using linking.
What is the first step in the integration process?
-The first step is to prepare the data in Microsoft Excel that will be linked to Microsoft Word.
How should the Excel file be saved for integration?
-The Excel file should be saved with a specific name, like 'contoh latihan peringkat satu,' using the 'Save As' option.
What is the next step after saving the Excel file?
-After saving the Excel file, the next step is to open Microsoft Word.
How do you link the Excel file to the Word document?
-To link the Excel file, go to the 'Insert' tab, select the 'Object' option under the 'Text' group, and choose 'Create from File.' Then, find and select the saved Excel file.
What is the importance of ensuring the 'Link to file' option is checked?
-Ensuring the 'Link to file' option is checked allows the data in the Word document to update dynamically whenever changes are made in the linked Excel file.
How can you verify that the Excel data is correctly linked to Word?
-You can verify the linking by minimizing the Word document, modifying data in the Excel file, and then checking if the changes are reflected in the Word document.
What example is used in the tutorial to demonstrate the data linking?
-The tutorial uses an example where student names and their grades are modified in the Excel file, and the changes are automatically updated in the Word document.
Can linked data be updated in real-time when changes are made in Excel?
-Yes, the linked data in Word will automatically update when changes are made in the linked Excel file.
What is the overall benefit of linking Excel data to Word or PowerPoint?
-The benefit of linking Excel data to Word or PowerPoint is that it allows the data to remain synchronized, meaning any updates in Excel will automatically reflect in Word or PowerPoint without manual intervention.
Outlines
đ» Introduction to Integrating Excel with Word
The video tutorial begins by welcoming the audience and introduces the topic of integrating Microsoft Excel data into Microsoft Word. The first step involves preparing the data in Excel, which will be linked to Word for demonstration purposes. A table has already been created in Excel for this example.
đ Saving the Excel File
The next step in the process is saving the Excel file. The user is instructed to use the 'Save As' function and to save the file with a specific name, in this case, 'Contoh Latihan Peringkat Satu'. This step is crucial for the integration to work properly in the following steps.
đ Opening Microsoft Word
After saving the Excel file, the tutorial continues with opening Microsoft Word. The video shows the process of preparing Word to receive the data from Excel by opening it and getting ready for the linking process.
đ Linking Excel to Word
This step demonstrates how to link the Excel file to Microsoft Word. The user is guided to go to the 'Insert' tab, select 'Object' from the 'Text' group, and choose 'Create from File'. The tutorial explains how to find and insert the previously saved Excel file to create the link.
â Verifying the Linked Data
The linked data is now displayed in Word. The tutorial checks whether the data in Word matches the data in Excel. After minimizing the Word window, the video compares the two sets of data, verifying that the connection has been established properly.
đ Testing Changes to Linked Data
The video now tests the dynamic link by changing some data in Excel and observing the updates in Word. For example, changing a student's score from '13' to '1' is reflected in Word, as well as modifying other values such as scores and ranks, confirming that the integration works.
đ Practical Demonstration of Data Update
The tutorial continues with more practical examples of updating student scores in Excel and observing the changes in Word. The user changes values such as a student's score from '65' to '85', and Word updates accordingly, showcasing the functionality of the linking feature.
đŻ Conclusion: Linking Excel to Word and PowerPoint
The tutorial concludes by summarizing the benefits of linking Excel data with Word (or PowerPoint). It reinforces that changes in Excel will be reflected in Word, and the linked data can be easily updated. The video ends with a reminder to like, subscribe, and comment if the tutorial was helpful.
Mindmap
Keywords
đĄMicrosoft Excel
đĄMicrosoft Word
đĄIntegration
đĄObject Linking
đĄInsert Object
đĄLink to File
đĄDynamic Data Update
đĄSave As
đĄData Consistency
đĄReal-time Synchronization
Highlights
Introduction to the video tutorial on integrating Microsoft Excel with Microsoft Word.
Step 1: Preparing data in Excel for integration with Microsoft Word.
Step 2: Save the Excel file with a specific name 'contoh latihan peringkat satu.'
Step 3: Open Microsoft Word to begin the integration process.
Step 4: Use the 'Insert' tab in Word, navigate to 'Group Text,' and select 'Object.'
In the 'Object' window, choose the option to create an object from the saved Excel file.
Locate the saved Excel file and link it to Word using 'Insert' and ensure 'Link to File' is selected.
Example demonstration: Linked Excel data is displayed within the Word document.
Verification: Changes made in Excel are reflected in the linked data in Word.
Example change: Modifying student data in Excel automatically updates in Word.
Further demonstration: Changing numeric values (e.g., from 100 to 90) shows automatic updates in Word.
Another example: Changing values for a specific student updates their ranking and totals in Word.
Explanation: Linking allows dynamic data synchronization between Excel and Word (or PowerPoint).
Conclusion: Benefits of linking Excel data to Word for real-time updates.
Call to action: Encouraging viewers to like, subscribe, and comment on the video.
Transcripts
Hai semua
selamat datang di wonebi tutorial
di video ini kita akan belajar
integrasi pada Microsoft Office dengan
cara menampilkan data objek lingking
dari Microsoft Excel ke dalam Microsoft
Word
Langkah pertama
siapkan data yang akan dilakukan
integrasi antara Microsoft Excel ke
dalam Microsoft Word sebagai contoh
sudah saya siapkan sebuah tabel yang
akan kita lakukan klengkeng dengan
Microsoft Word
Langkah kedua
simpan file Excel ini
file save as
kemudian
Simpan dengan nama file contoh latihan
peringkat satu
save
kemudian
langkah ketiganya kita buka Microsoft
Word
[Musik]
Oke langkah keempat kita hubungkan
Microsoft Excel ini ke dalam Microsoft
Word
caranya
kitab Insert
pilih
group text kemudian di sini
ada namanya objek
klik objek
maka akan terbuka jendela object
pilih tab create profile Hai
pada tapi ini Carilah file yang sudah
anda simpan tadi
[Musik]
cari lokasi Penyimpanan file excelnya
[Musik]
kemudian melakukan Insert
pastikan pling to file-nya tercinta
ngatif
klik ok
[Musik]
ini adalah hasil
dari lingking antara Microsoft Excel
dengan Microsoft Word
kita coba apakah data ini sama dengan
yang ada di Excel
saya minimized dulu He siapa
Kyuhyun menyeringai
Hai Oke kita cek Sekarang
apakah datanya terhubung ini adalah data
yang ada di Excel Sedangkan ini adalah
data yang ada di Microsoft Word kacek
Oke
kita coba
Hah siswa 13 ini akan saya rubah menjadi
siswa satu
saya Enter kita cek Apakah dia akan
berubah
Oke dia akan berubah menjadi siswa satu
kita cek lagi
siswa 3 ini memiliki lihat nilai agama
100 share Ubah menjadi 90
disini 100 ya Tekan enter
oke maka nilai siswa 3 berubah menjadi
90
peringkatnya pun akan ikut berubah
jumlahnya pun akan ikut berubah
Ayo kita coba lagi siswa nomor 6 dengan
nilai 65 kita rubah menjadi 85
[Musik]
disini siswa nomor 6 nilainya masih 65
Oke saya Enter
maka akan berubah menjadi 85
jadi fungsi dari lingking ini adalah
menghubungkan data yang ada di Microsoft
Excel dengan Microsoft Word ataupun
dengan Microsoft Powerpoint
Oke demikian video ini saya buat
Hai jika dirasa bermanfaat jangan lupa
klik like subscribe dan comment Terima
kasih sudah
Voir Plus de Vidéos Connexes
Integrasi Antar Aplikasi Office : Embedding, Object Linking, dan Mail Merge
Integrasi Aplikasi Perkantoran dengan OLE | Materi Informatika Kelas 9 | Elemen Literasi digital
Mengenal Aplikasi Perkantoran
Mail Merge from Excel to Microsoft Word
MENDELEY #1: CARA INSTAL, MENGENAL MENU-MENU, DAN MENGHUBUNGKAN KE MS WORD
Download and Install Office 2024 From Microsoft for Free | Genuine Version| Download Office 2024
5.0 / 5 (0 votes)