Financial Planning & Analysis Batch-11
| Responsible | Chaw Hsu Htet |
|---|---|
| Last Update | 10/09/2026 |
| Completion Time | 1 day 21 hours 46 minutes |
| Members | 21 |
-
Introduction
-
Instruction and Disclaimer
-
-
Teaching Materials
-
Dr. Hla Theingi
-
Dr.Cho Cho Wai
-
U Min Han Tun, CFA
-
-
Formatting and Productivity
-
Supportive MaterialsNew
-
Text to Columns
-
Absolute and Relative Ranges
-
Fill Series
-
Flash Fills
-
Excel Table Uses
-
Excel Filling cell down
-
Excel Filling cell down
-
Named Ranges
-
Remove Duplicates
-
Data Validation
-
Page Setup and Printing Documents
-
-
Pivot Tables
-
Supportive MaterialsNew
-
Pivot Table Introduction
-
Normalized Data Table Setup
-
Basic Pivot Table Setup
-
Slicers, Timelines, and Report Connections
-
Slicer Formatting and Dashboard Layout
-
Pivot Charts and Basic Chart Formatting
-
Pivot Options, Summarize, and Show Values
-
Pivot Design Ribbon Overview
-
Pivot Layers, Advanced Sorts and Filters
-
Conditional Formatting in Reporting
-
Sparklines in Reporting
-
Pivot Summary
-
-
Functions and Formulas
-
Supportive MaterialsNew
-
Maximum + Minimum + Average
-
Large + Small + Count + Index Part-1
-
Large + Small + Count + Index Part -2
-
Left,right & join Functions
-
Index Match Functions
-
Vlookup Function
-
Index Match Lookup Review
-
Sumif,Sumif Functions
-
Large , Small Functions
-
Combined Formulas Review
-
Combined Formulas Assignment
-
Date Functions Introduction
-
WorkDay Calculation Part -1
-
Date Dynamic Ranges Part -2
-
Datedif Function
-
WorkDay Calculation Part -2
-
Date Dynamic Range Part -1
-
-
Storytelling through Visualization
-
Supportive MaterialsNew
-
Intro Storytelling Through Visualization
-
What is Visualization
-
Preparing Effective Spreadshreet and Table Visual
-
Do and Don'ts Part - 1
-
Do and Don'ts Part - 2
-
Do and Don'ts Part - 3
-
Do and Don'ts Part - 4
-
Dos & Dont's Summary
-
Understanding Chart Types
-
Excel Chart Ribbon and Chart Components
-
Summary Storytelling Through Visualization
-
-
Building Basic Charts
-
Supportive MaterialsNew
-
Building Line Charts
-
Building Bar Charts
-
Building a Scatter Plot Part -1
-
Building a Scatter Plot Part -2
-
Building Pie Chart & Stacked Bar Chart
-
-
Building other Charts
-
Supportive MaterialsNew
-
Building a Box & Whisker Chart
-
Building a Tree Map
-
Building a Sunburst Chart
-
Building a Waterfall Chart
-
Building a Funnel Chart
-
Building a Stock Chart
-
Building a Radar Chart
-
Building a Heat Map
-
Building Area Charts and Compare Line Chart
-
Creating Save as Template for Chart Uses
-
-
Functions and Formulas
-
Nested If Case Introduction
-
If, Min, Max Formulas
-
Auditing Formulas
-
Counter Model Building to Check
-
-
Time Value of Money
-
Time Value of Money Part 1
-
Time Value of Money Part 2
-
20260827 Financial Planning & Analysis Batch-11, Instructor Dr. Cho Cho Wai
-
Time Value of Money Part 3
-
-
U Min Han Tun,CFA
-
20260917 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
-
20260813 Financial Planning & Analysis Batch-11, Instructor Dr. Cho Cho Wai
-
20261001 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
-
Time Value of Money Part 4
-
-
Dr. Cho Cho Wai
-
20260820 Financial Planning & Analysis Batch-11, Instructor Dr. Cho Cho Wai
-
20260903 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
-
20260924 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFA
-
-
Dr. Hla Theingi
-
20260809 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260816 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260823 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260830 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260906 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260913 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260920 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20260927 Financial Planning & Analysis Batch-11, Instructor Dr. Hla Theingi
-
20261004 Financial Planning & Analysis Batch-11, Instructor Dr. Hla TheingiNew
-
20261008 Financial Planning & Analysis Batch-11, Instructor U Min Han Tun, CFANew
-