Responsible Chaw Hsu Htet
Last Update 03/03/2026
Completion Time 2 days 13 hours 50 minutes
Members 59
  • Introduction
    • Instruction and Disclaimer
  • Teaching Materials
    • Tr.Cho Cho Wai
  • Support Materials of U Wai Lin Tun
    • Assignment
    • Teaching
  • Excel Intro
    • Excel Essential Intro+ Excel interface, sheet, options setup
  • Power Pivot
    • Power Pivot Workbooks
  • Excel Shortcuts
    • Excel Shortcut Part-1
    • Excel Shortcut Part-2
    • Group and Shortcut Part-1
    • Group and Shortcut Part-2
    • Text to columns
    • One Variable Data Table
    • Two Variable Data Table
  • What if Analysis
    • Data Table Case with Conditional Formatting
    • Data Table Case
    • Goal Seek Function
  • Data Visualization and Charts Beat Practices
    • Data Visualization
    • Dos and Don't of Charts
    • Excel Formatting Ribbons
  • Chart Types
    • Chart Types Part 1
    • Chart Types Part 2
    • Chart Types Part 3
  • Case Study 1: Stacked Columns Targets
    • Target Vs Actual Part 1
    • Target Vs Actual Part 2
  • Case study 2: Pareto Analysis
    • Pareto Part 1
    • Pareto Part 2
  • Case Study 3: Dropdown Boxes and Charts
    • Dropdown Part 1
    • Dropdown Part 2
    • Waterfall
    • Funnel Chart
    • Heat Map
  • Case Study 4: Guge Charts
    • Gauge Chart Part 1
    • Gauge Chart Part 2
    • Gauge Chart Part 3
    • Gauge Chart Part 4
    • Gauge Chart Part 5
  • Case Study 5: Bullent Charts
    • Bullet Chart
  • Formatting
    • Introduction + Formatting Part-1
    • Formatting Part-2
    • Remove Duplicate Function
  • Pivot Tables
    • Pivot Table Part-1
    • Pivot Table Part-2
    • Pivot Ribbon
    • Pivot Chart
    • Slicer Timeline
  • Conditional Formatting
    • Conditional Formatting
    • Spark-line
  • Power Pivot
    • Power Pivot Introduction
    • Power Pivot Setup
    • Building a Regular Pivot Table
    • Building a Basic Data Model Power Pivot
    • Calculating Basic Measures in Power Pivot
    • Power Pivot Analysis for Basic Data Model
    • Power Pivot Case Study Introduction
    • Adding Data to Data Model
    • Creating Relationships in Tables
    • Basic Measures Units, MarginAmt, SumX
    • Date Time Dimesion and Sorting
    • Adding PDF File to Data Model
    • Pivot Slicer and Timeline Connections
    • DAX Daily Sales Propotion of Selected Periods
    • DAX Sales Performance Same Period Last Year
    • DAX Margin Performance Same Period Last Year
    • DAX Contribution to Total Sales
    • DAX Promotion Value to Total Sales
    • DAX SalesDay, YTD Calculation
    • Creating and Editing KPIs in Power Pivot
    • Power Pivot Case Study Summary
  • Zoom Video Record
    • 20251102 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20251105 Professional Diploma In Data Analyst Batch- 8 , Instructor Tr Cho Cho Wai
    • 20251109 Professional Diploma In Data Analyst Batch- 8 , Instructor: U Wai Lin Htun
    • 20251112 Professional Diploma In Data Analyst Batch- 8 , Instructor Tr Cho Cho Wai
    • 20251116 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20251119 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20251123 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20251126 Professional Diploma In Data Analyst Batch- 8 , Instructor Tr Cho Cho Wai
    • 20251130 Professional Diploma In Data Analyst Batch- 8 , Instructor U Min Han Tun ,CFA
    • 20251203 Professional Diploma In Data Analyst Batch- 8 , Instructor Tr Cho Cho Wai
    • 20251207 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20251214 Professional Diploma In Data Analyst Batch- 8 , Instructor U Min Han Tun, CFA
    • 20251217 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20251221 Professional Diploma In Data Analyst Batch- 8 , Instructor U Min Han Tun, CFA
    • 20251224 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260107 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260111 Professional Diploma In Data Analyst Batch- 8 , Instructor U Min Han Tun, CFA
    • 20260114 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260118 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260121 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260125 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260128 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260201 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260204 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260208 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260211 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260222 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
    • 20260301 Professional Diploma In Data Analyst Batch- 8 , Instructor U Wai Lin Htun
      New