Igikorwa cyo gutwara abantu ni umurimo wo gushakisha verisiyo yingirakamaro yibyoherejwe byubwoko bumwe uhereye kubatanga isoko. Ishingiro ryayo nicyitegererezo gikoreshwa cyane mumibare itandukanye yimibare nubukungu. Microsoft Excel ifite ibikoresho byorohereza cyane igisubizo cyo gutwara abantu. Shakisha uko wabikoresha mubikorwa.
Ibisobanuro rusange byumurimo wo gutwara
Intego nyamukuru yumurimo wo gutwara ni ugushakisha gahunda yo gutwara ibintu neza uhereye kubitanga kubaguzi ku giciro gito. Ibisabwa kubikorwa nkibi byanditswe nka gahunda cyangwa matrix. Gahunda ya Excel ikoresha ubwoko bwa matrix.Niba ingano yibicuruzwa byose mubiro bitanga umusaruro bingana nubunini bwibisabwa, umurimo wo gutwara witwa gufunga. Niba ibi bipimo bidahwanye, umurimo nkuwo wo gutwara witwa. Kukemura, imiterere igomba kuzanwa muburyo bufunze. Kugirango ukore ibi, ongeraho ugurisha ibihimbakazi cyangwa umuguzi wimpimbano hamwe nibikoresho cyangwa bikenera itandukaniro riri hagati yibisabwa nigihe runaka. Muri iki kibazo, inkingi yinyongera cyangwa umugozi ufite indangagaciro ze zengewe kumeza.
Ibikoresho byo gukemura umurimo wo gutwara abantu
Gukemura umurimo wo gutwara abantu neza, imikorere "yumuti" irakoreshwa. Ikibazo nuko muburyo busanzwe bufite ubumuga. Kugirango ushoboze iki gikoresho, ugomba gukora ibikorwa bimwe.
- Dukora kuri tab "dosiye".
- Kanda ahanditse "Ibipimo".
- Mu idirishya rishya, jya ku nyandiko "yo kwandika".
- Muri "imiyoborere", iri munsi yidirishya ryakinguye, uhagarika guhitamo kuri Excel Ongeraho-Ingingo ziri kurutonde rwamanutse. Turakora kanda kuri buto "Genda ...".
- Idirishya ryakazi riratangira. Shyiramo agasanduku kegereye igika cya "Gushakisha igisubizo". Kanda kuri buto ya "OK".
- Bitewe nibikorwa muri tab "data", buto "igisubizo" kizagaragara muri rubbon igenamiterere. Azabikeneye mugihe abonye igisubizo cyumurimo wo gutwara.
Isomo: Imikorere "Igisubizo cyigisubizo" muri Excele
Urugero Igisubizo cyumurimo wo gutwara abantu
Noneho reka dusesengure urugero rwihariye rwikibazo cyo gutwara.Ibihe Byikibazo
Dufite abatanga isoko 5 nabaguzi 6. Umuyoboro wuwatanze umusaruro wa aba batanga 48, 65, 51, 61, ibice 53. Ukeneye abaguzi: 43, 47, 42, 46, 41, 159. Rero, umubare wibicuruzwa byose uhwanye nubunini, ni ukuvuga, duhura numurimo ufunze.
Byongeye kandi, munsi yimiterere, matrix igura ikiguzi cyo gutwara abantu kuva kumurongo umwe ujya mubindi, bigaragazwa kurugero munsi yicyatsi kibisi cyerekanwe.
Igisubizo cyikibazo
Duhura nibikorwa mubihe byavuzwe haruguru, kugirango bigabanye ibiciro byo gutwara abantu.
- Kugirango dukemure ikibazo, twubaka ameza hamwe numubare umwe wingirabuzimafatizo, kimwe na matrix yasobanuwe haruguru.
- Turagaragaza selile irimo ubusa kurupapuro. Kanda ahanditse "Shyiramo Imikorere" yashyizwe ibumoso bwumugozi wa formula.
- Yafunguriye "imirimo ya Wizard". Kurutonde atanga, dukwiye kubona imikorere ya Dimmprot. Turabigaragaza kandi tugakanda buto "OK".
- Impaka zinjiza. Nkimpaka zambere tuzakora urutonde rwingirabuzimafatizo za Matrix. Kugirango ukore ibi, birahagije kwerekana indanga amakuru ya selile. Impaka ya kabiri zizaba urwego rwamateka yintebe, rwateguwe kubara. Noneho, kanda buto "OK".
- Kanda kuri selire, iherereye ibumoso bwa selile ibumoso wimeza kugirango ibabare. Ubwanyuma wita imirimo, fungura impaka zirimo. Mugukanda kumurima wimpaka zambere, tugenera urwego rwose rwimeza kumibare. Nyuma yo guhuza urutonde rwashyizwe kumurongo uhuye, kanda kuri buto "OK".
- Duhinduka mu mfuruka yo hepfo iburyo bwa selire ifite imikorere yimari. Ikimenyetso cyuzuye kiragaragara. Kanda kuri buto yimbeba yibumoso hanyuma ukurura ikimenyetso cyuzuye kugeza kumpera yimeza kugirango ubare. Twandukuye rero formula.
- Kanda kuri selire yashyizwe hejuru uhereye hejuru ibumoso. Nko bimeze mugihe cyashize, twita imikorere yimibare, ariko iki gihe dukoresha inkingi yambere yimeza yo kubara nkimpaka. Kanda kuri buto ya "OK".
- Gukoporora Ikimenyetso cyo kuzuza formula kumurongo wose.
- Jya kuri tab "data". Hano haribintu "isesengura" bikurikirana ukanze kuri buto "yo gushakisha igisubizo".
- Ibisubizo Ishakisha. Muri "optimize intego yintego", kwerekana selile ikubiyemo ibintu byagutse. Muri "Block" guhagarika agaciro "byibuze". Muri "guhindura selile ihindura" umurima, ugaragaza urutonde rwimbonerahamwe yo kubara. Mu Igenamiterere rya Igenamiterere "Ukurikije aho imbogamizi", kanda kuri buto "Ongeraho" kugirango wongere ibintu byinshi byingenzi.
- Uburyo bwo kongeramo kubuza bwatangijwe. Mbere ya byose, dukeneye kongeramo imiterere umubare wamakuru mumurongo wimbonerahamwe kugirango ubare ugomba kuba uhwanye numubare wamakuru kumeza hamwe nibisabwa. Muri "Ihuza hamwe na selile", sobanura urwego rwimibare yimbonerahamwe. Noneho shyira ikimenyetso kingana na (=). Muri "imipaka", vuga urutonde rwibipimo kumurongo wimbonerahamwe hamwe nibisabwa. Nyuma yibyo, twongeyeho buto ya "OK".
- Mu buryo nk'ubwo, ongeraho ibintu ko inkingi z'imbonerahamwe ebyiri zigomba kuba zingana. Twongeyeho ko igiteranyo cyurwego rwa selile zose ziri kumeza kugirango tubare rugomba kuba ruruta cyangwa rungana na 0, kimwe nibisabwa bigomba kuba integer. Ubwoko rusange bwibibuza bigomba kuba nkuko bigaragara mumashusho hepfo. Witondere gukurikiza kugirango "uhindure impinduka nta mbogamizi zitari nziza" zihagaze kuri cheque, kandi igisubizo cyatoranijwe nigisubizo cyo gukemura ibisubizo byuburyo bwa Nelg. Nyuma yimiterere yose igaragara, kanda kuri buto "Shakisha igisubizo".
- Nyuma yibyo, hari kubara. Amakuru agaragara muri selile yimeza kugirango ubare. Idirishya ryigisha ibisubizo rifungura. Niba ibisubizo byagushimishije, kanda kuri buto "OK".
Nkuko mubibona, igisubizo cyumurimo wo gutwara muri Excel karagabanuka muburyo bwiza bwo kwinjiza amakuru. Kubara ubwabyo bikora gahunda aho kuba umukoresha.