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
|