(( Kuasai Microsoft EXCEL Cara Mudah )) Master Microsoft EXCEL Made Easy

raffiq_eddy · Post time 5-2-2018 09:40 AM

Edited by raffiq_eddy at 10-5-2018 04:10 PM

Course: Master Microsoft EXCEL Made Easy
Level: Advanced
Venue: In-House (Training at Your Venue)
Pax: 20 (Max)
Duration: 2 days
Fees: According to the number of days
Training kit, Material, Support & Assistance after training will be provided

INTRODUCTION
This course covers all you need to building organized workbooks. The trainer teaches you how to enter and organize data, perform calculations with functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

TARGET GROUPS
Users with a good understanding of Microsoft Excel who want to expand on their capabilities. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Below are just a few of the topics you will master:

Worksheet creation
Techniques for pasting and copying
Entering Auto Fill with data automatically
Targeting large data groups
Changing worksheet structure
Understanding functions and formulas
Entering a worksheet with data
Manually adding numbers
Using Sum and AutoSum and adding numbers
Adding a whole worksheet
Working with numbers in columns
Using absolute references to preventing errors
Working with times and dates
Using IF
Using relational operators and IF functions
Using functions and the COUNTIF family
Using AVERAGEIF and SUMIF
Using cell ranges and Naming
Choosing types of chart
Inserting Sparklines
Creating a column chart
Modifying a column chart
Creating pie chart and modify it
Placing into other Office applications with Excel charts
Understanding macros
Recording a simple macro and using it
Editing a macro
and much, much more...

TRAINER’S PROFILE
Raffiq Bin Eddy is highly motivated and dedicated professional trainer specialized in IT with over twenty three years of intensive experience in the successful design, development and delivery of software. A self-starter and independent; thorough and fast; excellent in researching and analytical skills; and focused as well as sensitive to customer needs. Take pride in seeing projects from concept through successful completion. He is a Full-Time Freelance IT Trainer, Award-Winning Software Programmer currently writing books and exploring Software Development on iPhone etc. and a HRDF Certified Trainer. Beside from developing and installing systems for individual or corporate customers, Raffiq also has experienced as IT lecturer at Colleges and Universities. He has experienced hundreds of users training throughout Malaysia and International, and guides them using the systems he builds. He currently provides Microsoft Office Training for Corporate and Individuals such as MS Access, MS Excel, MS PowerPoint, and MS Word. He also provides other IT / Programming Subjects such as Android Apps with Android Studio, Crystal Report, CSS3, Drupal, HTML5, Java, jQuery, MS SQL Server, MS Visio, MySQL, PHP, Visual Basic, WordPress and many others.

Our client such as:
PT Jaya Real Property Indonesia, CIIT Philippine, ICT Johor, Sime Darby Engineering, Petronas Chemicals Labuan, ExxonMobil, JVC Kenwood, Jabatan Pengangkutan Awam, RapidKL, Jabatan Perdana Menteri, SPRM, Sharp Manufacturing, Court Mammoth, Kontena Malaysia, Perbadanan Pengurusan Sisa Pepejal, Jabatan Perangkaan Putrajaya, Kementerian Pengajian Tinggi, KLMU, Asia e University, Institute Generasi, Asunta Clinics, Bank Rakyat, Cendanasari Insurance Broker, City Medical Center, Darussalam Publisher, Pusat Rawatan Sakit Puan Razif & Norana, Ingress Technology, Kazara Restaurant, Koperasi Peladang, HRDF, Raj Clinics, Shanzshine Trading, personal / private tutor to Professional e.g. lawyer / doctor, and students.

Countries which we visit to conduct training such as:

Philippine
Indonesia

We also a volunteer to:

Islamic Aid Malaysia (AIM)
Madrasah Tahfiz Al-Quran Syazwan
Masjid Ar-Rahimah Kg. Pandan

Contact NOW, and try out once and you will know why the clients continue to support us.

We look forward to working with you!

Thank you

Maya Raffiq
ImpianaSoft Enterprise
013-355-3513

####

Kursus: Kuasai Microsoft EXCEL Cara Mudah
Tahap: Lanjutan
Tempat: In-House (Kursus di Tempat Anda)
Pax: 20 (Max)
Tempoh: 2 hari
Yuran: Mengikut bilangan hari
Kit latihan, Bahan, Sokongan & Bantuan selepas latihan akan disediakan

PENGENALAN
Kursus ini merangkumi semua yang anda perlukan untuk membina Workbook yang teratur. Jurulatih mengajar anda bagaimana untuk memasuki dan menyusun data, melakukan pengiraan dengan fungsi, bekerja dengan pelbagai Worksheet, memformat rupa data anda, dan membina carta dan PivotTables. Pelajaran lain meliputi IF, VLOOKUP, dan fungsi keluarga COUNTIF; Goal Seek, Solver, dan alat analisis data lain; dan bagaimana untuk mengautomasikan banyak tugasan ini dengan Macro.

KUMPULAN SASARAN
Pengguna dengan pemahaman yang baik mengenai Microsoft Excel yang ingin mengembangkan keupayaan mereka. Delegasi harus mempunyai pengetahuan dan pemahaman yang baik tentang konsep-konsep yang terkandung dalam kursus Pengenalan.

Berikut adalah beberapa topik yang anda akan diajar:

Worksheet creation
Techniques for pasting and copying
Entering Auto Fill with data automatically
Targeting large data groups
Changing worksheet structure
Understanding functions and formulas
Entering a worksheet with data
Manually adding numbers
Using Sum and AutoSum and adding numbers
Adding a whole worksheet
Working with numbers in columns
Using absolute references to preventing errors
Working with times and dates
Using IF
Using relational operators and IF functions
Using functions and the COUNTIF family
Using AVERAGEIF and SUMIF
Using cell ranges and Naming
Choosing types of chart
Inserting Sparklines
Creating a column chart
Modifying a column chart
Creating pie chart and modify it
Placing into other Office applications with Excel charts
Understanding macros
Recording a simple macro and using it
Editing a macro
dan banyak lagi...

PROFIL JURULATIH
Raffiq Bin Eddy adalah jurulatih profesional yang bermotivasi dan berdedikasi khusus dalam IT dengan lebih daripada dua puluh tiga tahun pengalaman intensif dalam mereka bentuk, membangun dan menyiapkan perisian dengan berjaya. Teliti dan cepat; cemerlang dalam penyelidikan dan kemahiran analisis; dan memberi tumpuan serta sensitif kepada keperluan pelanggan. Bangga membangun projek dari mula hingga berjaya selesai. Beliau adalah Jurulatih IT bebas sepenuh Masa, Pemenang Anugerah dalam Perisian yang kini menulis buku dan meneroka pembangunan Perisian menggunakan Laravel dan seorang Jurulatih Bersertifikat HRDF. Selain daripada membangun dan memasang sistem untuk pelanggan individu atau korporat, Raffiq juga berpengalaman sebagai pensyarah IT di Kolej dan Universiti. Dia telah jalankan beratus-ratus latihan pengguna di seluruh Malaysia dan Antarabangsa, dan membimbing mereka menggunakan sistem yang dibinanya. Beliau kini menyediakan Latihan Microsoft Office untuk Korporat dan Individu seperti MS Access, MS Excel, MS PowerPoint, dan MS Word. Beliau juga menyediakan Mata Pelajaran IT / Pengaturcara lain seperti Android Apps dengan Android Studio, Crystal Report, CSS3, Drupal, HTML5, Java, jQuery, MS SQL Server, MS Visio, MySQL, PHP, Visual Basic, WordPress dan banyak lagi.

Pelanggan kami seperti:
PT Jaya Real Property Indonesia, CIIT Philippine, ICT Johor, Sime Darby Engineering, Petronas Chemicals Labuan, ExxonMobil, JVC Kenwood, Jabatan Pengangkutan Awam, RapidKL, Jabatan Perdana Menteri, SPRM, Sharp Manufacturing, Court Mammoth, Kontena Malaysia, Perbadanan Pengurusan Sisa Pepejal, Jabatan Perangkaan Putrajaya, Kementerian Pengajian Tinggi, KLMU, Institute Generasi, Asunta Clinics, Bank Rakyat, Cendanasari Insurance Broker, City Medical Center, Darussalam Publisher, Pusat Rawatan Sakit Puan Razif & Norana, Ingress Technology, Kazara Restaurant, Koperasi Peladang, HRDF, Raj Clinics, Shanzshine Trading, tutor peribadi / eksklusif kepada pelanggan Profesional cth. Peguam / Doktor, dan Pelajar.

Negara-negara yang kami lawati untuk menjalankan latihan komputer seperti:

Filipina
Indonesia

Kami juga Sukarelawan untuk:

Islamic Aid Malaysia (AIM)
Madrasah Tahfiz Al-Quran Syazwan
Masjid Ar-Rahimah Kg. Pandan

Hubungi SEKARANG, dan cuba sekali dan anda akan tahu mengapa pelanggan terus menyokong kami.

Beri kami peluang untuk bekerjasama dengan anda!

Terima kasih

Maya Raffiq
ImpianaSoft Enterprise
013-355-3513