×

Warning

JUser: :_load: Unable to load user with ID: 81428


Knowledge

Friday, 13 November 2020

Advanced Excel အကြောင်း

ခုလို နည်းပညာခေတ်ကြီးမှာ သင့်အနေနဲ့ 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

 

 

Read times
Rate this articles
(0 votes)