Kursus In-House Jabatan Kerajaan.
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
Module | Topics | Description |
---|---|---|
Pivot Table |
|
Learn how to summarize and analyze data efficiently using Pivot Tables. |
Power Pivot |
|
Utilize Power Pivot to analyze large datasets and create complex models. |
Charts |
|
Create effective visualizations to represent data using advanced chart techniques. |
Power Query |
|
Learn to automate data import and transformation using Power Query. |
Data Validation |
|
Implement data entry controls using data validation techniques. |
Conditional Formatting |
|
Learn how to visually highlight data based on custom conditions. |
Filter |
|
Filter large datasets efficiently using advanced filtering methods. |
XLOOKUP and VLOOKUP |
|
Master VLOOKUP and XLOOKUP for performing advanced data lookup and retrieval tasks. |
Advanced Formulas |
|
Explore advanced formulas for performing complex data analysis. |