Nigute ushobora kuvana muyunguruzi muri Excel

Kuyungurura amakuru muri Excel birakenewe kugirango byoroherezwe gukora hamwe nameza hamwe namakuru menshi. Kurugero rero, igice cyingenzi gishobora guhishwa kubakoresha, kandi mugihe ukora filteri, erekana amakuru akenewe. Rimwe na rimwe, iyo imbonerahamwe yaremwe nabi, cyangwa kubera impamvu zumukoresha udafite uburambe, hakenewe gukuraho akayunguruzo mumikino itandukanye cyangwa kurupapuro rwose. UKO BIKORWA, tuzasesengura mu ngingo.

Ingero zo Kurema Imbonerahamwe

Mbere yuko utangira gukuramo akayunguruzo, ubanza gusuzuma uburyo bwo kwinjiza kumeza ya Excel:

• Intoki. Uzuza imirongo ninkingi namakuru akenewe. Nyuma yibyo, hitamo aderesi yimbonerahamwe aho, harimo imitwe. Jya kuri tab "data" hejuru yibikoresho. Turabona "akayunguruzo" (byerekanwa muburyo bwa funnel) hanyuma ukande kuri lkm. Akayunguruzo gakoreshwa mumutwe wo hejuru.

imwe

• Mu buryo bwikora. Muri uru rubanza, imbonerahamwe nayo yuzuye, nyuma ya tab ya "Style", isanga gukora "umugozi nkameza". Hagomba kubaho muyunguruzi mu gaciro k'ameza.

2.

Mu rubanza rwa kabiri, ugomba kujya kuri tab "shyiramo" hanyuma ukabona igikoresho cyimbonerahamwe, kanda kuri LKM no muburyo butatu bwo guhitamo "imbonerahamwe".

3.

Idirishya rikurikira rifungura, aderesi yimeza yaremye irerekanwa. Biracyayemeze gusa, kandi muyungurura mu subu zihita zifungura.

Bane

Ingero hamwe na filteri muri excel

Genda gusuzuma imbonerahamwe imwe yashizweho hashyizweho inkingi eshatu.

• Hitamo inkingi aho ukeneye guhinduka. Mugukanda kumyambi muri selile yo hejuru, urashobora kubona urutonde. Gukuraho imwe mu ndangagaciro cyangwa ibintu, ugomba kuvanaho amatikunyura.
• Kurugero, dukeneye imboga gusa kumeza. Mu idirishya rifungura, kura tike hamwe n '"imbuto", hanyuma usige imboga zikora. Emera ukanze kuri buto ya "OK".

bitanu

• Nyuma yo gukora urutonde bizasa nkibi:

6.

Suzuma urundi rugero rwiyungurura:

• Imbonerahamwe igabanijwemo inkingi eshatu, hamwe nibiciro byanyuma kuri buri bwoko bwibicuruzwa. Ikeneye guhinduka. Dufate ko dukeneye gushungura ibicuruzwa igiciro kiri munsi yagaciro "45".
• Kanda kuri SULPERING MU BIKORWA byagenwe natwe. Kubera ko inkingi yuzuye indangagaciro, hanyuma mwidirishya urashobora kubona ko "umugozi wuyunguruzi" uri mubikorwa.
• Kugira indanga kuriyo, fungura tab nshya hamwe nibintu bitandukanye byimeza yo kuyungurura. Muri yo, hitamo agaciro "gake".

7.

• Noneho andika umubare "45" cyangwa uhitemo mugufungura urutonde rwimibare mumukoresha Autofilter.

Kandi, hamwe nubufasha bwiki gikorwa, ibiciro byungurujwe muburyo bwihariye bwa digitale. Kugirango ukore ibi, ugomba gukora buto "cyangwa" kumukoresha Autofilter. Noneho hejuru hejuru shyira agaciro "bike", no munsi "kurushaho". Mu mbuga za interineti iburyo, ibisabwa bisabwa byibiciro byiteguye kugenda. Kurugero, munsi ya 30 na barenga 45. Kubera iyo mpamvu, ameza azagumana indangagaciro 25 na 150.

umunani

Ibishoboka byo gushungura amakuru amakuru akuwe. Usibye ingero, birashoboka guhindura amakuru ku ibara ryingirabuzimafatizo, ukurikije inyuguti zambere zamazina nizindi ndangagaciro. Noneho, igihe twakoraga ibyamenyereye muri rusange nuburyo bwo gukora muyungurura n'amahame yo gukorana nabo, kujya muburyo bwo gukuraho.

Kuraho inkingi filteri

1. Icya mbere, dusangamo dosiye yakijijwe hamwe nimbonerahamwe kuri mudasobwa yawe hamwe no gukanda inshuro ebyiri lkm ifunguye muri excel. Ku rupapuro hamwe nimbonerahamwe, urashobora kubona ko ayunguruzo ari muburyo bukora mugiciro.

icyenda

1. Kanda ku gishushanyo cyombi hasi.
2. Mu kiganiro agasanduku karakinguye, urashobora kubona ko cheque yerekanana na nimero "25" irakurwaho. Niba usuhuje neza wakuweho ahantu hamwe gusa, noneho inzira yoroshye yo gushiraho ikirango hanyuma ukande kuri buto ya "OK".
3. Bitabaye ibyo, birakenewe kuzimya akayunguruzo. Kugirango ukore ibi, mumadirishya imwe ugomba kubona umugozi "gusiba akayunguruzo mu nkingi" ... "hanyuma ukande kuri lkm. Hazabaho guhagarika byikora, kandi amakuru yose yinjiye azerekanwa byuzuye.

10

Kuraho Akayunguruzo kurupapuro rwose

Rimwe na rimwe, ibihe birashobora kubaho mugihe ari ngombwa gukuraho akayunguruzo kumeza yose agaragara. Kugirango ukore ibi, uzakenera gukora ibikorwa bikurikira:

1. Fungura dosiye hamwe namakuru yazigamye muri Excel.
2. Shakisha inkingi imwe cyangwa benshi aho umuyunguruzi ukora. Muri uru rubanza, iyi niyo "izina" inkingi.

cumi n'umwe

1. Kanda ahantu hose kumeza cyangwa kumurika rwose.
2. Hejuru, shakisha "amakuru" kandi ukoreshe LKM.

12

1. Umunyamerika. Ahateganye n'inkingi ni ibimenyetso bitatu muburyo bwa funnel hamwe nuburyo butandukanye. Kanda kuri buto yimikorere "Birasobanutse" hamwe na vernel igaragara na crorsair itukura.
2. Ibikurikira bizazimya muyungurura kumeza.

Umwanzuro

Gushungura ibintu n'indangagaciro mu mbonerahamwe byorohereza cyane akazi muri Excel, ariko ikibabaje, umuntu ashishikajwe no gukora amakosa. Muri uru rubanza, gahunda ya benshi muri rusange ije kuburana, izafasha gutondekanya amakuru no gukuraho abayunguruzi badakenewe mbere hamwe no kubungabunga amakuru yinkomoko. Iyi mikorere ni ingirakamaro cyane mugihe wuzuza ameza manini.

Ubutumwa Nigute wakuraho Akayunguruzo muri Excel byagaragaye mbere kugirango ubone Ikoranabuhanga.