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

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

Login to Enroll
Responsible Administrator
Last Update 12/26/2022
Completion Time 1 day 5 hours 12 minutes
Members 34
  • Introduction
    • Excel Essential Intro+ Excel interface, sheet, options setup
    • Class Instruction
    • Excel Notes
    • Shortcut Key Note
  • Assignment
    • Pre-Course Assessment
    • Final Assignment
  • Support Materials
    • Work Book 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
    • 20221119 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221120 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221126 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221127 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221203 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221208 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221211 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
    • 20221217 Excel For Professionals Batch 4 AYA Sompo Min Han Tun, CFA
  • Theory Video Lesson Excel Viualization
    • 1 Excel Story Introduction
    • 2 Data Visualization
    • 3 Dos and Don't of Charts
    • 4 Excel Formatting Ribbons
    • 5 Chart Types Part 1
    • 6 Chart Types Part 2
    • 7 Chart Types Part 3
    • Line Charts
    • Bar Chart
    • Pie Chart & Stacked Bar
    • Scatter Part-1
    • Scatter Part-2
    • Pareto Part 1
    • Pareto Part 2
    • Box & Whisker
    • Tree Maps
    • Sunburst
    • Waterfall
    • Funnel Chart
    • Stock Chart
    • Radar Chart
    • Heat Map
    • Charts and Graphs Part-1
    • Charts and Graphs Part-2
    • Charts and Graphs Part 3
    • Target Vs Actual Part 1
    • Target Vs Actual Part 2
    • Breakeven Part 1
    • Breakeven Part 2
    • Dropdown Part 1
    • Dropdown Part 2
    • Gauge Chart Part 1
    • Gauge Chart Part 2
    • Gauge Chart Part 3
    • Gauge Chart Part 4
    • Gauge Chart Part 5
    • Bullet Chart
    • Highlight Ranges
    • 1 How to Use Page Setup for Printing Purposes
    • 2 How to Use Format as Table