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
-