Mukamagwira ntchito ndi ma Excel spreadsheet, nthawi zambiri ndizofunikira kugwira ntchito ndizomwe muli nazo. Pa nthawi yomweyi, ntchito zina zimatanthauza kuti gulu lonse la maselo liyenera kusandulika kwenikweni pang'onopang'ono. Mu Excel pali zipangizo zomwe zimalola ntchito zoterezi. Tiyeni tipeze momwe tingagwiritsire ntchito deta zamtunduwu pulogalamuyi.
Yambani ntchito
Mndandanda ndi gulu la deta yomwe ili pa pepala m'maselo apafupi. Mwachidule, tebulo lililonse lingalingalidwe, koma sikuti aliyense ali tebulo, chifukwa lingakhale lokha. Ndipotu, malo amenewa akhoza kukhala amodzi kapena awiri (matrix). Pachiyambi choyamba, deta yonse ili mu mzere umodzi kapena mzere umodzi.
Pachiwiri - panthawi zingapo panthawi yomweyo.
Kuwonjezera pamenepo, mitundu yopanda malire ndi yowongoka imasiyanitsidwa kuchokera kumbali imodzi yokha, malinga ndi mzere kapena khola.
Tiyenera kukumbukira kuti ndondomeko yogwirira ntchitoyi ndi yosiyana ndi ntchito zomwe zimadziwika bwino ndi maselo amodzi, ngakhale kuti pali zambiri zomwe zimagwirizana pakati pawo. Tiyeni tiyang'ane pazithunzi za ntchito zoterezi.
Chilengedwe
Ndondomeko yowonjezera ndiyo mawu omwe amagwiritsidwa ntchito pokonza zosiyana kuti apeze zotsatira zomaliza zomwe zimagwiritsidwa ntchito limodzi kapena selo limodzi. Mwachitsanzo, pofuna kuchulukitsa mtundu umodzi ndi wina, chigwiritsirochi chimagwiritsidwa ntchito motsatira ndondomeko yotsatirayi:
= array_address1 * array_address2
Mukhozanso kuwonjezera, kuchotsa, kupatukana, ndi machitidwe ena a masamu pamabuku a deta.
Zogwirizanitsa zazomwe zili mu maadiresi a selo yoyamba ndi yotsiriza, yolekanitsidwa ndi koloni. Ngati mzerewu uli ndi magawo awiri, ndiye maselo oyambirira ndi omalizira akupezeka mosiyana kuchokera kwa wina ndi mnzake. Mwachitsanzo, adiresi ya gawo limodzi akhoza kukhala: A2: A7.
Chitsanzo cha adiresi yazithunzi ziwiri ndi izi: A2: D7.
- Kuti muwerenge njira yowonjezera, muyenera kusankha pa pepala malo omwe zotsatirazo ziwonetsedwe, ndipo lembani mawonetsedwe kuti muwerengedwe mu bar.
- Pambuyo polowera simukudina pa batani Lowanimonga mwachizolowezi, ndipo lembani mgwirizano Ctrl + Shift + Lowani. Pambuyo pake, mawu omwe ali mu bar lachitsulo adzatengedwa ndi mabotolo ozungulira, ndipo maselo omwe ali pa pepala adzadzazidwa ndi deta yomwe imapezeka chifukwa cha kuwerengera, mkati mwa zonse zosankhidwa.
Sinthani Zamkatimu Zamkatimu
Ngati mutayesa kuchotsa zomwe zilipo kapena kusintha maselo onse, omwe ali pamtunda momwe zotsatirazo zikuwonetsedwa, ndiye kuti zomwe mukuchita zidzatha molephera. Sizimagwiranso ntchito ngati mukuyesera kusinthira deta muzomwe mukugwira ntchito. Pachifukwa ichi, uthenga wowonjezera udzawonekera momwe zidzanenedwa kuti sikutheka kusintha mbali ya mndandanda. Uthenga uwu udzawonekera ngakhale mutakhalabe ndi cholinga choti musinthe, ndipo mutangoyang'ana khungu lachinyumba mwadzidzidzi.
Ngati mutseka uthengawu podindira pa batani "Chabwino", ndiyeno yesetsani kusuntha cholozeracho ndi mbewa, kapena ingoyanikizani pakani Lowani ", uthenga wowonjezera udzawonekanso. N'zosatheka kutseka zenera pulogalamu kapena kusunga chikalata. Uthenga wokhumudwitsawu udzawonekera nthawi zonse, kutseka zochita zilizonse. Ndipo njira yotuluka ndi yosavuta.
- Tsekani zenera pazowonjezera pa batani. "Chabwino".
- Kenaka dinani batani "Tsitsani", yomwe ili m'gulu la zithunzi kumanzere kwa bar, ndipo ndi chizindikiro chokhala ngati mtanda. Mukhozanso kutsegula pa batani. Esc pabokosi. Pambuyo pazinthu zonsezi, ntchitoyi idzachotsedwa, ndipo mutha kugwira ntchito ndi pepala monga kale.
Koma bwanji ngati mukufunikira kuchotsa kapena kusintha ndondomekoyi? Pankhaniyi, tsatirani ndondomeko zotsatirazi.
- Kuti musinthe ndondomekoyi, sankhani chithunzithunzi, mutagwiritsa ntchito botani lamanzere, lonselo pa pepala pomwe zotsatirazo zikuwonetsedwa. Izi ndi zofunika kwambiri, chifukwa ngati mutasankha selo imodzi yokha, palibe chomwe chikuchitika. Kenaka pangani kusintha kofunikira mu bar.
- Zitatha kusintha, yesani kusakaniza Ctrl + Shift + Esc. Njirayi idzasinthidwa.
- Kuchotsa ndondomeko yambiri, muyenera kutero, mofanana ndi momwe munayambira kale, sankhani maselo osiyanasiyana omwe ali ndi chithunzithunzi. Kenaka tanizani batani Chotsani pabokosi.
- Pambuyo pake, njirayi idzachotsedwa kumalo onse. Tsopano mukhoza kulowa deta iliyonse.
Ntchito zowonongeka
Njira yabwino kwambiri yogwiritsira ntchito maonekedwe ndi kugwiritsa ntchito ntchito zomangidwa kale ku Excel. Mukhoza kuwapeza Mlaliki Wachipangizomwa kukanikiza batani "Ikani ntchito" kumanzere kwa bar. Kapena mu tab "Maonekedwe" Pa tepiyi, mungasankhe chimodzi mwa magulu omwe operekera chidwi omwe muli nawo akupezeka.
Mutatha kugwiritsa ntchito Wizard ntchito kapena pagulu lazamasamba, mumasankha dzina la wogwiritsira ntchito, ntchito yowonekera zowonekera, kumene mungalowetse deta yoyamba ya mawerengedwe.
Malamulo a kulowa ntchito ndi kukonza, ngati akuwonetsa zotsatira mu maselo angapo kamodzi, ali ofanana ndi machitidwe osiyana. Ndiko kuti, mutatha kulowa muyeso, muyenera kukhazikitsa cholozera muzenera zamtunduwu ndikuyimira pamodzi Ctrl + Shift + Lowani.
Phunziro: Wowonjezera Wogwira Ntchito
Ogwira ntchito SUM
Chimodzi mwa zinthu zopempha kwambiri ku Excel ndi SUM. Ikhoza kugwiritsidwa ntchito palimodzi kuti ziwerengere zomwe zili mumaselo ena, ndi kupeza mndandanda wa zigawo zonse. Mawu omasuliridwa kwa opareshoni awa pamakalata awa ndi awa:
= SUM (array1; array2; ...)
Wogwiritsa ntchitoyi amasonyeza zotsatira mu selo imodzi, choncho, kuti muyese kuwerengera, mutatha kuika deta yolandirira, ingoyanikizani pakani "Chabwino" muzitsulo zogwirira ntchito kapena fungulo Lowaningati kulowetsa kunkachitidwa mwaulere.
Phunziro: Momwe mungawerengere ndalama mu Excel
NTCHITO YOTENDA
Ntchito TRANSPORT ndi wodabwitsa wotere. Zimakupatsani inu kujambulitsira matebulo kapena matrices, ndiko kuti, kusintha mizere ndi zigawo kumalo ena. Panthawi imodzimodziyo, imagwiritsira ntchito kokha zotsatira za zotsatira mu maselo ambiri, choncho pambuyo poyambitsa kampaniyi, nkofunika kugwiritsa ntchito kuphatikiza Ctrl + Shift + Lowani. Tiyeneranso kukumbukira kuti musanayambe kufotokozera mawuwo, m'pofunika kusankha malo pa pepala yomwe ili ndi chiwerengero cha maselo omwe ali mumtanda wofanana ndi chiwerengero cha maselo omwe ali mzere wa tebulo (matrix) ndipo, mofananamo, chiwerengero cha maselo mzere chiyenera kulingana ndi chiwerengero chawo m'kamwa. Mawu ogwiritsira ntchito ogwiritsira ntchito ndi awa:
= TRANSPORT (gulu)
Phunziro: Kutumiza Matrices ku Excel
Phunziro: Momwe mungapangire tebulo mu Excel
MOBR operator
Ntchito MOBR kukulolani kuti muwerenge matrix ofotokozera. Malamulo onse oti alowe muyeso ya woyendetsa ntchitoyi ndi chimodzimodzi ndi chakale. Koma ndikofunika kudziŵa kuti kuwerengera kwa chiwerengero choyendetsa chotheka kumatheka kokha ngati kuli ndi nambala yofanana ndi mizere ndi mizere, ndipo ngati chiwerengero chake sichifanana ndi zero. Ngati mumagwiritsa ntchito ntchitoyi kudera lokhala ndi mizere ndi mizere yosiyana, ndiye kuti m'malo mwa zotsatira zolondola, zotsatirazi zidzawonetsedwa "#VALUE!". Mawu omasuliridwa awa ndi awa:
= MBR (gulu)
Kuti muzindikire chokhazikika, gwiritsani ntchito ntchitoyi ndi mawu ofanana awa:
= MEPRED (gulu)
Phunziro: Excel Kusintha Matrix
Monga momwe mukuonera, machitidwe ndi mndandanda amathandiza nthawi yosungira mawerengedwe, komanso malo omasuka a pepala, chifukwa palibe chifukwa chowonjezera kuwonjezera deta yomwe ikuphatikizidwa muzinthu zosiyanasiyana kuti agwire nawo ntchito. Zonsezi zimachitika pa ntchentche. Ndipo chifukwa cha kutembenuka kwa magome ndi matrices, ntchito zokhazokha ndizoyenera, popeza machitidwe ozoloŵera sangathe kupirira ntchito zomwezo. Koma panthawi imodzimodziyo, m'pofunika kuganizira kuti malamulo ena otsogolera ndi okonzedwera amagwiritsidwa ntchito pazinthu zoterezi.
