Responsible Chaw Hsu Htet
Last Update 10/09/2026
Completion Time 1 day 21 hours 46 minutes
Members 21
  • Introduction
    • Instruction and Disclaimer
  • Teaching Materials
    • Dr. Hla Theingi
    • Dr.Cho Cho Wai
    • U Min Han Tun, CFA
  • Formatting and Productivity
    • Supportive Materials
      New
    • Text to Columns
    • Absolute and Relative Ranges
    • Fill Series
    • Flash Fills
    • Excel Table Uses
    • Excel Filling cell down
    • Excel Filling cell down
    • Named Ranges
    • Remove Duplicates
    • Data Validation
    • Page Setup and Printing Documents
  • Pivot Tables
    • Supportive Materials
      New
    • Pivot Table Introduction
    • Normalized Data Table Setup
    • Basic Pivot Table Setup
    • Slicers, Timelines, and Report Connections
    • Slicer Formatting and Dashboard Layout
    • Pivot Charts and Basic Chart Formatting
    • Pivot Options, Summarize, and Show Values
    • Pivot Design Ribbon Overview
    • Pivot Layers, Advanced Sorts and Filters
    • Conditional Formatting in Reporting
    • Sparklines in Reporting
    • Pivot Summary
  • Functions and Formulas
    • Supportive Materials
      New
    • Maximum + Minimum + Average
    • Large + Small + Count + Index Part-1
    • Large + Small + Count + Index Part -2
    • Left,right & join Functions
    • Index Match Functions
    • Vlookup Function
    • Index Match Lookup Review
    • Sumif,Sumif Functions
    • Large , Small Functions
    • Combined Formulas Review
    • Combined Formulas Assignment
    • Date Functions Introduction
    • WorkDay Calculation Part -1
    • Date Dynamic Ranges Part -2
    • Datedif Function
    • WorkDay Calculation Part -2
    • Date Dynamic Range Part -1
  • Storytelling through Visualization
    • Supportive Materials
      New
    • Intro Storytelling Through Visualization
    • What is Visualization
    • Preparing Effective Spreadshreet and Table Visual
    • Do and Don'ts Part - 1
    • Do and Don'ts Part - 2
    • Do and Don'ts Part - 3
    • Do and Don'ts Part - 4
    • Dos & Dont's Summary
    • Understanding Chart Types
    • Excel Chart Ribbon and Chart Components
    • Summary Storytelling Through Visualization
  • Building Basic Charts
    • Supportive Materials
      New
    • Building Line Charts
    • Building Bar Charts
    • Building a Scatter Plot Part -1
    • Building a Scatter Plot Part -2
    • Building Pie Chart & Stacked Bar Chart
  • Building other Charts
    • Supportive Materials
      New
    • Building a Box & Whisker Chart
    • Building a Tree Map
    • Building a Sunburst Chart
    • Building a Waterfall Chart
    • Building a Funnel Chart
    • Building a Stock Chart
    • Building a Radar Chart
    • Building a Heat Map
    • Building Area Charts and Compare Line Chart
    • Creating Save as Template for Chart Uses
  • Functions and Formulas
    • Nested If Case Introduction
    • If, Min, Max Formulas
    • Auditing Formulas
    • Counter Model Building to Check
  • Time Value of Money
    • Time Value of Money Part 1
    • Time Value of Money Part 2
    • 20260827 Financial Planning & Analysis Batch-11, Instructor Dr. Cho Cho Wai
    • Time Value of Money Part 3
  • U Min Han Tun,CFA
    • 20260917 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
    • 20260813 Financial Planning & Analysis Batch-11, Instructor Dr. Cho Cho Wai
    • 20261001 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
    • Time Value of Money Part 4
  • Dr. Cho Cho Wai
    • 20260820 Financial Planning & Analysis Batch-11, Instructor Dr. Cho Cho Wai
    • 20260903 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
    • 20260924 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
  • Dr. Hla Theingi
    • 20260809 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260816 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260823 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260830 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260906 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260913 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260920 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20260927 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
    • 20261004 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
      New
    • 20261008 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
      New