ဒီေန႕ေတာ႕ excel formula ေလးေတြကိုလက္ေတြ႕အသံုးခ်တဲ႕နည္းေလးေတြနဲနဲေလာက္မွ်ေ၀ေပးခ်င္ပါတယ္
ပထမဆံုးေျပာခ်င္တာေလးက အခု promotion post ေတြမွာစာလံုးေရဘယ္လိုစစ္သလည္းဆိုတာေလးပါ။
smart phone ေတြမွာဆိုရင္ေတာ႕ count words ဆိုတဲ႕ application ေလး ေဒါင္းျပီး စစ္လို႕ရပါတယ္။
တကယ္လို႕ computer နဲ႕သံုးရင္ေတာ႕ excel formula ေလးနဲ႕လြယ္လြယ္ကူကူစစ္လို႕ရႏိုင္ပါတယ္။
ပထမဆံုးကိုယ္ေရးခ်င္တဲ႕စာေတြခ်ေရးထားျပီးသူ႕ေဘးမွာ formula column ေလးထားထားရင္ေရးေနရင္းနဲ႕စာလံုးေရဘယ္ေလာက္ထိေရာက္ေနျပီလဲဆိုတာကိုပါတစ္ခါတည္းသိႏိုင္ပါတယ္။
အခုျပထားတဲ႕ပံုေလးထဲကအတိုင္း =len( လို႕ေရးျပီး ကိုယ္စာရိုက္ထားတဲ႕ cell ကြက္ကို select ေပးျပီး enter ေခါက္လိုက္ရံုနဲ႕ စာလံုးအေရအတြက္ခ်က္ခ်င္းသိႏိုင္ပါတယ္
ခုျပထားတဲ႕ပံုေလးထဲကလို ေအာက္ဆံုးနားမွာ sum formula ေလးထည္႕ထားလိုက္ရင္ စာတစ္ပုဒ္လံုးအတြက္ စာလံုးေရကိုလည္းေရးေနရင္းနဲ႕သိႏိုင္မွာပါ။
အခုလက္ရွိက်ြန္မေရးျပီးသေလာက္က စာလံုးေရ 811 လံုးပါ။
ေနာက္ထပ္ formula ေလးတစ္ခုကေတာ႕ ကိုယ္႕ရဲ႕ေမြးေန႕ကို ရက္လႏွစ္အတိအက်တြက္တာပါ။
ကိုယ္ေမြးတဲ႕ေမြးေန႕နဲ႕ အခုလက္ရွိ date ႏွစ္ခုသိထားရင္တြက္လို႕ရပါျပီ။ တနည္းေျပာရရင္ကိုယ္စခ်င္တဲ႕ရက္ကေနဆံုးခ်င္တဲ႕ရက္ျကားမွာရွိတဲ႕ ရက္ လ ႏွစ္ အေရအတြက္ေတြကို အတိအက် တြက္ထုတ္လို႕ရတဲ႕နည္းေလးပါ။
အေပၚပံုေလးမွာ တကြက္ခ်င္းရဲ႕ formula ေလးေတြနဲ႕အတူတြက္ျပထားပါတယ္။ ဒီ dateif formula ေလးက excel ရဲ႕ hidden formula လို႕လည္းသိထားျကပါတယ္။
ေနာက္တစ္ခုက convert formula ေလးပါ။ ေပ ကေန လက္မေျပာင္းခ်င္တာ kg ကေန g ေျပာင္းခ်င္တာ စသျဖင္႕ကိုယ္ေျပာင္းခ်င္တဲ႕အတိုင္းအတာေတြကို လြယ္လြယ္နဲ႕ျမန္ျမန္ဆန္ဆန္ေျပာင္းႏိုင္တဲ႕ formula ေလးပါ။
ဒီပံုေလးမွာ လက္မေျခာက္ဆယ္မွာ ဘယ္ႏွေပရွိသလဲတြက္ထားပံုေလးပါ။ ကိုယ္လိုခ်င္တဲ႕အတိုင္းအတာေလးေတြကို ဒီ formula ထဲမွာ အစားထိုးျပီးတြက္သြားရံုပါပဲရွင္။
အခုေျပာခဲ႕တဲ႕ formula ေလးေတြကသိထားျပီးသူေတြအတြက္လြယ္ကူရိုးရွင္းေပမယ္႕ မသိေသးတဲ႕သူေတြအတြက္ေတာ႕တကယ္အသံုး၀င္မွာပါ။
ေနာက္လည္း အလ်င္းသင္႕သလို လြယ္ကူျပီးအသံုး၀င္တဲ႕ formula ေလးေတြကိုမ်ွေ၀ေပးသြားပါအံုးမယ္။
Myanmar Steemit အဖြဲ႕သားမ်ားအားလံုးကိုယ္စိတ္ႏွစ္ျဖာက်န္းမာခ်မ္းသာျကပါေစရွင္။
@zinzin
MSC-194
post တခု ရွာတာ အကြက္ျမင္လိုက္တာ ကြာ ငါေတာ့ post တခုရဖို ့ေခါင္းကို စက္တပ္ထားတာေတာက္မလြယ္ဘူး
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
တေန႕တေန႕မ်က္စိေရွ႔ဒါေတြပဲျမင္ေနရေတာ့ ဒါပဲခ်ေရးရေတာ့တာေပါ့ကြယ္ 😁
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This post is resteemed and upvoted by @bestboom
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank u
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ေဝမၽႇေပးတာေက်းဇုးပါညီမေလးေရ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ မမို 😘
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဗဟုသုတရပါတယ္ မဇင္။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္မမ်ိဳး။ ေက်းဇူးတင္ပါတယ္။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ေက်းဇူးပါ မဇင္ေရ အခုလုိ ေ၀မွ်ေပးတာေလးေတြအတြက္.....
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္။ ခုလိုလာဖတ္ေပးတာေလးလည္းေက်းဇူးတင္ပါတယ္ရွင္။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
မသိေသးတဲ့လူအတြက္အသံုးဝင္တဲ့အၾကာင္းအရာေလးပါ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ကဲ႕မအိေရ ေက်းဇူးပါ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you မဇင္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ကဲ႕ ညီမေလး လာဖတ္ေပးတာလည္းေက်းဇူးပါရွင္႕
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဗဟုသုတရပါတယ္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ ေက်းဇူး
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ျမန္မာစာနဲ႔ အဂၤလိပ္စာလံုးက
ေရတြက္ရင္မတူဘူးနဲ႔တူတယ္။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
စာတစ္လံုးစီကို count လုပ္သြားတာ ကိုရဲ။ "formula" ဆို 7 လံုး ျမန္မာလို "ဟုတ္ကဲ႕ပါ" ဆိုရင္ ၉လံုး အဲလိုတြက္သြားတာပါ။ space ျခားရင္ space ကိုပါထည္႕တြက္တယ္ သူက
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ေအာ္ ဟုတ္လား။ က်ေတာ္ေသခ်ာမသိပါဘူး။
ျမန္မာစာ နဲ႔ တြက္ရင္ ပိုပိုေနတာေတြ႔ဖူးလို႔။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
မ်ွေဝေပးတဲ႔အတြက္ေက်းဇူးပါအမေရ ေနာင္မ်ားလည္းဗဟုသုတရစရာေလးမ်ားရွိရင္မ်ွေဝေပးေစခ်င္ပါတယ္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ လာဖတ္ေပးတာလည္းေက်းဇူးတင္ပါတယ္ရွင္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဗဟုသုတ ရပါတယ္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ ကုိဇင္ ေက်းဇူးတင္ပါတယ္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Goood sis👍
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank u
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဗဟုသုတ ရပါတယ္ အစ္မေရ..
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
အဆင္ေျပမယ္ဆို ဝမ္းသာပါတယ္ရွင္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
အားေပးေနပါတယ္ မဇင္ေရ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ ေက်းဇူးပါ ကိုသက္ထူးေအာင္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဗဟုသုတရပါတယ္ဗ်ာ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ကဲ႕ကိုျမင္႕ လာဖတ္ေပးတာလည္းေက်းဇူးတင္ပါတယ္
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
မမွီဘူး
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
:D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you , i didn't even get this
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
yep. it's simple and easy.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
အမေရ excel တို႔ wordတို႔ကို ေလ့လာခ်င္ပါတယ္...။ သင္တန္းတက္မယ္ဆို အခ်ိန္ဘယ္ေလာက္ယူရမလဲ ခင္ဗ်......။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ms basic က ၂လေလာက္ဆို ရပါျပီ ကိုဂ်ြန္ေရ။ အျကာျကီးအခ်ိန္မယူရပါဖူး။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Excel တားတားမီတတ္ ေနာက္ေတာ႔ေလ႔လာပါရဦးမယ္ေသခ်ာ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ဟုတ္ ကိုဒိုေလး အေျခခံ ၂လေလာက္သင္တန္းတက္ျပီး ကိုယ့္ဘာသာ အိမ္မွာေလ့က်င့္တာ ပိုျမန္တယ္ ။
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You got a 16.67% upvote from @upmewhale courtesy of @zinzin! Earn 90% daily earning payout by delegating SP to @upmewhale.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank u
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
ေကာင္းတယ္ ဒါလည္းမသိေသးတဲ့သူအတြက္အသံုးဝင္တာပဲ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
တစ္ေယာက္ပဲျဖစ္ျဖစ္အသံုး၀င္သြားတယ္ဆို ေက်နပ္ပါတယ္အူးမင္းေရ
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
what number it is
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello fri, thank you for your ment. My post explain about the calculation for count words, age and convert use with excel formula.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit