Course Description

The course content and subtitles are in Bahasa Indonesia.


Ringkasan / Synopsis:

Di era digital saat ini, pemrosesan dan analisis data telah menjadi keterampilan penting bagi para profesional, terutama di bidang keuangan, audit, dan manajemen bisnis. Microsoft Excel tetap menjadi alat utama untuk mengelola data, melakukan perhitungan, dan menyajikan informasi secara efektif melalui visualisasi yang jelas. Pelatihan Menerapkan Prinsip-Prinsip Dasar Pemrosesan Data dirancang untuk membekali peserta dengan keterampilan Excel dasar hingga menengah, termasuk fungsi-fungsi dasar seperti SUM dan AVERAGE, membuat bagan sederhana, dan memanfaatkan fitur-fitur canggih seperti PivotTable, PivotChart, dan fungsi Lookup (VLOOKUP, HLOOKUP). Dengan pendekatan Pembelajaran Mandiri, peserta dapat belajar secara fleksibel sesuai kecepatan mereka sendiri, menerapkan teknik-teknik tersebut secara langsung dalam pekerjaan sehari-hari.


Pelatihan ini sangat relevan bagi para profesional di bidang keuangan, audit, dan sektor publik yang sering bekerja dengan kumpulan data besar dan membutuhkan alat yang efisien untuk menganalisis dan menyajikan informasi secara akurat. Dengan menguasai teknik pemrosesan data di Excel, peserta dapat meningkatkan efisiensi kerja, memastikan akurasi laporan, dan menyajikan data dalam format yang lebih mudah dipahami untuk mendukung pengambilan keputusan strategis.


Translated Synopsis:

This self-paced course teaches fundamental to intermediate Microsoft Excel skills for professionals in finance, auditing, and business. Participants will learn essential functions, data visualisation, and tools like PivotTables and Lookup functions to efficiently analyse and present large datasets. The training helps improve reporting accuracy, work efficiency, and supports better decision-making.



Ditujukan Untuk / Intended For:

  • Profesional Audit / Audit Professionals (PAIP) 
  • Profesional Keuangan / Finance Professionals (PAIB) 
  • Keuangan Sektor Publik / Public Sector Finance
  • Pemilik Bisnis / Business Owners


Pemetaan Kompetensi / Competency Mapping: 

  • CPE Category 5 = 1.0 CPE Hour
Instructor Image

Telly Chandra

Data Analyst, MNC Financial Services (PT MNC Kapital Indonesia Tbk)

Telly Chandra, S.Kom, is a professional trainer and data analyst with over 19 years of experience in data processing, business analysis, and data visualization for strategic decision-making. He is currently a Data Analyst at PT MNC Financial Services, where he is responsible for optimizing data warehousing systems, developing high-level analytical dashboards, and conducting in-depth analysis of user behavior and product performance.Previously, Telly worked as a Data Analyst at Cakap.com and a Data Scientist at Cogency Marketing Indonesia, where he developed automated reporting systems, processed customer data using statistical methods, and improved business conversion rates through AI-driven data analysis. His expertise in SQL, Microsoft Excel, Tableau, Power BI, and Google Data Studio makes him a specialist in transforming raw data into actionable insights.As a trainer and mentor, Telly has shared his expertise through various training programs, including Business Intelligence, Data Analytics using Excel and Metabase, and Upskill Training for major corporations. With a practical, case study-based, and easily applicable teaching approach, he helps participants grasp the fundamentals of data processing, master effective analytical techniques, and optimize data to enhance business efficiency.With a combination of extensive industry experience and strong technical expertise, Telly is ready to help individuals and organizations master data processing as a strategic asset for more accurate and effective decision-making.

1 CPE Hour

Lesson(s)

10

Related courses