Siba imirongo yihishe muri excel. Imwe kandi icyarimwe

Muri Microsoft Office Clossl, urashobora gukuraho byihuse imirongo yihishe, ubusangiza isura yimbonerahamwe. Uburyo bwo gukora ibi bizabwirwa muri iyi ngingo.

Nigute ushobora gukuramo imirongo yihishe muri excel

Hariho uburyo bwinshi bwo gukora umurimo washyizwe mubikorwa ukoresheje ibikoresho bya gahunda bisanzwe. Ibikurikira, bizasuzumwa nabyo bizasuzumwa.

Uburyo 1. Nigute ushobora kuvana imirongo mumeza imwe kugeza kuri menu

Guhangana niki gikorwa, birasabwa gukoresha algorithm ikurikira:

1. Hitamo umurongo wifuza kumeza array ya lkm.
2. Kanda ahantu hose agace kagenewe kanda iburyo.
3. Muri menu, kanda ku Ijambo "Gusiba ...".

Inzira yo gusiba idirishya rya selile muri Microsoft Office Excel

1. Mu idirishya rifungura, shyira guhinduranya kuruhande rwa "Umugozi" hanyuma ukande kuri OK.

Hitamo uburyo bukwiye kugirango ukureho umurongo mumeza

1. Reba ibisubizo. Umugozi watoranijwe ugomba gukuramo.
2. Kora ubu buryo hamwe nibindi bintu byisahani.

Uburyo 2. Imirongo imwe ikuramo ikoresheje amahitamo muri kaseti ya porogaramu

Excel ifite ibikoresho bisanzwe kugirango ukureho ingirabuzimafatizo. Kubikoresha kugirango ukureho imirongo, ugomba gukora gutya:

1. Hitamo selile iyo ari yo yose mu mugozi ushaka gusiba.
2. Jya kuri tab "urugo" muri excel yo hejuru.
3. Shakisha buto yo Gusiba hanyuma ukoreshe iyi nzira ukanze kumusaza iburyo.
4. Hitamo Ihitamo "Gusiba imirongo kuva urupapuro".

Algorithm yo gusiba umurongo watoranijwe kuva kurupapuro rwakazi ukoresheje igikoresho gisanzwe

1. Menya neza ko umuhigo watoranijwe mbere wacogoye.

Uburyo 3. Nigute wakuraho imirongo yose yihishe ako kanya

Ubuhungiro bushyira mubikorwa kandi bishoboka ko itsinda ritabumba ryibintu byatoranijwe bifatika. Ihitamo rigufasha gukuraho imirongo irimo ubusa yatatanye mubice bitandukanye byisahani. Muri rusange, inzira yo gukuramo igabanyijemo ibice bikurikira:

1. Na gahunda isa, hindura kuri tab.
2. Mu gace gafungura igice "guhindura", kanda kuri buto "Shakisha kandi utange.
3. Nyuma yo gukora ibikorwa byabanjirije, ibikubiyemo bizagaragara, aho umukoresha azakenera gukanda kumurongo "Guhitamo itsinda rya selile ...".

Gutanga imirongo yose irimo ubusa muri array ako kanya binyuze muri "Shakisha no Kugabana" muri Excel

1. Mu idirishya ryerekanwe, ugomba guhitamo ibintu kugirango ugaragaze. Muri ibi bihe, ugomba gushyira guhinduranya kuruhande rwa "ubusa" hanyuma ukande kuri "Ok". Noneho mumeza yinkomoko ugomba icyarimwe guhagarara kumurongo wose wubusa utitaye kumwanya wabo.

Guhitamo imirongo irimo ubusa mumadirishya yo gutoranya amatsinda

1. Iburyo-urufunguzo Manipulator Kanda kumurongo uwo ariwo wose watoranijwe.
2. Mu idirishya ry'idirishya, kanda ku Ijambo "Gusiba ..." hanyuma uhitemo "umugozi". Nyuma yo gukanda kuri "ok", ibintu byose byihishe ntibitandukanijwe.

Itsinda rikuramo ibintu byihishe

Isahani hamwe nuburyo bwacitse muburyo butandukanye bwo gukoresha 4. Gushyira mu bikorwa gutondeka

Uburyo nyabwo bukorwa hakurikijwe algorithm ikurikira:

1. Hitamo imbonerahamwe. Aka gace amakuru azatondeka.
2. Muri tab ya Murugo, ohereza ubwoko hanyuma uyunguruzo.
3. Mu idirishya rigaragara, hitamo Ihitamo "Gutondekanya Gutondekanya" ukanze kuri LKM.

Inzira igana Idirishya ryurutonde

1. Muri menu yo gutondekanya guhinduka, shyira ikimenyetso imbere ya "Data" (data "ikubiyemo imitwe.
2. Mu nkingi, vuga kimwe mu buryo bwo gutondeka: haba "kuva A kugeza kuri Z" cyangwa "kuri njye kugeza kuri".
3. Kurangiza gushiraho, kanda kuri "Ok" hepfo yidirishya. Nyuma yibyo, amakuru ari mumeza andray izemezwa nigipimo cyerekanwe.

Ibikorwa bisabwa muri menu yo gutondekanya

1. Nk'uko gahunda yaganiriweho mu gice kibanziriza ingingo, itange imirongo yose yihishe hanyuma uyisibe.

Gutondekanya indangagaciro zihita zigaragaza imirongo yose irimo ubusa kumpera yisahani.

Kuramo imirongo irimo ubusa, byahise bishyirwa kumpera yimbonerahamwe ya array nyuma yo gutondeka 5. Koresha kongurusha

Mu mbonerahamwe ya Excel, birashoboka gushungura umurongo wagenwe, hasigara gusa amakuru akenewe muri yo. Ubu buryo urashobora gukuramo umugozi uwo ariwo wose uva kumeza. Ni ngombwa gukurikiza ukurikije algorithm:

1. Urufunguzo rwibumoso rwa Manipulator rugaragaza umuhango.
2. Jya mu gice cya "Data", uherereye hejuru ya menu nkuru ya gahunda.
3. Kanda buto ya "Akayunguruzo". Nyuma yibyo, imyambi izagaragara mumutwe wa buri nkingi ya array.

Gushyira Akayunguruzo kumeza yinkomoko muri Excel

1. Kanda LKM kumyambi iyo ari yo yose yohereza urutonde rwabashumba baboneka.
2. Kuraho ibimenyetso byerekana indangagaciro mumirongo yifuzwa. Gukuramo umurongo wubusa, uzakenera kwerekana numero yacyo ikurikiranye.

Kuraho umurongo udakenewe ukoresheje uburyo bwo kurwara

1. Reba ibisubizo. Nyuma yo gukanda kuri "ok", impinduka zigomba gushora ingufu, kandi ibintu byatoranijwe bizavaho.

Umwanzuro

Rero, muri Microsoft Office Excel gukuramo imirongo yihishe mumeza yoroshye bihagije. Ibi ntabwo ari ngombwa kuba umukoresha w'inararibonye. Birahagije gukoresha bumwe muburyo bwavuzwe haruguru bukora bwigenga bwa software.

Ubutumwa Kuraho imirongo yihishe muri Excel. Umwe kandi bose bahise bagaragara mbere kuri tekinoroji yamakuru.