Mndandanda wa Excel

Kupanga mindandanda yotsika sikumangopulumutsa nthawi mukamasankha njira yomwe mungasankhire matebulo, komanso kuti mudziteteze ku zolakwika zolakwika. Ichi ndi chida chosavuta komanso chothandiza. Tiyeni tiwone momwe mungayambitsere mu Excel, ndi momwe mungagwiritsire ntchito, komanso kudziwa zina zakusintha.

Kugwiritsa ntchito mindandanda yotsika

Kutsatira, kapena monga chizolowezi kuyankhula, mndandanda womwewo pansi umagwiritsidwa ntchito nthawi zambiri pamagome. Mothandizidwa ndi thandizo lawo, mutha kuchepetsa zinthu zosiyanasiyana zomwe zapangidwa patebulo. Amakulolani kusankha kuti mupange mtengo wokha kuchokera mndandanda wokonzekereratu. Izi zimathandizira kuti mupange njira yopangira deta ndikuteteza ku cholakwika.

Ndondomeko Yopanga

Choyamba, tiyeni tiwone momwe mungapangire mndandanda wotsalira. Ndizosavuta kuchita izi ndi chida chotchedwa "Dance Check".

1. Timatsindika za mndandanda wa matebulo, m'maselo omwe amakonzekera kuyika mndandanda womwe watsikira. Kusunthira mu "deta" ndi dongo pa batani la "Data Check". Imakhazikika pa riboni mu "kugwira ntchito ndi deta" block.



2. Kholo la "Chitsimikizo" limayamba. Pitani ku "magawo". Mu "mtundu wa data" kuchokera pamndandanda, sankhani "mndandanda". Pambuyo pake, timasunthira ku "Gwero". Apa mukufunika kutchula gulu la mayina omwe amagwiritsidwa ntchito pamndandanda. Mayina awa amatha kupangidwa pamanja, ndipo mutha kufotokozera kuti angalankhule ndi iwo ngati atumizidwa kale mu Excel pamalo ena.

   Ngati kulowa kwamanja kumasankhidwa, ndiye kuti mndandanda uliwonse umafunikira kulowa m'deralo pa semicolon (;).

   

   Ngati mukufuna kukweza deta ya tebuloni yomwe ilipo, ndiye kuti muyenera kupita ku pepala lomwe lili (ngati lili pa chimzake), ikani chotembereredwa pazenera la data ya data , kenako sonyezani maselo angapo momwe mndandandawo uliri. Ndikofunika kuti maselo onse osiyana apezeka pamndandanda wapadera. Pambuyo pake, magwiridwe antchito a mtunduwo uyenera kuwonetsedwa m'dera la "Gwero".

   

   Njira ina kukhazikitsa kulumikizana ndi gawo latsambalo ndi mndandanda wa dzinalo. Sankhani kuchuluka komwe mfundo za data zikuwonetsedwa. Kumanzere kwa chingwe cha formula ndi dera la mayina. Mwachisawawa, mkati mwake, ikasankhidwa, magwiridwe antchito a selo yosankhidwa amawonetsedwa. Tikulowa m'dzinalo kuti tipeze mfundo zathu, zomwe timazilingalira moyenera. Zofunikira kwambiri pa dzina ndikuti ndizosiyana ndi bukulo, sizinali ndi mipata ndipo zinayamba ndi kalatayo. Tsopano kuti mitundu yomwe tidadziwitsidwa chinthu ichi chisanadziwike.

   

   Tsopano, mu zenera la deta mu dera la "muyenera kukhazikitsa chizindikiro cha" = ", kenako pambuyo pake kuti chilowe dzina lomwe talowamo. Pulogalamuyi imazindikira ubale womwe ulipo pakati pa dzinalo, ndipo adzakoka mndandanda womwe uli mmenemu.

   

   Koma zambiri zidzagwiritsidwa ntchito kugwiritsa ntchito mndandandandawo ngati mungasinthe tebulo la "anzeru". M'tebulo lotereli, lidzakhala losavuta kusintha zofunikira, potengera zomwe zalembedwa. Chifukwa chake, mitundu iyi isintha patebulo yoloweza.

   Pofuna kutembenuzira mtunduwo kukhala tebulo la "wanzeru", osasankha ndikuzisunthira ku tabu yakunyumba. Pamenepo, dongo pa batani "ngati tebulo", lomwe limayikidwa pa tepi mu "masitayilo" block. Gulu lalikulu limatsegulidwa. Pazogwiritsidwa ntchito patebulopo, kusankha kwa mtundu winawake sikukhudza aliyense, chifukwa chake sankhani.

   

   Pambuyo pake, zenera laling'ono limatseguka, lomwe lili ndi adilesi ya kusankha. Ngati kusankha kunachitika moyenera, ndiye kuti palibe chomwe chingasinthidwe. Popeza mtundu wathu ulibe mitu, ndiye kuti "tebulo lokhala ndi mutu" sichiyenera kukhala. Ngakhale zili choncho kwa inu, zingatheke, mutuwo udzayikidwa. Chifukwa chake titha kungodina batani la "OK".

   

   Pambuyo pake, mitunduyo idzakhazikitsidwa ngati tebulo. Ngati idagawidwa, ndiye kuti mutha kuwona m'deralo mayina, kuti dzinalo lomwe adamupatsa yekha. Dzinali litha kugwiritsidwa ntchito kuyika m'dera la "gwero" mu zenera la data molingana ndi Algorithm kale. Koma, ngati mukufuna kugwiritsa ntchito dzina lina, mutha kusintha, pangokhala pa dzina la dzinalo.

   

   Ngati mndandandawo walembedwa m'buku lina, ndiye kuti akuwonetsera molondola zomwe zikufunika kugwiritsa ntchito ntchito ya DVS. Wogwiritsa ntchitoyo adapangidwa kuti apange "superkobolite" zolemba za masamba omwe amalemba mawu. Kwenikweni, njirayi idzachitidwa chimodzimodzi monga momwe zalankhulidwe kale, kokha mu malo omwe kale anali m'deralo "=" ayenera kutchula dzina la wothandizira - "DVSL". Pambuyo pake, m'mabakaki, adilesi yamitunduyo iyenera kufotokozedwa ngati lingaliro la ntchitoyi, kuphatikizapo dzina la bukulo ndi pepala. Kwenikweni, monga taonera m'chithunzichi pansipa.



3. Pa izi tikhoza ndikumaliza njirayi podina batani la "Ok" mu zenera la data, koma ngati mukufuna, mutha kusintha mawonekedwe. Pitani ku "mauthenga kuti mulowe" gawo la zenera la data. Pano mu "uthenga" muyeso mutha kulemba zomwe ogwiritsa ntchito adzaona cholozera kwa tsamba lomwe lili ndi mndandanda wotsika. Timalemba uthenga womwe timaona kuti ndizofunikira.



4. Kenako, timasamukira ku "uthenga wolakwika". Pano mu "uthenga", mutha kulemba lembalo kuti wosuta ayang'anire polemba deta yolakwika, ndiye kuti, deta iliyonse yomwe ikusowa pamndandanda wotsika. M'dera la "Onani", mutha kusankha chizindikiro kuti mutsane ndi chenjezo. Lowetsani mawuwo ndi dongo pa "chabwino".

Phunziro: Momwe Mungapangire Mndandanda Wotsika

Kuchita Ntchito

Tsopano tiyeni tiwone momwe mungagwiritsire ntchito ndi chida chomwe tidapanga pamwambapa.

1. Ngati tikhazikitsa cholozera kwa chinthu chilichonse chomwe chili pamtunda wakhala chikugwiritsidwa ntchito, tiwona uthenga womwe umayambitsidwa ndi ife kale pazenera lotsimikizira za data. Kuphatikiza apo, chithunzi chojambula mu mawonekedwe a makona atatu chidzawonekera kumanja kwa cell. Ndizomwe zimathandizira kuti mupeze kusankha kwa zinthu. Dongo pamakona atatu.



2. Pambuyo podina pa icho, menyu kuchokera pamndandanda wa zinthu zikhala zotseguka. Muli zinthu zonse zomwe zidapangidwa kale kudzera pawindo lotsimikizika. Sankhani njira yomwe tikuona kuti ndi kofunika.



3. Njira yosankhidwa idzawonetsedwa mu khungu.



4. Ngati tiyesa kulowa mu khungu mtengo uliwonse womwe supezeka pamndandanda, izi zitsekedwa. Nthawi yomweyo, ngati mwapereka uthenga wochenjeza pawindo lotsimikizika la data, limawonetsedwa pazenera. Muyenera kudina batani la "Chotsani" pazenera lochenjeza komanso likuyesanso kulowa.

Mwanjira imeneyi, ngati kuli kotheka, dzazani tebulo lonse.

Kuwonjezera chinthu chatsopano

Koma kodi ndiyenera kugwiritsa ntchito chiyani chatsopano pano? Zochita pano zimatengera momwe mwapangidwira mndandanda mu zenera la data: adalowa pamanja kapena kuchotsedwa patebulo.

1. Ngati deta ya mapangidwe mndandanda watulutsidwa pa tebulo, kenako pitani. Sankhani mitundu yonse. Ngati ili si tebulo la "wanzeru", koma mtundu wophweka, ndiye kuti muyenera kuyika chingwe pakatikati. Ngati mungagwiritse ntchito tebulo la "wanzeru", ndiye kuti pakadali pano ndizokwanira kungolowa momwe mungafunire mu mzere woyamba pansi ndipo mzerewu udzaphatikizidwanso pagome. Ichi ndi mwayi chabe wa tebulo la "wanzeru", lomwe tidatchula pamwambapa.

   

   Koma tiyerekeze kuti tikuchita ndi nthawi yovuta kugwiritsa ntchito njira yokhazikika. Chifukwa chake, tikutsindika khungu pakati pa malo omwe atchulidwa. Ndiye kuti, pamwamba pa khungu ili ndipo pansi pake payenera kukhala mizere ingapo. Dongo pa chidutswa chosakanizidwa ndi batani lamanja mbewa. Mumenyu, sankhani njira yosankha "Ikani ...".



2. Zenera limayamba, pomwe kusankha kuyikako kuyenera kupangidwa. Sankhani "chingwe" ndikudina batani la "OK".



3. Chifukwa chake, chingwe chopanda kanthu chimawonjezeredwa.



4. Lowetsani mtengo womwe tikufuna kuwonetsedwa mndandanda wotsika.



5. Pambuyo pake, timabwereranso ku magome a pagome, omwe amaika mndandanda wotsika. Mwa kuwonekera pa makona atatu, kumanja kwa khungu lililonse la mndandanda, tikuwona kuti mtengo womwe umafunikira kuti zinthu zomwe zatsalali zikuwonjezeredwa. Tsopano, ngati mukufuna, mutha kusankha kulowa mu tebulo.

Koma kodi mungatani ngati mndandanda wa mfundo sakukakamizidwa osati patebulo lina, koma unapangidwa pamanja? Kuti muwonjezere chinthu pamenepa, alinso ndi algorithm yake.

1. Tikutsindika za tebulo lonse, pazomwe mndandanda womwe mndandanda wotsika umapezeka. Pitani ku "data" ndikudina batani la "deta yotsimikizika" kachiwiri mu "ntchito yomwe ili ndi" Gulu.



2. Windo lenileni limayambitsidwa. Timasamukira ku "magawo". Monga mukuwonera, zikhazikiko zonse pano ndizofanana ndendende monga momwe tidaziyika kale. Tidzakhala ndi chidwi ndi "gwero" pamenepa. Tiwonjezera kale mndandanda wokhala ndi tsamba (;) mtengo kapena mfundo zomwe tikufuna kuwona m'ndandanda wotsika. Pambuyo kuwonjezera dongo kuti "Chabwino".



3. Tsopano, ngati titsegula mndandanda womwe watsika mu tebulo, tiwona mtengo wowonjezedwa pamenepo.

Kuchotsa chinthu

Kuchotsa mndandanda wazomwezo kumachitika chimodzimodzi ndi algorithm omwewo monga kuwonjezera.

1. Ngati deta ikulimbikitsidwa patebulo, kenako pitani ku tebulo ndi Clay kumanja-dinani pafoni komwe mtengo wochotsedwayo umapezeka. Muzosankha zankhani, siyani kusankha pa "Chotsani ..." Njira.



2. Zenera lochotsa zenera lili pafupifupi lofanana ndi lomwe tidawona tikamawonjezera. Apa takhazikitsa kusinthira ku "chingwe" ndi dongo lokhalo.



3. Chingwe chochokera pagome la masitepe, monga tikuonera, kuchotsedwa.



4. Tsopano tabwerera ku tebulo limenelo kuli mndandanda wokhala ndi mndandanda wotsika. Dongo m'makona atatu kumanja kwa khungu lililonse. M'ndandanda wotayidwa tikuwona kuti chinthu chakutali sichinachitike.

Ndichite chiyani ngati mfundozo zidawonjezedwa patsamba la data la data pamanja, osagwiritsa ntchito tebulo lowonjezera?

1. Timatsindika patebulopo ndi mndandanda wotsika ndikupita ku bokosi la mfundo, monga tachita kale. Pawindo lotchulidwa, timasamukira ku "magawo". M'dera la "timagawana chotembereredwa pamtengo womwe mukufuna kufufuta. Kenako kanikizani batani la Delete pa kiyibodi.



2. Pambuyo pachomwecho chimachotsedwa, dinani pa "Chabwino". Tsopano sizikhala mndandanda wotsika, monga momwe tawonera m'mbuyomu patebulo.

Kuchotsedwa kwathunthu

Nthawi yomweyo, pamakhala zochitika kumene mndandanda wotsika umafunika kuchotsedwa kwathunthu. Ngati zilibe kanthu kuti deta yomwe idalowetsedwa imasungidwa, ndiye kuchotsedwa ndi kosavuta.

1. Timagawa mitundu yonse yomwe mndandanda wotsika umakhala. Kusamukira ku tabu "kunyumba". Dinani pa chithunzi cha "chomveka" chomveka, chomwe chimayikidwa pa riboni pamalo osinthira. Mumenyu zomwe zimatseguka, sankhani "zowonekera" zonse.



2. Izi zikasankhidwa m'magulu osankhidwa a pepalalo, zomwe zimatsukidwa, ndipo cholinga chachikulu cha ntchitoyo chidzathetsedwa: Mndandanda wotsika pansi udzachotsedwa Pamanja m'chipindacho.

Kuphatikiza apo, ngati wogwiritsa ntchito safunikira kupulumutsa deta yomwe yalowetsedwayo, ndiye kuti pali njira ina yochotsera mndandanda womwe watsika.

1. Tikuwonetsa kuchuluka kwa maselo osowa, omwe ali ofanana ndi mitundu yodutsamo ndi mndandanda wotsika. Kusamukira ku "kunyumba" ndipo pamenepo ndimadina chithunzi cha "kope", lomwe limakhazikika pa riboni mu "chosinthira".

   

   Komanso, mmalo mwa kuchita izi, mutha kudina chidutswa chosakanizidwa ndi mbewa ya mbewa ndikuyima pa "kope".

   

   Ngakhale ndizosavuta pambuyo posankha, gwiritsani ntchito ctrl + c mabatani.

2. Pambuyo pake, timagawa chidutswa cha masitepewo, pomwe zinthu zotsalira zilipo. Tidina batani la "Inni", lomwe lili pa tepi mu tabu yakunyumba mu "Zosinthana".

   

   Njira yachiwiri yochitira ndikuwunikira batani lakumanja ndikuyimitsa kusankha pa "Lowani" mu gulu.

   

   Pomaliza, ndizotheka kungosankha maselo omwe akufuna ndi kulemba mabatani a Ctrl + V.

3. Ndi chilichonse mwazomwe zili pamwambazi m'malo mwa maselo okhala ndi mindandanda yotsika ndi mndandanda wotsika, chidutswa choyeretsa kwambiri chidzaikidwe.

Ngati mukufuna, mutha kuyika malo opanda kanthu, koma chidutswa chodulidwa ndi deta. Kuperewera kwa mindandanda yotsika ndikuti sangathe kuyikapo data yomwe ikusowa pamndandandawo, koma amatha kukopedwa ndikuyikapo. Pankhaniyi, kutsimikizika kwa deta sikugwira ntchito. Komanso, monga tidazindikira, kapangidwe kalikonse kamene kamatsika komwe chidzawonongedwa.

Nthawi zambiri, ndikofunikirabe kuchotsabe mndandanda womwewo pansi, koma nthawi yomweyo kusiya zomwe adazilemba pogwiritsa ntchito, ndikusintha. Pankhaniyi, njira zolondola zochotsera chida chodzaza ndi zomwe zimachitika.

1. Tikuwonetsa chidutswa chonse chomwe zinthu zotsalira zili ndi mndandanda wapansi. Kusamukira ku "deta" ndi dongo pa chithunzi cha "Data cheke deta ya data, chomwe, monga tikukumbukira, chimapezeka pa tepi mu" kugwira ntchito ndi gulu la "Gulu.



2. Zenera lodziwika bwino la deta yolowera imatsegulidwa. Kukhala mu gawo lililonse la chida chotchulidwa, tiyenera kupanga chochita chimodzi - dinani pa batani "Lowetsani". Ili m'munsi mwa kumanzere kwa zenera.



3. Pambuyo pake, zenera lotsimikizika la data limatha kutsekedwa ndikudina batani lotseka lotseka mu ngodya yakumanja ngati mtanda kapena "Ok" pansi pazenera.



4. Kenako timagawa maselo aliwonse omwe mndandanda wotsika waikidwapo kale. Monga tikuwona, tsopano palibe lingaliro posankha chinthu, kapena koloko kuti iyitane mndandandandawo kumanja kwa foni. Koma nthawi yomweyo, kapangidwe kamangokhala osakhudzidwa ndipo mfundo zonse zomwe zalowetsedwa pogwiritsa ntchito mndandandawo zatsala. Izi zikutanthauza kuti ndi ntchito yomwe takwanitsa bwino: Chida chomwe sitikufuna zambiri, chochotsedwa, koma zotsatira za ntchito yake zidakhalabe ziwerengero.

Monga mukuwonera, mndandanda wotsika-pansi umatha kuthandizira mwamphamvu kuyambitsa deta mu tebulo, komanso kuletsa kuyambitsa mfundo zolakwika. Izi zimachepetsa kuchuluka kwa zolakwa mukadzaza matebulo. Ngati mukufuna kuwonjezera phindu lililonse, mutha kuchita zinthu zosintha. Njira yosinthira imadalira njira yotsutsira. Mukadzaza patebulopo, mutha kuchotsa mndandanda womwe watsika, ngakhale sikofunikira kuchita izi. Ogwiritsa ntchito ambiri amakonda kusiya ngakhale kumapeto kwa tebulo atamalizidwa.