Mwinanso, ogwiritsa ntchito ambiri osadziwa zambiri adayesa kutsatsa zina mu Excel, koma chifukwa cha zomwe adachitazo adapeza phindu losiyananso ndi cholakwika. Izi ndichifukwa choti formula idali pachiwonetsero choyambirira, ndipo ndiomwe adayikidwa, osati mtengo wake. Mavuto oterewa atha kupewedwa ngati ogwiritsa ntchito akudziwa za lingaliro monga "Lowetsani mwapadera". Ndi chithandizo chake, mutha kugwiranso ntchito zina zambiri, kuphatikizapo masamu. Tiyeni tiwone kuti chida ichi ndi chiyani ndikugwiritsa ntchito nacho.
Chitani ntchito ndi kulowetsa kwapadera
Kuyika kwapadera kumapangidwa makamaka kuti aike mawu ake mu pepala la Excel momwe ogwiritsira ntchito amafunikira. Ndi chida ichi, mutha kuyika mu foni sianthu onse omwe mwangomaliza, koma katundu yekha (maulidwe, mawonekedwe, mawonekedwe, ndi zina). Kuphatikiza apo, pogwiritsa ntchito zida, mutha kuchita ziwonetsero (kuwonjezera, kuchulukitsa, kuchotsa ndi kugawa), komanso kutanthauzira tebulo, ndiko kuti, kusintha kwa mizere ndi mizati.
Kuti mupite kumalo apadera, choyambirira, muyenera kuchita zoyeserera.
- Sankhani khungu kapena mtundu womwe mukufuna kukopera. Sankhani ndi chidziwitso mutagwira batani lakumanzere. Dinani pa kusankha ndi batani la mbewa yoyenera. Zosintha zamakina zimayambitsidwa momwe muyenera kusankha chinthu Copy.
Komanso, m'malo mwanjira yomwe ili pamwambapa, mutha, kukhala tabu "Pofikira"dinani pachizindikiro Copyzomwe zimayikidwa pa tepi mgululi Clipboard.
Mutha kukopera mawu posankha ndikusankha kuphatikiza kwa hotkey Ctrl + C.
- Kuti mupitilize ndi ndondomekoyi, sankhani malo omwe tilingako kuyika zinthu zomwe zidakopedwa kale. Timadina pamasankhidwe ndi batani la mbewa yoyenera. Pazosankha zomwe zikuyamba, sankhani malo "Ikani mwapadera ...". Pambuyo pake, mndandanda wowonjezereka umatsegulidwa, momwe mungasankhire mitundu yosiyanasiyana ya zochita, yogawika m'magulu atatu:
- Ikani ("Insert", "Transpose", "Fomula", "Ma formula ndi mafomu manambala", "Popanda mafelemu", "Sungani m'lifupi mwa mizati yoyambirira" ndi "Sungani mawonekedwe oyambira");
- Ikani Makhalidwe ("Value and Source Formtingting", "Ma Value" ndi "Makhwalidwe ndi Mawerengero Amanambala");
- Zosankha zina zothandizira (Kupanga mawonekedwe, Chithunzi, Ikani Chingwe, ndi Chithunzi Chogwirizanitsidwa).
Monga mukuwonera, zida za gulu loyambalo zimakopera mawu omwe ali mu khungu kapena mzere. Gulu lachiwirili lakonzedwa kuti muzitsatira mfundo zamtengo wapatali, osati fomula. Gulu lachitatu limasinthira mawonekedwe ndi mawonekedwe.
- Kuphatikiza apo, mumenyu yowonjezera yomweyi ilinso chinthu china chomwe chili ndi dzina lofanana - "Ikani mwapadera ...".
- Ngati mungayang'anire, zenera lina lolowera lokhalo limatseguka ndi zida zomwe zimagawidwa m'magulu awiri akulu: Ikani ndi "Ntchito". Mwakutero, chifukwa cha zida za gulu lomaliza, ndizotheka kuchita ziwonetsero, zomwe takambirana pamwambapa. Kuphatikiza apo, pazenera ili pali zinthu ziwiri zomwe sizikuphatikizidwa m'magulu osiyana: Kudumpha Maseli Opanda ndi "Transpose".
- Mutha kulowa pakanema kapadera kudzera menyu, komanso zida zomwe zili pa riboni. Kuti tichite izi, kukhala tabu "Pofikira", dinani chizindikirocho mumtundu wokhala wozungulira wapansi, womwe umakhala pansi pa batani Ikani pagululi Clipboard. Kenako, mndandanda wazotheka ukhoza kutsegulidwa, kuphatikiza kusintha kwa zenera lina.
Njira 1: gwiritsani ntchito mfundo zofunikira
Ngati mukufunikira kusintha maselo, zomwe zotsatira zake zimawonetsedwa pogwiritsa ntchito njira zowonekera, ndiye kuti kuphatikiza kwapadera kumangokonzekera nkhaniyi. Ngati mumagwiritsa ntchito kukopera pafupipafupi, formula imakopedwa, ndipo kufunikira kwake mu izo sikungakhale momwe mukufunira.
- Kuti mumvetsetse zamtunduwu, sankhani magulu omwe ali ndi zotsatira za kuwerengera. Timakopera mwanjira iliyonse yomwe tinakambirana pamwambapa: menyu wankhaniyo, batani la nthiti, kuphatikiza kwa mafungulo otentha.
- Sankhani malo omwe alembedwa. Timasintha menyu ndi imodzi mwazomwe tafotokozazi. Mu block Ikani Mfundo sankhani "Zotsatira zamawonekedwe ndi manambala". Izi ndizoyenera kwambiri pamkhalidwewu.
Njira imodzimodziyo imatha kuchitika kudzera pawindo lomwe lidafotokozedwapo kale. Kasikil’owu, muna longo Ikani sinthani kusintha kwa malo "Zotsatira zamawonekedwe ndi manambala" ndipo dinani batani "Zabwino".
- Kusankha kulikonse komwe mungasankhe, detayo idzasamutsidwira pamitundu yosankhidwa. Zotsatira ziziwonetsedwa popanda kusamutsira njira.
Phunziro: Momwe mungachotsere formula mu Excel
Njira 2: kukopera njira
Koma palinso zotsutsana pamene muyenera kukopera ndendende njira.
- Poterepa, timayeseza njira iliyonse yokopera.
- Pambuyo pake, sankhani malowo patsamba lomwe mukufuna kuyika tebulo kapena china. Timayambitsa menyu wankhaniyo ndikusankha chinthucho Mawonekedwe. Potere, ma formula okha ndi mfundo zake ndi zomwe zidzayikidwe (mu ma cell omwe mulibe mawonekedwe), koma nthawi yomweyo kupanga ndi mawonekedwe amitundu kudzatayika. Chifukwa chake, mwachitsanzo, ngati mtundu wa deti udalipo m'derali, ndiye kuti ukatha kukopera uwonetsedwa molakwika. Maselo ofanana adzafunika kuphatikizidwa.
Pazenera, izi zikugwirizana ndi kusunthira kusinthaku Mawonekedwe.
Koma ndikotheka kusamutsa formula mukusunga mtundu wamtundu, kapena kusungiratu mawonekedwe oyambira.
- Poyambirira, sankhani chinthucho menyu "Makonda ndi mitundu ya manambala".
Ngati ntchito ikuchitika kudzera pazenera, ndiye pamenepa, muyenera kusunthira ku "Makonda ndi mitundu ya manambala" kenako dinani batani "Zabwino".
- Kachiwiri, mukasowa kusungira mafomula ndi mafayilo nambala okha, komanso mawonekedwe onse, sankhani zomwe mwasankha "Sungani Mtundu Wathunthu".
Ngati wogwiritsa ntchito aganiza kuti agwire ntchito iyi popita pazenera, ndiye kuti muyenera kusunthira pamwambowu "Ndi mutu woyamba" ndipo dinani batani "Zabwino".
Njira 3: kusintha masinthidwe
Ngati wogwiritsa ntchito safunikira kusamutsa deta, koma akungofuna kujambula tebulo kuti mudzaze ndi zidziwitso zosiyana kwambiri, ndiye pankhani iyi, mutha kugwiritsa ntchito mfundo yeniyeniyo.
- Matulani gwero.
- Pa pepalalo, sankhani malo omwe tikufuna kuyika mawonekedwe a tebulo. Timatcha menyu wanthawi yonse. Muli gawo "Zosankha zina" sankhani Kukonza.
Ngati njirayi imagwiridwa kudzera pazenera, ndiye pamenepa, timasinthana ndikusintha "Mawonekedwe" ndipo dinani batani "Zabwino".
- Monga mukuwonera, pambuyo pa izi, mawonekedwe a tebulo loyambirira amasamutsidwa ndikusungidwa kosungidwa, koma osadzazidwa ndi deta.
Njira yachinayi: koperani patebulo pomwe mukusungira kukula kwa mizati
Si chinsinsi kuti ngati tichita zoseweretsa tebulo, ndiye kuti sizowona kuti maselo onse a thebulo latsopano azitha kukhala ndi zidziwitso zonse. Mutha kukonzanso izi mukamakopera pogwiritsa ntchito phala yapadera.
- Choyamba, pogwiritsa ntchito njira zilizonse pamwambapa, koperani pagulu la magwero.
- Mutayamba menyu omwe mukudziwa kale, sankhani phindu "Sanjani Kukula kwa Zithunzi Zoyambirira".
Njira yofananira imatha kuchitika kudzera pazenera lapadera. Kuti muchite izi, sinthani kusintha Zipilala Zam'mbali. Pambuyo pake, monga nthawi zonse, dinani batani "Zabwino".
- Gomelo lidzayikidwamobe likusamalidwa koyambirira.
Njira 5: ikani chithunzi
Chifukwa cha kulumikizidwa kwapadera, mutha kukopera chilichonse chomwe chikuwoneka papepala, kuphatikizapo tebulo, monga chithunzi.
- Koperani chinthucho pogwiritsa ntchito zida zosewerera.
- Timasankha malowo patsamba lomwe zojambulazo zidzaikidwire. Timayitanitsa menyu. Sankhani zomwe zili mmenemo "Zojambula" kapena "Chithunzi Cholumikizidwa". Poyambirira, chithunzi chomwe mwayika sichingalumikizidwe mwanjira iliyonse ndi gome la magwero. Pachiwonetsero chachiwiri, momwe mawonekedwe omwe ali patebulopo asinthidwa, chithunzicho chimasinthidwa zokha.
Pazenera lolo lolowetsa, ntchito yotere siyingachitike.
Njira 6: zolemba
Pogwiritsa ntchito phala yapadera, mutha kukopera zolemba mwachangu.
- Sankhani maselo omwe ali ndi zolemba. Timawakopera kudzera pamndandanda wanthawi yonse, pogwiritsa ntchito batani la riboni kapena kukanikiza kopanira Ctrl + C.
- Sankhani maselo omwe manotsi amayenera kuyikapo. Pitani pazenera lapadera.
- Pa zenera lomwe limatsegulira, sinthani kusinthaku "Zolemba". Dinani batani "Zabwino".
- Pambuyo pake, zolemba zidzasindikizidwa ku maselo osankhidwa, ndipo zina zonsezo sizingasinthe.
Njira 7: ikani tebulo
Pogwiritsa ntchito cholowa chapadera, mutha kusintha matebulo, matrices, ndi zinthu zina zomwe mukufuna kusinthana ndi mizati ndi mizere.
- Sankhani tebulo lomwe mukufuna kutembenuza ndikusintha pogwiritsa ntchito njira imodzi yomwe tikudziwa kale.
- Sankhani masanjidwewo papepala momwe mukufuna kuyikiramo tebulo. Timayambitsa menyu wankhaniyo ndikusankha nkhaniyo "Transpose".
Izi zitha kuchitika pogwiritsa ntchito zenera. Muna kuma kiaki, osadilanga e kwikizi kiawonso "Transpose" ndipo dinani batani "Zabwino".
- M'magawo onse awiri, kutulutsa kudzakhala gome lokhazikika, ndiye kuti, tebulo lomwe mizati ndi mizere ikusinthidwa.
Phunziro: Momwe mungatsegule tebulo ku Excel
Njira 8: gwiritsani ntchito masamu
Pogwiritsa ntchito chida chomwe tikufotokozera mu Excel, mutha kugwiranso ntchito zoyesera:
- Zowonjezera;
- Kuchulukitsa;
- Kuchotsera
- Gawoli.
Tiyeni tiwone momwe chidachi chimagwiritsidwira ntchito pa mfano wa kuchuluka.
- Choyamba, timalowa mu chipinda chopanda chopanda nambala yomwe timakonzekera kuchulukitsa kuchuluka kwathunthu pogwiritsa ntchito njira yapadera. Kenako, timakopera. Izi zitha kuchitika mwa kukanikiza kuphatikiza kiyi Ctrl + C, ndikuyitanitsa menyu yankhaniyo kapena kugwiritsa ntchito zida zogwiritsa ntchito pokopera pa tepi.
- Sankhani mtundu womwe uli patsamba lomwe tiyenera kuchulukitsa. Dinani pa kusankha ndi batani la mbewa yoyenera. Pazosankha zomwe zimatsegulira, dinani kawiri pazinthuzo "Ikani mwapadera ...".
- Zenera limayatsidwa. Gululi gulu "Ntchito" ikani kusintha Kuchulukitsa. Kenako dinani batani "Zabwino".
- Monga mukuwonera, izi zitatha, mphamvu zonse za magulu osankhidwa zidachulukitsidwa ndi nambala yomwe idasindidwa. M'malo mwathu, nambala iyi 10.
Mwa mfundo yomweyo, kugawa, kuwonjezera komanso kuchotsa zingachitike. Ndi izi zokha, pazenera, muyenera kukonzanso kusintha komwe "Gawani", Pindani kapena Chotsani. Kupanda kutero, machitidwe onse ali ofanana ndi pamanja.
Monga mukuwonera, kuyika kwapadera ndi chida chothandiza kwambiri kwa wogwiritsa ntchito. Kugwiritsa ntchito, simungathe kutsata zosanja zonse zomwe zili mu khungu kapena mzere, koma ndikuzigawa m'magawo osiyanasiyana. Poterepa, ndizotheka kuphatikiza zigawozi ndi mzake. Kuphatikiza apo, pogwiritsa ntchito chida chomwechi, masamu amatha kuchitidwa. Zachidziwikire, kupeza kwa luso logwiritsa ntchito ukadaulowu kumathandiza kwambiri ogwiritsa ntchito njira yophunzitsira Excel yonse.
