Advanced Microsoft Office And Computer Technique – Microsoft Office 2007/2010 merupakan produksi Microsoft® Corporation, sebuah paket program aplikasi popular untuk kebutuhan user perkantoran baik kebutuhan dasar ataupun kebutuhan tingkat lanjut (advanced) untuk bisnis dan manajerial, Microsoft Office menjadi sangat popular dikarenakan kemudahan dalam penggunaannya dan berjalan dengan sempurna diOperating system yang popular juga yaitu windows XP dan Windows Seven. Aplikasi popular yang terdapat di dalam Microsoft Office 2007/2010 dan sering digunakan dalam kegiatan sehari hari antara lain : MS. Word, MS. Excel.
MATERI:
Microsoft Word
- Macros and Proofing
- Sharing and Reviewing Documents
- Modify Word Document
- Set a Default Front for Documents
- Text Replacement and Autoformat Options
- Use Different Tools
Excel
1. advance Formulas & Functions
- Values and Formulas
- Operations in Formulas
- IF, AND, OR and NOT Functions
- VLOOKUP and HLOOKUP
- Tabulating Data and Multiple Criteria
- Median, Mode and Ranking Data
- Date, Time and Functions
- Array Formulas and Frequency Functions
- OFFSET and INDIRECT Function
- Different TEXT & Information Functions
- Advance Formatting And Techniques
2. Advance Formatting And Techniques
- Introduction to Excel Advance Formatting & Techniques
- Adjust Fonts, Font Sizes & Font Colours
- Adjust Cells and Tools
- Work with Formulas & Tables
- Adjust Row, Columns and Sheets
- Different Formatting Styles and Set up Data for Outlines
- Formatting Picture Styles
- Formatting Techniques – Restore Missing Data in a Column
Teknik Komputer dan Jaringan
- Menginstal Sistem Operasi (Windows/Linux) dan Program Aplikasi
- Antivirus dan update, recovery file terkena virus
- Prosedur dan troubleshooting Backup Data
- Troubleshooting komputer menggunakan software
- Lingkup Jaringan pada Microsoft Windows
- Memasang kabel UTP,connector, crimping, cross cable, installasi kartu jaringan,
- Sharing (file/folder, printer), dan permission
- Internet Connection Sharing
INSTRUKTUR:
Andika Bayu Saputra S.Kom., M.Kom and Tim
METODE:
Kegiatan pelatihan dirancang agar peserta dapat memahami secara komprehensif materi yang disampaikan, sehingga dapat dimplementasikan secara aplikatif dalam dunia kerja. Adapun metode yang digunakan adalah:
- Presentation
- Discuss
- Case Study
- Evaluation
PESERTA:
Manajer, Supervisor , Junior Supervisor yang bertanggung jawab terhadap TQM, etc
FASILITAS:
- Training Hand Out
- Digital Material
- Certificate
- Exclusive Souvenir
- Qualified Bag
- Training Photo
- Training room with full AC facilities and multimedia
- Once lunch and twice coffee break every day of training
- Qualified Instructor
Jadwal Pelatihan 2024
| JAN - FEB | MAR - APR | MEI - JUN | JUL - AGST | SEP - OKT | NOV - DES |
|---|---|---|---|---|---|
| 2 - 4 Jan | 5 - 7 Mar | 1 - 3 Mei | 2 - 4 Jul | 5 - 7 Sept | 5 - 6 Nov |
| 9 - 11 Jan | 12 - 14Mar | 7 - 9 Mei | 9 - 11 Jul | 12 - 14 Sept | 12 - 13 Nov |
| 17 - 19 Jan | 19 - 21 Mar | 14 - 16 Mei | 16 - 18 Jul | 19 - 21 Sept | 19 - 20 Nov |
| 23 - 25 Jan | 26 - 28 Mar | 21 - 23 Mei | 23 - 25 Jul | 27 - 28 Sept | 26 - 27 Nov |
| 30 Jan - 1 Feb | 2 - 4 Apr | 28 - 30 Mei | 30 Jul - 1 Agst | 3 - 5 Okt | 3 - 4 Des |
| 6 - 8 Feb | 16 - 18 Apr | 4 - 6 Jun | 6 - 8 Agst | 10 - 12 Okt | 10 - 11 Des |
| 13 - 15 Feb | 23 - 25 Apr | 11 - 13 Jun | 13 - 15 Agst | 15 - 16 Okt | 17 - 18 Des |
| 20 - 22 Feb | 18 - 20 Jun | 27 - 29 Agst | 24 - 26 Okt | 23 - 24 Des | |
| 27 - 29 Feb | 25 - 27 Jun | 29 - 31 Agst | 29 - 30 Okt | ||
Waktu dan tempat:
Pukul 08.30 – 16.00 WIB
Hotel Berbintang di Yogyakarta
Request for Training Venue: Semarang, Solo, Bandung, Jakarta, Balikpapan, Surabaya, Jogja, Lombok, Malang, Makassar and Batam
In House Training Depend on request
Leave a Reply