ခုလို နည်းပညာခေတ်ကြီးမှာ သင့်အနေနဲ့ Excel ကို တစ်ဘက်ကမ်းခတ် တတ်ထားတာဟာ သင့်အတွက် အားသာချက်တစ်ခုဖြစ်လာမှာပါ။ ဘယ်နေရာကိုရောက်ရောက် Excel ဟာ အလွန့်အလွန်ကို အသုံး ဝင်လှပါတယ်။ ကဲ သင့်အနေနဲ့ Excel ကို ပရော်ဖက်ရှင်နယ်ဆန်ဆန် တတ်မြောက်နိုင်စေဖို့အတွက် Advanced Excel အကြောင်းလေ့လာနိုင်တဲ့ ဗီဒီယိုလေး တွေ မျှဝေပေးပါ့မယ် ။
ဒါဆို Advanced Excels အကြောင်းပိုသိချင်ရင်တော့ အောက် က Link တွေထဲ ဝင်ကြည့်ပေးနော် ။
1) Chapter (1.1) https://bit.ly/2Ub3vpT
2) Chapter (1.2) https://bit.ly/3pfLANa
3) Chapter (2.1) https://bit.ly/3kfWjDx
4) Chapter (2.2) https://bit.ly/2GLvEAR
5) Chapter (2.3) https://bit.ly/3kagRgE
6) Chapter (2.4 - Conditional Formatting) https://bit.ly/35cWFGO
7) Chapter (3.1) https://bit.ly/3lh0ssc
8) Chapter (3.2 - Simple Array) https://bit.ly/3lhzVeb
9) Chapter (3.3) https://bit.ly/3lhJ46H
10) Chapter (3.4 - IF Function) https://bit.ly/3n8Ci3x
11) Chapter (3.5) - Logical Function) https://bit.ly/38w71U6
12) Chapter (3.5 - Count Function) https://bit.ly/3pe4vYF
13) Chapter (3.6 - Tax Payable Calculation) https://bit.ly/36l0IA7
14) Chapter (3.7 - Tax Payable Calculation) https://bit.ly/3kfcnoY
15) Chapter (3.8 – Leap Year IF Function (1) https://bit.ly/36ikso8
16) Chapter (3. 8 – Leap Year IF Function (2) https://bit.ly/36kEiPB
17) Chapter (3.9 – Date & Time Calculation (1) https://bit.ly/3kfXnHx
18) Chapter (3. 9 – Date & Time Calculation (2) https://bit.ly/35gyhUC
19) Chapter (3.10) https://bit.ly/2Ik3c9x
20) Chapter (3.11 – Filter, Sort, Subtotal) https://bit.ly/2UbVO2K
21) Chapter (3.12 – Complex Array Formula) https://bit.ly/3n7nC4K
22) Chapter (3.13) https://bit.ly/32skUPk
23) Chapter (3 – Vlookup/ Hlookup (1) https://bit.ly/2UefPFX
24) Chapter (3 – Vlookup/ Hlookup (2) https://bit.ly/3ph0NNI
25) Chapter (3 - The power of Match & Index Function) https://bit.ly/3phRVrw
26) Chapter (3 – Multiple Criteria in Lookup Function) https://bit.ly/38qKBUb
27) Chapter (3.14 – Creating the Calendar (1) https://bit.ly/2Ubf0gX
28) Chapter (3.14 – Creating the Calendar (2) https://bit.ly/2JIzcVt
29) Chapter (3.15 – DSUM Function) https://bit.ly/3khZSsG
30) Chapter (3 – Financial Function) https://bit.ly/3eKYHRK
31) Chapter (3.16 – Financial Function) https://bit.ly/38pfRmJ
32) Chapter (3.17 – Charting) https://bit.ly/38sdOy1
33) Chapter (3.18 – Pivot Table) https://bit.ly/3naQdWY
34) Chapter (3 - Macro Recording) https://bit.ly/2GLqN2t
35) Chapter (3.19 – Changing the Case) https://bit.ly/32u0eqe
36) Chapter (3 – Password Braker by Macro) https://bit.ly/3nbUSIi
37) Chapter (3 - Sum or count based on background color by Macro) https://bit.ly/2IhNega
38) Chapter (Conditional Format Function (1) https://bit.ly/32uoTLw
39) Chapter (Conditional Format Function (2) https://bit.ly/2JTa9zf
40) Chapter (Conditional Format Function (3)vhttps://bit.ly/35fwcZh
Credit : #Original Uploader, #Myanmar Pyi
ခုလို နည္းပညာေခတ္ႀကီးမွာ သင့္အေနနဲ႔ Excel ကို တစ္ဘက္ကမ္းခတ္ တတ္ထားတာဟာ သင့္အတြက္ အားသာခ်က္တစ္ခုျဖစ္လာမွာပါ။ ဘယ္ေနရာကိုေရာက္ေရာက္ Excel ဟာ အလြန္႔အလြန္ကို အသံုး ၀င္လွပါတယ္။ ကဲ သင့္အေနနဲ႔ Excel ကို ပေရာ္ဖက္ရွင္နယ္ဆန္ဆန္ တတ္ေျမာက္ႏိုင္ေစဖို႔အတြက္ Advanced Excel အေၾကာင္းေလ့လာႏိုင္တဲ့ ဗီဒီယိုေလး ေတြ မွ်ေဝေပးပါ့မယ္ ။
ဒါဆို Advanced Excels အေၾကာင္းပိုသိခ်င္ရင္ေတာ့ ေအာက္ က Link ေတြထဲ ဝင္ၾကည့္ေပးေနာ္ ။
1) Chapter (1.1) https://bit.ly/2Ub3vpT
2) Chapter (1.2) https://bit.ly/3pfLANa
3) Chapter (2.1) https://bit.ly/3kfWjDx
4) Chapter (2.2) https://bit.ly/2GLvEAR
5) Chapter (2.3) https://bit.ly/3kagRgE
6) Chapter (2.4 - Conditional Formatting) https://bit.ly/35cWFGO
7) Chapter (3.1) https://bit.ly/3lh0ssc
8) Chapter (3.2 - Simple Array) https://bit.ly/3lhzVeb
9) Chapter (3.3) https://bit.ly/3lhJ46H
10) Chapter (3.4 - IF Function) https://bit.ly/3n8Ci3x
11) Chapter (3.5) - Logical Function) https://bit.ly/38w71U6
12) Chapter (3.5 - Count Function) https://bit.ly/3pe4vYF
13) Chapter (3.6 - Tax Payable Calculation) https://bit.ly/36l0IA7
14) Chapter (3.7 - Tax Payable Calculation) https://bit.ly/3kfcnoY
15) Chapter (3.8 – Leap Year IF Function (1) https://bit.ly/36ikso8
16) Chapter (3. 8 – Leap Year IF Function (2) https://bit.ly/36kEiPB
17) Chapter (3.9 – Date & Time Calculation (1) https://bit.ly/3kfXnHx
18) Chapter (3. 9 – Date & Time Calculation (2) https://bit.ly/35gyhUC
19) Chapter (3.10) https://bit.ly/2Ik3c9x
20) Chapter (3.11 – Filter, Sort, Subtotal) https://bit.ly/2UbVO2K
21) Chapter (3.12 – Complex Array Formula) https://bit.ly/3n7nC4K
22) Chapter (3.13) https://bit.ly/32skUPk
23) Chapter (3 – Vlookup/ Hlookup (1) https://bit.ly/2UefPFX
24) Chapter (3 – Vlookup/ Hlookup (2) https://bit.ly/3ph0NNI
25) Chapter (3 - The power of Match & Index Function) https://bit.ly/3phRVrw
26) Chapter (3 – Multiple Criteria in Lookup Function) https://bit.ly/38qKBUb
27) Chapter (3.14 – Creating the Calendar (1) https://bit.ly/2Ubf0gX
28) Chapter (3.14 – Creating the Calendar (2) https://bit.ly/2JIzcVt
29) Chapter (3.15 – DSUM Function) https://bit.ly/3khZSsG
30) Chapter (3 – Financial Function) https://bit.ly/3eKYHRK
31) Chapter (3.16 – Financial Function) https://bit.ly/38pfRmJ
32) Chapter (3.17 – Charting) https://bit.ly/38sdOy1
33) Chapter (3.18 – Pivot Table) https://bit.ly/3naQdWY
34) Chapter (3 - Macro Recording) https://bit.ly/2GLqN2t
35) Chapter (3.19 – Changing the Case) https://bit.ly/32u0eqe
36) Chapter (3 – Password Braker by Macro) https://bit.ly/3nbUSIi
37) Chapter (3 - Sum or count based on background color by Macro) https://bit.ly/2IhNega
38) Chapter (Conditional Format Function (1) https://bit.ly/32uoTLw
39) Chapter (Conditional Format Function (2) https://bit.ly/2JTa9zf
40) Chapter (Conditional Format Function (3)vhttps://bit.ly/35fwcZh
Credit : #Original Uploader, #Myanmar Pyi