Kimwe mubintu bishimishije muri gahunda ya Microsoft Excel ni ukushakira igisubizo. Muri icyo gihe, twakagombye kumenya ko iki gikoresho kidashobora kwitirirwa ibikunzwe cyane mubakoresha muriyi porogaramu. N'ubusa. N'ubundi kandi, iyi miterere, ukoresheje amakuru yambere, muguhitamo, ugasanga igisubizo cyiza cyane kiva kuri byose. Reka tumenye uburyo bwo gukoresha igisubizo cyigisubizo muri Microsoft Excel.
Gushoboza imikorere
Urashobora gushakisha igihe kirekire kuri lebbon, aho igisubizo kirimo, ariko ntubone iki gikoresho. Byoroshye, kugirango ukore iyi miterere, ugomba kubishoboza muburyo bwa porogaramu.
Kugirango ukore ubushakashatsi kubisubizo biri muri Microsoft Excel 2010, hanyuma, jya kuri tab "dosiye". Kuri 2007, ugomba gukanda kuri buto ya Microsoft Office mugice cyo hejuru cyibumoso bwidirishya. Mu idirishya rifungura, jya ku gice cya "Parater".
Mu idirishya ryamahitamo, kanda ahanditse "Umusumari". Nyuma yo gufungura, hepfo yidirishya, imbere yibikorwa, hitamo "Excel Ongeraho" kuri "agaciro, hanyuma ukande kuri buto" Genda ".
Idirishya rifungura hamwe na superst. Dushyira akamenyetso ahagije kumazina yongeyeho - dukeneye - "igisubizo cyigisubizo". Kanda kuri buto ya "OK".
Nyuma yibyo, buto yo gutangira ibisubizo byishakisha bizagaragara kuri kaseti ya excel muri tab.
Gutegura imbonerahamwe
Noneho, tumaze gukora umurimo, reka tumenye uko ikora. Biroroshe kugandukira urugero runaka. Rero, dufite imbonerahamwe yumushahara w'abakozi b'ikigo. Tugomba kubara igihembo cya buri mukozi, ni umushahara werekanwa mu nkingi itandukanye, kuri coekele runaka. Muri icyo gihe, amafaranga yose yagenewe igihembo ni amafaranga 30000. Akagari muri aya mafaranga aherereye ni izina ryintego, kubera ko intego yacu ari uguhitamo amakuru kuriyi mibare.
Coeffificure ikoreshwa mukubara ingano yigihembo, tugomba kubarwa dukoresheje icyemezo-kugirango tubone ibisubizo. Akagari kaherereyemo byitwa icyifuzo.
Intego hamwe nibyifuzo byawe bigomba kuba bifitanye isano no gukoresha formula. Mu rubanza rwacu, formula iherereye mu kagari kagenewe, kandi ifite urupapuro rukurikira: "= C10 * $ G $ 3", aho $ G $ 3 ni adresse yuzuye ya selile wifuza, kandi "C10" - The Amafaranga yose yimishahara aho premium yabarwaga abakozi b'ikigo.
Koresha Igikoresho Cyibisubizo
Nyuma yimbonerahamwe itegurwa no kuba muri tab "data", kanda buto ya "Gushakisha igisubizo", iherereye kuri kaseti murwego rwa "Isesengura".
Idirishya rya Parameter rifungura amakuru agomba kongerwaho. Mumwanya wa "optimize intego", ugomba kwinjiza aderesi ya selire yintego, aho igihembo cyose cyatanzwe kubakozi bose bazaba. Ibi birashobora gukorwa cyangwa byacapishijwe nigitabo cyintoki, cyangwa ukanze kuri buto iherereye ibumoso bwamakuru yo gutangiza amakuru.
Nyuma yibyo, idirishya rya parameter rizaza, kandi urashobora guhitamo selile wifuza kumeza. Noneho, ugomba kongera gukanda kuri buto imwe ibumoso bwimiterere hamwe namakuru yinjiye yo kohereza idirishya rya parameter.
Munsi yidirishya hamwe na aderesi ya selile igenewe, ugomba gushyiraho ibipimo byindangagaciro zizaba muriyo. Ibi birashobora kuba byinshi byibuze, cyangwa agaciro kahariye. Kuri twe, bizaba inzira yanyuma. Kubwibyo, dushyira ahagaragara umwanya wa "Agaciro", kandi mu murima kugera ibumoso byanditseho umubare 30.000. Nkuko twibuka, niyi miterere y'ibihe byose bigize igihembo cyose kubakozi bose ba Uruganda.
Hasi ni "selile ihindura". Hano ukeneye kwerekana aderesi yumwanya wifuzwa, aho, nkuko twibuka, hariho coekerd, kugwiza umushahara munini uzabarirwa ingano. Aderesi irashobora gutondekwa inzira zimwe nkuko twabikoze kuri selile.
Muri "ukurikije imbogamizi", urashobora gushyiraho imipaka kubibazo runaka, kurugero, bitanga indangagaciro nka integer cyangwa atari bibi. Gukora ibi, kanda kuri buto "Ongeraho".
Nyuma yibyo, imyigaragambyo yongeyeho. Muri "Ihuza hamwe na selile", twiyandikisha ka selile zikagari ugereranije nububiko bwinjiye. Kuri twe, iyi niyo selile wifuzana na coefficient. Ibikurikira, shyira ikimenyetso wifuza: "Ntibisanzwe cyangwa bingana", "byinshi cyangwa bingana", "bingana", "bingana", "binary", "nibindi Kuri twe, tuzahitamo ikimenyetso "kinini cyangwa kingana" kugirango dufate ingamba nziza. Kubwibyo, muri "kubuza", kwerekana umubare 0. Niba dushaka gushiraho ikindi kibuza, noneho tugakanda kuri buto yongeyeho. Mu rubanza rutandukanye, kanda buto "OK" kugirango ukize imipaka.
Nkuko tubibona, nyuma yibyo, kubuza bigaragara murwego rukwiye rwibipimo byo gukemura. Kandi, kora impinduka zitari mbi, urashobora gushiraho cheque agasanduku kegereye ibipimo bihuye hepfo. Nibyifuzwa ko ibipimo byashyizweho hano ntibivuguruza uwo wanditswe muburyo bugarukira, bitabaye ibyo, amakimbirane arashobora kubaho.
Igenamiterere ryinyongera rirashobora gushyirwaho ukanda kuri buto "parameter".
Hano urashobora gushiraho ukuri kwukuri no kugabanya igisubizo. Iyo amakuru yifuzwa yinjiye, kanda kuri buto "OK". Ariko, kuri gahunda yacu, ntukeneye guhindura ibi bipimo.
Nyuma yimiterere yose yashyizweho, kanda kuri buto "Shakisha igisubizo".
Ibikurikira, gahunda ya Excel muri selile ikora ibikenewe. Icyarimwe hamwe no gutanga ibisubizo, idirishya rifungura aho ushobora gukiza igisubizo, cyangwa ugarura indangagaciro zo guhinduranya kumurongo ukwiye. Utitaye kumahitamo yatoranijwe, ashyiraho agasanduku "Garuka muri parameter ikiganiro", urashobora kongera kujya mubikorwa byo gukemura. Nyuma yo kugenzura no guhinduranya byashyizweho, kanda kuri buto "OK".
Niba kubwimpamvu iyo ari yo yose ibisubizo byishakisha kubisubizo ntuzaguhaze, cyangwa mugihe ubara gahunda, muriki gihe, turagaruka, tugatangirwa hejuru muburyo, muri parameter ikiganiro. Kuvugurura amakuru yose yinjiye, kubera ko bishoboka ahantu runaka hakozwe ikosa. Mugihe habonetse ikosa, noneho jya kuri "Hitamo Umuti" Plameter. Itanga amahirwe yo guhitamo bumwe mu buryo butatu bwo kubara: "Shakisha Gukemura imirimo idahwitse ku buryo bwa ODG. Mburabuzi, uburyo bwa mbere burakoreshwa. Turagerageza gukemura icyo gikorwa, duhitamo ubundi buryo. Mugihe cyo kunanirwa, dusubiramo kugerageza dukoresheje uburyo bwa nyuma. Ibikorwa algorithm biracyari nkibyo twasobanuye haruguru.
Nkuko mubibona, imikorere ishakisha igisubizo nigikoresho gishimishije cyane, hamwe no gukoresha neza, birashobora gukiza cyane igihe cyumukoresha kubibara bitandukanye. Kubwamahirwe, ntabwo buri mukoresha azi ko abaho kwe, tutibagiwe uburenganzira bwo gushobora gukorana niyi surarugia. Mu kintu, iki gikoresho gisa nimikorere "gutoranya ibipimo ...", ariko icyarimwe, bifite itandukaniro rikomeye nayo.