Iyo gukora imirimo runaka naho gukorana meza, ni ngombwa kubara Utudirishya yuzuye Ibyatanzwe. Excel itanga urugero amahirwe gukoreshwa ibikoresho Gitsindiye. Reka turebe uko kwica runaka uburyo muri iyi gahunda.
Utudirishya kubara
Mu gahunda Excel, umubare Utudirishya yuzuye bishobora kugaragarira gukoresha counter ku Imimerere Umurongo cyangwa umubare mirimo, buri bikaba bifite agaciro ibintu yuzuye ubwoko runaka Ibyatanzwe.Uburyo 1: Counter ku Irangamimerere Row
Uburyo bworoshye bwo kubara utugingo irimo Ibyatanzwe ni Kuri Koresha amakuru kuva metero ku, ni giherereye ku ruhande rw'iburyo Imimerere Ikurikiranyanyuguti ku i Ibumoso: Bya i Utubuto kureba mu Excel. Nubwo i Urutonde ni Byahiswemo ku sheet, mu Ibintu byose ni ubusa cyangwa umwe gusa irimo bamwe agaciro, kigaragaza iyi bukaba bwarahishanywe. Mu counter bwikora bigaragara igihe Utudirishya babiri cyangwa benshi batari ubusa ni akato, kandi ako kanya irerekana umubare wabo nyuma ijambo "ingano".
Ariko, nubwo ku Mburabuzi, metero iyi ni Bikora, gusa bategereje Umukoresha Kuri garagaza ibintu runaka, mu bihe bimwe bashobora Yahagaritswe intoki. Nuko ikibazo ko ryandikwa yayo yabaye zibishinzwe. Gukora iyi, Iburyo: Kanda-Kanda ku i Imimerere Umurongo na i Urutonde ko gitangura yaratanze Umubu ahateganye "Kontaro" Ikintu. Inyuma y'ivyo, counter izaba yagaragaje yongera.
Uburyo 2: Inama Umumaro
Bara umubare Utudirishya yuzuye ishobora ubarwa gukoresha Umumaro konti. Itandukanye mu buryo Ibanjirije gushoboza ibarura A Urutonde runaka mu kagari bitandukanye. Ni ukuvuga kubona amakuru ku, karere nta bagomba guhora yagenewe.
- Guhitamo i Umwanya mu bikaba ingaruka kubara bazaba bagaragaje. Kanda kuri "Shyiramo imikorere".
- Umuyobozi wimyitozo ya Wizard arakingura. Turi gushaka urutonde ya "Account" Ikigize ishyikirizwa. Nyuma zina birashirwa ahabona, Kanda ku "OK" Akabuto.
- Idirishya ritangira. Ruzumva Umumaro iyi ni amahuza kasho. Ihuza ku Urutonde bishobora giteganywa intoki, ariko ni byiza gushyiraho indanga mu murima "Value1", aho ushaka kwinjira Ibyatanzwe, na Guhitamo karere bibereye uwandika. Niba ukeneye akabara Utudirishya kuzuzwa Ibice byinshi kure buri ruhande, Bya kabiri, gatatu na nyuma Urutonde bigomba kwinjira mu murima witwa "Value2", "value3", n'ibindi Iyo mibare yose ni yinjira. Kanda kuri buto ya "OK".
- Iyi mikorere irashobora kandi kwinjizwa intoki muri selile cyangwa umugozi wa formulaire, ukurikiza syntax ikurikira:
= Konte (agaciro1; agaciro2; ...)
- Nyuma ya formula yinjiye, gahunda mubice byateganijwe byerekana ibisubizo byo kubara selile zuzuye.
Uburyo bwa 3: Konti Yimikorere
Byongeye kandi, kubara selile zuzuye muri excel haracyari imikorere ya konti. Bitandukanye na formulaire yabanjirije, isuzuma selile gusa yuzuye amakuru yumubare.
- Nko mu rubanza rwabanje, turagaragaza selile aho amakuru azerekanwa no gutangiza imikorere wizard muri ubwo buryo. Muri yo, hitamo umukoresha ukoresheje izina "konte". Kanda kuri buto ya "OK".
- Idirishya ritangira. Impaka ni kimwe no mugihe ukoresheje uburyo bwabanje. Uruhare rwabo rwerekanwe kuri selile. Shyiramo ibice byimibare iri kumpapuro ukeneye kubara umubare wubucuruzi bwuzuye hamwe namakuru yumubare. Kanda buto ya "OK".
Kubuto bwintangiriro ya formula, yubahiriza syntax ikurikira:
= Konte (agaciro1; agaciro2; ...)
- Nyuma yibyo, mukarere aho formula iherereye, umubare wingirabuzimafatizo wuzuye amakuru yumubare azagaragara.
Uburyo 4: Imikorere ya Meckel
Iyi mikorere igufasha kubara umubare wingirabuzimafatizo zuzuyemo imvugo yimibare, ariko nkabo gusa bahuje nikibazo runaka. Kurugero, niba ugaragaza imiterere "> 50", gusa iyo selile nkizo zizatabwaho, zirimo agaciro karenga 50. Urashobora kandi gushiraho indangagaciro za "" (ntabwo zingana), nibindi.
- Nyuma yuko selile igenerwa kwerekana ibisubizo igatangiza imikorere yubupfumu, hitamo inyandiko "ski". Kanda kuri buto ya "OK".
- Idirishya ry'impaka rifungura. Iyi mikorere ifite impaka ebyiri: Urutonde aho uruganda ruba, kandi ibipimo, ni ukuvuga ibintu twaganiriye hejuru. Mu murima "intera", tumenyekanisha imirongo ivuwe n'ahantu havuwe, kandi mu murima "certerion" field ihuye n'imiterere. Nyuma yibyo, kanda kuri buto "OK".
Kubitekerezo byintoki, inyandikorugero isa nkiyi:
= Gahunda (intera; ibipimo)
- Nyuma yibyo, porogaramu ibara selile zuzuye yurwego rweguriwe, ihuye nuburyo bwagenwe, kandi ikabagaragaza mukarere kerekanwe mu gika cya mbere cyubu buryo.
Uburyo 5: Igikorwa cyuburyo bwo kubara
Gutanga ibicuruzwa ni amahitamo akomeye yimikorere ya comptoir. Ikoreshwa mugihe ukeneye kwerekana ibintu birenze guhuza kimwe kugirango ugereranye zitandukanye. Urashobora kwerekana gusa ibihe bigera kuri 126.
- Twerekana selile ibisubizo bizerekanwa no gukora imirimo yimikorere. Irashaka ikintu cya "kubara". Turabigaragaza kandi tugakanda buto "OK".
- Gufungura idirishya ryimpaka ribaho. Mubyukuri, imikorere yimikorere ni kimwe nuwahoze - "urwego" na "imiterere". Itandukaniro nuko ururimi hamwe nibihe bihuye birashobora kuba byinshi. Twinjiye kuri aderesi yingingo nibisabwa bihuye, hanyuma ukande buto "OK".
Syntax yiyi miterere ni izi zikurikira:
= Kubara (intera_longs1; imiterere1; intera_longs2; imiterere2; ...)
- Nyuma yibyo, gusaba kubara ingirabuzimafatizo zuzuye zinyuranyije nimiterere yashyizweho. Igisubizo cyerekanwe ahantu hashyizweho ikimenyetso.
Nkuko mubibona, kubara byoroshye umubare wa selile zuzuye zurwego rwatoranijwe urashobora kugaragara mumurongo wa leta ya Excel. Niba ukeneye gukuramo ibisubizo mubice bitandukanye kurupapuro, ndetse birenzeho kubara ibintu bimwe na bimwe, noneho muriki gihe, imirimo yihariye izatabara.