Akayunguruzo kambere muri Excel

Birashoboka, abakoresha bose bahora bakorana na Microsoft Excel bazi imikorere yingirakamaro yiyi gahunda nkibijyanye no gushungura amakuru. Ariko ntabwo abantu bose bazi ko muri iki gikoresho. Reka turebe ibishobora gukora Microsoft yagezweho ya Microsoft Filter nuburyo bwo kuyikoresha.

Ukoresheje akayunguruzo kagutse muri excel

Ntabwo bihagije guhita utangira akayunguruzo kerekana - kubwibi ugomba kurangiza ikindi kintu. Ibikurikira, tuzavuga kubyerekeye urutonde rwibikorwa bigomba gufatwa.

Intambwe ya 1: Gushiraho ameza hamwe nibisabwa

Kugirango ushyireho akayunguruzo, mbere muri byose ukeneye gukora imbonerahamwe yinyongera hamwe nuburyo bwo gutoranya. Ingofero ye ni kimwe nibintu byingenzi twe, mubyukuri, bizagushungura. Kurugero, twashyize imbonerahamwe yinyongera hejuru yingenzi kandi irangiza selile muri orange. Nubwo bishoboka kubishyira ahantu hose kubuntu ndetse no kurundi rupapuro.

Noneho andika amakuru ushaka kuyungurura ameza nkuru. Mu rubanza rwacu, kuva kurutonde rwimishahara yatanzwe nabakozi, twafashe umwanzuro wo guhitamo amakuru kubakozi b'ingenzi bo mu igorofa ku ya 25 Nyakanga 2016.

Intambwe ya 2: Gutangira Akayunguruzo

Gusa nyuma yimbonerahamwe yinyongera iremwa, urashobora kujya gutangiza umushumba wagutse.

1. Jya kuri tab "data" no kuri rubbon muburyo bwa "Sort hanyuma uyunguruze" ibikoresho, kanda kuri "bidatinze".



2. Idirishya ryagutse rifungura. Nkuko mubibona, hari uburyo bubiri bwo gukoresha iki gikoresho: "Kuyungurura urutonde" na "Gukoporora ibisubizo ahandi." Mu rubanza rwa mbere, kuyungurura bizakorwa mu buryo butaziguye ku meza yumwimerere, kandi mu bya kabiri - bitandukanye mu nsanganyamatsiko ugaragaza.



3. Mu murima "Inkomoko", ugomba kwerekana urutonde rwa selile ameza yinkomoko. Ibi birashobora gukorwa intoki utwarwa nigikorwa cya clavier, cyangwa garagaza urwego rwifuzwa ukoresheje imbeba. Mu murima "imiterere", ugomba kwinjiza urwego rwimbeba yimbonerahamwe yinyongera numugozi urimo ibintu. Muri icyo gihe, twakagombye kumenya ko nta mirongo irimo ubusa muri uru rwego, bitabaye ibyo nta kintu na kimwe kizakora. Iyo igenamiterere rirangiye, kanda OK.



4. Mumeza yinkomoko, gusa ibisobanuro twahisemo kuyungurura.



5. Niba amahitamo yatoranijwe hamwe nibisubizo bisohoka ahandi, muri "shyira ibisubizo kumurima", sobanura urwego rwa selile aho amakuru ayungurura azerekanwa. Urashobora kwerekana selile imwe. Muri iki kibazo, bizahinduka selile yo hejuru yimbonerahamwe yameza mashya. Emeza amahitamo kuri buto "OK".



6. Nyuma yibi bikorwa, imbonerahamwe yinkomoko yakomeje guhinduka, kandi amakuru yayungurutswe yerekanwa mumeza itandukanye.



7. Kugirango usubiremo akayunguruzo mugihe ukoresheje urutonde rwurutonde aho, kuri kaseti muburyo bwa "Sort na filteri" agasanduku k'ibikoresho, kanda kuri buto ya "Soure".

Rero, birashobora kwemeza ko Akayunguruzo kambere gatanga ibintu byinshi kuruta gushungura amakuru asanzwe. Ariko ntibishoboka kumenya ko akazi hamwe niki gikoresho kitoroshye kuruta umuyunguruzo usanzwe.