Excel yave, pane zvayakanakira, chishandiso chakanakisa kugadzira maspredishiti erudzi chero rupi zvarwo, kubva kune izvo zvinotibvumidza kuita zuva nezuva-zuva accounting dhatabhesi rine chekuita nedhatabhesi, pamusoro pekutibvumidza isu kumiririra iyo data yavanosanganisira mumagrafu.
ari kudonhedza zvinyorwa uye matafura ane simba anotibvumidzwa neExcel, ndiwo maviri emabasa atinogona nawo wana zvakazara mairi, yekupedzisira iri rimwe remabasa ane simba kwazvo anopiwa nechishandiso ichi chiri mukati meHofisi 365.
Ndeapi matafura epivot
Zvichida kuti pane kanopfuura kamwe chiitiko iwe wakanzwa nezvematafura epivot, imwe ye mamwe mabasa anoshanda uye ane simba atinopihwa neExcel uye iyo inotibvumidza isu kubata yakawanda yakawanda yedhata nekukurumidza uye nyore.
Iwo matafura ane simba atinogona kugadzira neExcel, kwete chete anotibvumidza isu kuti titore iyo data kubva pamatafura, asi zvakare inotibvumidza isu bvisa dhata kubva kudhatabhesi rakagadzirwa neKupinda, Chishandiso chaMicrosoft chekugadzira dhatabhesi.
Ok, asi ndeapi matafura epivot? Pivot matafura ari mafirita atinogona kuisa kudhatabhesi uye izvo zvakare zvinotibvumidza isu kuti tiite mashoma emhedzisiro. Kana iwe uchigara uchishandisa mafirita mune ako maspredishiti, kana iwe ukashandisa pivot matafura, iwe uchaona kuti iyo nguva yaunofambidzana navo inoderedzwa.
Maitiro ekugadzira pivot matafura
Kugadzira matafura epivot, isu tinoda dhata sosi, dhata sosi inogona kunge iri pepa rekushandisa iro isu isu tinowanzoshandisa kuchengetedza iyo data. Kana tikashandisa dhatabhesi rakagadzirwa muKupinda, tinogona kuseta sosi yedata kune tafura panochengeterwa zvinyorwa zvese.
Kana iyo sosi yedhata iri chinyorwa fairaIine iyo data yakaparadzaniswa nemakoma, tinogona kugadzira kubva kune iro faira pepaiti kubva kwatinoburitsa iyo data kugadzira mapivot tafura. Kana iri mhando yefaera faira ndiyo yega sosi yemafaira yatinofanirwa kugadzira matafura ane simba, tinofanirwa kuona mukana wekukwanisa kuburitsa dhata mune imwe fomati kana kugadzira macro inozvitarisira yega kugadzira matafura ane simba nguva dzese isu tinopinza iyo data.
Kunyangwe zita rayo ringave richireva kuomarara, hapana chimwe chiri kure nechokwadi. Gadzira matafura epivot maitiro akareruka, kana isu tikatevera ese matanho atinoratidza pazasi.
Fomati dhata sosi
Kana tangova nedhatabhesi rakagadzirwa, tinofanirwa kuifomati kuitira kuti Excel kukwanisa kuziva ndiwo masero ane data uye ari iwo maseru ane mazita ezvinyorwa zvatinoda kusefa kuti tigadzire matafura ane simba.
Kuomesa tafura, chinhu chekutanga chatinofanira kuita kusarudza ese maseru ari chikamu chetafura uye tinya pane bhatani Fomati tafura iri pane Ribhoni repamba.
Tevere, marongero akasiyana anozoratidzwa, marongero ayo asingogadzirise chete aesthetics yetafura, asi udza Excel kuti ingangove data sosi. Muchikamu ichocho, hazvina basa kuti ndeipi sarudzo yatinosarudza. Kumubvunzo Iripi iyo data iri mutafura? Tinofanira kutarisa bhokisi Rondedzero ine misoro.
Nenzira iyi, tinoratidzira kuExcel kuti mutsara wekutanga wetafura unomiririra zita re data iri mutafura, kuitira kuti vagadzire matafura ane simba, ayo inotibvumidza isu kushandisa maficha maficha. Kana tangova netafura ine iyo data, uye isu takazvimisikidza nenzira kwayo, tinogona kugadzira matafura ane simba.
Gadzira matafura epivot
- Chinhu chekutanga chatinofanira kuita ndeche Sarudza tafura iripi iyo data ichave iri chikamu cheiyo tafura ine simba, kusanganisira maseru ayo anotiratidza kuti ndeapi mhando yedhata yavanosanganisira (mune yedu Manishuwa, Mushandi, Referensi, Kg).
- Tevere, tinoenda kuribhoni uye tinya pa Isa.
- Mukati Insert, tinya pa Tafura ine simba uye bhokisi rebhokisi rakatumidzwa Gadzira tafura yepivot.
- Mukati meiyi dialog bhokisi isu tinowana maviri sarudzo:
- Sarudza iyo data iwe yaunoda kuongorora. Sezvo isu tasarudza iyo tafura iyo yataida kushandisa kugadzira iyo inesimba tafura, yatove kuratidzwa yakasarudzwa pasi pezita Tafura1. Tinogona kushandura iri zita kuitira kana isu tichifunga kuwedzera mamwe matafura mune yakafanana spreadsheet.
- Sarudza kwaunoda kuisa tafura yepivot. Kana isu tisingade kusanganisa iyo sosi dhata netafura yepivot, zvinokurudzirwa kuumba pepa rekuparadzira idzva, iro ratinogona kudaidza kuti Pivot Tafura, kuti isazovhiringidzwa nejira panoratidzwa data, iro isu ratinogona kufona. Dhata.
Kana isu takaita matanho ese, mhedzisiro inofanirwa kunge yakafanana neiyo iri mumufananidzo uri pamusoro. Kana zvisiri, iwe unofanirwa kupfuura nematanho ese zvakare. Mune iyo pani kurudyi (pani iyo yatinogona kufamba kuburikidza nechishandiso kana kuisiya ichitenderera) data ratakasarudza rinoratidzwa kwatinofanira shandisa mafirita atinoda.
Ma parameter atinogona kugadzirisa anotevera:
Mafirita
Pano tinoisa (nekukweva minda iri pamusoro) iyo minda yatinoda kuratidza inoratidza huwandu kana huwandu. Muchiitiko chemuenzaniso, ini ndaisa minda Manisipari, Mushandi uye Referensi kuti ndikwanise kusarudza huwandu hwenongedzo zvatengeswa pamwe chete (Municipality, Mushandi uye Referensi) kana nemaMasipala, Vashandi kana Mareferenzi.
Mukati meMitemo, isu takasanganisira iyo pfupiso yezvese mareferenzi izvo zvatengeswa. Panyaya yemuenzaniso, 6 inomiririra huwandu hwereferenzi izvo vashandi vese vese mareferenzi ari mudhorobha re Novelda vakatengesa.
Columns
Muchikamu chino, tinofanirwa kuisa minda yese yatinoda inoratidzwa mune yekudonha-pasi fomati fomati kusarudza uye kuratidza zvese zvawanikwa zvine chekuita neicho kukosha.
Muchiitiko chemuenzaniso, isu takaisa iyo Municipality Municipality muColumns, kuti itiratidze huwandu hwenhamba yezvinongedzo izvo zvakatengeswa kumatunhu ese. Kana isu tikashandisa mafirita, ari pamusoro, tinogona kuwedzera kusefa mhedzisiro, tichimisikidza chaiyo mareferenzi akatengeswa uye ndeapi mushandi akaatengesa.
Mitsara
Chikamu cheMitsara chinotibvumidza isu kuti tione kuti ndeapi maitiro ayo inoratidzwa nemitsara uye basa racho rakafanana nemakoramu asi richichinja maitiro. Sezvo isu tichiona mumufananidzo uri pamusoro, kana uchiisa iyo Municipality munda muFiles, mhinduro dzekutsvaga dzinoratidzwa mumitsara uye kwete mumakoramu.
Values
Muchikamu chino tinofanirwa kuwedzera minda yatinoda kuti tiite show totals. Kana uchidhonza iyo Kg munda kune iyo Values chikamu, ikholamu inogadzirwa otomatiki uko iyo yakazara kg iyo yatengeswa nemadhorobha inoratidzwa, inova iyo Row firita yatakawedzera.
Muchikamu chino, isu zvakare tine Referensi Akaundi. Iyo yakagadzirirwa kuratidza iyo kuverenga kwemaguta kana zvigadzirwa. Iyo Sum yeKG munda yakagadzirirwa kuitira kuti kuratidza huwandu Kg. Kuti tishandure chiito chedu chatinoda kuita kumba mune imwe yeminda yakasimbiswa, tinofanira kudzvanya pane (i) iri kurudyi kwemunda.
Mazano anoshanda
Kana iwe wakazviita kusvika pano, iwe unogona kufunga matafura epivot inyika yakaoma kwazvo zvisina kukodzera kubata. Zvakapesana neizvozvo, kuti ungave wakaona sei muchinyorwa chino, zvese inyaya yekuyedza, kuyedza uye kuyedza kudzamara tagona kuratidza iyo data sezvatinoda kuti iratidzwe.
Kana iwe ukawedzera munda mune chikamu chausingade, iwe unofanirwa kungozvvuzvurudza kunze kwesheet uye ichabviswa. Pivot matafura anoitirwa huwandu hwakawanda hwe data, kwete yematafura e10 0 20 marekodhi. Kune aya kesi, tinogona kushandisa mafirita zvakananga.