ANDA BERADA DI HALAMAN MODUL EXCEL DATA ANALYSIS
banner
  • Analysis & Dashboard

  • Kursus In-House Jabatan Kerajaan.

  • 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

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.
Copyright (c) 2024. MVP Training Resources . https://mvptrainingresources.com