Momwe Mungapangire Zolemba Pa Excel

Njira 1: Kugwiritsa Ntchito Chida Chokha

Excel ili ndi chida chokha chomwe chimapangidwa kuti mugawire zolemba. Sikugwira ntchito zokha, kotero machitidwe onse adzayenera kuchitika pamanja, kusankha mitundu yokonzedwa. Komabe, mawonekedwewo ndi osavuta kwambiri komanso mwachangu pakukonzekera.

1. Ndi batani lakumanzere, sankhani maselo onse omwe mukufuna kugawana pamizamu.



2. Pambuyo pake, pitani ku Tab "deta" ndikudina mawu oti "meseji".



3. "Zolemba za Wizard zimawonekera, zomwe mukufuna kusankha mtundu wa data" wokhala ndi zolekanitsa ". Olekanitsa nthawi zambiri amagwira malo, koma ngati iyi ndi chizindikiro china chopumira, muyenera kuzifotokozera mu gawo lotsatira.



4. Chongani cheke chotsatizana kapena chotsani nokha, kenako werengani zotsatira zoyambira pawindo pansipa.



5. Mu gawo lomaliza, mutha kutchula mtundu watsopano ndi malo omwe ayenera kuyikidwapo. Kukhazikitsa kumamalizidwa, dinani "kumaliza" kuti musinthe zosintha zonse.



6. Bwererani patebulo ndikuwonetsetsa kuti kupatukana kwadutsa bwino.

Kuchokera pa malangizowa, titha kunena kuti chida chotere ndi chabwino m'mikhalidwe imeneyi pomwe kupatukana kumayenera kuchitidwa kokha kamodzi kokha, kutanthauza liwu lililonse. Komabe, ngati zatsopano zimayambitsidwa mu tebulo, nthawi zonse kuti zizigawanika zidzakhala zosavuta, motero chifukwa choganiza modzithandiza motere.

Njira 2: Kupanga mawonekedwe osindikizidwa

Kupambana, mutha kudzidalira njira yovuta yomwe ingakuthandizeni kuwerengera maudindo mu cell mu cell, kupeza mipata ndikugawa chilichonse. Mwachitsanzo, titenga khungu lokhala ndi mawu atatu olekanitsidwa ndi malo. Pa aliyense wa iwo, zimatengera formula yawo, chifukwa chake timagawa njirayo m'magawo atatu.

Gawo 1: kulekanitsa Mawu oyamba

Njira ya Mawu oyamba ndi yosavuta kwambiri, chifukwa iyenera kusinthidwa kokha kuchokera ku gap imodzi kuti mudziwe malo oyenera. Ganizirani za gawo lirilonse la chilengedwe chake, kuti chithunzi chathunthu chomwe chimapangidwa ndi chifukwa chake kuwerengetsa zina kumafunikira.

1. Kuti muthe, pangani mizati itatu yatsopano yokhala ndi siginecha komwe tidzawonjezera malemba olekanitsidwa. Mutha kuchita zomwezo kapena muthayike mphindi ino.



2. Sankhani foni komwe mukufuna kukhazikitsa mawu oyamba, ndipo lembani fomu = Mlingo (.



3. Pambuyo pake, kanikizani mawu oti "Zosankha", motero akusunthira pazenera losintha la formula.



4. Monga momwe nkhaniyo imakhalira ndi mawuwo podina podina ndi mbewa yakumanzere patebulo.



5. Chiwerengero cha zizindikilo kwa malo kapena wolekanitsa wina ayenera kuwerengera, koma pamanja sitichita izi, koma tidzagwiritsa ntchito njira ina - kusaka ().



6. Mukangolemba mtundu wotere, zimawonekera m'mawu a cell pamwamba ndipo mudzatsikiridwa molimba mtima. Dinani pa icho kuti musinthe mwachangu ku lingaliro la ntchitoyi.



7. M'munda wa "Skeleton" amangoyika malo kapena olekanitsa omwe amagwiritsidwa ntchito chifukwa chingakuthandizeni kumvetsetsa komwe mawu amathera. Mu "Zolemba_kusaka" Fotokozerani khungu lomwelo.



8. Dinani pa ntchito yoyamba kuti mubwererenso, ndikuwonjezera kumapeto kwa mkangano wachiwiri. Izi ndizofunikira kuti pulogalamuyi isakuganizire osati malo omwe angafune, koma chizindikiro chake. Monga momwe mungadziwire pazenera lotsatira, zotsatira zake zimawonetsedwa popanda malo aliwonse, zomwe zikutanthauza kuti njira yopanga ma formula imapangidwa molondola.



9. Tsekani mkonzi wa ntchito ndikuwonetsetsa kuti mawuwo amawonetsedwa bwino mu khungu latsopanoli.



10. Gwirani khungu m'munsi mwakumanja ndikukokerani ku chiwerengero chofunikira cha mizere kuti itole. Chifukwa chake zomwe zimasinthidwa, zomwe ziyenera kugawidwa, ndipo kukwaniritsidwa kwa formula ndi kokha.

Fomu yopangidwa kwathunthu ili ndi mawonekedwe = Levsimv (A1; Sakani (""; A1) -1), mutha kupanga izi molingana ndi zomwe zili pamwambapa. Musaiwale kusintha maselo okonzedwa.

Gawo 2: Kulekanitsa Mawu Achiwiri

Chovuta kwambiri ndikugawa Mawu achiwiri, omwe ali ndi dzina lathu. Izi zimachitika chifukwa chakuti imazunguliridwa ndi malo ochokera mbali zonse, chifukwa muyenera kuganizira zonse, ndikupanga njira yayikulu yowerengera malowo.

1. Pankhaniyi, mawonekedwe akuluakulu adzakhala = PS (- alembe mu mawonekedwe awa, kenako nkupita ku zenera lokhazikika.



2. Njira iyi ifunafuna chingwe chomwe mukufuna m'mawuwo, chomwe chimasankhidwa ndi khungu lomwe lalembedwa kuti mupatule.



3. Malo oyamba a mzerewo ayenera kutsimikiza pogwiritsa ntchito njira yodziwika bwino ya njira yodziwika bwino ().



4. Kupanga ndi kusunthira kwa icho, kudzazanso chimodzimodzi monga momwe zimasonyezedwera mu gawo lapitalo. Monga mutu womwe mukufuna, gwiritsani ntchito yolekanitsa, ndipo fotokozerani foniyo ngati lemba lofufuza.



5. Bwererani ku formula yapitayi, pomwe onjezerani ku ntchito ya "Sakani



6. Tsopano fomulayo ikhoza kuyamba kusaka mzere kuchokera ku dzina loyambirira, koma silikudziwa kuti likutha kumaliza, motero, poyerekeza "kachiwiri, lembani formula ().



7. Pitani ku zotsutsana zake ndikuzidzaza kale.



8. M'mbuyomu, sitinkaona gawo loyamba la ntchitoyi, koma tsopano ndikofunikira kulowa posaka (), popeza njirayi siyenera kupeza kusiyana koyamba, koma chachiwiri.



9. Pitani ku ntchito yopangidwa ndikudzaza chimodzimodzi.



10. Bwererani ku "Sakani" yoyamba ndikuwonjezera mu "Nach_iwo" + kumapeto, chifukwa sizifunikira mpata pofufuza mzere, koma wotsatira.



11. Dinani pa muzu = pst ndikuyika cholozera kumapeto kwa mzere wa "nambala ya".



12. Tulukani mawu akuti (""; A1) -1 kuti mumalize kuwerengetsa minda.



13. Bweretsani patebulo, tambasulani fomula ndikuwonetsetsa kuti mawuwo akuwonetsedwa bwino.

Fomu idakhala yayikulu, ndipo si onse ogwiritsa ntchito omwe amamvetsetsa momwe amagwirira ntchito. Chowonadi ndi chakuti kuti afufuze mzere womwe ndidagwiritsa ntchito ntchito zingapo zomwe zimatsimikizira malo oyamba ndi omaliza, kenako chiphiphiritso chimodzicho chidachoka kwa iwo, mipata imodzi imawonetsedwa. Zotsatira zake, mawonekedwe ndi awa: = PSTR (A1; Sakani (""; A1) +1; 1). Gwiritsani ntchito ngati chitsanzo, kusinthanitsa nambala yam'manja ndi lembalo.

Gawo 3: Kulekanitsa Mawu Achitatu

Gawo lomaliza la malangizo athu limatanthawuza kugawikana kwa Mawu achitatu, omwe amawoneka ngati momwe adachitikira ndi woyamba, koma mawonekedwe a General amasintha pang'ono.

1. Mu cell yopanda kanthu, kwa malo omwe ali mtsogolo, lembani = Rasiwemv (ndikupita kukangana za ntchitoyi.



2. Monga lembalo, fotokozerani khungu lomwe lili ndi cholembera cholekanitsa.



3. Ntchito yothandiza kuti ipeze mawu amatchedwa Dlstr (A1), komwe A1 ndi khungu lomwelo lomwe lili ndi malembawo. Izi zimatsimikizira kuchuluka kwa otchulidwa m'malembawo, ndipo titsala okwanira.



4. Kuti muchite izi, onjezani - ndikusintha njirayi.



5. Lowetsani kale kusanthula kale kufunafuna cholembera choyambirira mu chingwe.



6. Onjezani kusaka kwina kwa malo oyambira ().



7. Fotokozerani chimodzimodzi.



8. Bweretsani ku formula yakale.



9. Onjezerani +1 pamalo oyamba.



10. Pitani kuzu la formulav ndikuwonetsetsa kuti zotsatira zake zimawonetsedwa bwino, kenako tsimikizani kusintha. Njira yathunthu pankhani iyi imawoneka ngati = A1; Dlstr (A1) -Pask (""; kusaka (""; A1))))).



11. Zotsatira zake, pazithunzi chotsatira mumawona kuti mawu onse atatu asiyanitsidwa molondola ndipo ali mumitundu yawo. Pa izi, kunali kofunikira kugwiritsa ntchito mitundu yosiyanasiyana, koma imakupatsani mwayi wokulitsa tebulo ndipo musadandaule kuti nthawi iliyonse mukayenera kugawana lembalo. Ngati ndi kotheka, mungokulitsa formula pomusunthira kuti maselo awa akhudzidwa okha.