Kugwiritsa ntchito NTCHITO mu Microsoft Excel

Pogwira ntchito ku Excel, ogwiritsa ntchito nthawi zina amakumana ndi ntchito yosankha chinthu kuchokera pamndandanda ndikugawa mtengo wolozeredwa malinga ndi index yake. Ntchito, yomwe imatchedwa "DALIRANI". Tiyeni tiwone mwatsatanetsatane momwe mungagwiritsire ntchito ndi opareshoni, komanso mavuto omwe angathe kuthana nawo.

Kugwiritsa ntchito chiganizo cha NKHANI

Ntchito Kusankha ali m'gulu la ogwiritsira ntchito Malingaliro ndi Kufika. Cholinga chake ndikupeza phindu lenileni mu selo lomwe limatanthawuza, lomwe limafanana ndi nambala yolozera pazinthu zina papepala. Kapangidwe ka mawu awa ndi motere:

= SANGANI (index_nambala; value1; value2; ...)

Kukangana Chiwerengero Cha Index imakhala ndi ulalo wa foni komwe nambala yotsalira ya chinthucho, komwe gulu lotsatira la ophunzirawo limapatsidwa mtengo winawake. Nambala ya serial ikhoza kukhala yosiyanasiyana 1 kale 254. Mukatchulira index yomwe imapitilira nambala iyi, wothandizira amayenera kulakwitsa mu foni. Ngati tidziwitsa mtengo wokhazikika ngati mkanganowu, ntchitoyi idzauwona kuti ndi nambala yochepa kwambiri yayandikira kwambiri nambalayo. Mukafunsa Chiwerengero Cha IndexPomwe palibe kutsutsana "Mtengo", pomwepo wothandizira adzabweza cholakwika mu foni.

Gulu lotsatira lotsutsa "Mtengo". Amatha kufikira zochuluka 254 zinthu. Kutsutsana ndikofunikira "Mtengo1". Mu gulu latsopanoli, mfundo zomwe nambala yotsimikizira ya mfundo yapitayo yasonyezedwa. Ndiye kuti, ngati mkangano Chiwerengero Cha Index zokonda "3", ndiye kuti izigwirizana ndi mtengo womwe umayikidwa ngati mkangano "Mtengo3".

Mitundu yosiyanasiyana ya data imatha kukhala yamtengo wapatali:

• Malingaliro
• Manambala
• Zolemba
• Mawonekedwe
• Ntchito, etc.

Tsopano tiyeni tiwone zitsanzo zapadera za kugwiritsa ntchito kwa opareshoni.

Chitsanzo 1: Ndondomeko yotsatira

Tiyeni tiwone momwe ntchitoyi imagwirira ntchito mwachitsanzo chosavuta. Tili ndi tebulo lokhala ndi manambala kuchokera 1 kale 12. Ndikofunikira malinga ndi manambala omwe mwapatsidwa ogwiritsa ntchito Kusankha lembani dzina la mwezi wofananira mgulu lachiwiri la tebulo.

1. Sankhani selo yoyamba yopanda chilichonse. "Dzina la mwezi". Dinani pachizindikiro "Ikani ntchito" pafupi ndi mzere wa njira.



2. Kuyambira Ogwira Ntchito. Pitani ku gulu Malingaliro ndi Kufika. Sankhani dzina m'ndandanda "DALIRANI" ndipo dinani batani "Zabwino".



3. Woyendetsa Window Window Woyambitsa Kusankha. M'munda Chiwerengero Cha Index adilesi ya selo loyamba la manambala owerengeka a miyezi iyenera kuwonetsedwa. Njira imeneyi imatha kuchitika poyendetsa magalimoto pamanja. Koma tidzachita zambiri mosavuta. Timayika chidziwitso kumunda ndikudina kumanzere pa foni yolingana ndi pepalalo. Monga mukuwonera, zogwirizanitsa zimawonetsedwa zokha pamunda wa zenera la mkangano.

   Pambuyo pake, tiyenera kuyendetsa pamanja pagulu la minda "Mtengo" dzina la miyezi. Komanso, gawo lirilonse liyenera kukhala lofanana mwezi umodzi, ndiko kuti, kumunda "Mtengo1" lembani Januwarem'munda "Mtengo2" - February etc.

   Mukamaliza ntchito yomwe mwatchulayo, dinani batani "Zabwino" pansi pazenera.



4. Monga mukuwonera, nthawi yomweyo m'chipinda chomwe tidachiwona gawo loyamba, zotsatira zake zidawonetsedwa, dzina Januwarelolingana ndi nambala yoyamba ya mwezi wachaka.



5. Tsopano, kuti musagwiritse ntchito mwanjira ya maselo ena onse m'ndandawo "Dzina la mwezi", tiyenera kutengera. Kuti muchite izi, ikani temberezo pakona ya m'munsi ya foni ili ndi fomula. Chizindikiro Gwirani pansi batani lakumanzere ndikukokera chikhomo mpaka kumapeto kwa mzati.



6. Monga mukuwonera, fomuloli idatengera mitundu yonse yomwe timafunikira. Poterepa, mayina onse amiyezi yomwe akuwonetsedwa mu maselo amagwirizana ndi nambala yawo yosanja kuchokera kumunsi kumanzere.

Phunziro: Excel Feature Wizard

Chitsanzo 2: makonzedwe osintha a zinthu

M'mbuyomu, tidagwiritsa ntchito chilinganizo Kusankhapomwe mfundo zonse za manambala amndandanda zidakonzedwa molongosoka. Koma amagwira ntchito bwanji ngati mfundo zomwe zasungidwazo zasakanikirana ndikubwereza? Tiyeni tiwone chitsanzo cha chojambula cha ophunzira. Gawo loyamba la tebulo likuwonetsa dzina la wophunzirayo, kalasi yachiwiri (kuchokera 1 kale 5 mfundo), ndipo chachitatu tikuyenera kugwiritsa ntchito Kusankha perekani izi moyenera"zoyipa kwambiri", "zoyipa", zokhutiritsa, zabwino, zabwino).

1. Sankhani khungu loyamba mu mzati "Kufotokozera" ndi kudutsa njira yomwe idakambidwa kale pamwambapa, mpaka pazenera zotsutsa Kusankha.

   M'munda Chiwerengero Cha Index tchulani ulalo wa khungu loyambirira la chipilalacho "Gulu"yomwe ili ndi gawo.

   Gulu lakumunda "Mtengo" lembani izi:

   • "Mtengo1" - "Zabwino kwambiri";
   • "Mtengo2" - "Zoyipa";
   • "Mtengo3" - "Zokhutiritsa";
   • "Mtengo4" - Zabwino;
   • "Mtengo5" - "Opambana".

   Pambuyo kukhazikitsa kwa deta yomwe ili pamwambayi itatha, dinani batani "Zabwino".



2. Chizindikiro cha chinthu choyambirira chikuwonetsedwa mu cell.



3. Kuti muchite zofanana ndi zomwe zatsala pazomwe zili mgawo, koperani zomwezo m'maselo ake pogwiritsa ntchito chikhomo, monga momwe zidachitidwira mu Njira 1. Monga mukuwonera, nthawi ino ntchito idagwira ntchito moyenera ndikuwonetsa zotsatira zonse malinga ndi algorithm yomwe idaperekedwa.

Chitsanzo 3: gwiritsani ntchito limodzi ndi ena ogwira ntchito

Koma wothandizirayu ndiwopindulitsa kwambiri Kusankha itha kugwiritsidwa ntchito limodzi ndi ntchito zina. Tiyeni tiwone momwe izi zimachitikira pogwiritsa ntchito ogwiritsa ntchito ngati zitsanzo. Kusankha ndi SUM.

Pali tebulo lamalonda ndi malo ogulitsira. Iagawidwa m'mizere inayi, iliyonse yomwe ikufanana ndi malo enaake otumizira. Ndalama zikuwonetsedwa padera pa mzere wa tsiku ndi mzere. Ntchito yathu ndikuonetsetsa kuti mutalowa mu nambala ya pepala, kuchuluka kwa ndalama zonse masiku ogulitsira omwe akuwonetsedwa. Mwa izi tigwiritsa ntchito ophatikiza SUM ndi Kusankha.

1. Sankhani khungu lomwe zotsatira zikuwonetsedwa ngati zochuluka. Pambuyo pake, dinani chizindikiro chomwe timadziwa kale "Ikani ntchito".



2. Zenera limayatsidwa Ogwira Ntchito. Pano tikupita ku gulu "Masamu". Pezani ndikuwonetsa dzinalo SUM. Pambuyo pake, dinani batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imayamba. SUM. Wothandizirayu amagwiritsidwa ntchito kuwerengetsa kuchuluka kwa manambala omwe amapezeka m'maselo a pepalalo. Mapulogalamu ake ndi osavuta komanso osapita m'mbali:

   = SUM (nambala1; nambala2; ...)

   Ndiye kuti, zotsutsana za wothandizirazi nthawi zambiri zimakhala manambala, kapena, kawirikawiri, amakamba za maselo omwe manambala oti awonjezedwe ali. Koma kwa ife, mkangano wokhawo si chiwerengero kapena cholumikizira, koma zomwe zalembedwazo Kusankha.

   Khazikitsani chotembezera m'munda "Nambala1". Kenako timadina pachizindikirocho, chomwe chikuwonetsedwa ngati chosemedwa ndi makona atatu. Chithunzichi chili pamzere womwewo wopingasa ngati batani. "Ikani ntchito" Ndi mzere wazanjira, koma kumanzere kwawo. Mndandanda wazinthu zomwe zangogwiritsidwa ntchito posachedwa umatseguka. Popeza njira Kusankha omwe agwiritsidwa ntchito posachedwapa ndi ife m'mbuyomu, ndiye pamndandanda. Chifukwa chake, ingodinani ichi kuti mupite pazenera zotsutsa. Koma ndizotheka kuti simudzakhala ndi dzina ili mndandanda. Poterepa, dinani pa udindo "Zina ...".



4. Kuyambira Ogwira Ntchitomomwe Malingaliro ndi Kufika tiyenera kupeza dzinali "DALIRANI" ndipo onetsani. Dinani batani "Zabwino".



5. Zenera la wothandizira limayendetsedwa. Kusankha. M'munda Chiwerengero Cha Index fotokozerani ulalo wa khungu mu pepalalo lomwe tidzalembamo kuchuluka kwa malo omwe angatulukire chiwonetsero chonse cha ndalama zonsezo.

   M'munda "Mtengo1" ayenera kulowetsera pamagawo "1 logulitsa". Izi ndizosavuta kuchita. Khazikitsani chotengera ku gawo lomwe lalongosoledwa. Kenako, pogwirizira batani lakumanzere, sankhani maselo onse "1 logulitsa". Adilesiyo idzawonekera nthawi yomweyo pazenera zotsutsana.

   Momwemonso m'munda "Mtengo2" onjezani zotsogola "Malo 2"m'munda "Mtengo3" - "3 point of sale", ndi m'munda "Mtengo4" - "Malo 4".

   Mukamaliza izi, dinani batani "Zabwino".



6. Koma, monga momwe tikuonera, fomuloli imawonetsa mtengo wolakwika. Izi ndichifukwa choti sitidalowebe nambala ya zotulutsa mu foni yolumikizana.



7. Lowetsani nambala yotulutsa mu bokosi lomwe cholinga chake ndi izi. Ndalama zomwe zimafanana ndi mzere womwewu zikuwonetsedwa nthawi yomweyo pazomwe zimapangidwira.

Ndikofunikira kudziwa kuti mutha kuyika manambala okha kuchokera ku 1 mpaka 4, omwe angafanane ndi kuchuluka kwa malo omwe akutulutsidwirawo. Ngati mulowetsa nambala ina iliyonse, fomuloli iperekanso cholakwika.

Phunziro: Momwe mungawerengere kuchuluka kwa Excel

Monga mukuwonera, ntchitoyo Kusankha ikagwiritsidwa ntchito moyenera, imatha kukhala thandizo labwino kwambiri kuti mumalize ntchito zomwe mwapatsidwa. Mukagwiritsidwa ntchito limodzi ndi ogwiritsa ntchito ena, mwayiwo umachulukirachulukira.