Chizindikiro mu Microsoft Excel

Mu pulogalamu ya Microsoft Office, wogwiritsa ntchito nthawi zina amafunika kuyika chizindikiro kapena, monga chinthucho chimatchulidwira, chizindikiro (˅). Izi zitha kuchitidwa pazifukwa zosiyanasiyana: kungolembera chizindikiro chinthu, kuphatikiza zojambula zosiyanasiyana, ndi zina zambiri. Tiyeni tiwone momwe mungayang'anire bokosi ku Excel.

Bokosi

Pali njira zingapo zoyendera bokosi ku Excel. Kuti musankhe pazomwe mungasankhe, muyenera kukhazikitsa zomwe muyenera kuyang'ana m'bokosi: kungolembera chizindikiro kapena kungopanga njira zina ndi zolemba?

Phunziro: Momwe mungayang'anire mu Microsoft Mawu

Njira 1: Lowani kudzera mu mndandanda wa Chizindikiro

Ngati mukufunikira kuyang'ana bokosilo pongowonera, kuti mulembemo chinthu, ndiye kuti mutha kugwiritsa ntchito batani la "Symbol" lomwe lili pa riboni.

1. Tikuyika cholozera mchipinda momwe chizindikiro chizikhala. Pitani ku tabu Ikani. Dinani batani "Chizindikiro"ili mu chipangizo "Zizindikiro".



2. Zenera limayamba ndi mndandanda waukulu wazinthu zosiyanasiyana. Sipita kulikonse, koma khalanibe tabu "Zizindikiro". M'munda Font fon iliyonse muyezo ingatchulidwe: Mlandu, Verdana, Nthawi zatsopano roman etc. Kuti mupeze munthu amene akufuna kumunda "Khazikitsani" khazikitsani gawo "Makalata amasintha malo". Tikuyembekezera chizindikiro "˅". Sankhani ndikudina batani. Ikani.

Pambuyo pake, chinthu chosankhidwa chidzawoneka m'chipinda chomwe chidasimbidwa kale.

Momwemonso, mutha kuyika chizindikiritso chodziwika bwino ndi mbali zosasiyanitsa kapena chizidutswa bokosilo (bokosi laling'ono lomwe limapangidwa kuti liyike bokosi loyang'anira). Koma kuti izi zithe, muyenera kulima Font tchulani fonti yapadera m'malo mwa mtundu wokhazikika Mapiko. Kenako muyenera kupita kunsi kwa mndandanda wa zilembo ndikusankha omwe mukufuna. Pambuyo pake, dinani batani Ikani.

Khalidwe losankhidwa limayikidwa mu cell.

Njira 2: Kulanda Makhalidwe

Palinso ogwiritsa ntchito omwe sanakonzedwe kuti agwirizane ndi zilembo chimodzimodzi. Chifukwa chake, mmalo mokhazikitsa chizindikiro choyendera, amangolemba chizindikiro pa kiyibodi "v" m'Chingerezi. Nthawi zina zimakhala zomveka, chifukwa njirayi imatenga nthawi yochepa kwambiri. Ndipo kunja kwakanthawi kumakhala kosatheka.

Njira 3: yikani cheke

Koma kuti kuyika kapena kusasamala kuyendetse zolembedwa zina, muyenera kuchita ntchito yovuta kwambiri. Choyamba, muyenera kukhazikitsa cheki. Awa ndi bokosi laling'ono komwe bokosi limayikidwa. Kuti muyike chinthu ichi, muyenera kuwongolera menyu ya wopanga mapulogalamu, omwe amazimitsidwa pokhapokha mu Excel.

1. Kukhala mu tabu Fayilodinani pachinthucho "Zosankha", yomwe ili kumanzere kwa zenera pano.



2. Zenera la kusankha limayamba. Pitani ku gawo Kukhazikika kwa Ribbon. Mu mbali yoyenera ya zenera, yang'anani bokosi (ndizomwe tidzafunika kukhazikitsa pa pepalalo) moyang'anizana ndi gawo "Wopanga". M'munsi mwa zenera, dinani batani "Zabwino". Pambuyo pake, tabu idzawoneka pambali "Wopanga".



3. Pitani ku tabu yomwe yangoyambitsa kumene "Wopanga". Mu bokosi la zida "Olamulira" pa tepi dinani batani Ikani. Pamndandanda womwe umatseguka m'gululo "Zolamulira Fomu" sankhani Bokosi.



4. Pambuyo pake, cholozera chimasanduka mtanda. Dinani m'deralo pa pepalalo pomwe mukufuna kuyika fomuyo.

   

   Bokosi lopanda kanthu limapezeka.



5. Kuti muyike mbendera mmenemo, mufunika kungodinikiza pachimenechi ndipo mbendera iyikidwa.



6. Kuti muchotse zolemba zonse, zomwe nthawi zambiri sizofunikira, dinani kumanzere, sankhani zomwe zalembedwazo ndikudina batani Chotsani. M'malo mwa mawu omasulidwa, mutha kuyika wina, kapena simungathe kuyika chilichonse, kusiya bokosi lopanda dzina. Izi ndi zogwiritsa ntchito wogwiritsa ntchito.



7. Ngati pakufunika kupanga ma bokosi angapo owonera, ndiye kuti simungathe kupanga mzere wokhota mzere uliwonse, koma koperani womaliza, womwe ungapulumutse nthawi yambiri. Kuti muchite izi, sankhani mafomu nthawi yomweyo ndikudina mbewa, kenako kwezani batani lakumanzere ndikukokera fomuyo ku khungu lomwe mukufuna. Popanda kuponya batani la mbewa, gwiritsani fungulo Ctrlkenako ndikumasulani mbewa ya mbewa. Timagwiranso ntchito limodzi ndi ma cell ena momwe mumafunikira kuyika chizindikiro.

Njira yachinayi: pangani bokosi loyang'anira ndikusunga zolemba

Pamwambapa, taphunzira momwe tingayang'anire bokosilo m'njira zosiyanasiyana. Koma mwayi uwu sungagwiritsidwe ntchito osati kungowonetsera, komanso kuthana ndi mavuto. Mutha kukhazikitsa mawonekedwe osiyanasiyana mukasintha bokosi loyendera. Tiona momwe izi zimagwirira ntchito ndi chitsanzo chosintha mtundu wa khungu.

1. Timapanga bokosi loyendera molingana ndi algorithm yomwe tafotokozeredwa njira yapita pogwiritsa ntchito tsamba la mapulogalamu.
2. Timadina pamalopo ndi batani la mbewa yoyenera. Pazosankha zofanizira, sankhani "Fomu yazinthu ...".



3. Tsamba losintha likutsegulidwa. Pitani ku tabu "Lamulira"ngati idatsegulidwa kwina. Pakadutsa magawo "Makhalidwe" Maudindo apano akuyenera kuwonetsedwa. Ndiye kuti, ngati chizindikirochi chikuyikidwa pakadali pano, ndiye kuti kusinthaku kuyenera kukhala pamalo "Oyikidwa"ngati sichoncho - pamalowo "Shot". Maudindo Zosakanizidwa kuwonetsera sikulimbikitsidwa. Pambuyo pake, dinani chizindikiro pafupi ndi munda Cell Link.



4. Zenera losintha limachepetsedwa, ndipo tiyenera kusankha khungu pa pepalalo lomwe bokosi loyendera lingagwirizane. Kusankha kukapangidwa, dinani batani lomwelo momwe mungayimire chithunzi, chomwe takambirana pamwambapa, kuti mubwerere pazenera.



5. Pazenera lopangidwe, dinani batani "Zabwino" kuti musunge zosintha.

   

   Monga mukuwonera, mutatha kuchita izi mu foni yolumikizidwa, pomwe bokosi lipendekedwa, mtengo wake "ZOONA ". Mukazindikira kuti mtengo wake ndiwofunika FALSE. Kuti tikwaniritse ntchito yathu, yomwe ndiyoti tisinthe mawonekedwe, tifunika kugwirizanitsa izi mu cell ndi kanthu kena.



6. Sankhani foni yolumikizidwa ndikudina batani ili ndi batani la mbewa, pazosankha zomwe zimatsegulira, sankhani chinthucho "Mtundu wamtundu ...".



7. Tsamba losintha maselo limatseguka. Pa tabu "Chiwerengero" sankhani "Makonda onse" mu parpar block "Mawerengero Amanambala". Mundawo "Mtundu", yomwe ili mkati mwa zenera, timalemba mawu otsatirawa popanda mawu: ";;;". Dinani batani "Zabwino" pansi pazenera. Pambuyo pa izi, mawu owonekera "ZOONA" inasowa m'selo, koma phindu limakhalabe.



8. Sankhani foni yolumikizidwa kachiwiri ndikupita ku tabu. "Pofikira". Dinani batani Njira Zakukonzeraniyomwe ili mgululi Masitaelo. Pamndandanda womwe umawonekera, dinani chinthucho "Pangani lamulo ...".



9. Zenera lopanga mtundu wa fayilo limatsegulidwa. Pamwambamwamba, muyenera kusankha mtundu wamalamulo. Sankhani chinthu chomaliza pamndandanda: "Gwiritsani ntchito chilinganizo pofotokozera maselo osankhidwa". M'munda "Makhalidwe omwe njira zotsatirazi ndi zoona" tchulani adilesi ya foni yolumikizidwa (izi zitha kuchitidwa pamanja kapena kungosankha), ndipo ma mgwirizano atatulukira mu mzere, timawonjezera mawu "= ZOONA". Kuti muyike mtundu wowonekera, dinani batani "Fomu ...".



10. Tsamba losintha maselo limatseguka. Sankhani mtundu womwe mungafune kudzaza khungu mukayimitsa chizindikiro. Dinani batani "Zabwino".



11. Kubwereranso ku zenera lapaulamuliro, dinani batani "Zabwino".

Tsopano, chikwangwani chikatsegulidwa, foni yolumikizidwa imapakidwa utoto wosankhidwa.

Ngati cheki chizichotsedwa, khungu lidzasandukanso loyera.

Phunziro: Zowongolera mu Excel

Njira 5: chikhomo kugwiritsa ntchito zida za ActiveX

Chowongolera chizitha kukhazikitsidwa pogwiritsa ntchito zida za ActiveX. Izi zimapezeka pokhapokha pazosunga mapulogalamu. Chifukwa chake, ngati tabu iyi siingatheke, ndiye kuti muyenera kuyiyambitsa, monga tafotokozera pamwambapa.

1. Pitani ku tabu "Wopanga". Dinani batani Ikanilomwe lili mgulu la chida "Olamulira". Pa zenera lomwe limatseguka, muzitsegula ActiveX amazilamulira sankhani Onani bokosi.



2. Monga kale, chidziwitso chimakhala ndi mawonekedwe apadera. Timadina pamalo omwe pepalalo limayikidwa.



3. Kuti muyike chizidindo pabokosi, muyenera kuyika zinthu za chinthucho. Timadina ndi batani loyenera la mbewa ndipo mumenyu omwe amatsegula, sankhani chinthucho "Katundu".



4. Pazenera la katundu lomwe limatseguka, yang'anani chizindikiro "Mtengo". Ili pamunsi. Potsutsa iye, timasintha phindu ndi "Zabodza" pa "Zowona". Timachita izi pongoyendetsa otchulidwa ku kiyibodi. Ntchitoyo ikamalizidwa, tsekani zenera lamalowo podina batani lozungulira ngati mawonekedwe amtanda loyera mumalo ofiira pakona yakumanja ya zenera.

Mukamaliza kuchita izi, chizindikirocho mu bokosi loyendera chidzakhazikitsidwa.

Kulemba zolemba pogwiritsa ntchito ActiveX ndizotheka kugwiritsa ntchito zida za VBA, ndiye kuti, mwa kulemba macros. Zachidziwikire, izi ndizovuta kwambiri kuposa kugwiritsa ntchito zida zopangira. Kuwerenga nkhaniyi ndi mutu waukulu. Macros a ntchito zenizeni amatha kulembedwa ndi ogwiritsa ntchito omwe ali ndi chidziwitso cha mapulogalamu ndi luso ku Excel omwe ali apamwamba kwambiri kuposa avareji.

Kuti mupite ku mkonzi wa VBA, pomwe mutha kujambula macro, muyenera dinani pazinthuzo, momwemo bokosi, ndi batani lakumanzere. Pambuyo pake, adzayambitsa zenera la mkonzi momwe mungalembere code kuti ntchitoyi ichitike.

Phunziro: Momwe mungapangire zazikulu mu Excel

Monga mukuwonera, pali njira zingapo zowonera bokosi ku Excel. Njira iti yomwe mungasankhe zimatengera zolinga zakukhazikitsa. Ngati mukungofuna kuyika chizindikiro, ndiye kuti palibe nzeru kumaliza ntchitoyo kudzera pa menyu wopanga, chifukwa izi zimatenga nthawi yambiri. Ndiosavuta kugwiritsa ntchito kuyika kapena kulemba mtundu wa Chingerezi "v" pa kiyibodi m'malo mwa cheke. Ngati mukufuna kugwiritsa ntchito chizindikirocho kuti mupange zolemba zina papepala, ndiye kuti cholinga ichi chitha kukwaniritsidwa mothandizidwa ndi zida zopangira mapulogalamu.