Mukati
Nayo pachayo, pepa reExcel ratova tafura hombe yakagadzirirwa kuchengetedza akasiyana siyana data. Pamusoro pezvo, Microsoft Excel inopa chishandiso chepamberi chinoshandura huwandu hwemasero kuita "yepamutemo" tafura, inorerutsa zvakanyanya kushanda nedata, uye inowedzera akawanda mabhenefiti. Ichi chidzidzo chinovhara izvo zvekutanga zvekushanda nemaspredishiti muExcel.
Paunenge uchiisa data papepa rekushanda, ungangoda kuifomatidza mutafura. Kana ichienzaniswa neyakajairwa fomati, matafura anogona kuvandudza chitarisiko uye manzwiro ebhuku rose, pamwe nekubatsira kuronga data uye kurerutsa magadzirirwo aro. Excel ine akati wandei maturusi uye masitayera ekukubatsira iwe nekukurumidza uye nyore kugadzira matafura. Ngatizvitarisei.
Iyo chaiyo pfungwa ye "tafura muExcel" inogona kududzirwa nenzira dzakasiyana. Vanhu vazhinji vanofunga kuti tafura iratidziro yakarongwa yemasero papepa, uye havasati vambonzwa nezve chimwe chinhu chinoshanda. Matafura anokurukurwa muchidzidzo chino dzimwe nguva anodaidzwa kuti “smart” matafura ekuita nekushanda kwawo.
Maitiro ekugadzira tafura muExcel
- Sarudza maseru aunoda kushandura kutafura. Muchiitiko chedu, isu tichasarudza huwandu hwemasero A1: D7.
- Pa Advanced tabo Home muboka rekuraira Styles press command Fomati setafura.
- Sarudza chimiro chetafura kubva pane yekudonha-pasi menyu.
- Bhokisi rebhokisi richaonekwa umo Excel inonatsa huwandu hwetafura yeramangwana.
- Kana iine misoro, isa sarudzo Tafura ine misorozvobva wadzvanya OK.
- Huwandu hwemasero huchashandurwa kuita tafura mune yakasarudzwa maitiro.
Nekumisikidza, matafura ese muExcel ane mafirita, kureva kuti Unogona kusefa kana kuronga data chero nguva uchishandisa mabhatani emiseve ari mumisoro yemisoro. Kuti uwane rumwe ruzivo nezve kuronga uye kusefa muExcel, ona Kushanda neData muExcel 2013 Tutorial.
Kuchinja matafura muExcel
Nekuwedzera tafura kune pepa rekushanda, unogona kugara uchichinja chitarisiko chayo. Excel ine maturusi akawanda ekugadzirisa matafura, kusanganisira kuwedzera mitsara kana makoramu, kuchinja maitiro, nezvimwe.
Kuwedzera mitsara nemakoramu
Kuti uwedzere imwe data patafura yeExcel, unofanirwa kushandura chiyero chayo, kureva kuwedzera mitsetse mitsva kana makoramu. Pane nzira mbiri dziri nyore kuita izvi:
- Tanga kuisa data mumutsara usina chinhu (column) yakatarisana netafura pazasi (kurudyi). Muchiitiko ichi, mutsara kana koramu ichaiswa otomatiki mutafura.
- Dhonza kona yezasi yekurudyi yetafura kuti ubatanidze mamwe mitsara kana makoramu.
Kuchinja kwemaitiro
- Sarudza chero sero mutafura.
- Wobva wavhura iyo tab Constructor uye tsvaga boka rekuraira Zvitaera zvematafura. Dzvanya pane icon Dzimwe sarudzokuona masitayera ese aripo.
- Sarudza maitiro aunoda.
- Chimiro chichashandiswa patafura.
Shandura zvirongwa
Iwe unogona kugonesa uye kudzima dzimwe sarudzo pane tab Constructorkushandura chimiro chetafura. Pane 7 zvingasarudzwa zvakazara: Mutsara Wemusoro, Mutsetse Wese, Mitsetse Yakatsetseka, Koramu Yekutanga, Koramu Yekupedzisira, Yakatsetseka Columns uye Bhatani Resefa.
- Sarudza chero sero mutafura.
- Pa Advanced tabo Constructor muboka rekuraira Tafura maitiro sarudzo tarisa kana kusaongorora sarudzo dzinodiwa. Tichagonesa sarudzo Total rowkuwedzera mutsara wose patafura.
- Tafura ichachinja. Kwatiri, mutsara mutsva wakaonekwa pazasi petafura ine fomula inoverengera otomatiki huwandu hwehuwandu mukoramu D.
Izvi zvingasarudzwa zvinogona kuchinja kuonekwa kwetafura nenzira dzakasiyana, zvose zvinoenderana nezviri mukati. Iwe ungangoda kuyedza zvishoma neizvi sarudzo kuti uwane chitarisiko chaunoda.
Kudzima tafura muExcel
Nokufamba kwenguva, kudiwa kwekuwedzera kwekushanda kwetafura kunogona kupera. Muchiitiko ichi, zvakakodzera kubvisa tafura kubva mubhuku rekushanda, uchichengetedza data yose uye mafomati zvinhu.
- Sarudza chero sero mutafura uye enda kune tab Constructor.
- Muboka rekuraira sevhisi sarudza timu Shandura kuhuwandu.
- A yekusimbisa dialog box ichaonekwa. Dzvanya Ehe .
- Tafura ichashandurwa kuita yenguva dzose, zvisinei, iyo data uye fomati ichachengetedzwa.