Kugwira ntchito ndi wotchulidwa mu Microsoft Excel

Chimodzi mwa zipangizo zomwe zimachepetsa kugwira ntchito ndi malemba ndikukuthandizani kuti mukwaniritse ntchito ndi deta yanuyi ndi ntchito ya mayina ku zigawo izi. Choncho, ngati mukufuna kutchula deta yosiyanasiyana, simukuyenera kulemba zovuta zambiri, koma zokwanira kuti ziwonetse dzina losavuta, limene inuyo munapanga kalepo. Tiyeni tipeze mitu yeniyeni ndi ubwino wogwira ntchito ndi maina ake.

Dzina lotchedwa malo operekera

Malo otchulidwapo ndi malo amaselo omwe apatsidwa dzina lenileni ndi wogwiritsa ntchito. Pachifukwa ichi, dzina ili limatengedwa ndi Excel monga adiresi ya dera lachindunji. Zingagwiritsidwe ntchito m'mawu ndi zifukwa zomveka, komanso mu zida zamakono za Excel, mwachitsanzo, "Kuvomereza Makhalidwe Abwino".

Pali zofunikira zoyenera kuti dzina la gulu la maselo likhale:

  • Sitiyenera kukhala ndi mipata;
  • Icho chiyenera kuyamba ndi kalata;
  • Kutalika kwake sikuyenera kupitirira zilembo 255;
  • Sayenera kuyimilidwa ndi makonzedwe a mawonekedwe. A1 kapena R1C1;
  • Bukhulo siliyenera kukhala dzina lomwelo.

Dzina la selolo likhoza kuwonedwera pamene lasankhidwa mu munda, lomwe lili kumanzere kwa bar.

Ngati dzina silinaperekedwe kuzinthu zosiyanasiyana, ndiye m'munda wapamwambawu, pamene tawonetsedwera, adiresi yam'mbali yakumtunda ya sezere akuwonetsedwa.

Kupanga dzina lotchulidwa

Choyamba, phunzirani momwe mungapangire dzina lotchulidwa mu Excel.

  1. Njira yofulumira komanso yosavuta yogawira dzina ndizolemba ndizolemba m'munda mwachindunji mutasankha malo ofanana. Choncho, sankhani mndandanda ndikulowa m'munda dzina limene tikuona kuti ndilofunikira. Ndi zofunika kuti zikumbukiridwe mosavuta ndi zofanana ndi zomwe zili mu maselo. Ndipo, ndithudi, nkofunikira kuti ikhale ndi zofunikira zowonjezera zomwe zatchulidwa pamwambapa.

  2. Kuti pulogalamuyi ilowe muyina ili muwembetsembera yake ndikuikumbukira, dinani pa fungulo Lowani. Dzina lidzatumizidwa ku malo osankhidwa.

Pamwambapo idatchulidwa mwachangu njira yogawa dzina, koma ili kutali ndi lokha. Ndondomekoyi ikhonza kupangidwanso kudzera m'ndandanda wamakono.

  1. Sankhani zomwe mukufuna kuchita. Timasankha pakasankhidwe ndi batani laling'ono la mouse. Mndandanda umene umatsegulira, asiye kusankha kusankha "Lembani dzina ...".

  2. Dzina lakuti kulenga zitsegulira. Kumaloko "Dzina" dzina liyenera kuyendetsedwa molingana ndi zifukwa zomwe tatchula pamwambapa. Kumaloko "Mtundu" imasonyeza adiresi ya gulu losankhidwa. Ngati mwasankha bwino, ndiye kuti simukusowa kusintha m'dera lino. Dinani pa batani "Chabwino".

  3. Monga momwe mukuonera m'munda, dzina la deralo lapatsidwa mwachindunji.

Kuwonetsanso kwina kwa ntchitoyi kumaphatikizapo kugwiritsa ntchito zipangizo pa tepi.

  1. Sankhani malo a maselo omwe mukufuna kutembenuza kuwatchulidwa. Pitani ku tabu "Maonekedwe". Mu gulu "Mayina Otchulidwa" dinani pazithunzi "Lembani Dzina".

  2. Zimatsegula chimodzimodzi mawindo omwe amatchulidwa monga momwe zilili kale. Ntchito zowonjezera zonse zikuchitidwa chimodzimodzi mofanana.

Njira yotsiriza yogawa dzina la selo, yomwe tidzakayang'ana, ndiyogwiritsira ntchito Woyang'anira Dzina.

  1. Sankhani mndandanda. Tab "Maonekedwe"timakani pa chithunzi chachikulu Woyang'anira Dzinaonse omwe ali mu gulu lomwelo "Mayina Otchulidwa". Mwinanso, mungathe kugwiritsa ntchito njira yomasulira mmalo mwake. Ctrl + F3.

  2. Yatsegula zenera Woyang'anira dzina. Iyenera kudina pa batani "Pangani ..." mu ngodya ya kumanzere kumanzere.

  3. Ndiye, kale fayilo yodziwika bwino yowonekera yowonekera, pamene mukuyenera kuchita zochitika zomwe takambirana pamwambapa. Dzina limene lidzaperekedwa ku gulu likuwonetsedwa Kutumiza. Ikhoza kutsekedwa podindira pa batani omaliza omwe ali kumtunda wakumanja.

Phunziro: Mungapereke bwanji dzina la selo kwa Excel

Ntchito Zogwiritsidwa Ntchito

Monga tafotokozera pamwambapa, mayina omwe angatchulidwe angagwiritsidwe ntchito pochita ntchito zosiyanasiyana ku Excel: ma formula, ntchito, zipangizo zamakono. Tiyeni titenge chitsanzo cha konkire cha momwe izi zimachitikira.

Pa pepala limodzi tili ndi mndandanda wa zitsanzo zamakina a kompyuta. Tili ndi ntchito pa pepala lachiwiri mu tebulo kuti tipeze mndandanda wotsika pansi.

  1. Choyamba, pa pepala lamndandanda, timapereka dzina loyendetsa ndi njira iliyonse yomwe tafotokozera pamwambapa. Chotsatira chake, posankha mndandanda m'munda, tifunikira kuwonetsera dzina. Lembani dzinali "Zithunzi".

  2. Pambuyo pake timasunthira pa pepala pomwe pali tebulo limene tiyenera kupanga mndandanda wamatsitsi. Sankhani malo omwe ali patebulo limene tikukonzekera kutsegula mndandanda wotsika. Pitani ku tabu "Deta" ndipo dinani pa batani "Verification Data" mu chigawo cha zipangizo "Kugwira ntchito ndi deta" pa tepi.

  3. Muzenera yowonetsera deta yomwe imayambira, pitani ku tab "Zosankha". Kumunda Mtundu wa Deta " sankhani mtengo "Lembani". Kumunda "Gwero" mu nthawi yowonongeka, muyenera kulowetsa mwachindunji zinthu zonse za mndandanda wotsikirapo, kapena kuyika chiyanjano ku mndandanda wawo, ngati uli m'kalembedwe. Izi sizili bwino, makamaka ngati mndandanda uli pa pepala lina. Koma kwa ife, chirichonse chimakhala chophweka kwambiri, chifukwa ife tinapatsa dzina ku zofananazo. Kotero ingoikani chizindikiro zofanana ndipo lembani dzina ili m'munda. Mawu otsatirawa akupezeka:

    = Zithunzi

    Dinani "Chabwino".

  4. Tsopano, pamene mutsegula chithunzithunzi pa selo iliyonse muyeso yomwe timagwiritsira ntchito kufufuza deta, katatu kamangowonekera kumanja kwake. Kusindikiza pa katatu iyi kumatsegula mndandanda wa deta yowonjezera, yomwe imachokera pa mndandanda pa pepala lina.

  5. Timangoyenera kusankha njira yomwe tikufuna kuti phindu lichoke mndandanda wawonetsedwa mu selo losankhidwa pa tebulo.

Maina otchulidwawo ndi othandizira kuti agwiritse ntchito ngati zifukwa zosiyanasiyana. Tiyeni tiwone momwe izi zikugwiritsidwira ntchito pakuchita ndi chitsanzo chapadera.

Kotero, ife tiri ndi tebulo momwe mapindu a mwezi uliwonse a nthambi za malonda akulembedwera. Tiyenera kudziwa malipiro onse a Nthambi 1, Nthambi 3 ndi Nthambi 5 pa nthawi yonse yomwe ikuwonetsedwa patebulo.

  1. Choyamba, timapatsa dzina pamzere uliwonse wa nthambi yomwe ili ofanana ndiyi. Kwa Nthambi 1, sankhani deralo ndi maselo omwe ali ndi deta pa ndalama kwa miyezi itatu. Pambuyo posankha dzina mumunda "Branch_1" (musaiwale kuti dzina silingakhale ndi malo) ndipo dinani pa fungulo Lowani. Dzina la malo olingana lidzapatsidwa. Ngati mukufuna, mungagwiritse ntchito dzina lina lililonse, lomwe linakambidwa pamwambapa.

  2. Mofananamo, kuwonetsa malo oyenera, timapereka mayina a mizere ndi nthambi zina: "Branch_2", "Branch_3", "Branch_4", "Branch_5".

  3. Sankhani zomwe zili pamasamba omwe summation sum adzawonetsedwa. Timakani pa chithunzi "Ikani ntchito".

  4. Yambani ndiyambitsidwa. Oyang'anira ntchito. Kusunthira "Masamu". Lekani kusankha kuchokera pa mndandanda wa ogwira ntchito omwe alipo pa dzina "SUMM".

  5. Kugwiritsa ntchito zenera zotsutsana ndiwindo SUM. Ntchito imeneyi, yomwe ili mbali ya gulu la masamu, ikukonzekera makamaka kufotokozera ziwerengero. Chidulechi chikuyimiridwa ndi ndondomeko zotsatirazi:

    = SUM (nambala1; nambala2; ...)

    Zomwe sizili zovuta kumvetsa, wogwiritsa ntchito mwachidule amafotokozera mwachidule mfundo zonse za gululo. "Nambala". Mu mawonekedwe a zifukwa, ziwerengero zonsezi zingagwiritsidwe ntchito, komanso mafotokozedwe a maselo kapena mzere omwe ali. Pamene magalasi amagwiritsidwa ntchito ngati zotsutsana, chiwerengero cha zikhalidwe zomwe zili muzinthu zawo, zowerengedwa kumbuyo, zimagwiritsidwa ntchito. Tikhoza kunena kuti "tikudumpha" pogwiritsa ntchito. Ndiko kuthetsa vuto lathu kuti chidule cha mndandanda chidzagwiritsidwe ntchito.

    Onse opanga SUM akhoza kukhala ndi zifukwa zokwana 255 mpaka ziwiri. Koma kwa ife, tidzakhala ndi zifukwa zitatu zokha, popeza tiwonjezera mautatu atatu: "Branch_1", "Branch_3" ndi "Branch_5".

    Choncho, ikani chotsekeramo kumunda "Number1". Popeza tinapatsa mayina a mitsinje yomwe iyenera kuwonjezeredwa, ndiye palibe chifukwa cholowetsamo makonzedwe m'munda kapena kuwonetsera zofanana pa pepala. Zokwanira kuti tisiye dzina la mndandanda kuti uwonjezere: "Branch_1". M'minda "Number2" ndi "Number3" Choncho pangani mbiri "Branch_3" ndi "Branch_5". Zotsatirazi zitatha, timangodutsa "Chabwino".

  6. Chotsatira cha kuwerengetsera chikuwonetsedwa mu selo yomwe idapatsidwa asanapite Mlaliki Wachipangizo.

Monga momwe mukuonera, kupatsidwa dzina kwa magulu a maselo m'bungwe ili kunathandiza kuthetsa ntchito yowonjezera mawerengero omwe ali nawo, poyerekeza ngati tikugwira ntchito ndi ma adresse, osati maina.

Zoonadi, zitsanzo ziwiri zomwe tazitchula pamwambazi zikuwonetsera kutali ndi ubwino ndi mwayi wonse wogwiritsira ntchito mndandanda wa mayina pamene mukuwagwiritsa ntchito ngati gawo la ntchito, mayina ndi zida zina za Excel. Zosiyanasiyana za kugwiritsira ntchito zida, zomwe zinapatsidwa dzina, zopanda malire. Komabe, zitsanzozi zimatithandizanso kumvetsetsa ubwino waukulu wopereka mayina kumadera a pepala poyerekeza ndi kugwiritsa ntchito maadiresi awo.

PHUNZIRO: Momwe mungawerengere ndalama mu Microsoft Excel

Kutchedwa Management Range

Kusamalira malo omwe atchulidwawo ndi ophweka kwambiri Woyang'anira dzina. Pogwiritsira ntchito chida ichi, mungathe kugawa maina kuti asinthe ma selo ndi maselo, kusintha malo omwe kale amatchulidwa kale ndi kuwathetsa. Momwe mungayankhire dzina ndi Kutumiza tinayankhula kale, ndipo tsopano tikuphunzira momwe tingagwiritsire ntchito njira zina.

  1. Kuti mupite Kutumizasungani ku tabu "Maonekedwe". Kumeneko muyenera kudina pa chithunzi, chomwe chimatchedwa Woyang'anira Dzina. Chithunzi chododometsedwa chili mu gululo "Mayina Otchulidwa".

  2. Mukapita Kutumiza Kuti muyambe kugwiritsira ntchito zofunikira, muyenera kupeza dzina lake m'ndandanda. Ngati mndandanda wa zinthu sizowonjezereka, ndiye kuti ndi zophweka kuchita izi. Koma ngati bukhuli liripo ambirimbiri omwe amatchulidwa malemba kapena zambiri, ndiye kuti ntchitoyi ikhale yogwira ntchito pogwiritsa ntchito fyuluta. Timasankha pa batani "Fyuluta"iikidwa kumbali yakumanja yawindo. Kuwonetsa kungathe kuchitika m'madera otsatirawa posankha chinthu choyenera pa menyu yomwe imatsegula:
    • Mayina pa pepala;
    • mu bukhu;
    • ndi zolakwika;
    • palibe zolakwika;
    • Mayina enieni;
    • Mayina a matebulo.

    Kuti mubwerere ku mndandanda wa zinthu, sankhani kusankha "Tsitsani Fyuluta".

  3. Kusintha malire, mayina, kapena katundu wina wa wotchulidwapo, sankhani chinthu chomwe mukufuna Kutumiza ndi kukankhira batani "Sintha ...".

  4. Dzina lamasintha kusintha. Lili ndi madera omwewo monga zenera popanga dzina lotchulidwa, lomwe tinalankhula kale. Ndi nthawi iyi yomwe minda idzadzazidwa ndi deta.

    Kumunda "Dzina" Mukhoza kusintha dzina laderalo. Kumunda "Zindikirani" Mukhoza kuwonjezera kapena kusintha ndemanga yomwe ilipo kale. Kumunda "Mtundu" Mukhoza kusintha adiresi ya dzina lake. N'zotheka kuchita izi mwa kugwiritsa ntchito njira yowunikira maofesi omwe akufunikira, kapena poika chithunzithunzi m'munda ndikusankha maselo ofanana pa pepala. Adilesi yake idzawonekera mwamsanga kumunda. Malo okhawo omwe makhalidwe sangathe kusintha - "Malo".

    Pambuyo pa kusintha kwa deta kwatha, dinani pa batani. "Chabwino".

Ndiponso mu Kutumiza ngati ndi kotheka, mukhoza kuchita njira yochotsera dzina lake. Pachifukwa ichi, ndithudi, si malo omwe ali pa pepala pawokha adzachotsedwa, koma dzina lake lapatsidwa. Choncho, mutatha kukwaniritsa, ndondomekoyi ikhoza kupezedwa kudzera m'makonzedwe ake.

Izi ndi zofunika kwambiri, popeza ngati mwagwiritsa ntchito kale dzina lochotsedweramo muzondomeko, ndiye mutachotsa dzinalo, njirayi idzakhala yolakwika.

  1. Kuti muzitsatira ndondomeko yochotsamo, sankhani chinthu chofunika kuchokera m'ndandanda ndipo dinani pa batani "Chotsani".

  2. Pambuyo pa izi, bokosi la bokosi lidayambika, lomwe likukufunsani kuti mutsimikizire kuti mwatsimikiza kuchotsa chinthucho. Izi zatsimikiziridwa kuti tipewe wogwiritsa ntchito molakwika kutsatira njirayi. Kotero, ngati muli otsimikiza kuti mukufunika kuchotsa, ndiye kuti muyenera kutsegula pa batani. "Chabwino" mu bokosi lotsimikizira. Pankhani ina, dinani pa batani. "Tsitsani".

  3. Monga mukuonera, chinthu chosankhidwa chachotsedwa pa mndandanda. Kutumiza. Izi zikutanthauza kuti mndandanda womwe unayikidwamo unatayika dzina lake. Tsopano izo zidziwika kokha ndi makonzedwe. Pambuyo pazochitika zonse Kutumiza malizitsani, dinani batani "Yandikirani"kukwaniritsa zenera.

Kugwiritsira ntchito dzina lotchulidwa kungapangitse kukhala kosavuta kugwira ntchito ndi mawonekedwe, ntchito, ndi zida zina za Excel. Zina zotchulidwazo zimatha kulamulidwa (kusinthidwa ndi kuchotsedwa) pogwiritsa ntchito apadera Kutumiza.

Posts Popular

https://termotools.com ny.termotools.com © Excel 2024