Urutonde rwa Excel

Gukora urutonde rwamanutse ntiyemerera kuzigama igihe mugihe uhisemo amahitamo mugihe cyo kuzuza imbonerahamwe, ariko nanone kwikingira gukora amakuru atari yo. Iki nigikoresho cyoroshye kandi gifatika. Reka tumenye uburyo bwo kubikora muri Prorl, nuburyo bwo kuyikoresha, kimwe no kumenya ibindi bintu bimwe na kimwe cyo kubikemura.

Gukoresha urutonde-hasi

Gukurikira, cyangwa nkuko bisanzwe kuvuga, urutonde rwamanutse rukoreshwa cyane mumeza. Hamwe nubufasha bwabo, urashobora kugabanya indangagaciro zakozwe mumeza array. Bakwemerera guhitamo gukora agaciro kamwe kurutonde rwateguwe mbere. Ibi icyarimwe kumubuza inzira yo gukora amakuru ninzita ikosa.

Inzira yo kurema

Mbere ya byose, reka tumenye uburyo bwo gukora urutonde rwamanutse. Biroroshye kubikora hamwe nigikoresho cyitwa "Kugenzura amakuru".

1. Turagaragaza inkingi yimbonerahamwe, muri selile iteganijwe gushyira urutonde rwamanutse. Kwimuka muri "Data" na Clay kuri buto ya "Data Kugenzura". Ihari kuri lente muri "gukorana na data".



2. Idirishya ryibikoresho bya "Kugenzura" ritangira. Jya kuri "ibipimo". Muburyo bwa "Data Ubwoko" buva kurutonde, hitamo "urutonde". Nyuma yibyo, twimukira mu murima "inkomoko". Hano ukeneye kwerekana itsinda ryamazina agenewe gukoreshwa kurutonde. Aya mazina arashobora gukorwa intoki, kandi urashobora kwerekana isano nabo niba bamaze gutamburwa muri ako gace.

   Niba intoki yinjira yatoranijwe, noneho buri rutonde ikintu gisabwa kwinjira mukarere hejuru ya semicolon (;).

   

   Niba ushaka kongera amakuru kuva kumeza asanzwe, noneho ugomba kujya kurupapuro aho riherereye (niba riherereye kurundi), shyira indanga kumurima "isoko" yo kugenzura idirishya , hanyuma ugaragaze akarere ka selile aho urutonde ruherereye. Ni ngombwa ko buri selile itandukanye iherereye urutonde rwihariye. Nyuma yibyo, guhuza urwego rwabigenewe bigomba kwerekanwa ahantu "inkomoko".

   

   Ubundi buryo bwo gushiraho itumanaho ninshingano ya array hamwe nurutonde rwizina. Hitamo intera aho indangagaciro zamakuru zerekanwa. Ibumoso bw'umugozi ni agace k'amazina. Mburabuzi, muri bwo, iyo intera yatoranijwe, guhuza selile byambere byatoranijwe. Turimo kwinjiza gusa izina kubwintego zacu, ibyo dusuzuma byinshi bikwiye. Ibisabwa nyamukuru ku izina nuko birihariye mu gitabo, ntabwo byari bifite icyuho kandi byanze bikunze byatangiwe hamwe n'ibaruwa. Noneho ko urwego twamenyekanye mbere yiki kintu ruzamenyekana.

   

   Noneho, mumikino yo kugenzura amakuru muri "Inkomoko", ugomba kwinjizamo "=" ikimenyetso, hanyuma ukimara kwinjira mwizina twahaye inzego. Porogaramu ihita igaragaza isano iri hagati yizina na array, kandi izakurura urutonde ruri muri yo.

   

   Ariko cyane bizakoreshwa muburyo bwo gukoresha urutonde niba uhinduye imbonerahamwe ya "Smart". Mu mbonerahamwe nkaya, bizoroha guhindura indangagaciro, bityo bihita bihindura urutonde. Rero, uru rurimi ruzahinduka kumeza.

   Kugirango uhindure imbonerahamwe "yubwenge", hitamo hanyuma ubimure muri tab. Ngaho, ibumba kuri buto ya buto "nk'ameza", rishyirwa kuri kaseti mu ruganda "styles". Itsinda rinini rifungura. Ku mikorere yameza, guhitamo uburyo runaka ntibigira ingaruka kumuntu, bityo hitamo na kimwe muri byo.

   

   Nyuma yibyo, idirishya rito rifungura, rikubiyemo aderesi yatoranijwe. Niba guhitamo byakozwe neza, ntakintu kigomba guhinduka. Kubera ko intera yacu idafite imitwe, hanyuma "ameza akoresheje imitwe" ntagomba kuba. Nubwo byumwihariko mubibazo byawe, birashoboka, umutwe uzashyirwa mubikorwa. Turashobora rero gukanda gusa kuri buto "OK".

   

   Nyuma yibyo, intera izahindurwa nkimeza. Niba byatanzwe, noneho urashobora kubona ahantu h'amazina, iryo zina yahawe mu buryo bwikora. Iri zina rirashobora gukoreshwa mugushiramo ahantu "isoko" mugice cyo kugenzura amakuru ukurikije algorithm yasobanuwe mbere. Ariko, niba ushaka gukoresha irindi zina, urashobora kuyisimbuza, ku mazina yizina.

   

   Niba urutonde rwashyizwe mubindi gitabo, noneho kubigaragaza neza birasabwa gukoresha imikorere DVSL. Umukoresha wagenwe agenewe gukora "superabsolite" yerekanwe kubintu byimpapuro muburyo bwanditse. Mubyukuri, inzira izakorwa hafi kimwe no mubibazo byasobanuwe, gusa "inkomoko" nyuma yikimenyetso "=" bigomba kwerekana izina ry'umukoresha - "Dvssl". Nyuma yibyo, mumutwe, aderesi yurwego igomba kugaragazwa nkimpaka ziyi mikorere, harimo n'izina ryigitabo nurupapuro. Mubyukuri, nkuko bigaragara mwishusho hepfo.



3. Kuri ibi dushobora kurangiza inzira ukanda kuri buto ya "OK" mumadirishya yo kugenzura amakuru, ariko niba ubishaka, urashobora kunoza ifishi. Jya kuri "ubutumwa kugirango winjire" igice cyidirishya ryo kugenzura amakuru. Hano muri "ubutumwa" ushobora kwandika inyandiko abakoresha bazabona indanga ku kibabi c'ibabi hamwe nurutonde. Twanditse ubutumwa tubona ko ari ngombwa.



4. Ibikurikira, twimukira mu gice cya "Ubutumwa Bwiza". Hano muri "ubutumwa", urashobora kwinjiza inyandiko uyikoresha azareba mugihe ugerageza kwinjiza amakuru atariyo, ni ukuvuga amakuru yose yabuze murutonde rutonyanga. Muri "kureba", urashobora guhitamo igishushanyo cyo guherekezwa ni umuburo. Injira inyandiko yubutumwa nibumba kuri "ok".

Isomo: Nigute ushobora gukora urutonde rwamanutse muri Excel

Ibikorwa byo gukora

Noneho reka tumenye uburyo bwo gukora hamwe nigikoresho twaremye hejuru.

1. Niba twashizeho indanga kubintu byose byakoreshejwe aho intera yakoreshejwe, tuzabona ubutumwa bwamakuru bwatangijwe natwe mbere mumadirishya yo kugenzura amakuru. Byongeye kandi, pictografiya muburyo bwa mpandeshatu izagaragara iburyo bwa selire. Nibwo bikora kugirango ugere ku guhitamo ibintu. Ibumba kuri iyi mpandegisho.



2. Nyuma yo gukanda kuri yo, menu kuva kurutonde rwibintu bizakingurwa. Irimo ibintu byose byakozwe mbere mumadirishya yo kugenzura amakuru. Hitamo uburyo tubona ko ari ngombwa.



3. Amahitamo yatoranijwe azerekanwa muri selire.



4. Niba tugerageje kwinjira mu kagari kose gahari kurutonde, iki gikorwa kizahagarikwa. Mugihe kimwe, niba utanze ubutumwa bwo kuburira idirishya ryamakuru, ryerekanwa kuri ecran. Ugomba gukanda kuri buto ya "guhagarika" mumadirishya yo kuburira hamwe no kugerageza gukurikira kugirango winjire.

Muri ubu buryo, nibiba ngombwa, kuzuza ameza yose.

Ongeraho ikintu gishya

Ariko ni iki nakeneye kongeramo ikintu gishya? Ibikorwa hano biterwa nuburyo washizeho urutonde mumadirishya yo kugenzura amakuru: yinjiye mu ntoki cyangwa yakuwe mumeza array.

1. Niba amakuru yo gushiraho urutonde akururwa kumeza array, hanyuma ujyeyo. Hitamo urwego rwurwego. Niba ibi atari "Smart", ariko uburyo bworoshye bwamakuru, ugomba gusa gushiramo umugozi hagati ya array. Niba ukoresheje imbonerahamwe ya "Smart", noneho birahagije kugirango winjize gusa agaciro wifuza kumurongo wambere kandi uyu murongo uzahita ushyirwa mumeza array. Ibi ni byiza gusa kumeza ya "Smart", twavuze haruguru.

   

   Ariko tuvuge ko dukemura ibibazo bigoye dukoresheje urwego rusanzwe. Rero, turagaragaza selile hagati ya array yagenwe. Ni ukuvuga hejuru yaka kasho kandi munsi yacyo hagomba kubaho imirongo myinshi ya array. Ibumba ku gice cyagenwe hamwe na buto yimbeba iburyo. Muri menu, hitamo Ihitamo "Paste ...".



2. Idirishya ritangira, aho guhitamo ikintu cyinjizwamo bigomba gukorwa. Hitamo "umugozi" hanyuma ukande kuri buto "OK".



3. Rero, umurongo wubusa wongeyeho.



4. Injiza agaciro twifuza kwerekanwa kurutonde rwamanutse.



5. Nyuma yibyo, tugaruka kumeza array, ishyira urutonde rwamanutse. Mugukanda kuri mpandeshatu, iburyo bwa selile iyo ari yo yose ya array, tubona ko agaciro gakenewe kubintu bisanzwe byongeyeho. Noneho, niba ubishaka, urashobora guhitamo kwinjiza mubintu.

Ariko icyo gukora niba urutonde rwindangagaciro zikangwa n'ameza itandukanye, ariko wakozwe n'intoki? Kugirango wongere ikintu muriki kibazo, nacyo gifite algorithm yacyo.

1. Turagaragaza inzigera zose, mubitekerezo byabyo urutonde rwamanutse. Jya kuri tab "data" hanyuma ukande kuri buto "Kugenzura amakuru" muri "akazi hamwe namatsinda".



2. Idirishya ryo kugenzura ryatangiye. Twimukiye muri "Parameter". Nkuko mubibona, igenamiterere ryose hano rimeze neza nkuko tubishyira imbere. Tuzashishikazwa n "isoko" muriki kibazo. Twongeyeho kugeza ku rutonde runyuze mu ngingo hamwe na koma (;) agaciro cyangwa indangagaciro dushaka kubona mu rutonde rutonyanga. Nyuma yo kongera ibumba kuri "OK".



3. Noneho, niba dufunguye urutonde rwamanutse mumeza array, tuzabona agaciro kongerewe aho.

Kuraho ikintu

Gukuraho urutonde rwibintu bikorwa kuri algorithm imwe nkinyongera.

1. Niba amakuru yagonze kumeza array, hanyuma ujye kuri iyi mbonerahamwe no gukanda neza kuri selile aho agaciro ko gusibwa biherereye. Mubice bikubiyemo, guhagarika guhitamo kuri "gusiba ...".



2. Idirishya ryo gukuraho idirishya risa naryo twabonye iyo tukongereye. Hano twashizeho umwanya "umugozi" nibumba kuri "ok".



3. Umugozi uva kumeza array, nkuko dushobora kubibona, gusiba.



4. Noneho dusubira kuri iyo mbonerahamwe aho hari selile zifite urutonde ruto. Ibumba muri mpandeshatu ryiburyo bwa selile iyo ari yo yose. Kurutonde ruhagaritswe Turabona ko ikintu cya kure kidahari.

Nakora iki niba indangagaciro zongewe kuri idirishya ryamakuru intoki, kandi ntukoreshe ameza yinyongera?

1. Turagaragaza ameza hamwe nurutonde ruto hanyuma tujye kuri cheque agasanduku k'indangagaciro, nkuko tumaze gukora kare. Mu idirishya ryerekanwe, twimukira mu gice cya "Parameter". Muri "inkomoko", tugenera indanga ku gaciro ushaka gusiba. Noneho kanda buto yo gusiba kuri clavier.



2. Nyuma yikintu cyakuweho, kanda kuri "Ok". Noneho ntabwo bizaba biri murutonde rwamanutse, nkuko twabibonye muburyo bubanza bwibikorwa hamwe nimbonerahamwe.

Gukuraho byuzuye

Mugihe kimwe, hari aho urutonde rumanuka rugomba kuvaho burundu. Niba ntacyo bitwaye ko amakuru yinjiye akijijwe, noneho gukuraho ni byoroshye.

1. Tugenera umurongo wose aho urutonde rwamanutse ruherereye. Kwimukira kuri tab "urugo". Kanda ahanditse "Soure", zishyirwa kuri lente mu gice cyo guhindura. Muri menu ifungura, hitamo "Sobanura".



2. Iyo iki gikorwa cyatoranijwe mubintu byatoranijwe byurupapuro, indangagaciro zose zizasibwa, imiterere yisuku, kandi intego nyamukuru yumurimo igera: Noneho Urutonde urwo arirwo rwose Intoki mu Kagari.

Mubyongeyeho, niba umukoresha adakeneye gukiza amakuru yinjiye, noneho hariho ubundi buryo bwo gukuraho urutonde rwamanutse.

1. Turagaragaza urwego rwa selile zubusa, zihwanye nurwego rwa array hamwe nurutonde ruto. Kwimuka muri tab "urugo" ngaho ndakanda kuri "Gukoporora", bikaba byashyizwe ahagaragara kuri lebbon muri "Buffer".

   

   Kandi, aho kugirango iki gikorwa, urashobora gukanda ku gice cyagenwe na buto yimbeba iburyo hanyuma uhagarare kuri "kopi".

   

   Ndetse byoroshye ako kanya nyuma yo gutoranya, koresha urutonde rwa Ctrl + c Utubuto.

2. Nyuma yibyo, tugenera icyo gice cy'ameza array, aho ibintu bitonyanga biri. Twakanze kuri buto "Shyiramo", hirya no hino kuri kaseti murugo rwa "Guhana Buffer".

   

   Uburyo bwa kabiri bwibikorwa nukugaragaza buto yimbeba iburyo hanyuma uhagarike guhitamo kuri "Shyiramo" mumatsinda y'ibice.

   

   Hanyuma, birashoboka kwerekana gusa selile wifuza hanyuma wandike guhuza Ctrl + v buto.

3. Hamwe nimwe mu ntambwe zavuzwe haruguru aho kuba selile zirimo indangagaciro hamwe nurutonde ruto, igice gisukuye rwose kizinjizwa.

Niba ubishaka, urashobora gushiramo intera, ariko igice cyandukuwe namakuru. Kubura urutonde-yamanutse nuko badashobora kwinjizamo intoki zabuze kurutonde, ariko barashobora kwimurwa no kwinjizwa. Muri uru rubanza, kugenzura amakuru ntabwo bizakora. Byongeye kandi, nkuko twabimenye, imiterere y'urutonde rutonyanga ubwabwo ruzasenywa.

Akenshi, birakenewe gukomeza gukuraho urutonde rwamanutse, ariko icyarimwe usige indangagaciro zatangijwe kuyikoresha, no gutunganya. Muri iki kibazo, intambwe nyinshi zukuri zo gukuraho igikoresho cyuzuye cyo kuzuza.

1. Turagaragaza agace kose ibintu bifite urutonde rwibitonyanga ruherereye. Kwimukira kuri tab ya "Data" kuri "Data Kugenzura", nkuko twibuka, biherereye kuri kaseti mugihe cya "Gukorana namakuru".



2. Idirishya rimenyerewe rimenyerewe ryamakuru yinjiza afungura. Kuba mu gice icyo aricyo cyose cyigikoresho cyagenwe, dukeneye gukora igikorwa kimwe - kanda kuri buto "Sobanura". Iherereye mu mfuruka yo hepfo yidirishya.



3. Nyuma yibyo, idirishya ryo kugenzura amakuru rirashobora gufungwa ukanze kuri buto isanzwe yo gusoza mugice cyo hejuru cyiburyo nkumusaraba cyangwa "outon" hepfo yidirishya.



4. Noneho tugenera selile zose zirimo urutonde rwamanutse rwashyizwe mbere. Nkuko tubibona, ubu nta cyerekane mugihe uhitamo ikintu, cyangwa inyabutatu yo guhamagara urutonde iburyo bwa selire. Ariko icyarimwe, imiterere ikomeje gukorwa kandi indangagaciro zose zinjiye ukoresheje urutonde rusigaye. Ibi bivuze ko hamwe ninshingano twakoresheje neza: igikoresho tudakeneye byinshi, gisibwe, ariko ibisubizo byakazi bye byakomeje kuba integer.

Nkuko mubibona, urutonde rwamanuka rushobora koroshya cyane intangiriro yamakuru mumeza, kimwe no gukumira intangiriro yindangagaciro zitari zo. Ibi bizagabanya umubare wamakosa mugihe wuzuza ameza. Niba ukeneye kongera agaciro icyo ari cyo cyose, urashobora guhora ukora uburyo bwo guhindura. Amahitamo yo guhindura azaterwa nuburyo bwo gushiraho. Nyuma yo kuzuza ameza, urashobora gusiba urutonde rwamanutse, nubwo atari ngombwa kubikora. Abakoresha benshi bahitamo kuyisiga na nyuma yimpera yimbonerahamwe irangiye.