Home └Corporate Training For AYA Sompo B-5 : Excel For Professionals

Corporate Training For AYA Sompo B-5 : Excel For Professionals

Login to Enroll
Responsible U Min Han Tun
Last Update 05/23/2023
Completion Time 19 hours 1 minute
Members 32
  • Introduction
    • Excel Essential Intro+ Excel interface, sheet, options setup
    • Class Instruction
    • Excel Notes
    • Shortcut Key Note
  • Assignment
    • Pre-Course Assessment
    • Final Assignment
  • Support Materials
    • Workbook 1 To 5
  • Theory Video
    • Excel Shortcut Part-1
    • Excel Shortcut Part-2
    • Group and Shortcut Part-1
    • Group and Shortcut Part-2
    • Text to columns
    • Excel Exercise
    • Introduction + Formatting Part-1
    • Formatting Part-2
    • Remove Duplicate Function
    • Data Validation
    • Pivot Table Part-1
    • Pivot Table Part-2
    • Pivot Ribbon
    • Pivot Chart
    • Slicer Timeline
    • Conditional Formatting
    • Spark-line
    • Introduction + Date
    • Workday Part-1
    • Workday Part-2
    • Left & Right
    • Index Match
    • Vlookup
    • Index+Vlookup+Format
    • Sumif+Sumifs+Condition
    • Large + small + index + condition
  • Video Record
    • 20221218 Excel For Professionals Batch 5 AYA Sompo Min Han Tun, CFA
    • 20230108 Excel For Professionals Batch 5 AYA Sompo Min Han Tun, CFA 1
    • 20230107 Excel For Professionals Batch 5 AYA Sompo Min Han Tun, CFA
    • 20230114 Excel For Professionals Batch 5 AYA Sompo Min Han Tun, CFA
    • 20230122 Excel For Professionals Batch 5 AYA Sompo Min Han Tun, CFA
    • 20230129 Excel For Professionals Batch 5 AYA Sompo Min Han Tun, CFA
    • 20230204 Excel For Professionals Batch 5 AYA Sompo Min Tun Han,CFA