Njira imodzi yoyendetsera ndikusintha kwa zinthu ndi kusanthula kwa ABC. Ndi chithandizo chake, mutha kufotokozera zomwe zili m'bizinesi, katundu, makasitomala, ndi zina zambiri. mwa kuchuluka kwake. Nthawi yomweyo, malinga ndi kuchuluka kwa kufunika, gawo lililonse lili pamwambali limapatsidwa gawo limodzi mwa magawo atatu: A, B kapena C. Excel ali ndi zida zake zapamwamba zomwe zimapangitsa kuti zikhale zosavuta kuchita kafukufuku wamtunduwu. Tiwerenge momwe tingazigwiritsire ntchito, ndipo kuphatikizidwa kwa ABC ndi kotani.
Kugwiritsa Ntchito Kusanthula kwa ABC
Kusanthula kwa ABC ndi mtundu wa bwino komanso wogwirizana ndi mfundo zamakono zamikhalidwe ya Pareto. Malinga ndi njira yakakhazikitsire, zinthu zonse zowunikazo zimagawidwa m'magulu atatu molingana ndi kufunika kwake:
- Gulu A - zinthu zomwe zimakhala nazo mozungulira kuposa 80% mphamvu yayikulu;
- Gulu B - zinthu zomwe kuphatikiza kwake kumachokera 5% kale 15% mphamvu yayikulu;
- Gulu C - zomwe zatsala, kuphatikiza kwathunthu komwe kuli 5% ndi mphamvu yotsika pang'ono.
Makampani ena amagwiritsa ntchito njira zotsogola kwambiri ndikuphwanya zinthu m'magulu atatu kapena 4 kapena 5, koma tidalira dongosolo loyang'anira ABC.
Njira 1: kusintha kusanthula
Ku Excel, kusanthula kwa ABC kumachitika pogwiritsa ntchito mitundu. Zinthu zonse zimasanjidwa kuyambira zazing'ono mpaka zazing'ono. Kenako, kuwerengera kwazinthu zilizonse zowerengera kumawerengedwa, kutengera mtundu womwe wapatsidwa. Tiyeni tiwone, pogwiritsa ntchito chitsanzo, momwe njirayi imagwiritsidwira ntchito pochita.
Tili ndi tebulo lomwe lili ndi mndandanda wazinthu zomwe kampaniyo imagulitsa, ndi kuchuluka kogwirizana ndi zinthu zomwe zikugulitsidwa kwakanthawi. Pansipa ya tebulo, ndalama zonse za zinthu zonse zimamenyedwa. Ntchitoyi, pogwiritsa ntchito kusanthula kwa ABC, ndikugawa zinthuzi m'magulu molingana ndi kufunika kwa bizinesi.
- Sankhani tebulo ndi chowombezera cha deta, mutanyamula batani lakumanzere, kupatula mutu ndi mzere womaliza. Pitani ku tabu "Zambiri". Dinani batani. "Sinthani"ili mu chipangizo Sanjani ndi Fyuluta pa tepi.
Muthanso kuchita mosiyanasiyana. Sankhani pamwambapa patebulupo, ndikusunthira ku tabu "Pofikira" ndipo dinani batani Sanjani ndi Fyulutaili mu chipangizo "Kusintha" pa tepi. Mndandanda umayikidwa mmalo momwe timasankhira malo mmenemo. Makonda.
- Mukamagwiritsa ntchito zilizonse zomwe zatchulidwa pamwambapa, zenera lakukhazikitsa lakhazikitsidwa. Timayang'ana kotero mozungulira gawo "Zambiri zanga zimakhala ndi mutu" chizindikiritso chayikidwa. Ngati sichoncho, ikanipo.
M'munda Kholamu lembani dzina la mzere wokhala ndi zomwe mungapeze.
M'munda "Sinthani" muyenera kutchula mwachidule ndi mtundu wanji womwe mtunduwo uti udzapangidwe. Timasiya zosinthidwa - "Makhalidwe".
M'munda "Order" khazikitsani malo "Kuchotsa".
Mukapanga makonzedwe omwe atchulidwa, dinani batani "Zabwino" pansi pazenera.
- Pambuyo pochita zomwe zidanenedwazo, zinthu zonse zidasankhidwa ndi ndalama kuchokera zazikulu mpaka zazing'ono.
- Tsopano tikuyenera kuwerengera za kuchuluka kwa chilichonse cha zinthuzo kuti zitheke. Timapanga gawo lina pazolinga izi, zomwe tiziitcha "Mphamvu yapadera". Mu khungu loyamba la chipilalachi, ikani chikwangwani "=", Pambuyo pake timawonetsera kulumikizana ndi khungu komwe kuchuluka kwa ndalama zogulitsa zogwirizanazi kumapezeka. Kenako, ikani chizindikiro chogawa ("/") Pambuyo pake, sonyezani mgwirizano wa khungu, lomwe lili ndi kuchuluka kwathunthu kwa malonda mu bizinesi yonse.
Popeza kuti titengera njira yotsimikizika kumaselo ena omwe ali mgululi "Mphamvu yapadera" kugwiritsa ntchito chikhomo chodzaza, ndiye tiyenera kukonza adilesi yolumikizira chinthu chomwe chili ndi ndalama zonse zomwe bizinesiyo imayambitsa. Kuti muchite izi, pangani ulalo kuti ukhale mtheradi. Sankhani zolumikizira za selo lomwe mwatsimikiza ndikutsindikiza fungulo F4. Pamaso paogwirizanitsa, monga tikuonera, chikwangwani cha dollar chidatuluka, chomwe chikuwonetsa kuti ulalo wakhala mtheradi. Dziwani kuti kulumikizana kwa mtengo wa chuma cha chinthu choyambirira m'ndandandayo (Katundu 3) ayenera kukhala wachibale.
Kenako, kuti muwerenge, dinani batani Lowani.
- Monga mukuwonera, gawo lazopeza kuchokera kuzinthu zoyambirira zomwe zalembedwa mndandandawu zidawonetsedwa mu foni yomwe mukufuna. Kuti mumvere fomula pazomwe zili pansipa, ikani chikhazikitso pakona ya m'munsi ya foniyo. Amasandulika kukhala chikhomo chodzaza chomwe chimawoneka ngati mtanda wawung'ono. Dinani batani lakumanzere ndikukokera chikhomo mpaka kumapeto kwa mzati.
- Monga mukuwonera, mzere wonse umadzazidwa ndi data yodziwika ndi gawo lazopezeka pazogulitsa chilichonse. Koma mphamvu zenizeni zimawonetsedwa mwa mitundu, ndipo tiyenera kusintha kuti ikhale peresenti. Kuti muchite izi, sankhani zomwe zili patsamba "Mphamvu yapadera". Kenako timasunthira ku tabu "Pofikira". Pa riboni m'makonzedwe magulu "Chiwerengero" Pali malo omwe akuwonetsa mtundu wa data. Mwachidziwikire, ngati simunachite zowonjezera, mawonekedwe ayenera kukhazikitsidwa pamenepo "General". Timadina pachizindikiro mu mawonekedwe amakona atatu omwe ali kumanja kwa munda uno. Pamndandanda wamitundu yomwe imatseguka, sankhani malo "Chidwi".
- Monga mukuwonera, mawonekedwe onse azigawo adasinthidwa kukhala amitundu. Monga zikuyembekezeredwa, pamzere "Zonse" zikuwonetsedwa 100%. Gawo la katundu likuyembekezeka kukhala pamlingo kuchokera kulikulu kufikira laling'ono.
- Tsopano tikuyenera kupanga mzati momwe gawo lomwe lawerengeredwa likuwonetsedwa. Ndiye kuti, mumizere iliyonse, mphamvu inayake yazogulitsa inayake imawonjezera kulemera kwazinthu zonse zomwe zili pamndandanda womwe uli pamwambapa. Pazinthu zoyambirira m'ndandanda (Katundu 3) mphamvu yayikulu payokhapayokha komanso gawo lomwe mwapeza likhala lofanana, koma kwa onse otsatirawa, gawo lolandilidwa lakale la mndandanda liyenera kuwonjezeredwa ku chisonyezo.
Chifukwa chake, mzere woyamba timasunthira kukholalo Zogwirizana Chowonetsera mzati "Mphamvu yapadera".
- Kenako, ikani cholozera cha khungu lachiwiri mu mzati. Zogwirizana. Apa tikuyenera kuyikira formula. Timayika chikwangwani zofanana ndi kuwonjezera zomwe zili mchipsinacho "Mphamvu yapadera" mzere womwewo ndi zomwe zili ndi ma cell Zogwirizana kuchokera pamzere womwe uli pamwambapa. Timasiya maulalo onse, mwachitsanzo, sitimawanyengerera. Pambuyo pake, dinani batani Lowani kuwonetsa zotsatira zomaliza.
- Tsopano muyenera kukopera fomuloli m'maselo a gawo ili, omwe ali pansipa. Kuti muchite izi, gwiritsani ntchito chikhomo chodzaza, chomwe tidafotokozera kale mukamakopera fomamuyo "Mphamvu yapadera". Poterepa, mzere "Zonse" palibe chifukwa chogwira, chifukwa chokhala ndi zotsatira zake 100% ziwonetsedwa pazomaliza kuchokera pamndandanda. Monga mukuwonera, zinthu zonse za mzere wathu zidadzaza pambuyo pake.
- Pambuyo pake timapanga chipilala "Gulu". Tifunikira kugawa zinthu m'magulu A, B ndi C malinga ndi gawo lomwe mwapeza. Monga momwe timakumbukira, zinthu zonse zimagawika m'magulu molingana ndi chiwembu chotsatira:
- A - 80%;
- B - zotsatirazi 15%;
- Ndi --otsalira 5%.
Chifukwa chake, pazogulitsa zonse, gawo lolumikizidwa lazomwe limaphatikizidwa kumalire mpaka 80%gawani gulu A. Katundu wokhala ndi mphamvu inayake ya 80% kale 95% gawani gulu B. Gulu lazotsalira lomwe lili ndi mtengo woposa 95% anapeza mtundu wankhawo C.
- Pomveka, mutha kudzaza magulu awa ndi mitundu yosiyanasiyana. Koma izi ndizosankha.
Chifukwa chake, tidagawa zinthuzo m'magulu molingana ndi kufunika kwake, pogwiritsa ntchito kusanthula kwa ABC. Mukamagwiritsa ntchito njira zina, monga momwe zidatchulidwira pamwambapa, kugawanika m'magulu akulu kumagwiritsidwa ntchito, koma lingaliro la kugawanikana limakhalabe losasinthika.
Phunziro: Kutumiza ndi kusefa
Njira 2: gwiritsani ntchito kachitidwe kovuta
Zachidziwikire, kugwiritsa ntchito kusankha ndi njira yodziwika kwambiri yopanga kusanthula kwa ABC ku Excel. Koma nthawi zina, ndikofunikira kuwunikira osakonzanso mizere mu tebulo loyambayo. Poterepa, njira yovuta ingapulumutse. Mwachitsanzo, tidzagwiritsa ntchito gwero lomweli monga momwe lidalili poyambirira.
- Onjezani ku gome loyambirira lomwe lili ndi dzina la katunduyo ndi zomwe amapeza pogulitsa chilichonse, mzere "Gulu". Monga mukuwonera, pamenepa sitingawonjezere mzati powerengera magawo amtundu ndi owerengeka.
- Sankhani khungu loyamba mu mzati "Gulu"kenako dinani batani "Ikani ntchito"ili pafupi ndi mzere wa fomula.
- Kachitidwe kakuchitika Ogwira Ntchito. Timasunthira ku gululi Malingaliro ndi Kufika. Sankhani ntchito "DALIRANI". Dinani batani "Zabwino".
- Tsamba la mkangano wa ntchito limayambitsa. Kusankha. Mapangidwe ake amaperekedwa motere:
= SANGANI (Index_nambala; Mtengo1; Mtengo2; ...)Cholinga cha ntchitoyi ndikutulutsa imodzi mwazidziwitso, kutengera nambala ya index. Ziwerengero zamatchulidwe zimatha kufika 254, koma timangofunika mayina atatu okha omwe amafanana ndi magulu a kusanthula kwa ABC: A, B, Ndi. Titha kulowa mumunda nthawi yomweyo "Mtengo1" chizindikiro "A"m'munda "Mtengo2" - "B"m'munda "Mtengo3" - "C".
- Koma ndi mkangano Chiwerengero Cha Index muyenera kusamala nawo kwambiri ndi kuphatikiza owerenga ena ochepa mmenemo. Khazikitsani chotembezera m'munda Chiwerengero Cha Index. Chotsatira, dinani pazithunzi ngati mawonekedwe a makona atatu kumanzere kwa batani "Ikani ntchito". Mndandanda wa ogwiritsa ntchito omwe atha kugulidwa kumene akutsegulidwa. Tikufuna ntchito Sakani. Popeza mulibe mndandanda, ndiye dinani zomwe zalembedwazo "Zina ...".
- Zenera limayambiranso. Ogwira Ntchito. Apanso timasunthira ku gululi Malingaliro ndi Kufika. Pezani malo pamenepo "Sakani", sankhani ndikudina batani "Zabwino".
- Window Yogwiritsa Ntchito Itsegulidwa Sakani. Matchulidwe ake ndi awa:
= SEARCH (Searched_value; Viewed_array; Match_type)Cholinga cha ntchitoyi ndikudziwa kuchuluka kwa zinthu zomwe zaperekedwa. Ndiye kuti, ndizomwe timafunikira pamunda Chiwerengero Cha Index ntchito Kusankha.
M'munda Wawonedwa Mutha kunena mwachangu mawu otsatirawa:
{0:0,8:0,95}Iyenera kukhala mumabakitoni omatalikirana, ngati kachitidwe kakang'ono. Sizovuta kuganiza kuti manambala ((0; 0,8; 0,95) akuwonetsa malire a gawo lomwe mwapeza pakati pamagulu.
Mundawo Mtundu Wofananira kusankha koma pankhaniyi sitidzakwaniritsa.
M'munda "Kufunafuna mtengo" khazikitsani chotemberera. Ndiponso kudzera mu chithunzi pamwambapa mu mawonekedwe a pembera yomwe timasamukira Fotokozerani Wizard.
- Nthawi ino mkati Ntchito wiz kusunthira ku gulu "Masamu". Sankhani dzina SUMMS ndipo dinani batani "Zabwino".
- Tsamba la mkangano wa ntchito likuyamba SUMU. Wogwiritsa ntchitoyo amawerengera maselo omwe amakhala ndi vuto linalake. Kapangidwe kake ndi:
= SUMMES (mtundu; chitsimikizo; sum_range)M'munda "Zosintha" lowani adilesi "Ndalama". Pazifukwa izi, ikani cholozera m'munda, kenako, ndikusunga batani lakumanzere, sankhani maselo onse pamzera wolingana, osapatula phindu "Zonse". Monga mukuwonera, adilesiyi idawonetsedwa nthawi yomweyo m'munda. Kuphatikiza apo, tifunika kupanga ulalowu kukhala mtheradi. Kuti muchite izi, sankhani ndikusindikiza fungulo F4. Adilesiyi idadziwika ndi zizindikiro za dollar.
M'munda "Mundende" tiyenera kukhazikitsa. Tilowa mawu awa:
">"&Ndipo nthawi yomweyo tikamalowa timalowa mu adilesi yoyamba ya tsamba "Ndalama". Timapanga zolondera pamalonda adilesiyi popanga chikwangwani cha dola kuchokera ku kiyibodi yomwe ili kutsogolo kwa kalatayo. Timasiya maofesi owongoka, ndiye kuti, sayenera kukhala ndi chizindikiro pamaso pa manambala.
Pambuyo pake, osadina batani "Zabwino", ndikudina pa dzina la ntchitoyi Sakani bala.
- Kenako tibwereranso kuwindo latsutsano Sakani. Monga mukuwonera, m'munda "Kufunafuna mtengo" Zawonekera zomwe zayikidwa ndi wothandizira SUMU. Koma si zokhazo. Pitani ku gawo ili ndikuwonjezera chikwangwani pa zomwe zilipo. "+" opanda mawu. Kenako tikulembera adilesi yoyamba ya cholembayo "Ndalama". Ndiponso, timapanga zogwirizanitsa zolumikizana za ulalowu, ndikuzisiyira mbali.
Kenako, tengani zonse za mundawo "Kufunafuna mtengo" m'mabakaki, ndipo tidavumbulutsa chizindikirocho."/") Pambuyo pake, kachiwiri kudzera pa chithunzi cha makona atatu, pitani pazenera kusankha.
- Monga nthawi yotsiriza pothawa Ntchito wiz kufunafuna wothandizira yemwe ali mgululi "Masamu". Pakadali pano, ntchito yofunikayi imatchedwa SUM. Sankhani ndikudina batani. "Zabwino".
- Window Yogwiritsa Ntchito Itsegulidwa SUM. Cholinga chake chachikulu ndikubwereza mwachidule deta m'maselo. Kapangidwe ka mawu awa ndi kosavuta:
= SUM (Nambala1; Nambala2; ...)Kwa zolinga zathu ndi gawo lokhalo lofunikira "Nambala1". Lowani zolumikizira zamitundu yosiyanasiyana mu mzere. "Ndalama"kupatula khungu lomwe lili ndi totali. Tinachitanso zofananazi m'munda "Zosintha" ntchito SUMU. Monga nthawi imeneyo, timapanga zolumikizira zamtunduwu mosankha ndikusankha kiyi F4.
Pambuyo pake, dinani batani "Zabwino" pansi pazenera.
- Monga mukuwonera, zovuta za zomwe zimayambitsidwa zidawerengera ndikubwezeretsanso maselo oyambayo "Gulu". Zopangira zoyambirira zidapatsidwa gulu "A". Makina onse omwe tidawerengera awa ndi awa:
= SANGANI (SEWERANI ((SUMMES ($ B $ 2: $ B $ 27; ">" & $ B2) + $ B2) / SUM ($ B $ 2: $ B $ 27); {0: 0.8: 0.95} ); "A"; "B"; "C")Koma, zowonadi, muzochitika zonse, zogwirizanitsa mwanjira iyi zimakhala zosiyana. Chifukwa chake, silingaganizidwe ponseponse. Koma, pogwiritsa ntchito malangizo omwe aperekedwa pamwambapa, mutha kuyika zolumikizira za tebulo lililonse ndikugwiritsa ntchito mwanjira imeneyi mulimonse.
- Komabe, izi sizonse. Tidawerengera mzere woyamba wa tebulo. Kuti muthe kutchukitsa mzere womwe uli ndi deta "Gulu", muyenera kukopera formula iyi pamizere ili m'munsiyi (kupatula tsamba loyang'ana mzere) "Zonse") pogwiritsa ntchito chikhomo, monga tachita zoposa kale. Dongosolo litalowa, kusanthula kwa ABC kumatha kuonedwa kuti kumalizidwa.
Monga mukuwonera, zotsatira zomwe zimapezeka pogwiritsa ntchito njira yosavuta sizisiyanasiyana konse pazotsatira zomwe tidachita posankha. Zogulitsa zonse zimapatsidwa magulu omwewo, koma mizere sinasinthe mawonekedwe awo.
Phunziro: Excel Feature Wizard
Excel imathandizira kwambiri kusanthula kwa ABC kwa wogwiritsa ntchito. Izi zimatheka pogwiritsa ntchito chida monga kukonza. Pambuyo pa izi, mphamvu yapadera payekha, gawo lomwe lasonkhanitsidwa, ndipo, magawikidwe m'magulu amawerengedwa. Nthawi zosintha mawonekedwe oyamba a mizere patebulopo saloledwa, mutha kugwiritsa ntchito njirayi pogwiritsa ntchito njira yovuta.
