Channel Avatar

YIFM, Myanmar @UC8A9nL2_q0b8ludfDnPD4jg@youtube.com

623 subscribers - no pronouns :c

šŸ™†ā€ā™€ļø Mingalapar! Welcome to YIFM. YIFM is the go-to place


11:42
English į€…į€€į€¬į€øį€™į€¼į€”į€ŗį€™į€¼į€”į€ŗį€į€­į€Æį€øį€į€€į€ŗį€œį€­į€Æį€•į€«į€€ į€¤į€”į€Šį€ŗį€øį€œį€™į€ŗį€øį€–į€¼į€„į€·į€ŗ į€•į€Æį€¶į€™į€¾į€”į€ŗ į€œį€±į€·į€€į€»į€„į€·į€ŗį€•į€« -- į€”į€•į€­į€Æį€„į€ŗį€ø (įƒ)
04:52
Income Statement į€€į€­į€Æ Chart į€”į€”į€±į€–į€¼į€„į€·į€ŗ į€˜į€šį€ŗį€œį€­į€Æį€•į€¼į€™į€œį€²? Waterfall Chart į€€į€­į€Æ į€™į€­į€į€ŗį€†į€€į€ŗį€į€¼į€„į€ŗį€øį‹
19:38
2D/3D lookup į€†į€­į€Æį€į€¬į€˜į€¬į€œį€²? Vlookup į€”į€¾į€„į€·į€ŗ index/match į€€į€­į€Æ į€€į€»į€½į€™į€ŗį€øį€€į€»į€„į€ŗį€žį€°į€™į€»į€¬į€øį€”į€į€½į€€į€ŗ į€”į€±į€¬į€€į€ŗį€‘į€•į€ŗ lookup į€•į€«į‹
11:10
English į€…į€€į€¬į€øį€™į€¼į€”į€ŗį€™į€¼į€”į€ŗį€į€­į€Æį€øį€į€€į€ŗį€œį€­į€Æį€•į€«į€€ į€¤į€”į€Šį€ŗį€øį€œį€™į€ŗį€øį€–į€¼į€„į€·į€ŗ į€•į€Æį€¶į€™į€¾į€”į€ŗ į€œį€±į€·į€€į€»į€„į€·į€ŗį€•į€« -- į€”į€•į€­į€Æį€„į€ŗį€ø (į‚)
13:28
English į€…į€€į€¬į€øį€™į€¼į€”į€ŗį€™į€¼į€”į€ŗį€į€­į€Æį€øį€į€€į€ŗį€œį€­į€Æį€•į€«į€€ į€¤į€”į€Šį€ŗį€øį€œį€™į€ŗį€øį€–į€¼į€„į€·į€ŗ į€•į€Æį€¶į€™į€¾į€”į€ŗ į€œį€±į€·į€€į€»į€„į€·į€ŗį€•į€«įŠ į€žį€­į€žį€­į€žį€¬į€žį€¬ į€į€­į€Æį€øį€į€€į€ŗį€œį€¬į€•į€«į€œį€­į€™į€·į€ŗį€™į€šį€ŗį‹
17:11
Sparkline Chart į€žį€Æį€¶į€øį€•į€¼į€®į€ø ā€Œį€’į€±į€į€¬į€į€½į€±į€€į€­į€Æ dynamically visualize į€œį€Æį€•į€ŗį€€į€¼į€™į€šį€ŗ
18:51
Address į‚į€½į€„į€·į€¹ Indirect functions į€±į€į€¼į€€į€­į€Æ į€˜į€šį€¹į€œį€Æį€­į€žį€Æį€¶į€øį€›į€œį€²?
05:45
šŸ§­ Vlookup į€žį€Æį€¶į€øį€™į€›į€į€²į€· į€€į€­į€…į„į€›į€•į€¹: į€‘į€•į€¹į€±į€” į€±į€žį€¬ duplicate data į€€į€­į€Æ dget function į€žį€Æį€¶į€øį lookup į€»į€•į€³į€œį€Æį€•į€¹į€»į€į€„į€¹į€øį‹
21:51
Array į€†į€­į€Æį€į€¬į€˜į€¬į€œį€²? Excel į€į€¼į€„į€¹ Array į€»į€–į€„į€·į€¹į€į€¼į€€į€¹į€į€ŗį€€į€¹į€»į€į€„į€¹į€øį‹
06:08
šŸ“ˆ Radar chart į€™į€­į€į€¹į€†į€€į€¹ - į€˜į€šį€¹į€”į€į€ŗį€­į€”į€¹ radar chart į€€į€­į€Æį€žį€Æį€¶į€øį€žį€„į€·į€¹į€žį€œį€²?
17:29
į€¹āœØ Choose function į€€į€­į€Æ į€˜į€šį€¹į€œį€Æį€­į€žį€Æį€¶į€øį€œį€²? į€”į€›į€™į€¹į€øį€œį€¼į€šį€¹į€į€²į€· Choose function į€›į€²į‚• į€•į€«į€į€« į€€į€­į€Æį¾į€€į€Šį€·į€¹į¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
10:02
ā„ PowerQuery į€™į€­į€į€¹į€†į€€į€¹ - Website į€™į€½ į€±į€’į€į€¬į€€į€­į€Æ Excel į€žį€­į€Æį‚•į€į€„į€¹į€•į€­į€Æį‚•į€»į€į€„į€¹į€ø
07:54
šŸ“‰ Y-į€į€„į€¹į€›į€Æį€­į€ø (į‚) į€į€Æį€»į€–į€„į€·į€¹ Chart į€į€Šį€¹į€±į€†į€¬į€€į€¹į€»į€į€„į€¹į€øį‹ Combination chart į€˜į€šį€¹į€œį€Æį€­į€†į€¼į€²į€œį€² į¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
20:10
šŸ’„ Offset function į€žį€Æį€¶į€øį€»į€•į€®į€ø Excel į€į€¼į€„į€¹ dynamic calculations į€™į€ŗį€¬į€øį€»į€•į€³į€œį€Æį€•į€¹į€»į€į€„į€¹į€ø
06:46
šŸ„§ Pie Chart į€”į€±į¾į€€į€¬į€„į€¹į€øį€žį€­į€‘į€¬į€øį€žį€„į€·į€¹į€žį€Šį€·į€¹ į€”į€į€ŗį€€į€¹į€™į€ŗį€¬į€ø
17:14
šŸ§® Pivot Table į€į€¼į€„į€¹į€į€¼į€€į€¹į€į€ŗį€€į€¹į€™į‚ˆį€™į€ŗį€¬į€øį€»į€•į€³į€œį€Æį€•į€¹į€»į€į€„į€¹į€ø į€”į€•į€Æį€­į€„į€¹į€ø (į‚) - Calculated Fields & Calculated Items
16:57
šŸ“ Data validation į€œį€Æį€•į€¹į€»į€•į€®į€ø data rule į€†į€¼į€²į¾į€€į€™į€šį€¹į‹ Worksheet į€™į€½į€¬ data į€į€­į€Æį€„į€¹į€øį€œį€€į€¹į€™į€į€¶į€•į€«į‚į€½į€„į€·į€¹į‹
23:47
šŸ¤” Pivot Table į€į€¼į€„į€¹į€į€¼į€€į€¹į€į€ŗį€€į€¹į€™į‚ˆį€™į€ŗį€¬į€øį€»į€•į€³į€œį€Æį€•į€¹į€»į€į€„į€¹į€ø į€”į€•į€­į€Æį€„į€¹į€ø (į) - Pivot Data Summary, Values & Subtotal
18:12
ā›… Data į€€į€­į€Æį€”į€¬į€™į€Šį€¹į€±į€•į€øį€»į€•į€®į€øį€į€¼į€€į€¹į€į€ŗį€€į€¹į€»į€į€„į€¹į€øį‹ Naming į€œį€Æį€•į€¹į€»į€į€„į€¹į€øį€›į€²į‚• į€”į€€į€ŗį€­į€³į€øį€±į€€į€ŗį€øį€‡į€°į€øį€±į€į€¼į€€į€­į€Æį¾į€€į€Šį€·į€¹į€›į€±į€”į€¬į€„į€¹į€•į€«į‹
16:31
šŸ¦ į€˜į€į€¹į€±į€į€¼ į€˜į€šį€¹į€œį€Æį€­į€•į€Æį€­į€€į€¹į€†į€¶į€›į€½į€¬į€žį€œį€²? JPMorgan Chase į€˜į€į€¹ į€›į€²į‚• income statement į€€į€­į€Æį€–į€į€¹į¾į€€į€Šį€·į€¹į€›į€±į€”į€¬į€„į€¹į€•į€«į‹
20:58
šŸ’„ PowerPivot į€™į€­į€į€¹į€†į€€į€¹: Connecting tables in Data Model for summarizing in pivot table
10:23
šŸŽÆ Presentation į€”į€į€¼į€€į€¹ Pivot table į¾į€€į€®į€øį€į€…į€¹į€į€Æį€œį€Æį€¶į€øį€€į€Æį€­į€™į€»į€•į€•į€«į‚į€½į€„į€·į€¹į‹ Slicer į‚į€½į€„į€·į€¹ Timeline į€€į€Æį€­į€žį€Æį€¶į€øį€•į€«į‹
10:22
šŸ’¢ Excel Table į€†į€Æį€­į€į€¬į€˜į€¬į€œį€²? į€˜į€šį€¹į€”į€į€ŗį€­į€”į€¹į€™į€½į€¬ į€žį€Æį€¶į€øį€žį€„į€·į€¹į€žį€œį€²? Excel Table į€±į€€į€¬į€„į€¹į€øį€€į€¼į€€į€¹ į€±į€œį€øį€±į€į€¼į€€į€Æį€­ į¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
23:22
āš” index/match functions į€±į€•į€«į€„į€¹į€øį€žį€Æį€¶į€øį€»į€•į€®į€ø į€˜į€šį€¹į€œį€­į€Æ lookup į€œį€Æį€•į€¹į€œį€²? vlookup/hlookup į‚į€½į€„į€·į€¹į€šį€½į€„į€¹į¾į€€į€Šį€·į€¹ į¾į€€į€™į€šį€¹į‹
12:45
āœ‚ Text to column į€žį€Æį€¶į€øį€»į€•į€®į€ø į€œį€Æį€­į€į€ŗį€„į€¹į€į€²į€· text data į€”į€»į€–į€…į€¹į€žį€Æį€­į‚• į€•į€Æį€­į€„į€¹į€øį€»į€–į€į€¹į¾į€€į€™į€šį€¹į‹
19:45
šŸ’± Financial Analyst į€į€Æį€­į€„į€¹į€øį€žį€­į€žį€„į€·į€¹į€žį€Šį€·į€¹ % Change Analysis į€»į€–į€„į€·į€¹ į€•į€‘į€™į€”į€†į€„į€·į€¹ Financial Analysis į€œį€Æį€•į€¹į€»į€į€„į€¹į€øį‹
27:34
šŸ“‹ Clipboard & Fill į€€į€Æį€­ į€žį€Æį€¶į€øį€»į€•į€®į€ø data į€±į€į€¼į€€į€­į€Æį€»į€™į€”į€¹į€»į€™į€”į€¹į€†į€”į€¹į€†į€”į€¹ į€»į€–į€Šį€·į€¹į€™į€šį€¹
19:22
šŸŒž į€” į€±į€»į€į€į€¶ Pivot Table į€į€Šį€¹į€±į€†į€¬į€€į€¹į€»į€į€„į€¹į€øį‹ Presentation/Analysis į€”į€į€¼į€€į€¹ data į€±į€į€¼ summarize į€œį€Æį€•į€¹į¾į€€į€™į€šį€¹į‹
09:52
šŸ’¬ Excel į€™į€½į€¬ Picture į€žį€Æį€¶į€øį€»į€•į€®į€ø comment į€˜į€šį€¹į€œį€Æį€­į€±į€•į€øį€›į€™į€œį€²? Picture comment į€±į€•į€øį€»į€•į€®į€ø digital backup į€‘į€¬į€øį€»į€į€„į€¹į€ø
10:30
šŸ’¹ Stacked Area Chart į€†į€­į€Æį€į€¬į€˜į€¬į€œį€²? į€˜į€šį€¹į€”į€į€ŗį€­į€”į€¹į€™į€½į€¬ į€žį€Æį€¶į€øį€žį€œį€²? Stacked Area Chart į‚ į€™į€ŗį€­į€³į€øį€€į€­į€Æį¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
15:48
šŸŒŸ ACCA financial management preparation ā€“ ROA į€†į€­į€Æį€į€¬į€˜į€¬į€œį€²? ROE į‚į€½į€„į€·į€¹ ROA į€€į€˜į€šį€¹į€œį€Æį€­į€€į€¼į€¬į€œį€²?
20:11
šŸ’° Financial Analyst į€į€Æį€­į€„į€¹į€øį€žį€­į€žį€„į€·į€¹į€žį€Šį€·į€¹ Common-size Analysis į€»į€–į€„į€·į€¹ į€•į€‘į€™į€”į€†į€„į€·į€¹ Analysis į€»į€•į€³į€œį€Æį€•į€¹į€»į€į€„į€¹į€ø
13:01
āœØ Data į€±į€į€¼į€€į€­į€Æ į€»į€™į€”į€¹į€»į€™į€”į€¹į¾į€€į€Šį€·į€¹į€»į€į€„į€¹į€ø - vlookup & hlookup į€€į€Æį€­ į€˜į€šį€¹į€œį€Æį€­į€žį€Æį€¶į€øį€›į€œį€²?
19:23
šŸ’” ACCA financial management preparation- ROE į€€ į€˜į€¬į€”į€“į€­į€•įøį€¬į€šį€¹į€œį€²? į€˜į€šį€¹į€œį€­į€Æį€į€¼į€€į€¹į€œį€²?
10:20
šŸ§® Count family (count, countif, etc) į€™į€½į€¬į€•į€«į€į€²į€· functions į€±į€į€¼ į€žį€Æį€¶į€øį€»į€•į€®į€ø data į€±į€į€¼į€€į€­į€Æ count į€œį€Æį€•į€¹į€»į€į€„į€¹į€øį‹
13:58
šŸ’» sumif/sumifs function į€€į€­į€Æį€˜į€šį€¹į€œį€­į€Æį€žį€Æį€¶į€øį€›į€œį€²? į€„į€•į€™į€¬ (į…) į€į€Æį€±į€œį€¬į€€į€¹į¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
13:07
šŸŒµ if function į€€į€­į€Æ į€˜į€šį€¹į€œį€­į€Æį€žį€Æį€¶į€øį€›į€œį€²? į€„į€•į€™į€¬ (į„) į€™į€ŗį€­į€³į€øį¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
25:20
šŸ”— Excel į€™į€žį€­į€™į€»į€–į€…į€¹ Functions, Cell Reference & Linkage į€”į€žį€Æį€¶į€øį€»į€•į€³į€•į€Æį€¶
20:20
šŸ¤øā€ā™‚ļø Navigation & Selection Shortcuts, Sort and Filter į€€į€­į€Æį€˜į€šį€¹į€œį€Æį€­į€žį€Æį€¶į€øį€›į€œį€²?
16:48
šŸ–Œ Conditional Formatting į‚į€½į€„į€·į€¹ Heat Map į€€į€­į€Æ į€žį€Æį€¶į€øį€»į€•į€®į€ø data į€±į€į€¼į€€į€Æį€­ visualize į€œį€Æį€•į€¹į€»į€į€„į€¹į€øį‹
17:04
šŸ’ø Term Loan (fixed rate) į€›į€²į‚• Amortization Schedule į€˜į€šį€¹į€œį€Æį€­į€†į€¼į€² į€œį€² į¾į€€į€Šį€·į€¹į€› į€±į€”į€¬į€„į€¹į€•į€«į‹
10:50
šŸŽØ Microsoft Excel į€į€¼į€„į€¹ į€” į€±į€»į€į€į€¶ į€į€¼į€€į€¹į€į€ŗį€€į€¹į€»į€į€„į€¹į€øįŠ format į€į€ŗį€»į€į€„į€¹į€ø į€™į€ŗį€¬į€øį€»į€•į€³į€œį€Æį€•į€¹į€»į€į€„į€¹į€ø