Mu mapulogalamu a spreadsheet monga Excel ndi Google Spreadsheets, mndandanda ndi mndandanda kapena mndandanda wokhudzana ndi chiwerengero cha deta zomwe nthawi zambiri amasungidwa m'maselo oyandikana pa tsamba.
Ndondomeko yambiri ndi ndondomeko yomwe imawerengetsera-monga Kuwonjezerapo, kapena kuchulukitsa-pazinthu zamtengo umodzi kapena zingapo kusiyana ndi chiwerengero chimodzi cha deta.
Ndondomeko:
- gwiritsani ntchito mawu ofanana monga machitidwe ozolowereka-onse amayamba ndi chizindikiro chofanana (=) mwachitsanzo;
- gwiritsani ntchito olemba masamu omwewo;
- ndipo tsatirani dongosolo lomwelo la ntchito.
Kulemba Mafomu ndi Ntchito za Excel
Zambiri mwa ntchito zodzikongoletsera za Excel-monga SUM , AVERAGE , kapena COUNT -gwiranso ntchito mu njira yowonjezera.
Palinso ntchito zingapo-monga TRANSPOSE ntchito-yomwe imayenera kuikidwa nthawi zonse kuti ikhale yogwira ntchito bwino.
Phindu la ntchito zambiri monga INDEX ndi MATCH kapena MAX ndi IF zingakhoze kupitilidwa mwa kuzigwiritsa ntchito palimodzi mu ndondomeko yosiyanasiyana.
CSE Mafomu
Mu Excel, malemba amodzi akuzunguliridwa ndi "brace braces" " {} ". Izi zimangokhala zolembedwera, koma ziyenera kuwonjezeredwa pa ndondomeko mwa kukakamiza makina a Ctrl, Shift, ndi Enter mukatha kulemba fomu mu selo kapena maselo.
Pachifukwa ichi, ndondomeko yowonjezera nthawi zina imatchedwa fomu ya CSE mu Excel.
Chosavuta pa lamulo ili ndi pamene zibangili zogwiritsidwa ntchito zimagwiritsidwa ntchito polemba ndondomeko ya ntchito imene kawirikawiri imakhala ndi mtengo umodzi kapena selo.
Mwachitsanzo, mu phunziro ili m'munsimu lomwe limagwiritsa ntchito VLOOKUP ndi ntchito YOPHUNZIRA kuti apange mawonekedwe a kumanzere akumanzere, gululi limapangidwira pa CHOOSE ntchito Index_num kukweza polemba zilembo pazowonjezera.
Zomwe Mungachite Kuti Muzipanga Maonekedwe Athu
- Lowani ndondomeko;
- Gwiritsani makina a Ctrl ndi Shift pa kibokosi;
- Koperani ndi kumasula fungulo lolowamo kuti mupange ndondomeko yambiri;
- Tulutsani makiyi a Ctrl ndi Shift .
Ngati mwachita bwino, njirayi idzazunguliridwa ndi mabotolo ozungulira ndipo selo iliyonse yomwe ikugwira ntchitoyi idzakhala ndi zotsatira zosiyana.
Kusintha Mndandanda Wowonjezera
Nthaŵi iliyonse ndondomeko yowonongeka yowonongeka imakhala yosasunthika kuchoka kumbali yonse.
Kuti muwabwezeretse, njira yowonjezera iyenera kulowa mwa kukakamiza makina a Ctrl, Shift, ndi Enter monga momwe ndondomeko yoyamba inakhazikitsidwira.
Mitundu Yowonjezera Mafomu
Pali mitundu iwiri ikuluikulu ya mitundu yosiyanasiyana:
- mitundu yambiri ya selo - njira yomweyi ili mu selo limodzi pa tsamba lopangira
- selo limodzi lokha lachindunji njira imodzi yomwe imapanga mawerengedwe angapo mu selo limodzi la masamba
Multi Multi Array Formula
Monga momwe dzina lawo limasonyezera, malemba awa ali m'maselo ambiri apakompyuta ndipo amabweretsanso mndandanda ngati yankho.
M'mawu ena, mawonekedwe omwewo ali m'maselo awiri kapena angapo ndikubwezera mayankho osiyanasiyana pa selo iliyonse.
Momwe zimachitikire izi ndikuti kapepala kapena kachitidwe kalikonse kameneka kamakhala ndi chiwerengero chomwecho mu selo iliyonse yomwe ilipo, koma mchitidwe uliwonse wa machitidwewo umagwiritsira ntchito deta yosiyana pazowerengerazo, choncho, nthawi iliyonse imabala zotsatira zosiyana.
Chitsanzo cha njira zambiri zamaselo zingakhale:
{= A1: A2 * B1: B2}
Ngati chitsanzo chapamwamba chili m'maselo C1 ndi C2 mu tsamba lothandizira ndiye zotsatira zotsatirazi zidzakhala:
- deta mu A1 imachulukitsidwa ndi deta mu B1 ndi zotsatira zosungidwa mu selo C1
- Deta mu A2 imachulukitsidwa ndi deta mu B2 ndi zotsatira zosungidwa mu selo C2
Maselo Okhaokha Opanga Mafomu
Mitundu yachiwiriyi imagwiritsira ntchito ntchito, monga SUM, AVERAGE, kapena COUNT, kuti agwirizane ndi zotsatira za mawonekedwe a maselo ambiri omwe ali ndi selo limodzi.
Chitsanzo cha njira imodzi yokha ya selo chingakhale:
{= SUM (A1: A2 * B1: B2)}
Fomuyi imaphatikizapo zotsatira za A1 * B1 ndi A2 * B2 ndipo amabweretsanso zotsatira imodzi mu selo limodzi pa tsamba.
Njira ina yolembera ndondomekoyi ndi iyi:
= (A1 * B1) + (A2 * B2)
Mndandanda wa Maofomu Otsatira a Excel
M'munsimu muli mndandanda wa maphunziro omwe ali ndi ma Excel osiyanasiyana.
- Phunziro loyamba limaphatikizapo maulendo ambirimbiri a maselo
- Mautumiki asanu ndi atatu otsatirawa ali pafupi ndi ma selo amodzi omwe amagwiritsa ntchito ntchito zosiyanasiyana za Excel
- Maphunziro omalizira ali pa TRANSPOSE ntchito
01 pa 10
Excel Multi Cell Array Form
Maselo angapo kapena maselo ambirimbiri a selo ndi njira yowonjezera yomwe ili mu selo limodzi pa tsamba . Ziwerengero zomwezo zimagwiritsidwa ntchito mumaselo ambiri pogwiritsira ntchito deta yosiyana siyana. Zambiri "
02 pa 10
Excel Single Cell Array Momwe Pang'onopang'ono Phunziro Tutorial
Mafelemu osaphatikizapo amodzi nthawi yoyamba amachita mawerengedwe angapo a maselo (monga kuchulukitsa) ndiyeno amagwiritsira ntchito ntchito monga AVERAGE kapena SUM kuti agwirizanitse zotsatira za mndandanda mu zotsatira imodzi. Zambiri "
03 pa 10
Pezani Zolakwa Zosintha pamene Mudapeza KODI
Ndondomekoyi ingagwiritsidwe ntchito kupeza mtengo wa deta yomwe ilipo ponyalanyaza mfundo zolakwika monga # DIV / 0 !, kapena #NAME?
Igwiritsira ntchito NTCHITO ntchito pamodzi ndi ntchito IF ndi ISNUMBER. Zambiri "
04 pa 10
SUM ya SUM IF IF Formula
Gwiritsani ntchito ntchito ya SUM ndipo ngati mutagwira ntchito mwa njira yowerengera m'malo mowerengera maselo a deta omwe amakumana ndi zifukwa zambiri.
Izi zimasiyana ndi ntchito ya Excel COUNTIFS yomwe imapangitsa kuti zonse zikhazikike musanayambe selo.
05 ya 10
Excel MAX IF Kupeza Mndandanda Wopezera Nambala Yopambana Kapena Yopanda Nzeru
Phunziroli limaphatikizapo ntchito ya MAX ndipo IF ikugwira ntchito mwachindunji chomwe chidzapeza mtengo waukulu kapena wapatali pa deta yambiri pamene chitsimikizochi chidzakwaniritsidwa. Zambiri "
06 cha 10
Excel MIN NGATI Makhalidwe - Pezani Chinthu Chochepa Kwambiri Kapena Nambala Yoipa
Mofanana ndi nkhani yomwe ili pamwambapa, iyi imaphatikiza ntchito MIN ndi IF ngatiyi mwa njira yowonjezerapo kuti mupeze phindu laling'ono kapena laling'ono la deta pamene chitsimikizo china chikuchitika. Zambiri "
07 pa 10
Excel MEDIAN IF Array Form - Pezani Mtengo Wapakati kapena Wakale
Ntchito ya MEDIAN mu Excel imapeza mtengo wapakati wa mndandanda wa deta. Mwachiphatikiza icho ndi IF mukugwira ntchito mu njira yowonjezera, mtengo wapakati wa magulu osiyana a deta yokhudzana angapezeke. Zambiri "
08 pa 10
Pezani Mpangidwe ndi Zowonjezera Zambiri mu Excel
Pogwiritsira ntchito ndondomeko yowonjezereka njira yowonjezera ikhoza kugwiritsidwa ntchito yomwe imagwiritsa ntchito njira zingapo kuti mupeze zambiri mu database. Njira yowonjezerayi ikuphatikizapo kumangirira ntchito MATCH ndi INDEX . Zambiri "
09 ya 10
Excel Powonda Kufufuza Makhalidwe
Ntchito ya VLOOKUP kawirikawiri imangosanthula deta yomwe ili m'mizere kumanja, koma mwa kuphatikiza ndi CHOOSE ntchito pulogalamu yowonjezera yowonjezera ikhoza kukhazikitsidwa kuti ifufuze ndondomeko za deta kumanzere kwa mtsutso wa Lookup_value . Zambiri "
10 pa 10
Kutumiza kapena Flip Mows kapena Columns of Data mu Excel
Ntchito YOPHUNZITSIRA imagwiritsidwa ntchito kufotokoza deta yomwe ili pamzere mndandanda kapena deta ya deta yomwe ili m'ndandanda mumzere. Ntchitoyi ndi imodzi mwa zochepa zomwe zili mu Excel zomwe ziyenera kugwiritsidwa ntchito nthawi zonse. Zambiri "