Zitsanzo za "smerei" ntchito ku Excel

Malembedwe chilengedwe ntchito

Ntchitoyi ndiyotchuka kwambiri, chifukwa pafupifupi tebulo lililonse, ndikofunikira kuwerengera kuchuluka kwa manambala m'maselo, kunyalanyaza mfundo zomwe sizimagwera pansi pa matenda akulu. Chifukwa cha njirayi, kuwerengera sikukukhala kovuta komanso yayitali. Ntchito yopanga mapangidwe imawoneka ngati = chete (mtundu; kuchuluka; Mitundu_kuganiza), ndi "Remiation" imangowonetsedwa munthawi iliyonse. Ngati deta mu "chimangirizo osiyanasiyana" akusowa, maselo onse ali m'gulu la "uthunthu" adzakhala adafikapo.

Ubwenzi ndi malembedwe a ntchito ndi chete mu kupambana pamaso pa chilengedwe chake

Tidzakambirana mfundo ziwiri zotsalazo - "osiyanasiyana" ndi "chitsimikizo". Zoyambira zoyambirira za maselo (A1: A100) ikukwanira (A1: A100), omwe adzayang'anitsidwe ndikuyerekeza ndi momwe ziliri. Mu "chizolowezi", wogwiritsa ntchitoyo amabweretsa vutoli, mukamachita cell amakhala amodzi mwa mawu. Izi zitha kukhala momwe sizikuwoneka manambala (50) kapena kutsatira zomwe zalembedwa ("mawu"). Kuti muchepetse kumvetsetsa kwa kukhazikitsa kwa mikangano, tsegulani zenera la zithunzi "kutsutsana" ndikuyika zikhalidwe zonse momwe mungasinthire.

Kugwiritsa ntchito mndandanda wazojambula kuti mulengeze ntchito zotsatirazi

Palibe zitsanzo zambiri zambiri, mawonekedwe a kukwaniritsidwa kumeneku ndikofunikira kulingalira za ntchitoyo ikakhala chete, kenako ndikuwona zodziwika komanso zodziwika bwino.

Ntchitoyo yakhala chete pansi pazomwe sizikulingana

Chitsanzo choyamba ndi kugwiritsa ntchito ntchito ya ntchitoyo, malinga ndi kuchuluka kwa kugunda kuyenera kukhala kokulirapo, kochepera kapena osati kofanana ndi nambala yomwe yatchulidwa. Ndi syntax, ntchito imayang'ana maselo onse a mtunduwo ndipo amawona kuti ndi yoyenera yokha. Maudindo akulemba kudzera mu gawo lolowera lili ndi magawo angapo:

Dziwani mitundu ya maselo oyambitsira fomu, tidzakhala ndi phindu la mwezi.

Kusankha mitundu ya maselo kuti apange mawonekedwe a ntchitoyo

Yambitsani kulowa kuchokera ku malangizo ake mu gawo lolowera polemba.

Kulengeza kwa ntchitoyo sikuli chete pakusankha maselo osiyanasiyana.

Pangani bulaketi ndikutseka bulaketi pomwe mumalowa m'maselo osankhidwa, mwachitsanzo C2: C25. Pambuyo pake, onetsetsani kuti mwasankha; zomwe zikutanthauza kutha kwa mkangano.

Kulowa mkangano wa maselo ogwiritsira ntchito mu ntchito yomwe apangidwa bwino

Kutseguka mawu ndikufotokozerani zomwe zili momwe ziliri> 300000.

Lowetsani zomwe zili muyeso wa ntchitoyo

Mukangokakamiza fungulo la ENTER, ntchitoyo idayambitsidwa. Pazithunzithunzi, zikuwonekeratu kuti maselo awiri okha ndi omwe amafanana ndi vutoli> 300000, chifukwa chake, mawonekedwe amafotokozera mwachidule ziwerengero zawo ndikuwonetsa mu chipilala chosiyana.

Kudziwika ndi zotsatira za kugwiritsidwa ntchito kwa ntchito kumadetsedwa ku Excel

Pamwambapa, chimodzi mwa zitsanzo zomwe zidachitika mwangozi zidasokonekera. Palibe chomwe chingalepheretse kuyikapo chilichonse, kukulira kapena chopapatiza pamtundu - njirayi idzaganiziranso kufunika kwake ngati malamulo a Syntax adawonedwa.

Ntchitoyo ili chete, malinga ndi zolemba

Tengani chitsanzo chachiwiri pomwe ali chete kuwerengera kuchuluka kwa maselo omwe akuyenera kutsatira zolemba zina pamtundu wina. Izi zidzakhala zothandiza, mwachitsanzo, pamene mtengo wonse wa zinthu zina amawerengedwa, kapena ndalama za kampaniyo za malipiro kwa ogwira ntchito zimawerengeredwa m'malo mwapadera. Chitsanzo cha kulembetsa munthawi ngati izi chikusangalatsabe kuti syntax imasintha pang'ono, popeza matendawo amagwera maselo angapo.

Nthawi ino, kuwonjezera pamitundu yobisika, onani komwe mukulembamo.

Kusankhidwa kwa maselo osiyanasiyana kugwiritsa ntchito ntchitoyo sikuli chete poyerekeza mayina

Yambani kujambula ntchito kuchokera ku lingaliro lake monga momwe zasonyezedweratu pamwambapa.

Kulengeza kwa ntchitoyo sikuli chete pa Excel pomwe ntchito kufanizira mitu

Choyamba, lowetsani zomwe zidalembedwazo, ikani; Ndipo khalani ndi vutoli. Ndiye mawu awa mu syntactic mtundu wa Syntactic adzalandira mtundu uwu: A2: A25; "Seputembala";

Kulengeza kwa maselo a maselo mukamagwiritsa ntchito ntchitoyo, osazengereza poyerekeza mayina

Monga mkangano wotsiriza, zikatchulanso mitundu yambiri maselo, kuchuluka kwa komwe kudzajambulidwa kumodzi. Mukudziwa kale malamulo ojambulira mkanganowo.

Kulengeza kwa maselo ojambulidwa mukamagwiritsa ntchito ntchitoyo, osazengereza kuyerekezera maudindo

Onani ntchito. Timatchula mwezi wa Seputembala monga momwe timakhalira ndikuyang'ana patebulopo, yomwe idafotokoza zidziwitso ziwiri za maselo omwe amagwirizana nazo. Zambiri zotsalazo mukamayang'ana kungonyalanyazidwa.

Zotsatira zakugwiritsa ntchito ntchitoyo sikumakhala chete poyerekeza ndi mayina

Sinthani mawu kapena lowetsani mawu onse, atapatsidwa malo olembetsera kuti mudzipangire okha powerengera mfundo zofunika.

Ntchito smerevim ndi zinthu zingapo

Tidamaliza kusanthula zitsanzo ndi njira yachitatu, pomwe zofunikira zowonjezera zingapo nthawi imodzi. Ndi kuwerengera kotero, ntchito yomwe imayang'aniridwa imasinthidwa ndi svmemalimn yosinthidwa, yomwe imakupatsani mwayi wokhazikitsa mkangano umodzi, womwe sungakhazikitsidwe mu mtundu woyamba. Chimodzi mwazosavuta kwambiri ndi makalata athunthu omwe amapangidwa motere:

Tengani tebulo pomwe pali zinthu zitatu zosiyanasiyana pazachidziwitso pamenepo komanso malinga ndi mitundu yawo. Iyi ndi mwezi, phindu lonse ndi kuchuluka kwa katundu wogulitsidwa. Mu gawo limodzi ndi zinthu zingapo, ndikofunikira kupanga zotsatirazi zokhazokha, zomwe zidapezeka mu Seputembala ndi malonda pamwamba pa 29.

Kusankhidwa kwa tebulo kuti apange ntchitoyo sikuli chete osamala ndi mfundo zingapo

Yambani kulowa kuchokera ku Makina otsatsa = smererense, tsegulani mabatani ndikulemba ma cell omwe adzafotokozedwe. Musaiwale kutseka chilengezo cha chizindikirocho;

Kupanga kwa kamwano koyamba kwa ntchitoyo sikuli chete osachita bwino ndi mfundo zingapo.

Kutsatira kukangana kwachiwiri - mwakanema mu khungu. Kujambulidwa kwa gawo ili kunalidi komwe talingalira kale ndipo kumatha kuwonekanso mu chithunzithunzi.

Kupanga mkangano wachiwiri wa ntchitoyo sikuli chete osamala ndi mfundo zingapo

Mkhalidwe wachitatu ndi makalata a kusalingana komwe kunakonzedweratu, komwe tadzifotokozera koyambirira kwa nkhaniyo. Apanso mwanjira yomweyo, tchulani mfundo zosiyanasiyana komanso kusagwirizana komwe. Musaiwale kuyika bulaketi, mwakutero kumaliza ntchito yolemba.

Kupanga kwa lingaliro lachitatu la ntchitoyo sikuli chete osachita bwino kwambiri.

Kwathunthu, mzere wa ntchitoyi uli ndi mawonekedwe = SVumprem (C2: C25; A25; "> 29"), koma mutha kusintha nokha kuti muchite bwino. Zitha kuwoneka kuti ndizovuta kulengeza mkangano uliwonse osati kusokonezeka mwa otchulidwa, koma mosiyana siyenera kukhala mavuto.

Amasauliranso ndi Svamprems ndi a ntchito za masamu omwe ali ndi choyimira chofananira, koma amagwiritsidwa ntchito mosiyanasiyana. Kuti muwerenge zambiri pa njira zonse zodziwika bwino zomwe zimadziwika bwino, onani zomwe zili pansipa.

Werengani zambiri: Masamu 10 odziwika bwino a Microsoft Excel