Responsible Administrator
Last Update 12/26/2023
Completion Time 1 day 1 hour 1 minute
Members 32
Basic, Intermediate
  • Instruction
    • Disclaimer and Ruel & Regulation
  • Exam Test
    • Pre-Assessment
    • Post Assessment
  • Support Materials
    • Short Cut Key Note
  • Week 1
    • Workbook3_Charts (exercise)EE
    • Workbook3_Charts (complete)EE
    • Workbook2_Sales (exercise)
    • Workbook1_DD (exercise)
    • Workbook1_DD (complete)
    • Workbook2_Functions&Formulas (exercise)
    • Workbook2_Functions&Formulas (complete)
  • Week 2
    • Workbook6_Personal Finance (exercise)
    • Workbook5_Functions
    • Workbook2_Sales (complete)EE
    • Workbook4_Dates (exercise)EE
    • Workbook4_Dates (complete)EE
  • Productivity
    • Excel Essential Intro+ Excel interface, sheet, options setup
    • Excel Shortcut Part-1
    • Excel Shortcut Part-2
    • Group and Shortcut Part-1
    • Group and Shortcut Part-2
    • Text to columns
    • Excel Exercise
  • Formatting
    • Introduction + Formatting Part-1
    • Formatting Part-2
    • Remove Duplicate Function
    • Data Validation
  • Pivot Table
    • Pivot Table Part-1
    • Pivot Table Part-2
    • Pivot Ribbon
    • Pivot Chart
    • Slicer Timeline
  • Conditional Formatting
    • Conditional Formatting
    • Spark-line
  • Functions and Formulas
    • Functions & Formulas Intro
    • Absolute & Relation Reference
  • Date Functions
    • Introduction + Date
    • Workday Part-1
    • Workday Part-2
    • Left & Right
  • Index, Match
    • Index Match
  • Vlookup
    • Vlookup
    • Index+Vlookup+Format
  • sumif + sumifs
    • Sumif+Sumifs+Condition
    • Large + small + index + condition
    • Maximum + Minimum + Average
    • Large + Small + Count + Index Part-1
    • Large + Small + Count + Index Part-2
    • Dynamic Range
  • Powerpoint
    • 1 Excel Essential Powerpoint Introduction
    • 2 Excel Essential Pitching Intro
    • 3 Excel Essential Powerpoint Layout Overview
    • 4 Excel Essential Guidelines, Slide Master, Section Divider
  • Data Visualization and Charts Best Practices Week 1
    • Download Workbook Files
    • 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
  • Basic Chart Making
    • Line Charts
    • Bar Chart
    • Pie Chart & Stacked Bar
    • Scatter Part-1
    • Scatter Part-2
    • Pareto Part 1
    • Pareto Part 2
  • Advanced Charts Week 2
    • Download Workbook Files
    • Box & Whisker
    • Tree Maps
    • Sunburst
    • Waterfall
    • Funnel Chart
    • Stock Chart
    • Radar Chart
    • Heat Map
  • Case Study 1: Finance Charts and Graphs
    • Charts and Graphs Part-1
    • Charts and Graphs Part-2
    • Charts and Graphs Part 3
  • Case Study 2: Stacked Columns Targets
    • Download Workbook Files
    • Target Vs Actual Part 1
    • Target Vs Actual Part 2
    • Finance For Non Finance Valuation 4
    • Finance for Non Finance valuation 5
    • Finance for Non Finance valuation 6
    • Finance for Non Finance valuation 7
    • Finance for Non Finance valuation 8
    • Finance for Non Finance valuation 9
  • Case Study 3: Breakeven (Line & Scatter)
    • Breakeven Part 1
    • Breakeven Part 2
  • Case Study 4: Dropdown Boxes and Charts
    • Dropdown Part 1
    • Dropdown Part 2
  • Case Study 5: Gauge Charts
    • Gauge Chart Part 1
    • Gauge Chart Part 2
    • Gauge Chart Part 3
    • Gauge Chart Part 4
    • Gauge Chart Part 5
  • Bullet Charts
    • Bullet Chart
    • Highlight Ranges
  • Word
    • Microsoft Word Intro
    • Adding Table of Contents
    • Adding Table of Figures
    • Adding Captions to Figures and Tables
    • Applying Headings to the Document
    • Choosing Navigation Pane
    • Cross Referencing Documents
    • Editing the Heading Styles
    • Inserting Footnotes to the Documents
    • Numbering the Document Headings
  • Video Record
    • 20230823 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20230830 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20230906 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20230913 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20230920 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20230927 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20231004 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
    • 20231011 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA