Nigute wakuramo umubare mubisohoka

Gahunda ya Excel ikoresheje igikoresho, nka formula, yemerera ibikorwa bitandukanye byimibare hagati yamakuru muri selile. Ibi bikorwa harimo gukuramo. Reka dusesengura mu buryo burambuye ni ubuhe buryo bushobora gutanga iyi mibare.

Gukoresha Kureka

Kureka kuri Excel birashobora gukoreshwa haba kumibare yihariye hamwe na aderesi ya selile aho amakuru aherereye. Iki gikorwa gikorwa kubera formula idasanzwe. Nko mubindi bibuga byimibare muriyi gahunda, mbere yimiterere yo gukuramo, ugomba gushiraho ikimenyetso kingana na (=). Noneho kugabanuka (muburyo bwa numero cyangwa aderesi ya selile), ukuyemo (-) ikimenyetso, uwambere avuza (muburyo bumwe), kandi mubihe bimwe na bimwe) bivuyeho.

Reka dusesengure ku ngero zihariye uburyo iki gikorwa cyibisobanuro cyakozwe muri excel.

Uburyo 1: Imibare ikuramo

Urugero rworoshye ni ukubogama. Muri uru rubanza, ibikorwa byose bikozwe hagati yimibare yihariye nko muburambe busanzwe, ntabwo ari hagati ya selile.

1. Hitamo selile iyo ari yo yose cyangwa ushireho indanga mumirongo ya formula. Dushyize ikimenyetso "bingana." Ducapura ingaruka zimibare hamwe no gukuramo, nkuko tubikora kumpapuro. Kurugero, andika formula ikurikira:

   = 895-45-69



2. Kugirango utange uburyo bwo kubara, kanda buto yinjira kuri clavier.

Izi ntambwe zimaze gukorwa, ibisubizo bigaragazwa muri selire yatoranijwe. Kuri twe, iyi niyo nimero 781. Niba wakoresheje izindi nama zo kubara, noneho, ibisubizo, ibisubizo byawe bizatandukana.

Uburyo 2: Kubomama bivuye muri selile

Ariko, nkuko mubizi, Excel, mbere ya byose, gahunda yo gukorana nameza. Kubwibyo, ibikorwa hamwe na selile bikinirwa byingenzi. By'umwihariko, barashobora gukoreshwa mu kutarerwa.

1. Turagaragaza selile aho gutaka. Dushyira ikimenyetso "=". Kanda kuri selire irimo amakuru. Nkuko mubibona, nyuma yiki gikorwa, adresse yayo yinjiye mumirongo ya formula kandi yongeraho ikimenyetso "kingana". Turacapa numero ukeneye kugirango ukureho.



2. Nko mu rubanza rwabanje, kugirango ubone ibisubizo byo kubara, kanda urufunguzo rwa Enter.

Uburyo 3: Akagari kamwe

Urashobora gukora ibikorwa bivuguruye kandi muri rusange nta numero, gukoresha gusa aderesi ya selile gusa. Ihame ryibikorwa niryo.

1. Hitamo selile kugirango werekane ibisubizo bikaba hanyuma ushireho ikimenyetso "kingana. Kanda kuri selile zirimo kugabanuka. Dushyize ikimenyetso "-". Kanda kuri selile irimo guterwa. Mugihe igikorwa gikeneye gukorerwa byinshi kugasingwa, noneho nanone shyira ikimenyetso "ukuyemo" kandi ugakora ibikorwa kuri gahunda imwe.



2. Nyuma yamakuru yose yinjiye, kubisubizo byibisubizo, kanda kuri buto ya Enter.

Isomo: Kora hamwe na formulaire muri excel

Uburyo 4: Gutunganya imikorere yo hanze

Kenshi na kenshi, mugihe ukorana na gahunda ya Excel, bibaho ko ari ngombwa kubara kugabanywa inkingi yose ya selile kurundi nkingi. Nibyo, birashoboka kuri buri gikorwa cyo kwandika formula itandukanye, ariko bisaba igihe kinini. Kubwamahirwe, imikorere yubusaba irashobora ahanini mu buryo busanzwe kubara, tubikesha imikorere yo mucyo autofile.

Kurugero, tubara inyungu yikigo mubice bitandukanye, tuzi amafaranga rusange nigiciro cyumusaruro. Kubwibyo, amafaranga agomba guhishurwa.

1. Tugenera selile yo hejuru kugirango tubare inyungu. Dushyira ikimenyetso "=". Kanda kuri selile ikubiyemo ingano yinjiza murutonde rumwe. Dushyize ikimenyetso "-". Turagaragaza selile hamwe nigiciro.



2. Kugirango usohoke inyungu kuri uyu murongo kuri ecran, kanda kuri buto yinjira.



3. Noneho dukeneye kwigana iyi formulaire murwego rwo hasi kugirango tubarezwe. Kugirango dukore ibi, dushyira indanga kuruhande rwiburyo bwa selile irimo formula. Ikimenyetso cyuzuye kiragaragara. Tugaca kanda buto yibumoso no muburyo bwo gukurura indanga kumanuka kugeza kumpera yameza.



4. Nkuko mubibona, nyuma yibi bikorwa, formula yandukuwe kumurongo wose hepfo. Muri icyo gihe, kubera uyu mutungo, nkuburwayi bwa aderesi, iyi kopi yabaye hamwe no kwimurwa, byatumye bishoboka kubara neza no muri selile zegeranye.

Isomo: Nigute ushobora gukora autocomplete muri excel

Uburyo 5: Gukuramo imbaga yamakuru ya selile imwe uhereye kumurongo

Ariko rimwe na rimwe ugomba gukora ibinyuranye, aribo, ko aderesi idahinduka iyo yandukuye, ariko yagumye uhoraho, yerekeza ku kagari runaka. Nigute wabikora?

1. Twabaye mu kagari ka mbere kugirango tuvuge ibisubizo byimibare. Dushyize ikimenyetso "bingana." Kanda ku kagari kagabanutse. Shyira ikimenyetso "ukuyemo". Dutanga gukanda kuri selile guterwa, aderesi ya zigomba guhinduka.



2. Noneho duhindukirira itandukaniro ryingenzi ryubu buryo kuva bwabanje. Nibi bikurikira bigufasha guhindura umurongo uva kuri mwene wabo rwose. Dushyira ikimenyetso cyamadorari imbere ya coordinates ya vertical kandi itambitse y selire ifite aderesi itagomba guhinduka.



3. Kanda kuri clavier ku rufunguzo rwa Enter, zigufasha gusohoka kubara kumurongo kuri ecran.



4. Kugirango tubarebare kurundi mirongo, kimwe no murugero rwabanje, twita ikimenyetso cyuzuye kandi tukabikurura.



5. Nkuko tubibona, gahunda yo kwigaragaza yarakozwe neza nkuko dukeneye. Ni ukuvuga, iyo kwimura aderesi yamakuru yagabanijwe, ariko uwayivaga yarahindutse.

Urugero rwavuzwe haruguru ni urubanza rwihariye gusa. Mu buryo nk'ubwo, birashobora gukorwa ku rundi buryo, kugira ngo kugabanuka bikomeje guhoraho, kandi ihohoterwa ryaramuwe kandi ryahinduwe.

Isomo: Ihuza ryuzuye kandi ugereranije kuri Excel

Nkuko mubibona, mugutezimbere uburyo bwo gukuramo muri gahunda ya Excel ntakintu kigoye. Byakozwe hakurikijwe amategeko amwe nkubundi kubara aruthmetic muri iyi porogaramu. Kumenya bimwe mubihuru bishimishije bizatuma uyikoresha akora neza ibikorwa byimibare yibikorwa binini byamakuru manini, bizazigama cyane umwanya wacyo.