Excel For Professionals: PSI Myanmar

Responsible	U Min Han Tun
Last Update	09/20/2023
Completion Time	21 hours 16 minutes
Members	15

Corporate Training

Instruction
- Introduction & Disclaimer
- Excel Essential Intro+ Excel interface, sheet, options setup
- Excel Notes
Suport Materials
- Short Cut Key
- Exercise & Complete File
- Materials
Assignment
- Pre Course Assessment
- Final Assessment
Formatting & Productivity
- 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 Tables
- Pivot Table Part-1
- Pivot Table Part-2
- Pivot Ribbon
- Pivot Chart
- Slicer Timeline
- Conditional Formatting
- Spark-line
- How to Use Format as Table
- How to Use Page Setup for Printing Purposes
Using Date Functions
- Introduction + Date
- Workday Part-1
- Workday Part-2
Coffee Shop Setup (Functions - vlookup, index, match, sumif, sumifs)
- Left & Right
- Index Match
- Vlookup
- Index+Vlookup+Format
- Sumif+Sumifs+Condition
- Large + small + index + condition
Visualization and Story Telling
- Excel Story Introduction
- Data Visualization
- Dos and Don't of Charts
- Excel Formatting Ribbons
Basic Chart Types
- Chart Types Part 1
- Chart Types Part 2
- 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
Advanced Charts (Combo)
- 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
Advanced Charts (Gauge Charts)
- Gauge Chart Part 1
- Gauge Chart Part 2
- Gauge Chart Part 3
- Gauge Chart Part 4
- Gauge Chart Part 5
- Highlight Ranges
- Bullet Chart
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
- 20230803 Excel For Professionals PSI Myanmar Training Instructor U Min Han Tun, CFA
- 20230810 Excel For Professionals PSI Myanmar Training Instructor U Min Han Tun, CFA
- 20230905 Excel For Professionals PSI Myanmar Training Instructor U Min Han Tun, CFA
- 20230908 Excel For Professionals PSI Myanmar Training Instructor U Min Han Tun CFA