Usebenzisa Ukuhlaziywa kwe-ABC kuMicrosoft Excel

Enye yezindlela ezibalulekile zokuphatha kanye nokuhlelwa kwezinto ukuhlolwa kwe-ABC. Ngosizo lwayo, ungahlukanisa izinsiza zebhizinisi, izimpahla, amakhasimende, njll. ngezinga lokubaluleka. Ngasikhathi sinye, ngokuya ngezinga lokubaluleka, ngalinye lalamayunithi angenhla labelwe isigaba esisodwa kwezi ezintathu: A, B noma C. Excel linamathuluzi alo wemithwalo okwenza kube lula ukuqhuba lolu hlobo lokuhlaziya. Ake sibheke ukuthi sizisebenzisa kanjani, nokuthi yini eyakha ukuhlaziywa kwe-ABC.

Kusetshenziswa Ukuhlaziywa kwe-ABC

Ukuhlaziywa kwe-ABC luhlobo lokuthuthuka futhi oluvumelaniswa nezimo zanamuhla zenkambiso yemigomo ye-Pareto. Ngokwendlela yokuqalisa ukusebenza kwayo, zonke izinto zokuhlaziywa zihlukaniswe izigaba ezintathu ngokuya ngokubaluleka:

• Isigaba A - Izinto ezinokubumbene ngaphezulu kwe 80% amandla athile adonsela phansi;
• Isigaba B -izakhi zokuhlanganiswa kwazo okuvela kuzo 5% ngaphambili 15% amandla athile adonsela phansi;
• Isigaba C - izinto ezisele, inhlanganisela ephelele yazo 5% namandla adonsela phansi.

Ezinye izinkampani zisebenzisa amasu athuthukile futhi zibhidliza izinto zibe ngamaqembu ama-3 noma ama-4 noma ama-5, kepha sizoncika ohlelweni lokuhlaziya lwe-ABC lwakudala.

Indlela yoku-1: ukuhlaziya ukuhlaziya

E-Excel, ukuhlaziywa kwe-ABC kwenziwa kusetshenziswa ukuhlunga. Zonke izinto zihlelwe ukusuka kokukhulu kuya kokuncane. Ngemuva kwalokho, kubalwa amandla athile aqoqiwe entweni ngayinye, kususelwa ekutheni isigaba esithile sabelwe sona. Ake sibheke, sisebenzisa isibonelo esithile, ukuthi le ndlela isetshenziswa kanjani ekusebenzeni.

Sinethebula elinohlu lwezimpahla ezithengiswa yinkampani, kanye nenani elihambisanayo lemali evela ekuthengisweni kwabo isikhathi esithile. Ngezansi kwetafula, imali engenayo yazo zonke izinto zezimpahla iyashaywa. Umsebenzi, usebenzisa ukuhlaziywa kwe-ABC, ukwahlukanisa le mikhiqizo ngamaqembu ngokuya ngokubaluleka kwebhizinisi.

1. Khetha itafula nesikhombisi sedatha, ubambe inkinobho yegundane kwesobunxele, ungafaki unhlokweni kanye nomugqa wokugcina. Iya kuthebhu "Idatha". Chofoza inkinobho. "Hlunga"etholakala kwibhulokhi yamathuluzi Hlunga nesihlungi ekhasethini.

   

   Ungenza futhi ngokuhlukile. Khetha uhla olungenhla lwethebula, bese udlulela kuthebhu "Ikhaya" bese uchofoza inkinobho Hlunga nesihlungietholakala kwibhulokhi yamathuluzi "Ukuhlela" ekhasethini. Uhlu lusebenza lapho sikhetha khona isikhundla kulo. Uhlobo Lwezifiso.



2. Uma usebenzisa noma yiziphi izenzo ezingenhla, kuvulwa iwindi lezilungiselelo zokuhlela. Sibheka ukuze azungeze ipharamitha "Imininingwane yami iqukethe izihloko" umaki wokuhlola usethiwe. Uma kwenzeka ungekho, faka.

   Ensimini Ikholomu khombisa igama lekholomu eliqukethe idatha yengeniso.

   Ensimini "Hlunga" udinga ukucacisa ukuthi iyiphi indlela ethile yokuhlunga okuzokwenziwa. Sishiya izilungiselelo ezichazwe ngaphambilini - "Amanani".

   Ensimini "I-oda" setha isikhundla Yehla ".

   Ngemuva kokwenza izilungiselelo ezichaziwe, chofoza inkinobho "Kulungile" phansi kwewindi.



3. Ngemuva kokwenza isenzo esibekiwe, zonke izinto zahlelwa ngenzuzo ukusuka kokukhulu kuya kokuncane.



4. Manje kufanele sifunde amandla athile adonsela phansi wezinto ngazinye ngenani. Sakha ikholamu eyengeziwe yalezi zinhloso, esizoyibiza "Ukudonsela okuthile". Esitokisini sokuqala sale kholamu, faka uphawu "=", ngemuva kwalokho sibonisa isixhumanisi esitokisini lapho inani lemali evela ekuthengisweni komkhiqizo elihambisanayo litholakala. Okulandelayo, setha uphawu lokuhlukanisa ("/") Ngemuva kwalokho, bonisa izixhumanisi zeseli, equkethe inani lokuthengiswa kwezimpahla kulo lonke ibhizinisi.

   Njengoba kunikezwe iqiniso lokuthi sizokopisha ifomula ebekiwe kwamanye amaseli kukholamu "Ukudonsela okuthile" sisebenzisa umaki wokugcwalisa, lapho-ke sidinga ukulungisa ikheli lesixhumanisi sento equkethe inani lemali engenayo yebhizinisi. Ukuze wenze lokhu, yenza isixhumanisi siphelele. Khetha izixhumanisi zeseli elicacisiwe kwifomula bese ucindezela ukhiye F4. Phambi kwezixhumanisi, njengoba sibona, kwavela uphawu lwedola, okukhombisa ukuthi isixhumanisi sesiphelele. Kufanele kuqashelwe ukuthi isixhumanisi esilinganisweni senzuzo yento yokuqala ohlwini (Umkhiqizo 3) kumele ihlale isihlobo.

   Ngemuva kwalokho, ukwenza ukubala, chofoza inkinobho Ngena.



5. Njengoba ukwazi ukubona, ingxenye yemali evela kumkhiqizo wokuqala obhalwe kuhlu iboniswe kuseli kwelitshe. Ukukopisha ifomula ebangeni elingezansi, beka ikhesa ekhoneni elingezansi kweseli. Ishintsha ibe umaka wokugcwalisa obukeka njengesiphambano esincane. Chofoza inkinobho yegundane kwesobunxele bese uhudula umaki wokugcwalisa uze ufike ekugcineni kwekholomu.



6. Njengoba ubona, ikholomu yonke igcwele ngemininingwane efakwa ekwabelaneni kwemali etholwayo ngokuthengiswa komkhiqizo ngamunye. Kodwa amandla adonsela phansi aboniswa ngefomethi yamanani, futhi sidinga ukukuguqula kube yipesenti. Ukuze wenze lokhu, khetha okuqukethwe kwikholamu "Ukudonsela okuthile". Ngemuva kwalokho siqhubekela kuthebhu "Ikhaya". Kubambo obeseqoqweni lezilungiselelo "Inombolo" Kunenkambu ebonisa ifomethi yedatha. Ngokuzenzakalelayo, uma ungazange wenze umkhawulo owengeziwe, ifomethi kufanele isethwe lapho "Okujwayelekile". Sichofoza isithonjana ngesimo sonxantathu otholakala ngakwesokunene sale nkambu. Uhlu lwamafomethi oluvulayo, khetha isikhundla "Intshisekelo".



7. Njengoba ubona, wonke amanani wekholomu aguqulwe abe ngamanani wamaphesenti. Njengoba kulindeleke, emgqeni "Okuphelele" kukhonjisiwe 100%. Ingxenye yezimpahla kulindeleke ukuba ibe kukholamu ukusuka kokukhulu kuya kokuncane.



8. Manje kufanele sakhe ikholomu lapho isabelo esinqwabelanayo esinenani eliphelele lizovezwa. Okusho ukuthi, kumugqa ngamunye, amandla adonsela phansi womkhiqizo othize azokwengeza isisindo esithile sazo zonke lezo mikhiqizo ezisehlwini olungenhla. Kwinto yokuqala ohlwini (Umkhiqizo 3) amandla athile athize kanye nokwabelana okuqoqiwe kuzolingana, kepha kubo bonke abalandelayo, isabelo esinqunyelwe sengxenye yangaphambilini yohlu sizodinga ukungezwa kwinkomba yomuntu ngamunye.

   Ngakho-ke, emgqeni wokuqala sidlulela kukholomu Isabelo Esitholwayo inkomba yekholomu "Ukudonsela okuthile".



9. Okulandelayo, setha ikhesa kuseli lesibili kwikholamu. Isabelo Esitholwayo. Lapha kufanele sisebenzise ifomula. Sibeka isibonakaliso okulinganayo bese wengeza okuqukethwe kuseli "Ukudonsela okuthile" umugqa ofanayo nokuqukethwe kweseli Isabelo Esitholwayo kusuka kulayini ongenhla. Sishiya zonke izixhumanisi, okungukuthi, asizikhohlisi. Ngemuva kwalokho chofoza inkinobho Ngena ukukhombisa umphumela wokugcina.



10. Manje udinga ukukopisha le formula kumaseli ale kholomu, akhiwe ngezansi. Ukuze wenze lokhu, sebenzisa umaki wokugcwalisa, esivele sisebenza kuwo lapho sikopisha ifomula kwikholamu "Ukudonsela okuthile". Kulokhu, umugqa "Okuphelele" asikho isidingo sokuthwebula, ngoba umphumela oqoqiwe kuwo 100% izokhonjiswa entweni yokugcina kusuka ohlwini. Njengoba ubona, zonke izakhi zekholomu yethu zagcwaliswa emva kwalokho.



11. Ngemuva kwalokho sakha ikholomu "Iqembu". Sizodinga ukuhlanganisa imikhiqizo ngezigaba A, B futhi C ngokwesabelo esibonisiwe. Njengoba sikhumbula, zonke izinto zisatshalaliswa ngamaqembu ngokuya ngohlelo olulandelayo:
    • A - ukuze 80%;
    • B - okulandelayo 15%;
    • Nge - okusele 5%.

    Ngakho-ke, kuyo yonke impahla, isabelo esinqwabelanayo sobugwegwe obuthile obufakiwe emngceleni kuze kube 80%nika isigaba A. Izimpahla ezinokudlanga okuthile kwe 80% ngaphambili 95% nika isigaba B. Iqembu lomkhiqizo elisele elinenani elikhulu kune 95% isigaba esinqunyelwe sokwabelwa isisindo C.



12. Ukucaciswa, ungagcwalisa la maqembu ngemibala ehlukene. Kepha lokhu kungakhethwa.

Ngakho-ke, sahlukanisa izakhi zaba ngamaqembu ngokuya ngezinga lokubaluleka, sisebenzisa ukuhlaziywa kwe-ABC. Lapho usebenzisa amanye amasu, njengoba sekushiwo ngenhla, ukuhlukanisa kube inani elikhulu lamaqembu kuyasetshenziswa, kepha umgomo wokuhlukanisa uqhubeka cishe ungashintshi.

Isifundo: Ukuhlunga nokuhlunga

Indlela 2: sebenzisa ifomula eyinkimbinkimbi

Vele, ukusetshenziswa kokuhlunga kuyindlela ejwayelekile kakhulu yokwenza ukuhlaziya kwe-ABC e-Excel. Kepha kwezinye izimo, kuyadingeka ukwenza lokhu kuhlaziya ngaphandle kokuhlela kabusha imigqa ethebuleni lasekuqaleni. Kulokhu, ifomula eyinkimbinkimbi izokusiza. Njengesibonelo, sizosebenzisa itafula lomthombo elifanayo njengasekuqaleni.

1. Faka etafuleni lokuqala eliqukethe igama lezimpahla kanye nembuyiselo ethengisiwe yomunye wabo, ikholamu "Iqembu". Njengoba ukwazi ukubona, kuleli cala ngeke sengeze amakholomu ngokubalwa kwezabelo ngazinye nezandayo.



2. Khetha iseli lokuqala kukholamu "Iqembu"bese uchofoza inkinobho "Faka umsebenzi"eseduze komugqa wamafomula.



3. Ukuqalisa kuyaqhubeka Umsebenzi Wizards. Siqhubekela esigabeni Izinkomba kanye nokufika. Khetha umsebenzi "UKUKHETHA". Chofoza inkinobho "Kulungile".



4. Iwindi lokuphikisana ngomsebenzi lisebenza. Ukukhetha. I-syntax yayo yethulwe kanjena:

   = KHETHA (Inkomba_inothi; Ivelu1; Inani2; ...)

   Inhloso yalo msebenzi ukukhipha enye yamanani akhonjisiwe, kuya ngenombolo yenkomba. Inani lamanani lingafinyelela ku-254, kepha sidinga amagama amathathu kuphela ahambelana nezigaba zokuhlaziywa kwe-ABC: A, B, Nge. Singangena ngokushesha ensimini "Inani1" uphawu "A"enkundleni "Inani2" - "B"enkundleni "Inani3" - "C".



5. Kepha ngengxabano Inombolo ye-Index kufanele unamathele ngokuphelele kuyo ngokuhlanganisa opharetha abengeziwe abengeziwe kuyo. Setha isikhombisi esigangeni Inombolo ye-Index. Okulandelayo, chofoza isithonjana ngesimo sonxantathu ngakwesobunxele inkinobho "Faka umsebenzi". Uhlu lwabasebenzisi abasanda kusetyenziswa luvulwa. Sidinga umsebenzi SESHA. Njengoba ingekho ohlwini, bese uchofoza okubhaliwe "Ezinye izinto ...".



6. Iwindows liqala futhi. Umsebenzi Wizards. Siphinde futhi sithuthele esigabeni Izinkomba kanye nokufika. Thola isikhundla lapho "FUNA", ikhethe bese uchofoza inkinobho "Kulungile".



7. Iwindows Opgree Window Ivula SESHA. I-syntax yayo imi ngolu hlobo:

   = SEARCH (Kubhungiwe_value; kubukwe_kwenziwe; Match_type)

   Inhloso yalo msebenzi ukuthola inani lesikhundla sento ethile. Lokho wukuthi, yilokho esikudingayo kuphela ngensimu Inombolo ye-Index imisebenzi Ukukhetha.

   Ensimini Kubukwa u-Array Ungacacisa ngokushesha le nkulumo elandelayo:

   {0:0,8:0,95}

   Kufanele kube kubakaki abangama-curly, njengefomula yamalungu afanayo. Akunzima ukuqagela ukuthi lezi zinombolo (0; 0,8; 0,95) khombisa imingcele yesabelo esinqwabelene phakathi kwamaqembu.

   Insimu Uhlobo Lomdlalo ngokuzithandela futhi kulokhu ngeke sikugcwalise.

   Ensimini "Ukufuna inani" setha isikhombisi. Bese siphinda futhi sisebenzise le pictograph engenhla ngesimo sonxantathu esithuthela kuwo Isici Wizard.



8. Kulokhu ku Umsebenzi wizadi hambisa esigabeni "Izibalo". Khetha igama ISUMMS bese uchofoza inkinobho "Kulungile".



9. Iwindi lokuphikisana ngomsebenzi liyaqala ISILAMU. U-opharetha ochaziwe ufingqa amaseli ahlangabezana nesimo esithile. I-syntax yayo yile:

   = SUMMES (ububanzi; inqubomgomo; isibalo_ububanzi)

   Ensimini "Ububanzi" faka ikheli lekholomu "Imali engenayo". Ngalezi zinhloso, setha ikhesa endle, bese ubamba inkinobho yegundane kwesobunxele, ukhethe wonke amaseli kukholamu ehambisanayo, ngaphandle kwenani "Okuphelele". Njengoba ukwazi ukubona, ikheli lalikhonjiswa ngokushesha enkundleni. Ngaphezu kwalokho, kudingeka senze lesi sixhumanisi sibe ngokuphelele. Ukuze wenze lokhu, khetha bese ucindezela inkinobho F4. Ikheli livele nezimpawu zamadola.

   Ensimini "Indawo yokuhlala" kudingeka sibeke isimo. Sifaka le nkulumo elandelayo:

   ">"&

   Bese kuthi ngokushesha emva kwawo sifaka ikheli leseli lokuqala lekholamu "Imali engenayo". Senza izixhumanisi ezilinganayo kuleli kheli ngokuphelele ngokufaka uphawu lwedola kusuka kukhibhodi ephambi kwencwadi. Sishiya izixhumanisi eziqonde mpo, okungukuthi, akufanele kube khona uphawu phambi kwidijithi.

   Ngemuva kwalokho, ungachofozi inkinobho "Kulungile", bese uchofoza igama lomsebenzi SESHA emugqeni wefomula.



10. Ngemuva kwalokho sibuyela ewindini lokuphikisana ngomsebenzi SESHA. Njengoba ubona, enkundleni "Ukufuna inani" kwavela idatha esethwe yisisebenzisi ISILAMU. Kepha akupheleli lapho. Iya kule nsimu bese ungeza isibonakaliso kudatha ekhona. "+" ngaphandle kwezingcaphuno. Ngemuva kwalokho sifaka ikheli leseli lokuqala lekholamu "Imali engenayo". Futhi, senza izixhumanisi ezivundlile zalesi sixhumanisi ngokuphelele, futhi sizishiyela isihlobo mpo.

    Okulandelayo, thatha konke okuqukethwe insimu "Ukufuna inani" kubakaki, okwathi ngemuva kwalokho sabeka uphawu lokuhlukanisa ("/") Ngemuva kwalokho, futhi ngesithonjana sikunxantathu, iya ewindini lokukhetha umsebenzi.



11. Like okokugcina ekubalekeni Umsebenzi wizadi ngifuna opharetha ofunayo esigabeni "Izibalo". Manje, umsebenzi owuthandayo ubizwa ISUM. Khetha bese uchofoza inkinobho. "Kulungile".



12. Iwindows Opgree Window Ivula ISUM. Inhloso yawo eyinhloko ukufingqa idatha kumaseli. I-syntax yalesi sitatimende ilula:

    = SUM (Inombolo1; Inombolo2; ...)

    Ngezinhloso zethu kuphela insimu edingekayo "Inombolo1". Faka izixhumanisi zobubanzi bekholomu kuyo. "Imali engenayo"ngaphandle kweseli equkethe amanani. Sivele senze umsebenzi ofanayo enkundleni "Ububanzi" imisebenzi ISILAMU. Njengamanje ngalesosikhathi, senza abaxhumanisi babubanzi ngokuphelele ngokukhetha kwabo nokucindezela ukhiye F4.

    Ngemuva kwalokho chofoza inkinobho "Kulungile" phansi kwewindi.



13. Njengoba ubona, inkimbinkimbi yemisebenzi eyethuliwe yenza isibalo futhi yabuya nomphumela kwiseli yokuqala yekholamu "Iqembu". Umkhiqizo wokuqala wabelwa iqembu "A". Ifomula egcwele esiyisebenzisile kulokhu kubalwa yile elandelayo:

    = KHETHA (SEBULA ((ISUMMES ($ B $ 2: $ B $ 27; ">" & $ B2) + $ B2) / SUM ($ B $ 2: $ B $ 27); {0: 0.8: 0.95} ); "A"; "B"; "C")

    Kepha, kunjalo, esimweni ngasinye, izixhumanisi ezikule formula zizohluka. Ngakho-ke, akunakubhekwa njengendawo yonke. Kepha, usebenzisa inkombandlela enikezwe ngenhla, ungafaka izixhumanisi zanoma iyiphi ithebula bese usebenzisa ngempumelelo le ndlela kunoma yisiphi isimo.



14. Kodwa-ke, lokhu akupheleli. Senze ukubala kuphela umugqa wokuqala wethebula. Ukuze ugcwalise ngokuphelele ikholomu nedatha "Iqembu", udinga ukukopisha le formula ebangeni elingezansi (ngaphandle kweseli lomugqa "Okuphelele") usebenzisa umaki wokugcwalisa, njengoba senze kaningi ukwedlula. Ngemuva kokuthi idatha ifakiwe, ukuhlaziywa kwe-ABC kungabhekwa njengokuqediwe.

Njengoba ukwazi ukubona, imiphumela etholwe kusetshenziswa inketho usebenzisa ifomula eyinkimbinkimbi ayihlukile nakancane emiphumeleni esiyenzile ngokuhlela. Yonke imikhiqizo yabelwe izigaba ezifanayo, kepha imigqa ayikashintshi isikhundla sayo sokuqala.

Isifundo: I-Excel Feature Wizard

I-Excel ingenza kakhulu ukuhlaziywa kwe-ABC komsebenzisi. Lokhu kutholakala kusetshenziswa ithuluzi njengokuhlunga. Ngemuva kwalokhu, amandla adonsela ngokuqondile, isabelo esinqwabelene futhi, empeleni, ukwahlukana kube ngamaqembu kubalwa. Ezimweni lapho ukuguqula isikhundla sokuqala semigqa etafuleni kungavunyelwe, ungafaka indlela usebenzisa ifomula eyinkimbinkimbi.