Imikorere ine Excel

Imwe mu mirimo yashyizwe kuri gahunda ya Excel irahagarara. Igikorwa cyacyo ni ugusubira mubibabi, aho biherereye, ibikubiye muri kasho ihuza imiterere yinyandiko igaragara muburyo bwimpaka.

Byasa nkaho ntakintu kidasanzwe kuricyo, kubera ko bishoboka kwerekana ibiri muri kasho imwe mu rindi kandi byoroshye. Ariko, uko bizirika, nolines zimwe zituma idasanzwe ifitanye isano no gukoresha uyu mukoresha. Rimwe na rimwe, iyi formula irashobora gukemura imirimo nkiyi mubundi buryo ntishobora kwihanganira cyangwa gusa bizagorana gukora. Reka twige byinshi, bigereranya umukoresha wa kure nuburyo bushobora gukoreshwa mubikorwa.

Gukoresha formula dvssl

Izina ryuyu mukoresha Dvssl rihanaguwe nka "Ihuza kabiri". Mubyukuri, ibi byerekana intego yacyo - kwerekana amakuru binyuze muburyo bwerekanwe kuva muri seliji kubindi. Byongeye kandi, bitandukanye nibindi bikorwa byinshi bikora hamwe nibisobanuro, bigomba guterwa muburyo bwinyandiko, ni ukuvuga, bigaragazwa kumpande zombi hamwe na cote.

Uyu mukoresha yerekeza ku cyiciro cya "Ihuza hamwe na Arrays" imikorere kandi ifite syntax ikurikira:

= Dwarf (link_namechair; [a1])

Rero, formula ifite impaka ebyiri gusa.

Impaka "guhuza selile" zitangwa nkumuhuza kubintu byamababi, amakuru akubiyemo aho ushaka kwerekana. Muri uru rubanza, umurongo wagenwe ugomba kugira urupapuro rwanditse, ni ukuvuga "gupfunyika" hamwe na cote.

Impaka "A1" ntabwo ari itegeko no mu rugero rudasanzwe rw'imanza ntizikeneye kugaragazwa na gato. Irashobora kugira indangagaciro ebyiri z '"ukuri" no "kubeshya". Ku rubanza rwa mbere, umukoresha agena amahuza muburyo bwa "A1", aribo, ubu buryo bushoboka mu kuba indashyikirwa muburyo busanzwe. Niba agaciro k'impaka kadasobanura na gato, bizasuzumwa neza nk "ukuri". Mu rubanza rwa kabiri, ibivugwa bigenwa muburyo bwa R1C1. Ubu buryo bwo guhuza bugomba gushyirwa muburyo bwa exel.

Niba uvuze gusa, dwarf ni ubwoko buhwanye nimirongo ya selile imwe igana mubindi nyuma yikimenyetso "kingana." Kurugero, mubihe byinshi imvugo

= Dwarns ("a1")

Bizaba bihwanye no gutanga ibitekerezo

= A1.

Ariko bitandukanye nimvugo "= A1", DVSL yo gufungura ntabwo ifatanye na selile yihariye, ahubwo ihuza ikintu kurupapuro.

Reba icyo bisobanura kurugero rworoshye. Mu kagari B8 na B9, bikurikirana, byanditswe binyuze muri "=" "imikorere ya dwarf. Ibicuruzwa byombi bivuga element b4 hanyuma bisohoke ibirimo ku rupapuro. Mubisanzwe ibi bikubiyemo ni bimwe.

Ongeraho ikindi kintu cyubusa kumeza. Nkuko mubibona, imirongo yimutse. Muri formula ukoresheje "bingana", agaciro gakomeza kuba kimwe, kuko bivuga selile yanyuma, nubwo imigani yacyo yarahindutse, ariko amakuru yahindutse, ariko amakuru ava mumukoresha nuwayikoresha yarahindutse. Ibi biterwa nuko bivuga aho bivuga ikintu cyamababi, ahubwo kirimo kuduhuza. Nyuma yo kongeramo umurongo, aderesi b4 ikubiyemo urundi rupapuro. Ibirimo ubu ni formula kandi byerekana kurupapuro.

Uyu mukoresha arashoboye kwerekana umubare gusa, ahubwo ninyandiko, ibisubizo byo kubara formulaire nizindi ndangagaciro ziri mu rupapuro rwatoranijwe. Ariko mubikorwa, iki gikorwa ntabwo gikoreshwa mu bwigenge, kandi kenshi cyane ni igice cyingenzi cya formulaire.

Twabibutsa ko umukoresha akurikizwa kubindi bigize ndetse no kubiri mubindi bitabo bya Excel, ariko muriki kibazo bigomba gutangizwa.

Noneho reka dusuzume ingero zihariye zo gushyira mu bikorwa umukoresha.

Urugero 1: Gukoresha umukoresha

Gutangira, suzuma urugero rworoshye aho film ikora isohoka yigenga kugirango ubashe kumva ishingiro ryakazi ke.

Dufite imbonerahamwe uko ari kubishaka. Hariho umurimo wo kwerekana amakuru ya mbere yinkingi yambere mubintu byambere byinkingi ya mbere ukoresheje formulaire yize.

1. Turagaragaza ikintu cyambere cyubusa cyinkingi, aho duteganya gushyiramo formula. Kanda kuri "Shyiramo imikorere".



2. Ikirangantego Wizard Idirishya ritangira kwiruka. Twimukiye mucyiciro "amahuza na arrays". Kuva kurutonde, hitamo agaciro "dvssl". Kanda kuri buto ya "OK".



3. Idirishya ryamadirishya yumukoresha wagenwe uratangizwa. Muri "Ihuza na Akagari", ugomba kwerekana aderesi yicyo kintu kurupapuro, ibikubiye muribyo tuzerekanwa. Birumvikana ko bishobora kwinjizwa intoki, ariko bifatika cyane kandi bizarushaho koroherwa gukora ibi bikurikira. Shyira indanga mumurima, hanyuma ukande buto yimbeba yibumoso kubintu bikwiye kurupapuro. Nkuko mubibona, ako kanya nyuma yibyo, aderesi yacyo yagaragaye mumurima. Noneho tugenera umurongo n'amagambo aturutse impande zombi. Nkuko twibuka, iyi ni ikintu kiranga gukorana nimpaka ziyi formula.

   Muri "A1", kubera ko dukora muburyo busanzwe bwo guhuza, urashobora gushyira agaciro k '"ukuri", kandi urashobora kubireka na gato ubusa. Ibi bizaba ibikorwa bihwanye.

   Nyuma yibyo, kanda kuri buto "OK".



4. Nkuko tubibona, ubu ibiri muri selire yambere yinkingi ya mbere yimbonerahamwe yerekanwe mubintu byurupapuro aho formula iherereye.



5. Niba dushaka gukurikiza iki gikorwa muri selile, biherereye hepfo, noneho muriki kibazo ugomba guhabwa kuri buri etara etape. Niba tugerageje kuyagerageza dukoresheje ikimenyetso cyuzuye cyangwa ubundi buryo bwo gukoporora, izina rimwe rizerekanwa mubintu byose byinkingi. Ikigaragara ni uko, nkuko twibuka, ibikorwa byerekana nkimpaka muburyo bwanditse (kuzinga muri cote), bivuze ko bidashobora kuba isano.

Isomo: Umukozi wizard muri gahunda ya Excel

Urugero rwa 2: Gukoresha umukoresha muburyo bunoze

Noneho reka turebe urugero rwikoreshwa kenshi ryumukoresha bombi, mugihe ari igice cyingenzi cya formulaire.

Dufite ameza ya buri kwezi yinjiza amafaranga. Tugomba kubara amafaranga yinjiza mugihe runaka, urugero Mart - Gicurasi cyangwa Kamena. Birumvikana, kubwibi, birashoboka gukoresha formula yoroshye, ariko muriki gihe, nibiba ngombwa, kubara ibisubizo rusange kuri buri gihe, tugomba guhindura iyi formula igihe cyose. Ariko iyo ukoresheje imikorere, umwijima urashobora guhindurwa nurwego rwinvuma, ugaragaza gusa ukwezi guhuriye nu selile. Reka tugerageze gukoresha ubu buryo mubikorwa byo kubanza kubara amafaranga mugihe kuva muri Werurwe kugeza Gicurasi. Ibi bizakoresha formula hamwe no guhuza abakora leta na dash.

1. Mbere ya byose, mubintu byihariye kumpapuro yizina ryamezi yintangiriro nigihe cyo kubara, kubara "na" Gicurasi ".



2. Noneho tugenera izina muri selile zose mumashuri "yinjiza", bizaba bisa nizina ryukwezi kumwe. Ni ukuvuga, ikintu cya mbere mu nkingi "yinjiza", ikubiyemo ingano yinjiza, igomba kwitwa "Mutarama", iya kabiri - "Gashyantare", nibindi

   Rero, kugirango utange izina kubintu byambere byinkingi, hitamo hanyuma ukande buto yimbeba iburyo. Ibikubiyemo bifungura. Hitamo ikintu "uha izina ...".



3. Idirishya ryo kurema Idirishya ryatangijwe. Muri "izina" umurima ukwiranye izina "Mutarama". Ntakindi gihinduka mu idirishya ntirikeneye gukorwa, nubwo mugihe ushobora kugenzura ko guhuza "intera" bihuye na aderesi yinjira muri Mutarama. Nyuma yibyo, kanda kuri buto "OK".



4. Nkuko mubibona, ubungubu, mugihe utanze iki kintu mwizina ryidirishya, ntabwo ryerekanwa kuri aderesi yayo, hanyuma izina twamuhaye. Imikorere isa nayo irakorwa hamwe nibindi bintu byose byinkingi "yinjiza", ibaha isi yose yitwa "Gashyantare", "Werurwe", "Mata", nibindi. kugeza Ukuboza.



5. Hitamo akagari muri progaramu yindangagaciro ziterabwoba zizerekanwa no kugenera. Noneho kanda kuri "Shyiramo imikorere". Yashyizwe ibumoso bwumurongo wa formulamo hamwe nuburenganzira bwumurima aho izina rya selile ryerekanwa.



6. Mu idirishya rikora, ba shebuja imikorere yimuka mucyiciro "imibare". Ngaho hitamo izina "amafaranga". Kanda kuri buto ya "OK".



7. Nyuma yiki gikorwa, idirishya ryabakozi ryatangijwe, umurimo wonyine waryo ni incamake yindangagaciro zagenwe. Syntax yiyi mikorere ni yoroshye cyane:

   = Amafaranga (umubare1; Umubare2; ...)

   Muri rusange, umubare w'impaka urashobora kugera ku ndangagaciro za 255. Ariko izi mpaka zose zirahari. Ni umubare cyangwa imirongo ya selile iyi numero irimo. Barashobora kandi gukora muburyo bwubwubatswe bubaka umubare wifuzwa cyangwa bwerekana aderesi yibibabi ahantu hashyizwe. Muri iyi mikorere yimikorere hamwe numukoresha wacu bizakoreshwa mururwo rubanza.

   Shyira indanga muri "Umubare1". Noneho kanda kumashusho muburyo bwa mpandeshatu yahinduwe iburyo bwurwego rwimibare. Urutonde rwimikorere ya vuba ikoreshwa iratangazwa. Niba hari izina "DVSSL" muribo, noneho uhite ukande kuri yo kugirango ujye ku idirishya ryimpaka ryiyi mikorere. Ariko birashobora kuba bimeze mururwo rutonde ntuzabona. Muri iki kibazo, ugomba gukanda mwizina "indi mirimo ..." hepfo yurutonde.



8. Yatangiriyeho kumenyera idirishya rya Wizard. Twimukiye mu gice "amahuza na arrays" hanyuma uhitemo izina rya Dvssl. Nyuma yibyo, ukanda kuri buto ya "ok" hepfo yidirishya.



9. Idirishya ryimpaka zabakoresha ryatangijwe. Muri "Ihuza na Akagari", sobanura aderesi y'ibibabi by'ibabi, ikubiyemo izina ry'ukwezi kwambere ryagenewe kubara amafaranga. Nyamuneka menya ko muriki kibazo udakeneye gufata umurongo mubisubiramo, kuva muriki gihe ntihazabaho guhuza akagari, ariko ibirimo birimo, bimaze kugira imiterere yinyandiko (ijambo ""). Umwanya "A1" usigaye ubusa, kubera ko dukoresha ubwoko busanzwe bwo kugena.

   Nyuma ya aderesi yerekanwe mu murima, ntukihute kuri buto "OK", nkuko iyi ari imikorere yashyizwe ahagaragara, kandi ibikorwa bigufi bitandukanye nibisanzwe algorithm isanzwe. Kanda ku izina "amafaranga" kumurongo wa formulaire.



10. Nyuma yibyo, tugaruka ku mpaka z'amafaranga. Nkuko mubibona, "umubare wa" Umubare1 "wamaze kubura umukoresha uhindagurika nibirimo. Shyira indanga mumurima umwe ako kanya nyuma yikimenyetso cyanyuma muri dosiye. Shyira ikimenyetso cya colon (:). Iki kimenyetso bisobanura ikimenyetso cyerekana intera. Ibikurikira, utakuye indanga mumurima, ongera ukande ku gishushanyo nka mpandeshatu zo guhitamo imirimo. Iki gihe kurutonde rwibikoresha vuba aha, izina "Dvssl" rigomba gufatwa nkukuri, nkuko dukoresha iyi miterere. Kanda mwizina.



11. Impaka zimpaka zabigenewe zifungura. Twinjije "ihuriro n'Akagari" umurima w'ikintu ku rupapuro aho izina ry'ukwezi riherereye, rirangiza igihe cyagenwe. Na none imirongo igomba gutondekwa nta magambo. Umurima "A1" Ureke ubusa. Nyuma yibyo, kanda kuri buto "OK".



12. Nkuko mubibona, nyuma yibi bikorwa, gahunda itanga ibyabaye kandi itanga ibisubizo byiyongera kwimibare yinjiza mugihe cyagenwe (Werurwe - Gicurasi) mu buryo bwihariye bwibanze .



13. Niba duhinduye mu tugari, aho amazina y'imitangire n'iherezo ry'igihe cyagenwe byanditswe, kubandi, ku rugero, kugeza ku nkuru, ku bw'Ugushyingo, kandi ibisubizo bizahinduka uko bikwiye. Ingano yinjiza mugihe cyagenwe izakumira.

Isomo: Nigute ushobora kubara amafaranga muri Excel

Nkuko dushobora kubibona, nubwo imikorere ya FV idashobora kwitwa umwe mubakoresha bazwi cyane, ariko, bifasha gukemura imirimo yingorane zitandukanye muri Excel biroroshye cyane kuruta uko byakorwa nibindi bikoresho. Byinshi muribi bikoresha byose ni ingirakamaro nkigice cyimiterere igoye aho ari igice cyimvugo. Ariko nanone twakagombye kumenya ko ibishoboka byose bya Dock byafashwe bikabije kugirango byumvikane. Ibi birasobanura gusa kuba yaramamaye kuri iki gikorwa cyingirakamaro kubakoresha.