ANDA BERADA DI HALAMAN MODUL EXCEL DATA ANALYSIS
search
banner

  • Analysis & Dashboard

  • Kursus In-House Jabatan Kerajaan.

Topik Utama

  • Kursus In House Terkini

  • Excel Data Analysis
  • Advance
  • Visio Professional
  • Intermediate Advance.
  • Microsoft Office IPTA/S
  • Intermediate.


  • MISI Kami!
  • Kami mahu peserta faham dan tahu buat, apabila tamat kursus, bukan nama atau siapa yang mengajar tetapi cukup apa yang mereka pelajari sentiasa ingat di minda lekat di hati. Suka dan puashati memberikan kesan pada peserta dan kami sebagai tenaga pengajar.
    • banner

    banner

    banner

    banner

Penceramah / Tenaga Pengajar

Master in IT, TTT Cert IV (VET) TTT PP/Pengajar (MLVK/JPK).

banner

Assalammualaikum/Salam Malaysia Madani. Modul akan diseragamkan mengikut keperluan jabatan, disusun semula mengikut masa dan bilangan hari. Modul disesuaikan khusus untuk jabatan kerajaan, korporat dan IPTA/S dengan metodologi yang berbeza.

Selain Excel, beliau juga aktif mengendalikan kursus Kreatif PowerPoint, Word, Visio Carta dan Diagram serta Excel Power BI Desktop.  PowerPoint Impak Tinggi

More Info

In House pelbagai agensi kerajaan di seluruh Malaysia

Kursus dijayakan selama 2 - 3 hari atas permintaan dan keperluan.

Advanced Excel Data Analysis Outline


Module Topics Description
Pivot Table
  • Creating Pivot Tables
  • Customizing Pivot Tables
  • Grouping Data
  • Calculated Fields & Items
  • Slicer & Timeline
 Learn how to summarize and analyze data efficiently using Pivot Tables.
Power Pivot
  • Introduction to Power Pivot
  • Creating Data Models
  • Managing Relationships
  • Advanced DAX Formulas
 Utilize Power Pivot to analyze large datasets and create complex models.
Charts
  • Creating Dynamic Charts
  • Advanced Chart Techniques
  • Combining Multiple Charts
  • Using Sparklines
 Create effective visualizations to represent data using advanced chart techniques.
Power Query
  • Introduction to Power Query
  • Connecting to Data Sources
  • Data Transformation Techniques
  • Creating and Using Queries
 Learn to automate data import and transformation using Power Query.
Data Validation
  • Setting up Data Validation Rules
  • Using Custom Formulas in Data Validation
  • Creating Drop-Down Lists
  • Error Alerts and Prompts
 Implement data entry controls using data validation techniques.
Conditional Formatting
  • Creating Custom Rules
  • Using Formulas in Conditional Formatting
  • Highlighting Duplicate and Unique Values
  • Data Bars, Color Scales, and Icon Sets
 Learn how to visually highlight data based on custom conditions.
Filter
  • Advanced Filtering Techniques
  • Using Search and Wildcards
  • Custom and Dynamic Filters
 Filter large datasets efficiently using advanced filtering methods.
XLOOKUP and VLOOKUP
  • Using VLOOKUP Function
  • Using XLOOKUP for Dynamic Searching
  • Combining Lookup Functions with IFERROR
  • Advanced Lookup Scenarios
 Master VLOOKUP and XLOOKUP for performing advanced data lookup and retrieval tasks.
Advanced Formulas
  • Array Formulas
  • INDEX and MATCH
  • SUMPRODUCT and OFFSET
  • IF, AND, OR, NOT Functions
  • TEXT, DATE, and TIME Functions
 Explore advanced formulas for performing complex data analysis.

PAKEJ BAYARAN:-

Pakej bayaran samada melalui LP/eP ATAU mengikut tuntutan surat Pekeliling Perbendaharaan Bil.9 Tahun 2002 / Malaysia WP 1.8

Bayaran pekeliling dengan kadar per jam mengikut kelayakan penceramah.
TAWARAN KESELURUHAN & CAJ BAYARAN TENAGA PENGAJAR, PEMBANGUNAN MODUL, BAHAN AMALI DAN YANG BERKAITAN DALAM KURSUS SECARA BERSEMUKA.

Kursus In-House jemputan, tempat disediakan oleh pihak penganjur/Urusetia.

Kaedah Latihan

Bersemuka, Dalam Talian (berkumpulan/individu)

Bahan Syarahan dan e-Sijil disediakan.

Emel: training@akademipowerpoint.com

Talian terus: (Kosong Satu Tujuh) 659-9572 or WhatApps


Copyright (c) 2024. MVP Training Resources . https://mvptrainingresources.com