by Belajarlagi

Day 1: Opening MBSM & Basic Data Operation

• Introduction to Spreadsheet
• Getting to Know the Data
• Data Cleansing
• Ensuring Data Integrity
• Relative & Absolute References
• Basic Formulas
• Date Formulas
• Text Formulas

Day 2: Case Study 1 Recap & Deep Dive: Advanced Data Operation

• Relative & Absolute References (recap)
• Lookup Formulas: VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP
• Logical Functions: IF & Nested IF
• Conditional Aggregation Functions: COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
• Excel Hidden Features: Data Validation, Conditional Formatting, What-If Analysis
• Case Study

Day 3: Case Study 2 Recap & Basic Dashboard in Excel

• Introduction to Data Visualization
• Intoduction to Pivot Table
• Introduction to Pivot Chart and Slicer
• Choose your data for your final project

Day 4: Create your Interactive Dashboard with Excel

• Combining OFFSET, ROW, COLUMN, and INDIRECT Functions
• Basic Dashboard Creation

Day 5: Ms Excel Advance Feature

• Introduction to Power Query
• Introduction to Power Pivot

Day 6: Final Project Assistance

Day 7: Graduation & Final Showcase

• Dashboard Showcase from student
• Certificate handover & Awards