In-House Training

Unlock the Full Potential of Your Data: Become an Excel Data Analyst with Akademi PowerPoint Malaysia. (MVP Training Resources)

Advanced Power Pivot Data Analysis & Visualization
Day 1: Introduction to Power Pivot and Data Modeling Working with Data: Importing & DAX formulas Analyzing Data: PivotTables, Charts, Slicers Advanced Techniques: Power Query, KPIs, DAX
Day 2: Advanced Data Modeling & Many-to-Many Relationships Creating Interactive Reports and Dashboards Using Power BI for Visual Analytics Final Project & Q&A
Advanced Pivot Table, Power Query & Dashboard Reporting
Day 1: Mastering PivotTables & Advanced Data Sorting Power Query: Data Cleaning & Transformation Combining Multiple Data Sources
Day 2: Creating Interactive Dashboards Advanced Visualization & Charting Techniques Final Project & Real-World Applications
Basic to Intermediate Microsoft Excel 365
Day 1: Excel Basics: Interface, Formatting, AutoFill Using Formulas: SUM, AVERAGE, IF, VLOOKUP Data Analysis: Sorting, Filtering, PivotTables
Day 2: Advanced Excel Techniques: Conditional Formatting Data Validation, Scenario Manager, Solver Final Project & Hands-On Training
Intermediate Microsoft Excel 365
Day 1: Advanced Formulas & Data Validation Working with Large Data Sets Advanced Charting & Data Tables
Day 2: PivotTables & PivotCharts Mastery Macros & VBA for Automation Final Project & Certificate of Completion