Kwa ogwiritsira ntchito Microsoft Excel si chinsinsi kuti deta ya pulojekitiyi imayikidwa m'maselo osiyana. Kuti wogwiritsa ntchito adziwe deta iyi, chigawo chilichonse cha pepalacho chapatsidwa adilesi. Tiyeni tipeze kuti ndi mfundo ziti zomwe zili mu Excel ndipo ngati n'zotheka kusintha chiwerengerochi.
Mitundu ya Kuwerenga mu Microsoft Excel
Choyamba, ziyenera kunenedwa kuti Excel ikhoza kusinthana pakati pa mitundu iwiri yowerengera. Adilesi ya zinthu zomwe zimagwiritsidwa ntchito pogwiritsa ntchito njira yoyamba, yomwe imayikidwa ndi chosasintha, ndi A1. Njira yachiwiri ikuyimiridwa ndi mawonekedwe otsatirawa - R1C1. Kuti muzigwiritse ntchito, muyenera kusintha pazowonjezera. Kuwonjezera pamenepo, wogwiritsa ntchitoyo amatha kuwerenga maselo, pogwiritsa ntchito njira zingapo nthawi imodzi. Tiyeni tiwone mbali zonsezi mwatsatanetsatane.
Njira 1: kusinthani njira yowerengera
Choyamba, tiyeni tione ngati zingatheke kusintha mtundu wa chiwerengero. Monga tanenera kale, adiresi yadilesi yosasinthika yayikidwa ndi mtundu. A1. Ndiko kuti, zipilala zikufotokozedwa ndi zilembo zachi Latin, ndi mizere - mu ziwerengero zachiarabu. Pitani ku machitidwe R1C1 amatsindika kusiyana kwake komwe sizongogwirizana chabe ndi mizere, komanso ndondomeko zimatchulidwa muzinthu. Tiyeni tione m'mene tingasinthire.
- Pitani ku tabu "Foni".
- Pawindo limene limatsegula, pitani ku gawo pogwiritsa ntchito menyu yowonekera "Zosankha".
- Foni ya Excel imatsegula. Kupyolera mu menyu, yomwe ili kumanzere, pitani ku ndime "Maonekedwe".
- Pambuyo pa kusinthako kumvetsera kumbali yakanja yawindo. Tikuyang'ana gulu la zoikamo kumeneko "Kugwira ntchito ndi mayendedwe". About parameter "Link Style R1C1" ikani mbendera. Pambuyo pake, mukhoza kusindikiza batani "Chabwino" pansi pazenera.
- Pambuyo pazowonjezera pamwambapa muwindo lazitali, chithunzi chogwirizana chidzasintha R1C1. Tsopano si mizere yokha, koma zikho zidzawerengedwa.
Pofuna kubwezeretsanso mainawo kuti azikhala osasintha, muyenera kuchita chimodzimodzi, koma nthawi ino musatsegule bokosilo. "Link Style R1C1".
PHUNZIRO: Chifukwa chiyani mu Excel mmalo mwa zilembo zamakalata
Njira 2: Lembani Malipiro
Kuwonjezera apo, wosuta mwiniyo amatha kulemba mizere kapena mizere yomwe maselo ali, malinga ndi zosowa zawo. Kuwerengetsa mwambowu kungagwiritsidwe ntchito kuzindikira mizere kapena zipilala za tebulo, kusinthitsa nambala ya mzere kupita ku ntchito zomwe anakhetsa, ndi zolinga zina. Zoonadi, kuwerengera kungatheke mwachindunji, polemba ziwerengero zofunikira kuchokera ku khibhodi, koma ndi kosavuta komanso mofulumira kuti muchite njirayi pogwiritsira ntchito zipangizo zodzigwiritsira ntchito. Izi ndizoona makamaka polemba deta yambiri.
Tiyeni tiwone momwe kugwiritsa ntchito chikhomo chodzazira mungathe kupanga ziwerengero zowonjezeredwa.
- Ikani chiwerengerocho "1" mu selo limene tikukonzekera kuyamba kuyimba. Kenaka sutsani cholozeracho kumunsi kumbali yakumapeto kwa chinthucho. Pa nthawi yomweyo, iyenera kusandulika kukhala mtanda wakuda. Icho chimatchedwa chikalata chodzaza. Timagwiritsa ntchito batani lamanzere ndikukweza cholozera kumanja kapena kumanja, malingana ndi zomwe muyenera kulemba: mizere kapena zipilala.
- Pambuyo popeza selo lotsiriza kuti muwerenge, tulutsani batani la mbewa. Koma, monga momwe tikuonera, zinthu zonse zomwe zili ndi chiwerengero zimadzazidwa ndi zigawo zokha. Kuti mukonze izi, dinani pazithunzi zomwe ziri pamapeto a owerengedwawo. Onetsani zosintha pafupi ndi chinthucho "Lembani".
- Pambuyo pochita ichi, mndandanda wonsewo udzawerengedwa.
Njira 3: Kupita patsogolo
Njira ina imene zinthu zomwe zili mu Excel zingawerengedwe ndi kugwiritsa ntchito chida chotchedwa "Kupitirira".
- Monga mwa njira yapitayi, yikani nambalayi "1" mu selo yoyamba kuwerengedwa. Pambuyo pake, sankhani chinthu ichi pa pepala podindira pazitsulo lamanzere.
- Pakafunika kusankha, pita ku tabu "Kunyumba". Dinani pa batani "Lembani"anayika pa tepi mu block Kusintha. Mndandanda wa zochitika zimatsegulidwa. Sankhani malo kuchokera "Kupita patsogolo ...".
- Foni ya Excel imatsegulidwa. "Kupitirira". Muzenera ili, malo ambiri. Choyamba, tiyeni tiime pambali. "Malo". Mmenemo, mawotchiwa ali ndi malo awiri: "M'mizere" ndi "Ndi ndondomeko". Ngati mukufuna kupanga nambala yopingasa, sankhani kusankha "M'mizere"ngati zowoneka - ndiye "Ndi ndondomeko".
Mu bokosi lokhalamo Lembani " chifukwa cha zolinga zathu, muyenera kuyimitsa pa malo "Masamu". Komabe, iye ali kale pa malowa mwachisawawa, kotero iwe umangoyenera kuti ulamulire malo ake.
Mipangidwe yamasintha "Units" imakhala yogwira ntchito posankha mtundu Miyezi. Popeza tinasankha mtunduwo "Masamu", sitidzakhala ndi chidwi ndi chibokosi chapamwamba.
Kumunda "Khwerero" ayenera kuyika nambalayi "1". Kumunda "Pezani mtengo" ikani chiwerengero cha zinthu zowerengeka.
Mutachita zochitika pamwambapa, dinani pa batani "Chabwino" pansi pazenera "Kupitirira".
- Monga momwe tikuwonera, tawonekera pawindo "Kupitirira" zolemba zamakalata zidzawerengedwa.
Ngati simukufuna kuwerengera chiwerengero cha zinthu zowonjezera, kuti muwawonetse iwo kumunda "Pezani mtengo" pawindo "Kupitirira"ndiye pakadali pano ndikofunikira kusankha mndandanda wonse kuti muwerenge musanayambe kuyambitsa zenera.
Pambuyo pake pawindo "Kupitirira" Chitani zochitika zomwezo zomwe tafotokoza pamwambapa, koma nthawi ino timachoka kumunda "Pezani mtengo" chopanda kanthu.
Zotsatira zake zidzakhala chimodzimodzi: zinthu zosankhidwa zidzawerengedwa.
PHUNZIRO: Momwe mungakwaniritsire zamoto ku Excel
Njira 4: Gwiritsani ntchito ntchitoyi
Mukhoza kufotokoza zomwe zili pa pepala, mungagwiritsire ntchito ntchito zowonjezera za Excel. Mwachitsanzo, mungagwiritse ntchito wogwiritsa ntchito nambala yowerengera LINE.
Ntchito LINE limatanthawuza ku chigawo cha operesheni "Zolumikizana ndi zolemba". Ntchito yake yaikulu ndi kubwezeretsa nambala ya mndandanda wa Excel pepala yomwe chingwecho chidzaikidwa. Izi zikutanthauza kuti ngati tifotokozera ngati ndondomeko ya ntchitoyi selo iliyonse mzere woyamba wa pepala, ndiye kuti idzapereka phindu "1" mu selo yomwe ilipo yokha. Ngati mukulongosola chiyanjano ku zigawo za mzere wachiwiri, woyendetsa adzawonetsa nambalayi "2" ndi zina zotero
Ntchito yomasulira LINE lotsatira:
= LINE (chiyanjano)
Monga mukuonera, mtsutso wokha wa ntchitoyi ndikutanthauza selo limene mzere wake wa mzere uyenera kutulutsidwa ku chinthu chomwe chimapangidwa ndi pepala.
Tiyeni tiwone momwe tingagwirire ntchito ndi wogwiritsa ntchitoyo pochita.
- Sankhani chinthu chomwe chidzakhala choyamba muzowerengedwa. Dinani pazithunzi "Ikani ntchito"yomwe ili pamwamba pa workspace ya Excel pepala.
- Iyamba Mlaliki Wachipangizo. Kupanga kusintha mu gululo "Zolumikizana ndi zolemba". Kuchokera pa mayina omwe akutsindika, sankhani dzina "LINE". Pambuyo pofotokoza dzina ili, dinani pa batani. "Chabwino".
- Imayendetsa zitsulo zokhudzana ndi ntchito. LINE. Ali ndi munda umodzi wokha, malinga ndi chiwerengero cha zifukwa izi. Kumunda "Lumikizanani" Tiyenera kulowa adilesi ya selo iliyonse yomwe ili mu mzere woyamba wa pepala. Kukonzekera kungalowetsedwe mwa kuwapaka pogwiritsa ntchito makiyi. Komabe, ndizosavuta kuchita izi mwa kungoyika mtolowo kumunda, ndiyeno ndikukweza batani lamanzere pamphindi iliyonse pamzere woyamba wa pepala. Adilesi yake idzawonetsedwa nthawi yomweyo muzenera zotsutsana LINE. Kenaka dinani pa batani "Chabwino".
- Mu selo la pepala kumene ntchitoyo ili LINE, chiwonetsero chikuwonetsedwa "1".
- Tsopano tikufunikira kuwerengera mizere ina yonse. Kuti musachite ndondomeko pogwiritsira ntchito wogwiritsa ntchito pazinthu zonse, zomwe zingatenge nthawi yaitali, tiyeni tipange fomuyi pogwiritsira ntchito chikhomo chodzaza kale chomwe tikudziŵa kale. Sungani chithunzithunzi pamphepete mwachindunji cha selo la fomu. LINE ndipo pambuyo polemba chizindikiro chodzaza, gwiritsani batani lamanzere. Tambani chithunzithunzi pansi pa nambala ya mizere yomwe iyenera kuwerengedwa.
- Monga momwe mukuonera, atatha kuchita izi, mizere yonse ya mndandanda wazinthuyi idzawerengedwa ndi kuwerenga manambala.
Koma tangopanga mizere yokha, ndikukwaniritsa ntchito yogawira adiresi monga nambala mkati mwa tebulo, tiyeneranso kulemba zipilalazo. Izi zikhoza kuchitidwanso pogwiritsa ntchito ntchito yomanga Excel. Wogwiritsira ntchito amayenera kukhala ndi dzina "ZOCHITA".
Ntchito COLUMN Komanso ndilo gulu la ogwira ntchito "Zolumikizana ndi zolemba". Monga momwe mungaganizire, ntchito yake ndikutenga chiwerengero cha mndandanda muzolemba zomwe zafotokozedwa, selo limene likufotokozedwa. Chidule cha ntchitoyi chiri pafupi chimodzimodzi ndi mawu apitalo:
= COLUMN (kulumikiza)
Monga mukuonera, dzina lokhalokha ndilosiyana, ndipo kukangana, nthawi yotsiriza, ndiko kutchulidwa kwa chinthu china cha pepala.
Tiyeni tiwone momwe tingakwaniritsire ntchitoyi mothandizidwa ndi chida ichi pakuchita.
- Sankhani chinthucho, chomwe chidzafanana ndi ndime yoyamba yazithunzi zosinthidwa. Timakani pa chithunzi "Ikani ntchito".
- Kupita Mlaliki WachipangizoPitani ku gawo "Zolumikizana ndi zolemba" ndipo apo timasankha dzina "ZOCHITA". Timasankha pa batani "Chabwino".
- Fesholo yotsutsana ikuyamba. COLUMN. Mofanana ndi nthawi yapitayi, yikani mtolowo kumunda "Lumikizanani". Koma pakadali pano timasankha chinthu chilichonse chomwe sichinali mzere woyamba wa pepala, koma pa ndime yoyamba. Makonzedwewa adzawonekera nthawi yomweyo kumunda. Kenaka mukhoza kutsegula pa batani "Chabwino".
- Pambuyo pake, chiwerengerochi chidzawonetsedwa mu selo yeniyeni. "1"zofanana ndi chiwerengero cha chiwerengero cha tebulo, chomwe chimatchulidwa ndi wogwiritsa ntchito. Kuwerengera kwazitsulo zotsalira, komanso m'mizere, timagwiritsa ntchito chikhomo chodzaza. Timayenderera pansi pambali pa selo yomwe ili ndi ntchitoyi COLUMN. Tikudikira mpaka chizindikiro chodzaza chikuwonekera ndipo, mutagwira batani lamanzere pansi, kwezani chithunzithunzi kupita kumanja kwa nambala yofunikira ya zinthu.
Tsopano maselo onse a tebulo lathu lovomerezeka ali ndi chiwerengero chawo chachibale. Mwachitsanzo, chinthu chomwe chiwerengero chachisanu chimaikidwa mu chithunzi chomwe chili pansipa chikugwirizanitsa (3;3), ngakhale kuti mndandanda wake wothetsera mndandanda wa tsambali ulipobe E9.
PHUNZIRO: Wofalitsa Wothandizira ku Microsoft Excel
Njira 5: Sungani Cell Name
Kuwonjezera pa njira zomwe tazitchulazi, tiyenera kukumbukira kuti, ngakhale kupatsidwa kwa manambala kukhala ndi zigawo ndi mizere ya mtundu wina, maina a maselo omwe ali mmenemo adzaikidwa molingana ndi chiwerengero cha pepala lonselo. Izi zikhoza kuwonetsedwa m'munda wamtundu wapadera pamene chinthucho chikusankhidwa.
Kuti musinthe dzina lolingana ndi makonzedwe a pepala kwa omwe tanenapo pogwiritsa ntchito mgwirizano wokhudzana ndi gulu lathu, ingosankhira zinthu zomwe mukugwirizana nazo podindira batani lamanzere. Ndiye, kuchokera pa kambokosi kamene kali pamtunda, lembani dzina limene wogwiritsa ntchitoyo amaona kuti ndilofunika. Kungakhale mawu alionse. Koma kwa ife, timangolowetsa mgwirizano wapadera wa chigawo ichi. Tiyeni tiwone nambala ya mzere mu dzina lathu. "Tsamba"ndi chiwerengero cha mzere "Mndandanda". Tipeze dzina la mtundu wotsatira: "Stol3Str3". Ife timayendetsa iyo mu malo a dzina ndikusindikizira fungulo Lowani.
Tsopano selo lathu limapatsidwa dzina molingana ndi adiresi yake yeniyeni mu mndandanda. Mofananamo, mungathe kupereka mayina ku zinthu zina zadongosolo.
Phunziro: Mungapereke bwanji dzina la selo kwa Excel
Monga mukuonera, pali mitundu iwiri yokhazikika mu Excel: A1 (osasintha) ndi R1C1 (kuphatikizapo m'makonzedwe). Mitundu yowonjezerayi ikugwiritsidwa ntchito pa pepala lonselonthu. Koma kuwonjezera apo, aliyense wogwiritsa ntchito akhoza kupanga nambala yake mkati mwa tebulo kapena deta yambiri. Pali njira zingapo zotsimikizirika zoyenera kupereka manambala ku maselo: kugwiritsa ntchito chikhomo chodzaza, chida "Kupitirira" ndi ntchito yapadera yomanga Excel. Pambuyo pa kuwerengetsa, ndizotheka kugawira dzina ku chigawo china pa pepala.
