How to Create Certificate Template and Insert Data in MS Word (video in khmer)

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

Do you need to make certificates for 50 or 100 students in your school or company? Don't type student names one by one manually! That takes whole day and makes headache!

Today I show you step-by-step how to create a beautiful Certificate Template in Microsoft Word and auto-fill student data directly from Excel file easy easy!

📺 Video Tutorial: Create Certificate in Word with Excel Data

Watch this video tutorial in Khmer to see how to design certificate template and connect Excel student list:

🛠️ Step 1: Design & Setup Certificate Page in Word

First, set up your Word page orientation to Landscape and design your certificate layout:

1. Open MS Word and create a blank document.
2. Go to Layout tab => click Orientation => select Landscape.
3. Click Margins => select Narrow (or set 1 cm for top, bottom, left, right).
4. Go to Design tab => click Page Borders => choose decorative border line or Kbach art frame.
5. Add certificate main titles (e.g. "CERTIFICATE OF ACHIEVEMENT"), awarded text, signature lines, and date line.

> 💡 Tip: Want ready-made professional designs? Go to File => New and search for "Certificate" in the template search box! Word will load beautiful templates for free!

🛠️ Step 2: Prepare Your Excel Data File

Before linking data to Word, make sure your Excel student list is organized properly:

1. Open Excel and create a new spreadsheet.
2. In Row 1, type clear column header titles: No, Full Name, Course Title, Date.
3. Type student info under each column row by row.
4. Save your Excel file (e.g. Student_List.xlsx) and close Excel.

> 💡 Tip: Always keep header names in Row 1 with no blank rows above it so Word can recognize field names accurately!

🛠️ Step 3: Connect Excel List to Word Certificate (Mail Merge)

Now link your Excel file to your Word certificate template so all names generate automatically:

1. In your Word certificate document, go to Mailings tab on top menu.
2. Click Select Recipients => choose Use an Existing List....
3. Browse and select your saved Excel file (Student_List.xlsx) => click Open => select Sheet1$ => click OK.
4. Highlight where student name goes on certificate => click Insert Merge Field => select Full Name.
5. Click Preview Results icon on Mailings tab! BOOM! Student names show up on certificate page!
6. Click arrow ▶ to check next student name.
7. When ready, click Finish & Merge => Edit Individual Documents... => select All => click OK.

MS Word will create a new document with all customized student certificates automatically!

> 💡 Tip: Need to print all certificates directly? Click Finish & Merge => Print Documents to send all certificates directly to your printer!

💡 Summary of Certificate Tips

• Layout => Orientation => Landscape = Standard horizontal certificate page layout.
• File => New => Search "Certificate" = Use built-in templates to save time.
• Mailings => Select Recipients => Use Existing List = Connect Excel file list.
• Insert Merge Field = Place dynamic student name tag on template.
• Finish & Merge = Generate all certificates at once!

🔗 Related Resources & Downloads:

• 🖼️ Download & Use Border Frames for Certificates
• 📐 How to Set Shape Size 4x6 or 3x4 in Word
• 📄 Create CV & Cover Letter with Templates in MS Word