Excel ifite ikunzwe cyane mu bacunga, abahanga mu bukungu ntibagomba kubera ibikoresho byinshi byo gushyira mu bikorwa ibirego bitandukanye by'imari. Ahanini ukora imirimo yiyi nteguro ihabwa itsinda ryimirimo. Benshi muribo ntibashobora kuba ingirakamaro kubahanga gusa, ahubwo no kubakozi banganda zijyanye, hamwe nabakoresha basanzwe mubikorwa byabo byo murugo. Reka dusuzume muburyo burambuye kuri iyi porogaramu, kimwe no kwita cyane kubakoresha cyane muri iri tsinda.
Gushyira mu bikorwa kubara ukoresheje imirimo y'amafaranga
Itsinda ryamakuru ryabakoresha ririmo formula zirenga 50. Tuzamwibandaho ku icumi bashakishijwe cyane. Ariko ubanza reka turebe uko twafungura urutonde rwibikoresho byubukungu kugirango bimuke gukora umurimo runaka.
Inzibacyuho kuri iyi ngingo yibikoresho biroroshye gukora ibintu byose binyuze mubumenyi bwimikorere.
- Turagaragaza selile aho ibisubizo byo kubara bizerekanwa, hanyuma ukande kuri buto "Shyiramo imikorere", iri hafi yumurongo wa formula.
- Inshingano nyamukuru iratangira. Turakora kanda kuri "Icyiciro".
- Urutonde rwamatsinda aboneka yabatwara abakora. Hitamo muri yo izina "imari".
- Urutonde rwibikoresho dukeneye byatangijwe. Hitamo ikintu runaka cyo gukora umurimo hanyuma ukande kuri buto "OK". Nyuma yibyo, ingingo yitabiriye idirishya ryabakoresha batoranijwe.
Urashobora kandi kujya kuri nyir'imikorere ukoresheje formulas. Mugukora inzibacyuho, ugomba gukanda kuri buto kuri kaseti "Shyiramo imikorere", shyira mubikoresho bya "imikorere". Ako kanya nyuma yibi bizatangira shebuja ibikorwa.
Hariho uburyo bwo kujya kumukoresha wifuzwa atatangiye idirishya ryambere rya Wizard. Kuri izo ntego muri tab imwe ya formula, mugice cya "imikorere" Itsinda rya Igenamiterere kuri RIBE Kanda kuri buto yimari. Nyuma yibyo, urutonde rwamanutse rwibikoresho byose bihari kugirango hazafungurwe. Hitamo ikintu wifuza hanyuma ukande kuri yo. Ako kanya nyuma yidirishya ryimpaka zaryo rizakingurira.
Isomo: Umukozi wa Wizard muri Excel
Amafaranga
Umwe mu bakora cyane abaterankunga ni umurimo winjiza. Iragufasha kubara inyungu zinyamanswa kumunsi wamasezerano, itariki yo kwinjira (kwishyura), igiciro cyinyungu 100, umubare winyungu zumwaka wibiciro bya 100 byo gucungurwa kandi ingano yishyurwa (inshuro). Nibipimo ni ingingo ziyi formula. Byongeye kandi, hariho impano zidahwitse ". Aya makuru yose arashobora kwinjizwa muri clavier mubice bihuye nidirishya cyangwa bibitswe mu tugari k'amabati. Mu rubanza rwa nyuma, aho kuba imibare n'amatariki, ugomba kwinjiza amahuza muriyi selile. Nanone, imikorere irashobora kandi kwinjizwa mumirongo cyangwa agace kurupapuro intoki nta guhamagara idirishya ryimpaka. Mugihe kimwe ugomba gukurikiza syntax ikurikira:
= Amafaranga (itariki_sog; itariki_se_se_se_se; igipimo; igiciro; kwishyura;
Bs
Igikorwa nyamukuru cyimikorere ya bs nugusobanura agaciro kazaza k'ishoramari. Ibitekerezo byayo ni igipimo cyinyungu mugihe ("igipimo"), umubare wibihe byose ("kol_per") hamwe no kwishyura buri gihe ("plt"). Impaka zidateganijwe zirimo agaciro ka none ("ps") no gushiraho igihe cyo kwishyura mugitangiriro cyangwa kurangiza igihe ("ubwoko"). Umukoresha afite syntax ikurikira:
= Bs (igipimo; kubara_per; pl; [PS]; [ubwoko])
Vd
Umukoresha wa EDR ibara igipimo cyimbere cyinyungu kumafaranga. Impaka zonyine kuri iki gikorwa ni indangagaciro zamafaranga, kumpapuro za Excel zishobora gushyikirizwa amakuru intera ("indangagaciro"). Byongeye kandi, muri selire ya mbere yurwego, umubare wumugereka wikimenyetso "-" ugomba kwerekanwa, kandi mubindi byinjijwe. Byongeye kandi, hariho impaka zidahwitse "igitekerezo". Irerekana inyungu zigereranijwe. Niba utabigaragaje, hanyuma usanzwe, agaciro kafashwe muri 10%. Syntax ya formula niyi ikurikira:
= Vd (indangagaciro; [Ibitekerezo])
MWSD
Umukoresha wa MWSD akora kubara igipimo cyahinduwe imbere, ahabwa ijanisha ryo gushora amafaranga. Muri iyi mikorere, usibye amafaranga yimiterere ("indangagaciro") Impaka ni igipimo cyo gutera inkunga no gutanga umusaruro. Kubera iyo mpamvu, syntax ifite ubwoko:
= Mwsd (indangagaciro; igipimo_financir; igipimo_ibisobanuro)
Prt
Umukoresha wa PRT abara umubare winyungu ubwitonzi mugihe cyagenwe. Imikorere ingaruka ni igipimo cyinyungu mugihe ("igipimo"); Umubare w'ibihe ("igihe"), agaciro kacyo kadashobora kurenza umubare rusange wibihe; Umubare wibihe ("cal_per"); Agaciro kagabanijwe ("PS"). Byongeye kandi, hariho impaka zidahwitse - igiciro kizaza ("BS"). Iyi formula irashobora gukoreshwa gusa niba kwishyura muri buri gihe bikorwa nibice bingana. Syntax ya Ifite urupapuro rukurikira:
= Prt (igipimo; igihe; kubara_per; ps; [bs])
Plt.
Umukoresha wa PL ibara umubare wigihe cyo kwishyura buri gihe hamwe nijanisha rihoraho. Bitandukanye nimikorere yabanjirije, ibi ntabwo bifite "igihe". Ariko ubwoko bwubupfumu "ubwoko" bwongeweho, bugaragaza mugitangiriro cyangwa mugihe cyigihe gikwiye kwishyurwa. Ibipimo bisigaye birahurira rwose hamwe na formula. Syntax isa nkiyi:
= Plt (igipimo; kubara_ibiciro; ps; [BS]; [ubwoko]))
Zab.
PS formula ikoreshwa mu kubara agaciro keza k'ishoramari. Iyi mikorere ihinda umukoresha ppt. Afite ibitekerezo bimwe, ariko aho gutongana ko agaciro kagaciro ("ps"), mubyukuri kubara, byerekana umubare wishyurwa buri gihe ("PLT"). Syntax, kimwe,
= PS (igipimo; kubara_ibiciro; pll; [BS]; [ubwoko])
Chps
Umukoresha ukurikira arasabwa kubara net igiciro cyerekanwe cyangwa cyagabanijwe. Iyi mikorere ifite impaka ebyiri: Igipimo cyo kugabanyirizwa hamwe nagaciro ko kwishyura cyangwa amafaranga yinjira. Nibyo, uwa kabiri muribo arashobora kugira amahitamo agera kuri 254 agereranya amafaranga. Syntax yiyi formula niyi:
= Chps (igipimo; agaciro1; agaciro2; ...)
Gupiganira
Imikorere igipimo kibara igipimo cyinyungu kumwaka. Impaka zuyu mukoresha ni umubare wibihe ("umufuka"), ubunini bwo kwishyura buri gihe ("PLT") hamwe nubunini bwo kwishyura ("PS"). Mubyongeyeho, hari izindi mpano zibigenewe: Igiciro kizaza ("BS") hamwe no kumenya mu ntangiriro cyangwa igihe kirangiye kizakorwa ("ubwoko"). Syntax ifata ubwoko bwubu:
= Igipimo (kubara_per; pl; PS [BS]; [ubwoko])
Ingaruka
Ingaruka zifata imibare ifatika (cyangwa ikora) inyungu. Iyi mikorere ifite impaka ebyiri gusa: umubare wibihe byumwaka, kubwinyungu zibara zikoreshwa, kimwe nigipimo cyizina. Syntax isa nkiyi:
= Ingaruka (nom_pet; col_per)
Twasuzumye gusa ibyashakishijwe cyane - nyuma yibikorwa byamafaranga. Muri rusange, umubare wabakora muri iri tsinda ni inshuro nyinshi. Ariko muri izi ngero, imikorere nuburyo bworoshye bwo gukoresha ibi bikoresho, byoroshya cyane kubara kubakoresha, biragaragara neza.