MNDANDANDA WOTSIKA PANSI WA EXCEL

Kupanga mndandanda wotsika pansi sikulola kungosiya nthawi posankha zosankhidwa pokonzekera matebulo, komanso kudzitetezera ku zopereka zolakwika za deta yolondola. Ichi ndi chida chabwino komanso chothandiza kwambiri. Tiyeni tipeze momwe tingawathandizire ku Excel, ndi momwe tingagwiritsire ntchito, komanso tiphunzire zina zomwe zingathe kuchitapo kanthu.

Pogwiritsa ntchito ndandanda yochepetsedwa

Kutsika pansi, kapena monga akunena, mndandanda wazomwe amagwiritsidwa ntchito nthawi zambiri m'matawuni. Ndi chithandizo chawo, mungathe kuchepetsa miyeso yamtengo wapatali yomwe yalowa mu tebulo. Amakulolani kuti musankhe kulowetsa malingana ndi mndandanda wokonzedweratu. Izi zimapititsa patsogolo njira yolowera deta komanso zimateteza zolakwika.

Chilengedwe

Choyamba, tiyeni tiwone m'mene tingapangire mndandanda wotsika. Njira yosavuta yochitira izi ndi chida chotchedwa "Verification Data".

Sankhani ndondomeko ya tebulo, m'maselo omwe mukukonzekera kulemba mndandanda wazitsulo. Pitani ku tabu "Deta" ndipo dinani pa batani "Verification Data". Ndilowuniyeni pa tepi mu block. "Kugwira ntchito ndi deta".

Chida chowonekera chimayambira. "Yang'anani Makhalidwe". Pitani ku gawoli "Zosankha". Kumaloko Mtundu wa Deta " sankhani kuchokera mndandanda "Lembani". Mutatha kusamukira kumunda "Gwero". Pano muyenera kufotokozera gulu la zinthu zomwe zingagwiritsidwe ntchito mndandanda. Mayina awa akhoza kulowetsedwa pamanja, kapena mungathe kuwagwirizanitsa ngati atayikidwa kale mu kafukufuku wa Excel kwinakwake.
Ngati njira yowonjezera imasankhidwa, ndiye mndandanda uliwonse wa mndandanda umayenera kulowa m'deralo kudzera mu semicolon (;).
Ngati mukufuna kukoka deta kuchokera pa tebulo yomwe ilipo kale, pita ku pepala komwe ili (ngati ili pamtunda wina), ikani malonda m'deralo "Gwero" mawindo otsimikizira deta, ndiyeno musankhe maselo osiyanasiyana omwe mndandanda ulipo. Nkofunika kuti selo lirilonse likhale ndi mndandanda wosiyana mndandanda. Pambuyo pake, makonzedwe a mtundu wotchulidwawo ayenera kuwonekera m'deralo "Gwero".
Njira inanso yothetsera kuyankhulana ndi kupereka mndandanda wa mayina. Sankhani mtundu umene ma data adatchulidwa. Kumanzere kwa bar lachondomeko ndi malo a mayina. Mwachikhazikitso, pamene chisankho chasankhidwa, makonzedwe a selo yoyamba yosankhidwa amawonetsedwa. Ife, chifukwa cha zolinga zathu, timangotchula dzina lomwe timaganizira moyenera. Zofunikira zazikuluzikulu za dzinali ndizosiyana kwambiri ndi bukhuli, alibe malo, ndipo zimayamba ndi kalata. Tsopano ndi dzina ili kuti mndandanda umene tidawazindikirako udzadziwika.
Tsopano muwindo loonetsetsa deta m'derali "Gwero" akufunika kukhazikitsa khalidwe "="ndipo mwamsanga mutangolowetsa dzina lomwe tinapereka pazomwezo. Pulogalamu yomweyo imasonyeza kugwirizana pakati pa dzina ndi mndandanda, ndipo imatulutsa mndandanda umene uli mmenemo.
Koma zidzakhala zogwira mtima kwambiri kugwiritsa ntchito mndandanda ngati utasanduka tebulo lapamwamba. Mu tebulo ngatilo kudzakhala kosavuta kusintha miyeso, motero kusintha mndandanda. Potero, kusiyana kumeneku kudzasanduka tebulo loyang'ana.
Kuti mutembenuzire mndandanda ku tebulo lapamwamba, sankhani ndikusuntha ku tabu "Kunyumba". Kumeneko timangodutsa pa batani "Pangani monga tebulo"yomwe imayikidwa pa tepi mu block "Masitala". Gulu lalikulu la mafashoni limatsegula. Kusankhidwa kwa kalembedwe kamene sikakhudza ntchito ya tebulo, choncho timasankha aliyense wa iwo.
Pambuyo pake, mawindo oyamba amatsegula, okhala ndi adiresi ya osankhidwa. Ngati chisankhocho chinapangidwa molondola, palibe chomwe chiyenera kusintha. Kuchokera pazomwe tili nazo mulibe mutu, chinthu "Mndandanda ndi mutu" tsikidzi sayenera kukhala. Ngakhale kuti mwatsatanetsatane mwa inu, mwinamwake mutuwo udzagwiritsidwa ntchito. Kotero ife tikungoyenera kukankhira batani. "Chabwino".
Pambuyo potsatila izi zidzapangidwira monga tebulo. Ngati mumasankha, mukhoza kuwona m'munda wa dzina lomwe mwadzidzidzi linapatsidwa. Dzina ili lingagwiritsidwe ntchito poyika m'deralo. "Gwero" muzenera zowonetsera deta pogwiritsa ntchito algorithm yomwe tafotokoza kale. Koma, ngati mukufuna kugwiritsa ntchito dzina losiyana, mukhoza kulisintha m'malo polemba mayina.
Ngati mndandanda waikidwa mu bukhu lina, ndiye kuti muwonetsetse bwino, muyenera kugwiritsa ntchito ntchitoyi FLOSS. Wogwiritsidwa ntchitoyo akukonzekera kuti apange maunjano "apamwamba-mtheradi" ku mapepala omwe ali ndi mawonekedwe olembera. Kwenikweni, ndondomekoyi idzachitidwa pafupifupi chimodzimodzi ndi zomwe zafotokozedweratu kale, m'munda wa "Gwero" pambuyo pa khalidwe "=" ayenera kusonyeza dzina la wogwiritsira ntchito - "DVSSYL". Pambuyo pake, adiresi ya zosiyana, kuphatikizapo dzina la bukhulo ndi pepala, ayenera kufotokozedwa ngati kutsutsana kwa ntchitoyi pakati pa makolo. Kwenikweni, monga momwe zasonyezera mu fano ili m'munsimu.

Panthawiyi tikhoza kumaliza njirayi podindira pa batani. "Chabwino" muwindo lowonetsetsa deta, koma ngati mukufuna, mukhoza kusintha mawonekedwe. Pitani ku gawoli "Mauthenga Odziwika" tsamba loonetsetsa deta. Kuno kudera "Uthenga" Mukhoza kulemba mawu omwe abasebenzisi awone pozembera pa mndandanda wa mndandanda ndi mndandanda wotsika. Timalemba uthenga umene timawona kuti uli wofunikira.

Kenaka, pita ku gawo "Uthenga Wolakwika". Kuno kudera "Uthenga" Mukhoza kulemba malemba omwe wogwiritsa ntchito angayang'ane pamene mukuyesa kulumikiza deta yolondola, ndiko kuti, deta iliyonse yomwe ilibe mndandanda wotsika. Kumaloko "Onani" Mukhoza kusankha chizindikiro chomwe chidzaperekedwa ndi chenjezo. Lowani mawu a uthengawo ndipo dinani "Chabwino".

PHUNZIRO: Momwe mungapangire mndandanda wotsika mu Excel

Kuchita ntchito

Tsopano tiyeni tiwone momwe tingagwiritsire ntchito ndi chida chomwe tachipanga pamwambapa.

Ngati tiyika cholozera pa chinthu chilichonse cha pepala chomwe mndandanda wazomwe wagwiritsidwa ntchito, tidzatha kuona uthenga wothandizira womwe talowa kale pawindo lazitsimikizidwe. Komanso, chizindikiro cha katatu chidzaonekera kumanja kwa selo. Zomwe zimathandiza kupeza mndandanda wamndandanda. Ife tikukanikiza pa triangleyi.

Pambuyo pajambulira, mndandanda wa mndandanda wa zinthu udzatsegulidwa. Lili ndi zinthu zonse zomwe zinalowetsedweratu kudzera muzenera lazitsimikizidwe. Timasankha njira yomwe timaganiza kuti ndi yofunika.

Njira yosankhidwa ikuwonetsedwa mu selo.

Ngati tiyesa kulowa mu selo ubwino uliwonse umene suli mndandanda, ndiye kuti zotsatirazi zidzatsekedwa. Panthawi imodzimodziyo, ngati mutalowa uthenga wochenjeza pawindo loonetsetsa deta, liwonetsedwe pazenera. Ndikofunika pawindo lochenjeza kuti lidine pa batani. "Tsitsani" ndipo potsatira kuyesa kulumikiza deta yolondola.

Mwanjira iyi, ngati kuli koyenera, lembani tebulo lonse.

Kuwonjezera chinthu chatsopano

Koma bwanji ngati mukufunikabe kuwonjezera chinthu chatsopano? Zochita apa zimadalira momwe mwakhazikitsira ndandanda muzenera lazowunikira deta: inalowa mwachindunji kapena kuchotsedwa pa tebulo.

Ngati deta yopanga mndandanda imachokera pa tebulo, pita kwa iyo. Sankhani seloli. Ngati izi siziri tebulo lapamwamba, koma ndi deta yosavuta, ndiye kuti mukufunika kuyika chingwe pakati pa gulu. Ngati mumagwiritsa ntchito tebulo "wochenjera," pakadali pano ndikwanira kuti mulowe muyeso wofunikira mumzere woyamba pansipa ndipo mzerewu udzaphatikizidwa patebulo. Izi ndizo phindu la tebulo lapamwamba lomwe talitchula pamwambapa.
Koma tiyerekeze kuti tikukumana ndi vuto lovuta kwambiri, pogwiritsa ntchito mtundu wozolowereka. Choncho, sankhani selo pakati pa ndondomekoyi. Ndiko, pamwamba pa selo ili pansi pake, payenera kukhala mizere yambiri. Timasindikiza chidutswa chodindidwa ndi batani lamanja la mouse. Mu menyu, sankhani kusankha "Sakani ...".

Fenera yayambika, kumene muyenera kusankha chinthu chosungira. Sankhani njira "Mzere" ndipo dinani pa batani "Chabwino".

Kotero mzere wopanda kanthu wawonjezedwa.

Ife timalowa mmenemo mtengo umene tikufuna kuti uwonetsedwe mndandanda wotsika.

Pambuyo pake, ife tibwerera ku gome lomwe mndandanda wotsikawu uli. Pogwiritsa ntchito katatu kumanja kwa selo iliyonse, titha kuona kuti phindu limene tikulifuna linaphatikizidwa kuzinthu zomwe zilipo kale. Tsopano, ngati mukukhumba, mukhoza kusankha kuti muyiike muyibulo la tebulo.

Koma choyenera kuchita chiyani ngati mndandanda wazinthu sizingatengedwe kuchokera pa tebulo lapadera, koma unalowa mkati mwawo? Kuonjezera chinthu chofunika pa nkhaniyi, nachonso, chiri ndi zochita zake zokha.

Sankhani mndandanda wonse wa tebulo, zomwe zilipo mndandanda wotsika pansi. Pitani ku tabu "Deta" ndipo dinani pa batani kachiwiri "Verification Data" mu gulu "Kugwira ntchito ndi deta".

Fayilo yowonjezera yowonjezera ikuyamba. Pitani ku gawo "Zosankha". Monga momwe mukuonera, zoikidwiratu zonse ziri chimodzimodzi monga taziika kale. Ife tiri mu nkhaniyi tidzakhala ndi chidwi ndi dera "Gwero". Ife tikuwonjezera apo ku mndandanda womwe uli nawo kale, wolekanitsidwa ndi semicolon (;) mtengo kapena mfundo zomwe tikufuna kuziwona mundandanda wazitsitsa. Titatha kuwonjezera ife dinani "Chabwino".

Tsopano, ngati titsegula mndandanda wazitsulo mu tebulo, tidzawona mtengo wapatali kumeneko.

Chotsani chinthu

Kutulutsidwa kwa mndandanda wa mndandanda ukuchitidwa molingana ndi ndondomeko yomweyo monga Kuwonjezera.

Ngati deta ikuchotsedwera kuchokera pa tebulo, pita ku tebulo ili ndikugwiritsira ntchito pang'onopang'ono mu selo komwe mtengo ulipo, umene uyenera kuchotsedwa. Muzolemba zamkati, sankhani kusankha "Chotsani ...".

Fenera la kuchotsa maselo likuyamba ndi chimodzimodzi monga momwe tawonera pamene tiwawonjezera. Pano ife tinayambanso kusinthanso ku malo "Mzere" ndipo dinani "Chabwino".

Chingwe chochokera pa tebulo, monga tikuwonera, chatsuka.

Tsopano ife tibwerera ku tebulo kumene maselo okhala ndi mndandanda wotsika pansi alipo. Timakani pa katatu kumanja kwa selo iliyonse. M'ndandanda imene imatsegulidwa, tikuwona kuti chinthu chochotsedwacho chikusowa.

Zomwe mungachite ngati mfundo zowonjezera zowonjezedwa pawindo lazitsimikizidwe, osati pogwiritsa ntchito tebulo lina?

Sankhani ndondomeko ya tebulo ndi mndandanda wotsika pansi ndipo pita kuwindo kuti muyang'ane zoyenera, monga momwe tachita kale. Muwindo lofotokozedwa, pita ku gawolo "Zosankha". Kumaloko "Gwero" sankhani mtengo womwe mukufuna kuchotsa ndi chithunzithunzi. Kenaka dinani pa batani Chotsani pabokosi.

Chinthucho chitachotsedwa, dinani "Chabwino". Tsopano sizidzakhala mundandanda wotsika pansi, mofanana ndi momwe tawonera mu njira yapitayi ndi tebulo.

Kuchotsa kwathunthu

Pa nthawi yomweyi, pali mndandanda umene mndandanda wotsikawu uyenera kuchotsedwa kwathunthu. Ngati ziribe kanthu kwa inu kuti deta yolumikizidwa inasungidwa, ndiye kuchotsa ndi kosavuta.

Sankhani gulu lonse pamene mndandanda wotsikawu ulipo. Pitani ku tabu "Kunyumba". Dinani pazithunzi "Chotsani"yomwe imayikidwa pa tepi mu block Kusintha. Mu menyu yomwe imatsegula, sankhani malo "Chotsani Zonse".

Izi zikadzasankhidwa, mfundo zonse zomwe zili muzasankhidwazo zidzasulidwa, kukonzedweratu kudzasulidwa, komanso kuonjezera, cholinga chachikulu cha ntchitoyo chidzakwaniritsidwa: mndandanda wazitsulo udzachotsedwa ndipo tsopano mukhoza kulowetsa malingaliro aliwonse mumaselo.

Kuwonjezera apo, ngati wogwiritsa ntchito sakufunika kusunga deta, ndiye kuti pali njira ina yochotsera mndandanda wotsika.

Sankhani zamtundu uliwonse zopanda kanthu, zomwe ziri zofanana ndi zigawo zosiyana siyana ndi mndandanda wotsika. Pitani ku tabu "Kunyumba" ndipo pomwepo ife timakani pa chithunzi "Kopani"yomwe ili pamtengowu m'deralo "Zokongoletsera".
Ndiponso, mmalo mwachitachi, mungathe kudula chidutswa chowonetsedwa ndi batani lamanja la mouse ndikuima pazomwe mungasankhe "Kopani".
N'zosavuta kugwiritsa ntchito mabatani atsopano mwamsanga musanasankhe. Ctrl + C.
Pambuyo pake, sankhani chidutswa chimenecho cha gome, pomwe zinthu zowonongeka zilipo. Timakanikiza batani Sakanizanimalo okhala pa kaboni mu tabu "Kunyumba" mu gawo "Zokongoletsera".
Njira yachiwiri ndikulumikiza molondola pa chisankho ndikusiya kusankha pazomwe mungasankhe Sakanizani mu gulu "Njira Zowonjezera".
Pomaliza, n'zotheka kuwonetsa maselo omwe mukufunayo ndikulemba mawonekedwe a mabatani. Ctrl + V.
Pa chilichonse cha pamwambapa, mmalo mwa maselo omwe ali ndi mndandanda wamtengo wapatali ndi wotsika pansi, chidutswa choyera kwambiri chidzaikidwa.

Ngati mukufuna, mwanjira yomweyi, simungathe kuyikapo kanthu kopanda pake, koma chidutswa chopangidwa ndi deta. Chosavuta cha mndandanda wotsikirapo ndikuti simungathe kulemba ma data omwe sali m'ndandanda, koma mukhoza kulilemba ndi kuliyika. Pankhaniyi, kufufuza deta sikugwira ntchito. Komanso, monga momwe tawonera, kapangidwe kowonongeka komweko kadzawonongedwa.

Kawirikawiri, mumayenera kuchotsa mndandanda wotsika pansi, koma panthawi imodzimodziyo musiye makhalidwe omwe adalowa nawo pogwiritsa ntchito, ndi kupanga. Pankhaniyi, zochita zowonjezereka ziyenera kutengedwa kuchotsa chida chodziwika.

Sankhani chidutswa chonse chimene zinthu ndi mndandanda wotsika pansi ulipo. Pitani ku tabu "Deta" ndipo dinani pazithunzi "Verification Data"zomwe, monga tikukumbukira, zitayikidwa pa tepi mu gululo "Kugwira ntchito ndi deta".

Fayilo lovomerezeka lodziwika bwino limatsegulidwa. Pokhala mu gawo lirilonse la chida chodziwika, tifunika kuchita chinthu chimodzi - dinani pa batani. "Chotsani Zonse". Icho chiri kumbali ya kumanzere kumanzere kwa zenera.

Pambuyo pake, mawindo otsimikizira deta akhoza kutsekedwa podindira pa batani omaliza omwe ali pamtunda wa kumanja kwa mawonekedwe a mtanda kapena pa batani "Chabwino" pansi pazenera.

Kenaka sankhani maselo aliwonse omwe mndandanda wazomwe unayikidwapo poyamba. Monga momwe mukuonera, tsopano palibe chodabwitsa posankha chinthucho, ngakhalenso katatu kuti muyitanidwe kumanja kwa selo. Koma panthawi imodzimodziyo, maonekedwe ndi zikhalidwe zonse zomwe adalowa pogwiritsa ntchito mndandanda adakalibe. Izi zikutanthauza kuti tinagonjetsa bwino ntchitoyi: chida chimene sitimasowa chikuchotsedwa, koma zotsatira za ntchito yake zidakali zogwirizana.

Monga momwe mukuonera, mndandanda wazitsulo ungathandize kwambiri kukhazikitsa deta m'matawuni, komanso kuteteza kuyambitsidwa kwa ziyeso zolakwika. Izi zidzachepetsa chiwerengero cha zolakwika pamene mukudzaza matebulo. Ngati phindu lililonse liyenera kuwonjezeredwa, ndiye kuti nthawi zonse mukhoza kuchita ndondomeko yokonza. Njira yosintha idzadalira njira yolenga. Pambuyo mutadzaza tebulo, mukhoza kuchotsa mndandanda wotsika pansi, ngakhale kuti sikoyenera kuchita izi. Ambiri ogwiritsa ntchito amakonda kusiya izo ngakhale atamaliza ntchito pakudza tebulo ndi deta.