Nigute Kubara Itandukaniro Muri Excel

Kimwe mu bipimo ngenderwaho by'ibarurishamibare byimibare ni ugukora itandukaniro. Kugirango ubone ni kubara cyane. Ibikoresho bya Microsoft Excel bikwemerera kugabanya cyane kubakoresha.

Kubara serivisi zitandukanijwe

Iki kimenyetso nigipimo cyo gutandukana bisanzwe kumurongo wo hagati. Ibisubizo byabonetse bigaragazwa nkijanisha.

Excel ntabwo ibaho muburyo bwo kubara iki kimenyetso, ariko hariho formulaire yo kubara gutandukana bisanzwe hamwe nurukurikirane rwimibare, aribo bamenyereye kubonana itandukaniro.

Intambwe ya 1: Kubara gutandukana bisanzwe

Gutandukana bisanzwe, cyangwa, nkuko byitwa ukundi, gutandukana bisanzwe ni umuzi wa kare uva kuritatanya. Kubara gutandukana bisanzwe, imikorere ya sitasiyo ikoreshwa. Guhera kuri verisiyo ya Excel 2010, igabanijwe, ukurikije niba ishimwe rusange ribarwa cyangwa ryicyitegererezo, amahitamo abiri atandukanye: VatiotClone.b na kasengena.b.

Syntax yiyi mikorere isa:

= Seriatlone (umubare1; Umubare2; ...)

= Seriatecloning.g (Umubare1; Umubare2; ...)

= VeritClonil.V (Umubare1; Umubare2; ...)

1. Kugirango ubare gutandukana bisanzwe, hitamo selile iyo ari yo yose ku rupapuro, ikaba nziza kuri wewe kugirango werekane ibisubizo byibarwa. Kanda kuri buto "Andika imikorere". Ifite isura ya Pictogram kandi iherereye ibumoso bwumugozi wa formula.



2. Gukora kwinuba ibikorwa bikorwa, bitangizwa nkidirishya ritandukanye nurutonde rwimpaka. Jya kuri Icyiciro "Staristike" cyangwa "Urutonde rwuzuye". Duhitamo izina "katotecloning.g" cyangwa "cartutclona.v.", Ukurikije niba guhuza rusange cyangwa icyitegererezo kigomba kubarwa. Kanda kuri buto ya "OK".



3. Idirishya rifungura. Irashobora kugira imirima 1 kugeza 255, aho hari umubare wihariye kandi witondere selile cyangwa iringaniye. Dushyira indanga muri "Umubare1". Imbeba itanga indangagaciro zigomba gutunganywa kurupapuro. Niba hari ahantu henshi nkaba kandi ntibabyegeranye, guhuza ibi bikurikira byerekana ko "umubare", nibindi. Iyo amakuru yose akenewe yinjiye, kanda kuri buto "OK"



4. Muri selire yabanjirije, kubara burundu ubwoko bwatoranijwe bwo gutandukana busanzwe bwerekanwe.

Isomo: Gutandukana kwa Quadratic Thiadet muri Excel

Intambwe ya 2: kubara ugereranije imibare

Impuzandengo yimibare nigipimo cyindangagaciro zose zindangagaciro zose zumubare ku bwinshi. Kubara iki cyerekezo, hariho nuburyo butandukanye - CPNPH. Kubara agaciro kayo kurugero runaka.

1. Hitamo Akagari kurupapuro kugirango usohoke ibisubizo. Twakanze kuri "Shyiramo imikorere" yamaze kumenyera.



2. Mu cyiciro cy'ibarurishamibare cya Wizard y'imirimo, turashaka izina "Srnvov". Nyuma yacyo, kanda buto "OK".



3. Idirishya ryatangijwe. Impaka zirasa rwose nukuvuga ko abakora itsinda rya statitlone. Ni ukuvuga, muburyo bwiza burashobora gukora nkindangagaciro zitandukanye. Shyira indanga muri "Umubare1". Nanone, nkuko bimeze mbere, tugenera selile kurupapuro. Nyuma yo guhuza kwabo kwari kurutonde rwidirishya ryidirishya, kanda kuri buto "OK".



4. Ingaruka zo kubara impuzandengo zisanzwe zikomoka mu kagari mbere yo gufungura imirimo wizard.

Isomo: Nigute ushobora kubara impuzandengo yagaciro muri Excel

Intambwe ya 3: Gushakisha Coefficient

Noneho dufite amakuru yose nkenerwa kugirango tubare mu buryo butaziguye.

1. Hitamo akagari ibisubizo bizerekanwa. Mbere ya byose, birakenewe gusuzuma ko guhuza itandukaniro ari ijanisha. Ni muri urwo rwego, imiterere y'utugari igomba guhinduka kubikwiye. Ibi birashobora gukorwa nyuma yo guhitamo, mugihe uri muri tab "murugo". Kanda kumurima wa format kuri lebon muri "Umubare" wibikoresho. Kuva kurutonde rwaganiriweho, hitamo "ijanisha". Nyuma yibi bikorwa, imiterere yibihe izaba ikwiye.



2. Kugaruka gusubira mu kagari kugirango werekane ibisubizo. Kuyikora hamwe no gukanda kabiri buto yimbeba. Twabishyize ikimenyetso "=". Hitamo ikintu ibisubizo ni ibisubizo byo kubara gutandukana bisanzwe. Kanda kuri buto ya "Gutandukanya" (/) kuri clavier. Ibikurikira, tugenera akagari aho ari arthmetic gushiraho urukurikirane rwumubare ruherereye. Kugirango ubare kandi usohoke, kanda kuri buto yinjira kuri clavier.



3. Nkuko mubibona, ibisubizo byo kubara birerekanwa.

Rero, twabazwe gahunda yo gutandukana, bivuga selile aho gutandukana bisanzwe hamwe nibishushanyo mbonera bimaze kubarwa. Ariko urashobora gukomeza kandi ukundi, utabaze izi ndangagaciro.

1. Hitamo selile zakozwe mbere muburyo bwijanishamo ibisubizo bizakomotse. Dutegeka ubwoko bwanditse muri IT:

   = VeritClonil.V (Range_name) / SR izaza (intera_name)

   Mu mwanya wizina rya "Range Range" Shyiramo imirongo nyayo yakarere, aho urukurikirane rwumubare rwashyizwe. Ibi birashobora gukorwa muburyo bworoshye kururu rwego. Aho kuba umukoresha wa kato. Muri, niba umukoresha abona ko ari ngombwa, imikorere isanzwe ya standasiyo irashobora gukoreshwa.



2. Nyuma yibyo, kubara agaciro hanyuma werekane ibisubizo kuri ecran ya mobire, kanda kuri buto yintonde.

Hariho itandukaniro riteganijwe. Byemezwa ko niba ibipimo byerekana ko gutandukana biri munsi ya 33%, noneho urutonde rwimibare ni kimwe. Mu rubanza, biramenyerewe kuranga nk'ubuhungiro.

Nkuko mubibona, gahunda ya Excel igufasha koroshya kwizirikana cyane kubara imibare itoroshye mugihe ushakisha ibikorwa bitandukanye. Kubwamahirwe, umugereka ntuzabaho imikorere yabara iki kimenyetso mugikorwa kimwe, ariko abifashijwemo nabakoresha-clone, iki gikorwa cyoroshe cyane. Rero, muri Excel, numuntu udafite urwego rwo hejuru rwubumenyi bujyanye nubushushanyo bwibarurishamibare burashobora gukorwa.