Phunzirani momwe zikhomo zingathandizire ntchito ku Excel
Mndandanda uli wautali kapena gulu lazomwe zimagwirizana ndi deta. Mu mapulogalamu a spreadsheet monga Excel ndi Google Spreadsheets, malingaliro amtunduwu amakhala osungidwa m'maselo apafupi.
Zimagwiritsa Ntchito Zopangira
Mipangidwe ingagwiritsidwe ntchito m'mawonekedwe onse (zolemba mafomu) ndi chifukwa cha ntchito monga mitundu yosiyanasiyana ya ntchito LOOKUP ndi INDEX .
Mitundu ya Arrays
Pali mitundu iwiri ya zojambula mu Excel:
- Mzere umodzi, womwe umatchedwanso vector kapena vector. Deta ilipo:
- mu mzere umodzi (umodzi-wamitundu wosakanikirana mzere).
- mu ndodo imodzi (imodzi-dimensional yowoneka bwino).
- Zithunzi ziwiri, zomwe zimatchedwanso matrix
- deta ili m'mizere yambiri kapena mizere.
- Mndandanda wa Masamba - Mndandanda wa tebulo ndi chimodzi mwa zifukwa zomwe zikugwiritsidwa ntchito pa Excel, monga VLOOKUP ndi HLOOKUP.
- Ntchito ZOKUKHALA zimafufuzira pa tebulo kuti mudziwe zambiri.
- Kwa VLOOKUP (kuwonekera kotsimikizika), tebulo_yiyenera kukhala ndi zigawo ziwiri za deta .
- Kwa HLOOKUP (kutambasula kosakanikirana), tebulo_yiyenera kukhala ndi mizere iwiri ya deta.
Yambani Mphindi Mwachidule
Ndondomeko yambiri ndi ndondomeko yomwe imawerengetsera - monga Kuonjezera, kapena kuchulukitsa - pazinthu zamtengo umodzi kapena zingapo kusiyana ndi chiwerengero chimodzi cha deta.
Ndondomeko:
- gwiritsani ntchito mawu ofanana monga machitidwe omwe amapezeka nthawi zonse (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 zowonjezera za Excel - monga SUM, AVERAGE, kapena COUNT - zingagwiritsidwe ntchito potsatira njira.
Palinso ntchito zingapo - monga TRANSPOSE function - zomwe ziyenera kuikidwa nthawi zonse kuti zikhale 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 muzondomeko mwa kukakamiza makina a Ctrl, Shift, ndi Enter mukatha kulembera 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 ndondomekoyi.
- Gwiritsani makiyi a Ctrl ndi Shift pa makiyi.
- Sakanizani ndi kumasula fungulo lolowamo kuti mupange ndondomekoyi.
- 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 ya mawonekedwe:
- Mndandanda wa ma selo ochuluka, pamene njira yomweyi imapezeka mu selo limodzi pa tsamba lamasamba;
- Njira imodzi yokha ya maselo, pamene chiganizo chimodzi chimapanga mawerengedwe angapo mu selo limodzi lamasamba.
Multi-Cell 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 zimakhalira izi ndikuti kapepala iliyonse kapena chitsanzo cha ndondomekoyi ikupanga mawerengedwe omwewo mu selo iliyonse yomwe ilipo, koma mchitidwe uliwonse wa machitidwewo umagwiritsira ntchito deta yosiyana siyana, choncho, nthawi iliyonse imabala zotsatira zosiyana.
Chitsanzo cha njira zambiri zamaselo zingakhale:
{= A1: A2 * B1: B2}
Maselo Okhaokha Opanga Mafomu
Mitundu yachiwiriyi imagwiritsira ntchito ntchito - monga SUM, AVERAGE, kapena COUNT - kuti agwirizane ndi chiwerengero cha makompyuta ambirimbiri mu selo limodzi.
Chitsanzo cha njira imodzi yokha ya selo chingakhale:
{= SUM (A1: A2 * B1: B2)}