Mugihe cyo kubara bitandukanye namakuru hamwe namakuru, akenshi ni ngombwa kubara agaciro kabo. Irabarwa no kongeramo imibare no kugabana amafaranga yose kumubare wabo. Reka tumenye uburyo bwo kubara impuzandengo yashyizweho numubare ukoresheje gahunda ya Microsoft Excel muburyo butandukanye.
Uburyo busanzwe bwo kubara
Inzira yoroshye kandi izwi cyane kugirango ubone impuzandengo yimibare ibanzizi ni ugukoresha buto idasanzwe kuri Microsoft Excel Ribbon. Hitamo urwego rwimibare iherereye mu nkingi cyangwa mumirongo yinyandiko. Mugihe muri tab "urugo", kanda kuri buto ya Autosumn, iherereye kuri kaseti murwego rwo guhindura ibikoresho. Kuva kurutonde rwamanutse, hitamo ikintu "ugereranije".
Nyuma yibyo, ukoresheje "SRVNAK", ubarwa. Muri kagari munsi yinkingi yatoranijwe, cyangwa iburyo bwumurongo watoranijwe, impuzandengo yurubuga rwimibare irerekanwa.
Ubu buryo nuburyo bwiza bworoshye kandi bworoshye. Ariko, afite inenge nyinshi. Ukoresheje ubu buryo, urashobora kubara impuzandengo ya Agaciro kamwe gusa iyo mibare iri kumurongo mu nkingi imwe, cyangwa kumurongo umwe. Ariko, hamwe na selile za selile, cyangwa selile zitatanye kurupapuro, ntibishoboka gukorana nubu buryo.
Kurugero, niba uhisemo inkingi ebyiri, hamwe nintoki zishushanyije zasobanuwe haruguru, igisubizo kizahabwa kuri buri nkingi ukwane, kandi ntabwo ari kubice byose bya selile.
Kubara ukoresheje umupfumu wibikorwa
Kubibazo mugihe ukeneye kubara impuzandengo yurwego rwamategeko, cyangwa selile zitatanye, urashobora gukoresha imikorere yimikorere. Bikoreshwa mubikorwa bimwe "crnval", tuzwi natwe dukurikije uburyo bwa mbere bwo kubara, ariko butuma bunyuramo.
Kanda ku kagari, aho dushaka kwerekana ibisubizo byo kubara agaciro. Kanda kuri buto "Shyiramo Imikorere", ishyirwa ibumoso bwumugozi wa formula. Haba, twandika ihuriro rya shift + f3 kuri clavier.
Inshingano nyamukuru iratangira. Kurutonde rwimikorere yatanzwe ni ugushaka "Srnvow". Turabigaragaza, hanyuma tukande buto ya "ok".
Idirishya rifungura. Imirima ya "Umubare" yinjijwe nibikorwa. Irashobora kuba imibare isanzwe na aderesi ya selile, aho iyi mibare iherereye. Niba utamerewe neza kwinjiza aderesi ya selile intoki, ugomba gukanda kuri buto iherereye iburyo bwamakuru yinjira.
Nyuma yibyo, imikorere yimikorere izaza, kandi urashobora guhitamo itsinda rya selile kurupapuro ruzara. Noneho, na none, kanda buto ibumoso bwamakuru yinjira kugirango usubire mubikorwa byanditse.
Niba ushaka kubara impuzandengo yimibare hagati yimibare mumatsinda yakatana, ibikorwa bimwe byavuzwe haruguru ni "umubare wa" umubare 2 ". Kandi rero igihe cyose amatsinda yose asigaye ya selile ntabwo agaragara.
Nyuma yibyo, kanda kuri buto "OK".
Igisubizo cyo kubara impuzandengo yikigereranyo kizagaragazwa mu kagari wahaye mbere yo gutangira umupfumu wimirimo.
Amayeri
Hariho ubundi buryo bwa gatatu bwo gutangiza imikorere "Srntvow". Kubwibi, jya kuri tab "formulaire". Turagaragaza akagari ibisubizo bizerekanwa. Nyuma yibyo, muburyo bwa "imikorere yisomero" yumurongo kuri kaseti tukanda buto "indi mikorere". Urutonde rugaragara aho ukeneye kunyura mubyo "imibare" na "Sonzov".
Noneho, imikorere imwe yidirishya ryimikorere itangiye, kimwe no gukoresha imikorere yacyo, akazi twasobanuye birambuye hejuru.
Ibindi bikorwa birasa.
Imikorere yintoki
Ariko, ntukibagirwe ko buri gihe, niba ubishaka, urashobora kwinjiza imikorere "Srnval" intoki. Izaba ifite inyandikorugero ikurikira: "= SRNAVOV (Aderesi_Dapazone_ (Umubare); aderesi_diapazone_ychek (umubare)).
Nibyo, ubu buryo ntabwo bumeze neza nkaba mbere, kandi bisaba formulaire zimwe mumutwe wumukoresha, ariko birahinduka.
Kubara bivuze kubisanzwe
Usibye kubara bisanzwe bifite agaciro, birashoboka kubara impuzandengo kumiterere. Muri iki gihe, iyo mibare yonyine kuva murwego rwatoranijwe ruhuye nuburyo runaka bizakoreshwa. Kurugero, niba iyi mibare ari nyinshi cyangwa nkeya.
Kuri izo ntego, imikorere "yo kubaho" ikoreshwa. Kimwe na "SRNVAL", birashoboka kuyiyobora binyuze mumikorere yimikorere, uhereye kumurongo wa formula, cyangwa hamwe nibikoresho byimfashanyigisho kuri selire. Nyuma yibikorwa byanditse idirishya byafunguwe, ugomba kwinjira mubipimo byayo. Mu murima, twinjije urwego rwa selile, indangagaciro zizokwitabira ibisobanuro byurugero rwurubuga. Turabikora muburyo bumwe hamwe nimikorere "Srnvow".
Ariko, muburyo bwa "imiterere", tugomba kwerekana agaciro kahariye, umubare munini cyangwa bike uzagira uruhare mukubara. Ibi birashobora gukorwa ukoresheje ibimenyetso byo kugereranya. Kurugero, twafashe "> = 15000" imvugo. Ni ukuvuga, umurongo wa interineti gusa uzafatwa kugirango ubaze imibare ni nini cyangwa ingana na 15,000. Nibiba ngombwa, aho kuba umubare runaka, hano urashobora kwerekana adresse yumubare uhuye.
Umurima "ugereranyije" ntabwo ari ngombwa kuzura. Kwinjiza amakuru muribi ni itegeko gusa mugihe ukoresheje selile zifite ibintu.
Iyo amakuru yose yinjiye, kanda buto "OK".
Nyuma yibyo, muri selire yabanjirije yatoranijwe, ibisubizo byo kubara impuzandengo yurubuga rwururimi rwatoranijwe kugaragara, usibye selile zidafite amakuru atujuje ibisabwa.
Nkuko mubibona, muri gahunda ya Microsoft Excel hari umubare wibikoresho byinshi ushobora kubara agaciro kagereranijwe k'umubare watoranijwe. Byongeye kandi, hari imikorere ihita ihitamo imibare itahuye nigipimo cyateganijwe mbere. Ibi bituma kubara muri Microsoft Excel, ndetse byoroshye kubakoresha.