Isesengura rya ABC muri Excel

Bumwe mu buryo bwingenzi bwo gucunga hamwe nibikoresho ni isesengura rya ABC. Hamwe nacyo, urashobora gutondekanya umutungo wimishinga, ibicuruzwa, abakiriya, nibindi. Ukurikije urwego rwingenzi. Muri icyo gihe, ku rwego rw'akamaro, buri gice cyavuzwe haruguru cyahawe kimwe mu byiciro bitatu: A, B cyangwa CESL gahunda ifite ibikoresho byo mu mizigo byoroshye gukora ubu bwoko bw'isesengura. Reka tumenye uburyo bwo kubikoresha, kandi isesengura rya ABC.

Ukoresheje isesengura rya ABC

Isesengura rya ABC nubwoko bwongerewe kandi bumenyereye imiterere igezweho kumahame ya pareto. Dukurikije uburyo bw'imyitwarire yacyo, ibintu byose bigize isesengura bigabanijwemo ibyiciro bitatu ukurikije urwego rwingenzi:

• Icyiciro A - Ibintu bifite ihuriro rirenga 80% byuburemere bwihariye;
• Icyiciro B - Ibintu bifitanye isano kuva kuri 5% kugeza 15% byuburemere bwihariye;
• Icyiciro C - Ibintu bisigaye, igiteranyo cyose cyacyo ni 5% na bike.

Gutandukanya ibigo bikoresha tekinike nyinshi hanyuma ugabanye ibintu bitagera kuri 3, ariko bitarenze 4 cyangwa 5, ariko tuzashingira kuri gahunda ya Classic ABC ya kera.

Uburyo 1: Isesengura rifite Gutondeka

Isesengura rya Excel ABC rikorwa ukoresheje itondekanya. Ibintu byose byakemuwe mu mavuta kuri bike. Noneho umugabane uhura na buri kintu ubarwa, hashingiwe kubyo yahawe icyiciro runaka. Reka tumenye uburyo uburyo bwerekanwe bukoreshwa mubikorwa.

Dufite ameza hamwe nurutonde rwibicuruzwa Isosiyete igurisha, hamwe numubare winjiza ugurishwa mugihe runaka. Hasi yameza, ibisubizo byinjiza muri rusange kumazina yose yibicuruzwa. Hariho umurimo ukoresheje isesengura rya ABC, fata ibyo bicuruzwa mumatsinda akoresheje akamaro kayo.

1. Turagaragaza ameza hamwe na indanga ufunga buto yimbeba yibumoso, ukuyemo cap hamwe nizuba ryanyuma. Jya kuri tab "data". Twakanze kuri buto ya "Sort", iherereye muburyo bwa "Stret na filteri" umurongo kuri kaseti.

   

   Urashobora kandi gukora ukundi. Tugenera inzitizi yavuzwe haruguru, hanyuma tujye kuri tab "urugo" hanyuma ukande kuri "Sort na Akayunguruzo" muri buto yo guhinduranya. Urutonde rukoreshwa aho umwanya "utondekanya gutondekanya" ukora.



2. Iyo ushyira mubikorwa bimwe byavuzwe haruguru, igenamiterere ryidirishya ryatangiriye. Turareba rero ko "amakuru yanjye arimo imitwe" parameter yashyizwe kuri cheque. Kubireba kubura, shyiramo.

   Mu murima "inkingi", sobanura izina ryinkingi aho amakuru yinjiza akubiye.

   Muri "Stre" ", ugomba kwerekana, aho ibipimo byihariye bizakemurwa. Kureka Igenamiterere rya Preset - "Indangagaciro".

   Muri "gahunda", erekana umwanya "kumanuka".

   Nyuma yibicuruzwa byigenamiterere ryagenwe, kanda kuri buto "OK" hepfo yidirishya.



3. Nyuma yo gukora ibikorwa byagenwe, ibintu byose byakemuwe ninjiza kuva kuri byinshi kuri bito.



4. Noneho tugomba kubara igipimo cya buri kintu cyibisubizo rusange. Kora inkingi yinyongera kuri izo ntego, niyita "kugabana uburemere". Muri selire ya mbere yiyi nkingi, dushyira ikimenyetso "=", nyuma ugaragaza isano ihuza akanywaho aho amafaranga yinjiza ashyirwa mubikorwa ryibicuruzwa bijyanye. Ubukurikira, shiraho ikimenyetso cy'ishami ("/"). Nyuma yibyo, twerekana imirongo ya selile, irimo umubare wuzuye wo kugurisha ibicuruzwa mumuryango wose.

   Urebye ko formula yagenwe izandukure mubindi bigo bya "umugabane" wikimenyetso cyuzuye, adresse yumurongo winjiza ikubiyemo amafaranga yanyuma, dukeneye gukosorwa. Gukora ibi, kora umurongo rwose. Hitamo imirongo ya selile yerekanwe muri formula hanyuma ukande urufunguzo rwa F4. Mbere yo guhuza, nkuko tubibona, ikimenyetso cyamadorari cyagaragaye, cyerekana ko umurongo wabaye rwose. Twabibutsa ko yerekeza kumwanya winjiza ubanza kurutonde rwibicuruzwa (ibicuruzwa 3) bigomba gukomeza kuba umwe.

   Noneho, kugirango ibabare, kanda buto yimtonde.



5. Nkuko tubibona, igice cyinjiza kubicuruzwa byambere byerekanwe kurutonde rwagaragaye muri selire. Gukoporora formula iri murwego rukurikira, dushyira indanga kuruhande rwiburyo bwiburyo bwa selire. Guhinduka kwayo mu mashusho yo kuzura, kureba umusaraba muto. Tugacamo buto yimbeba hanyuma tukurure ikimenyetso cyuzuye kugeza kumpera yinkingi.



6. Nkuko mubibona, inkingi yose yuzuyemo amakuru aranga igipimo cyinjiza kuva mu ishyirwa mu bikorwa rya buri gicuruzwa. Ariko agaciro k'uburemere bwihariye rugaragazwa muburyo bwumubare, kandi dukeneye kubihindura mu ijanisha. Kugira ngo ukore ibi, garagaza ibiri mu nkingi "uburemere bwihariye". Noneho twimukira kuri tab "urugo". Kuri kaseti mumatsinda igenamiterere hari itsinda ryerekana imiterere yamakuru. Mburabuzi, niba utatanze ibikoresho byinyongera, imiterere "rusange" igomba gushyirwaho aho. Kanda ku gishushanyo muburyo bwa mpandeshaturereye iburyo bwuyu muriyi. Kurutonde rwimiterere, hitamo umwanya "ijanisha".



7. Nkuko tubibona, indangagaciro zose zinjijwe zahinduwe indangagaciro. Nkuko bikwiye, 100% byerekanwe mumurongo wa "byose". Umugabane wibicuruzwa biteganijwe mu nkingi kuva nini kugeza kuri nto.



8. Noneho dukwiye gukora inkingi aho umugabane wakusanyije hamwe nibisubizo byihuse byagaragara. Ni ukuvuga, muri buri murongo ku buremere bwihariye bwibicuruzwa byihariye bizongerwaho ugereranije nibicuruzwa byose biherereye kurutonde rwavuzwe haruguru. Kubicuruzwa byambere kurutonde (ibicuruzwa 3), umubare wumuntu ku giti cye hamwe numugabane wikusanyirijwe hamwe, ariko byose bikurikizwa kubiranganya kugiti cye bizakenera kongeramo umugabane winjijwemo kurutonde.

   Rero, ku murongo wa mbere twimuriwe ku nkingi "tugiriye uruhare runini" byerekana ko inkingi "yihariye".



9. Ibikurikira, shiraho indanga kuri selire ya kabiri y 'inkingi "yegeranijwe". Hano tugomba gukoresha formula. Dushyize ikimenyetso "bingana kandi tugafata ibikubiye mu kagari" igipimo "cy'umurongo umwe n'ibiri mu kagari" bigize uruhare runini "duhereye ku mugozi wavuzwe haruguru. Ibijyanye nibisobanuro byabitswe, nibyo, ntabwo dukora mamipimagem. Nyuma yibyo, kora gukanda kuri buto yinjira kugirango werekane ibisubizo byanyuma.



10. Noneho ukeneye kwigana iyi formulaire muri selile yiyi nkingi, ishyirwa hepfo. Kugirango dukore ibi, dukoresha ikimenyetso cyuzuyemo tumaze kwitabaza mugihe cyo kwigana formulaire mumigabane. Muri icyo gihe, umugozi "wose" ntabwo ari ngombwa, kubera ko ibisubizo byegeranijwe 100% bizerekanwa 100% ku bicuruzwa byanyuma uhereye kurutonde. Nkuko mubibona, ibintu byose byinkingi zacu nyuma yujujwe.



11. Nyuma yibyo, kora inkingi ". Tuzakenera kwinjiza ibicuruzwa murwego A, B na C ukurikije umugabane wagaragaye. Nkuko twibuka, ibintu byose bitangwa namatsinda ukurikije gahunda ikurikira:
    • A - kugeza kuri 80%;
    • B - abakurikira 15%;
    • C - 5% isigaye.

    Rero, ibicuruzwa byose byakusanyije uburemere bwihariye buri mu rubibe rw'abagera kuri 80%, tugenera icyiciro. Ibicuruzwa bifite uburemere bwihariye bwo gukusanya 80% kugeza 95% basigaye mu cyiciro B. Ibisigaye Itsinda ryibicuruzwa hamwe nagaciro karenze 95% yuburemere bweruye duha icyiciro C.



12. Kuburyo busobanutse, urashobora kuzuza amatsinda yerekanwe n'amabara atandukanye. Ariko ni ubushake.

Rero, twamennye ibintu kurwego rwingirakamaro, dukoresheje isesengura ya ABC. Iyo ukoresheje ubundi buryo bumwe, nkuko byavuzwe haruguru, bikoreshwa mu kumena umubare munini wamatsinda, ariko ihame ryo kumena uru rubanza rikomeje guhinduka.

Isomo: Gutondeka no gushungura muri Excel

Uburyo 2: Gukoresha formula igoye

Birumvikana ko gukoresha gutondeka nuburyo bukunze kuyobora isesengura rya ABC muri Excele. Ariko mubihe bimwe ni ngombwa gukora iri sesengura ridafite imirongo ahantu mumeza yinkomoko. Muri iki kibazo, formulaire igoye izaza gutabara. Kurugero, tuzakoresha imbonerahamwe imwe nkurubanza rwa mbere.

1. Twongeyeho kumeza yinkomoko arimo izina ryibicuruzwa hamwe ninjiza yatanzwe na buri kimwe muri byo, "Inkingi" ". Nkuko mubibona, muriki gihe, ntidushobora kongera inkingi hamwe no kubara kubwurutonde bwa buri muntu na butuzuye.



2. Dutanga ibicuruzwa byambere mu matsinda, nyuma yo gukanda kuri buto "Shyiramo imikorere" hafi ya formula.



3. Masters Gukora imirimo. Twimukiye mucyiciro "amahuza na arrays". Hitamo imikorere "guhitamo". Dukora kanda kuri buto ya "ok".



4. Idirishya ryimikino idirishya rirakorwa. Syntax yatanzwe kuburyo bukurikira:

   = Guhitamo (Umubare_intex; Agaciro1; Agaciro2; ...)

   Inshingano yiyi ngingo ni imwe mu zingagaciro zagenwe, bitewe numubare wa SIX. Umubare windangagaciro urashobora kugera kuri 254, ariko tuzakenera amazina atatu gusa ahuye nibyiciro bya Abc-isesengura: A, B, C. Turashobora guhita twinjira muri "B" muri "B" muri "B" muri "b "umurima, umurima" agaciro3 "-" c ".



5. Ariko hamwe nimpaka "nimero yerekana inomero" igomba gutagwa neza yubaka abakora benshi. Shyira indanga muri "Inomero Umubare". Ibikurikira, kanda kumashusho ukoresheje inyabutatu, ibumoso bwa "Ongeraho imikorere". Urutonde rwabakora abakora bakoreshwa. Dukeneye imikorere yubushakashatsi. Kubera ko atari kurutonde, noneho tukanze ku nyandiko "indi mirimo ...".



6. Idirishya ryibikorwa Wizard idirishya ryongeye gutangira. Na none, jya mucyiciro "hamwe na barray". Turasanga umwanya w "Inama y'Ubushakashatsi", kugenera hanyuma ukande buto ya "ok".



7. Impaka zimpaka zishakisha zifungura. Syntax ya Ifite urupapuro rukurikira:

   = Ubuyobozi bushakisha (gushakisha_izina; kureba__sive; ubwoko_atation)

   Intego yiki gikorwa nugusobanura umubare wikibanza cyikintu cyagenwe. Ni ukuvuga, gusa ibyo dukeneye kuri "nimero ya nde" "yerekana guhitamo.

   Muri "urutonde rwa ARDS", urashobora guhita ubaza imvugo ikurikira:

   {0: 0.8: 0,95}

   Byagomba kuba muburyo bwuzuye bwuzuye, nka formula. Ntabwo bigoye gukeka ko iyi mibare (0; 0.8; 0.95) yerekana imbibi zumugabane wakusanyije hagati yitsinda.

   Umurima "Ubwoko bwo kugereranya" ntabwo ari itegeko kandi muriki kibazo ntituzuzuza.

   Muri "Agaciro ka kabiri", shyira indanga. Ubutaha nongeye kubishusho byasobanuwe haruguru muburyo bwa mpandeshatu, twimukira muri wizard yimikorere.



8. Iki gihe mumikorere yimyambaro, tuvuga kwimukira "imibare". Hitamo izina "guceceka" hanyuma ukande buto "OK".



9. Idirishya ry'ibiganiro rizatangizwa. Umudepite wagenwe avuga muri make selile yujuje ibisabwa neza. Syntax yayo ni:

   = Guceceka (intera; ibipimo; intera_sumung)

   Mu murima "intera", andika aderesi ya "Revenue". Kuri iyi ntego, twashizeho indanga mu murima, hanyuma dukora clip ya buto y'imbeba y'ibumoso, hitamo selile zose z'inkingi ihuye, ukuyemo agaciro "byose". Nkuko mubibona, adresse yahise igaragara mumurima. Mubyongeyeho, dukeneye gukora iyi sano rwose. Kugirango ukore ibi, bitanga amafaranga yacyo hanyuma ukande kurutonde rwa F4. Aderesi yarekuwe n'ibimenyetso by'amadolari.

   Mu rwego rwa "CRETER", dukeneye gushiraho imiterere. Injira imvugo ikurikira:

   ">"&

   Noneho ako kanya nyuma yo kwinjira kuri aderesi ya selire ya mbere ya "Revenue". Dutera guhuza mu buryo butambitse muri iyi aderesi yuzuye, yongeraho ikimenyetso cyamadorari kuva clavier imbere yinyuguti. Abahuza uhagaritse basiga umuvandimwe, ni ukuvuga, ntihagomba kubaho ikimenyetso imbere yimibare.

   Nyuma yibyo, ntabwo tukanda buto "OK", hanyuma ukande ku izina ryibikorwa byubushakashatsi mumirongo ya formula.



10. Noneho tugaruka ku mpaka idirishya ryinama yubushakashatsi. Nkuko tubibona, muburyo bwa "Fogilar busobanura", amakuru yashyizweho numukoresha yaracecetse. Ariko ibyo sibyo byose. Jya kuri uyu murima kandi umaze kwiyongera kumakuru aboneka kugirango wongere "+" nta bisobanuro. Noneho tumenyekanisha aderesi ya selire ya mbere ya "Revenue". Kandi na none dukora imirongo itambitse hamwe no gusiga umuvandimwe.

    Ibikurikira, dufata ibiri mu murima "agaciro wifuza" mu mutwe, nyuma dushyira ikimenyetso cy'ishami ("/"). Nyuma yibyo, na none binyuze mu gishushanyo cya mpagaro, jya kumurimo wo guhitamo imirimo.



11. Nkigihe cyanyuma mugipfumu cyiruka, turashaka umukoresha ukenewe muri icyiciro cya "imibare". Iki gihe imikorere yifuzwa yitwa "amafaranga". Turabigaragaza kandi tugakanda buto "OK".



12. Idirishya rya Operator rifungura. Intego nyamukuru yayo ni incamake yamakuru muri selile. Syntax yuyu mukoresha biroroshye cyane:

    = Amafaranga (umubare1; Umubare2; ...)

    Kuntego zacu, gusa "umubare1" uzakenerwa. Turabimenyekanisha muri IT coumialne zinkingi "yinjira", gukuraho selile irimo ibisubizo. Tumaze gukora igikorwa nkiki muburyo bwa "Urugero" rw'imikorere. Nko muri kiriya gihe, urutonde ruhuza rwose, rukabarika no gukanda urufunguzo rwa F4.

    Nyuma yibyo, kanda urufunguzo rwa "OK" hepfo yidirishya.



13. Nkuko mubibona, uruganda rwimikorere yinjiye rwabaye kubara no gutanga ibisubizo muri selire ya mbere yitsinda ". Igicuruzwa cya mbere cyahawe itsinda "a". Inzira yuzuye yakoreshejwe natwe kubara ni izi zikurikira:

    = Guhitamo (Ishakisha ryishakisha ((guceceka ($ B $ 2: $ B $ 27; ">" & $ B2); {0: 0.8: 0. , 95}); "a"; "b"; "c")

    Ariko, byanze bikunze, muri buri kibazo, guhuza muri iyi fomu biratandukanye. Kubwibyo, ntibishobora gufatwa nkisi yose. Ariko, ukoresheje igitabo cyatanzwe hejuru, urashobora gushiramo imirongo yimeza iyo ari yo yose kandi ukoreshe neza ubu buryo mubihe byose.



14. Ariko, ibi ntabwo aribyo byose. Twabaruwe gusa kumurongo wambere wimeza. Kugirango wuzuze byuzuye mumatsinda "Itsinda", ugomba kwigana iyi formulaire iri hagati (Kuraho selire yumugozi "byose") ukoresheje ikimenyetso cyuzuye, nkuko tumaze gukora inshuro zirenze imwe. Nyuma yamakuru yatanzwe, gusesengura ABC birashobora gusuzumwa.

Nkuko tubibona, ibisubizo byabonetse ukoresheje amahitamo ukoresheje formula igoye ntabwo itandukanye na ibyo bisubizo twakozwe no gutondeka. Ibicuruzwa byose byahawe ibyiciro bimwe, icyarimwe gusa imirongo ntabwo yahinduye umwanya wabo wambere.

Isomo: Master of Imikorere muri Excele

Gahunda ya Excel irashobora kugabanya cyane isesengura rya ABC kubakoresha. Ibi bigerwaho ukoresheje igikoresho nkiki cyo gutondeka. Nyuma yibyo, uburemere bwihariye, umugabane wakusanyije kandi mubyukuri, gutandukanya amatsinda yabarwa. Mu manza aho impinduka mumwanya wambere wumurongo mumeza ntibyemewe, urashobora gukoresha uburyo ukoresheje formulaire igoye.