Yepamberi sefa muExcel. Maitiro ekushandisa, maitiro ekukanzura kusefa kwepamberi

Purogiramu yeExcel ine mabasa akasiyana-siyana. Kusefa kweruzivo chinhu chakajairika chespredishiti. Vazhinji vashandisi vanoshandisa kusefa kana vachishanda nehuwandu hwakawanda hwe data, asi havasi vese vanoziva kuti kune yepamberi sefa inowedzera maficha matsva. Kubva kuchinyorwa, iwe unowana ese maficha ekusefa kwepamberi uye dzidza mashandisiro ari nyore chinhu ichi.

Chii chinonzi kusefa data muExcel

Kusefa data chinhu chinobatsira chinokutendera kuti uronge ruzivo zvinoenderana nemamiriro akatarwa, uye kuvanza mitsara isina basa.

Kushandisa Advanced Sefa muExcel

Ngatitii tine tafura ine ruzivo rwunoda kusefa.

Detailed mirairo inoita seizvi:

1. Pakutanga, tinogadzira tafura yechipiri yekuwedzera, iyo ichange iine mamiriro ekusefa. Isu tinogadzira kopi yemusoro wetafura yekutanga uye tinoiisa mune yechipiri. Kuti tinzwisise zviri nani muenzaniso, ngatiisei ndiro yekubatsira zvishoma pane yekutanga. Uyezve, zadza itsva nemumvuri wakasiyana. Zvakakosha kuziva kuti tafura yechipiri inogona kuiswa chero kupi zvako kwete chete papepa rekushanda, asi pabhuku rose rose.

2. Pachikamu chinotevera, tichazadza ndiro yekuwedzera nemashoko anodiwa kune rimwe basa. Tinoda zviratidzo kubva patafura yezvinyorwa, izvo zvatinozosefa ruzivo. Mumuenzaniso uyu, isu tinofanirwa kusefa nehunhu hwevakadzi uye mutambo wakaita setennis.

3. Mushure mekuzadza ndiro yekuwedzera, tinopfuurira kune danho rinotevera. Isu tinonongedza iyo mbeva pointer pane zvachose chero sero rekwakabva kana mamwe matafura. Muchikamu chepamusoro chespreadsheet editor interface, tinowana chikamu che "Data" uye tinya pairi neLMB. Isu tinowana block yemirairo inonzi "Sefa" uye sarudza iyo "Advanced" chinhu.

4. Iwindo rakakosha rakaonekwa pachiratidziri, rinonzi "Advanced Filter". Pano unogona kugadzira marongero akasiyana-siyana ekusefa kwepamusoro.

5. Ichi chishandiso chine mashandisiro maviri. Sarudzo yekutanga ndeye "Kopira mhinduro kune imwe nzvimbo" uye yechipiri sarudzo ndeye "Sefa runyorwa panzvimbo". Aya mabasa anoita zvakasiyana-siyana zvinobuda zve data yakasefa. Musiyano wekutanga unoratidza ruzivo rwakasefa mune imwe nzvimbo mubhuku, yakafanotsanangurwa nemushandisi. Musiyano wechipiri unoratidza ruzivo rwakasefa mundiro huru. Isu tinosarudza chinhu chinodiwa. Mumuenzaniso wedu chaiwo, tinoisa cheki padivi pechinyorwa "Sefa runyorwa panzvimbo." Ngatienderere mberi kune nhanho inotevera.

6. Mumutsara we "List range" unofanirwa kuisa kero yeplate pamwe chete nemisoro. Pane nzira mbiri dzekushandisa iyi nzira iri nyore. Nzira yekutanga ndeyekunyora zvinorongeka zveplate uchishandisa keyboard. Chechipiri - mushure mekudzvanya pane icon padivi pemutsara wekupinda muyero, unofanirwa kusarudza ndiro nekubata pasi bhatani rekuruboshwe. Mumutsara we "Range of conditions" nenzira yakafanana, tinotyaira mukero yeplate yakawedzerwa pamwe chete nemisoro uye mitsetse ine mamiriro. Dzvanya pakanzi "OK" kuratidza shanduko dzakaitwa.

Zvinokosha! Paunenge uchisarudza, chenjerera kuti usasanganise chero masero asina chinhu munzvimbo yakasarudzwa. Kana sero isina chinhu ichiwira munzvimbo yekusarudza, ipapo nzira yekusefa haizoitwe. Pane chikanganiso chichaitika.

7. Pakupera kwekuita, ruzivo chete rwatinoda ruchasara mundiro huru.

8. Ngatidzoke nhanho shoma. Kana mushandisi akasarudza "Copy results kune imwe nzvimbo" sarudzo, ipapo chiratidzo chekupedzisira chicharatidzwa munzvimbo yakataurwa naye, uye ndiro huru haizoshanduki nenzira ipi zvayo. Mumutsara "Nzvimbo inoguma muhuwandu" iwe uchada kutyaira mukero yenzvimbo iyo mhedzisiro icharatidzwa. Pano iwe unogona kupinda mundima imwe chete, iyo pakupedzisira inozova mavambo endiro itsva yekuwedzera. Mune yedu chaiyo muenzaniso, iyi ndiyo sero ine kero A42.

9. Nekudzvanya pakanzi "Zvakanaka", imwe nyowani yekuwedzera ndiro ine yakatsanangurwa kusefa marongero ichaiswa muchitokisi A42 uye yakatambanudzirwa kunzvimbo iri padyo.

Kanzura kusefa kwepamusoro muExcel

Pane nzira mbiri dzekukanzura kusefa kwepamusoro. Ngatitarisei nzira imwe neimwe zvakadzama. Nzira yekutanga kudarika kusefa kwepamusoro:

1. Tinotamira kune chikamu chinonzi "Kumba".
2. Isu tinowana block yemirairo "Sefa".
3. Dzvanya bhatani "Clear".

Yechipiri nzira, iyo inodzima kusefa kwepamberi:

1. Tinotamira kune chikamu chinonzi "Kumba".
2. Dzvanya bhatani rekuruboshwe rembeva pane chinhu "Editing"
3. Padanho rinotevera, tinovhura runyoro rudiki rwe "Sort and Filter".
4. Mune menyu yemukati inooneka, tinya LMB pane chinhu chinonzi "Bvisa".

Zvinokosha! Kana imwe yekuwedzera ine kusefa kwepamberi iri munzvimbo nyowani, saka maitiro anoitwa kuburikidza ne "Yakachena" chinhu haabatsire. Zvese manipulations zvinoda kuitwa nemaoko.

Mhedziso uye mhedziso nezve advanced filter maitiro

Muchinyorwa ichi, takaongorora mumatanho akati wandei nzira dzekushandisa iyo yepamusoro ruzivo sefa muExcel spreadsheet edhita. Kuti uite iyi nzira iri nyore, ingori nyowani yekuwedzera ndiro inodiwa, umo mafirita mamiriro achave aripo. Hongu, nzira iyi yakanyanya kuoma kushandisa pane kusefa yakajairwa, asi inoshandisa panguva imwe chete kusefa pane akati wandei. Iyi nzira inokubvumira kukurumidza uye kushanda nesimba nehuwandu hwemashoko etabular.