Microsoft Office

Microsoft Office

Durasi : 5 hari

Deskripsi:

Microsoft Office adalah suatu piranti lunak banyak digunakan dalam bidang industri seperti administrasi perkantoran, akunting, real-estate, konstruksi, penjualan, pemasaran dan lain sebagainya.

Pelatihan Microsoft Office Basic ini memberikan pemahaman yang benar kepada para Peserta tentang cara penggunaan aplikasi-aplikasi MS Office yang efisien dan efektip sehingga dicapai hasil kerja yang produktif dengan kualitas yang memuaskan.

Dengan metode pelatihan step-by-step serta dibimbing oleh trainer mempunyai kompetensi dan dedikadi yang tinggi, setelah menyelesaikan pelatihan diharapkan peserta akan mampu meningkat kemampuan dalam pelaksanaan pekerjaan sehingga memperoleh hasil yang akurat, cermat, aman, dan elegan.

Prasyarat :

Tidak ada prasyarat untuk mengikuti training ini

Materi :

Part-1: MS Office
1. Explore MS Office
• Work in the Office user interface
• Change Office and app options
• Customize the Quick Access Toolbar
• Customize the ribbon
• Get help and provide feedback

2. Create and manage files
• Create files
• Open and move around in files
• Display different views of files
• Display and edit file properties
• Save and close files
Part-2: MS Word
3. Modify the structure and appearance of text
• Apply paragraph formatting
• Structure content manually
• Apply character formatting
• Create and modify lists
• Apply built-in styles to text
• Change the document theme
• Practice tasks

4. Merge data with documents and label
• Understand the mail merge process
• Start the mail merge process
• Choose and refine the data source
• Insert merge fields
• Preview and complete the merge
• Create individual envelopes and labels
• Practice tasks
Part-3: MS Excel

5. Perform calculations on data
• Name groups of data
• Create formulas to calculate values
• Summarize data that meets specific conditions
• Set iterative calculation options and enable or disable automatic calculation
• Use array formulas
• Find and correct errors in calculations
• Practice tasks

6. Manage worksheet data
• Limit data that appears on your screen

• Manipulate worksheet data
• Define valid sets of values for ranges of cells
• Practice tasks

7. Reorder and summarize data
• Sort worksheet data
• Sort data by using custom lists
• Organize data into levels
• Look up information in a worksheet
• Practice tasks
Part-4 : MS PowerPoint
8. Create and manage slides
• Add and remove slides
• Apply themes
• Change slide backgrounds
• Divide presentations into sections
• Rearrange slides and sections
• Practice tasks

9. Insert and manage simple graphics
• Insert, move, and resize pictures
• Edit and format pictures
• Provide additional information about pictures
• Practice tasks

 

 

Phone: (022) 4221130
Fax: (022) 4235692
Jl. Lengkong Kecil No. 73, Gedung Labora Lantai 2, Paledang, Kota Bandung, Jawa Barat 40261