USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chekiriniki  ››  Mirayiridzo yechirongwa chekurapa  ›› 

Ronga tafura

Nzira yekugadzirisa sei tafura?

Kuronga tafura nearufabheti kunodiwa kazhinji kazhinji nemushandisi wega wega wechirongwa. Kuronga muExcel uye zvimwe zvirongwa zve accounting hazvina kuchinjika kunodiwa. Asi vashandi vazhinji vari kunetseka kuti vangagadzirisa sei data muchirongwa chavo chebasa. Mukambani yedu, takashamiswa nenyaya iyi pachine uye takaedza kugadzira huwandu hwese hwakasiyana marongero kuitira nyore kuratidza ruzivo. Gara zvakanaka. Iye zvino tichakudzidzisa nzira yekugadzirisa tafura nenzira kwayo.

Ronga Kukwira

Nzira iri nyore yekugadzirisa rondedzero ndeyekuronga rondedzero mukukwira. Vamwe vashandisi vanodana iyi nzira yekurongedza: ' rongedza alfabheti '.

Kurongedza data, ingodzvanya kamwe chete pamusoro wekoramu inodiwa. Somuenzaniso, mugwaro "Vashandi" ngatidzvanye pandima "Zita rizere" . Vashandi vave kurongwa nemazita. Chiratidzo chekuti kurongedza kunoitwa chaizvo ne ' Zita ' munda igrey gonyo rinowanikwa munzvimbo yemusoro wekoromo.

Ronga Kudzika

Iwe ungangoda kuronga iyo data mune reverse order, kubva kumusoro kusvika yakaderera. Hazvina kuomawo. Izvi zvinodaidzwa kuti ' sort achidzika '.

Kana iwe ukadzvanya pamusoro mumwechete zvakare, iyo yetatu inochinja nzira, uye nayo, iyo yekurongeka inoshanduka zvakare. Vashandi vave kurongwa nemazita vachidzokera kumashure kubva 'Z' kusvika 'A'.

Cancel sort

Kana iwe wakatoona iyo data uye ukaita mashandiro anodiwa pairi, ungangoda kukanzura rudzi.

Kuita kuti pembetatu yegrey inyangarike, uye nayo kurongwa kwemarekodhi kwakadzimwa, ingodzvanya pamusoro wekoromo wakabata pasi kiyi ye' Ctrl '.

Ronga chikamu

Sezvo mutemo, kune minda yakawanda mumatafura. Munzvimbo yekurapa, aya ma parameter anogona kusanganisira: zera remurwere, zuva rekushanya kwake kukiriniki, zuva rekubvumidzwa, huwandu hwekubhadhara kwesevhisi, nezvimwe zvakawanda. Mu pharmacy, tafura ichasanganisira: zita rechigadzirwa, mutengo wayo, chiyero pakati pevatengi. Mushure meizvozvo, ungangoda kuronga ruzivo urwu nendima imwe chaiyo - nekoramu imwe. Munda, mbiru, mbiru - zvese zvakafanana. Iyo purogiramu inogona nyore kuronga tafura nekoramu. Iyi ficha inosanganisirwa muchirongwa. Iwe unogona kuronga minda yemhando dzakasiyana: nemazuva, alfabheti yemunda une tambo, uye kukwira kune manhamba ndima. Zvinogoneka kuronga koromo yemhando ipi neipi, kunze kweminda inochengeta data rebhinari. Semuenzaniso, mufananidzo wemutengi.

Kana ukadzvanya pane musoro weimwe column "bazi" , ipapo vashandi vacharongwa nedhipatimendi ravanoshanda mariri.

Ronga data neminda yakawanda yematafura

Uyezve, kunyange kurongedza kwakawanda kunotsigirwa. Kana paine vashandi vakawanda, unogona kutanga waronga navo "department" , uyezve - ne "zita" .

Zvingave zvakafanira kuchinjana makoramu kuitira kuti dhipatimendi riri kuruboshwe. Naizvozvi tatova nekugadzirisa. Inoramba ichiwedzera chikamu chechipiri kune rudzi. Kuti uite izvi, tinya pamusoro wekoramu. "Zita rizere" nekiyi ' Shift ' yakadzvanywa.

Dzidza zvakawanda nezvekuti ungachinjanisa sei makoramu .

Kuronga pakuunganidza mitsetse

Zvinonakidza chaizvo kuronga zvikwanisiro pakuunganidza mitsetse . Iri ibasa rakaoma, asi rinorerutsa zvakanyanya basa renyanzvi.

Ona pazasi mamwe misoro inobatsira:

• Kufamba mbiru
• Tsvaga mutafura
• Kuronga pakuunganidza mitsetse
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana