Maitiro ekugadzira tafura yepivot muExcel

Excel ishanduro yakashandiswa kwazvo purogiramu. Izvo zvinodikanwa kuti uverenge kuverenga, kuongororwa kwedata, kufanotaura, kudhirowa mireza yekubhadhara, matafura uye machati, kuverenga mabasa akareruka uye akaoma uye akaoma.

Kana iwe uchibata nedata, ipapo iwe unogona kushandisa mashizha.  Microsoft Excel   isoftware yakakurumbira software, uye pane mukana wakanaka wekuti unoishandisa. Iwe unogona kuita zvakawanda neExcel; pamusoro peizvozvo, zvirevo zvakaita seExcel template zvinopa matapuro anobatsira kwazvo kuvandudza chibereko chako. Excel inopawo zvishandiso zvakawanda zvine simba. Chimwe chishandiso chakadaro chinogona kukubatsira kuongorora data Pivot tafura. Ungaita sei kugadzira tafura yepivot muExcel? Verenga kuverenga kuti uzive.

Matafura ePivot: Sumo pfupi.

Ngatitange tinzwisise kuti tafura yepivot ndeyei - chinhu chakavakirwa muMicrosoft Excel.  Itafura yepivot inomiririra   pfupiso ye data rako muExcel spreadsheet. Inopa machati anoshanda ayo anokubatsira iwe kuti unzwisise maitiro ari kumashure kwedata rako. Iwe uchazoda kugadzira mishumo zvichibva pane yako data, uye pivot tafura inoita izvi zvive nyore.

Why is it called a “Pivot table”? This is because you can  tenderedza kana kutenderera   this table using another attribute of your data. Let’s gain a deeper understanding of this.

Iwe unogona kunge uine zviuru zvemitsara muExcel spreadsheet ine akawanda maitiro kana makoramu. Iyo pivot tafura inogona kukubatsira iwe kuti uwane maonero akavakirwa pane imwe yehumwe hunhu, nepo imwe pivot tafura inogona kupa maonero kune imwe hunhu.

Kune izvi, iwe unongofanirwa kutenderedza tafura, kuibvisa pane imwe hunhu. Iwe haufanirwe kuchinja data nenzira ipi neipi, uye zvakare haufanire kuwedzera imwe ikholamu yeizvi.

Izvo zvakanakira pivot tafura.

Sei kudzidza kugadzira pivot tafura kunogona kukubatsira? Ngatifungei kuti une maspredishiti ane zviuru zvakati tambo. Iri peji rekushambadzira rinomiririra data rekutengesa yezvigadzirwa zvakasiyana uye inoronga zviuru zvekutengesa zvinotengesa.

Inotora ruzivo rwakasiyana siyana semari uye mutengo wekutengeserana kwega kwega. Iwe unoda kutsvaga kuti ndechipi chigadzirwa chinotengesa zvakanyanya uye icho chigadzirwa chinopa yakanyanya purofiti peresenti.

Pasina chishandiso chakafanana nefurasi yepivot, iwe waizoda kupfupisa mari uye mutengo wechigadzirwa chimwe nechimwe kubva kuzviuru zvekushambadzira. Pashure pezvo, iwe ungazoda kuongorora kuti ndeipi chigadzirwa chinounza mari kwazvo.

Nekubatsirwa kwematafura epivot, iwe unogona kuita izvi zvakanyanya nyore. Iyi ficha ichapfupisa nhoroondo senge mari uye mutengo nechigadzirwa. Iwe unogona kunyange kuvaratidza semaperesenti emari yakazara uye mutengo wakakwana.

Izvo  zvakanakira pivot tafura   ndeizvi:

• Iwe unogona nyore kuti uzvigadzire pamwe nekungobaya mashoma.
• Iwe unogona nyore nyore kugadzirisa pivot tafura uye sarudza chete yakakodzera mativi, ayo anoita kuti kuongororwa kwako kutariswe.
• Matafura ePivot anopfupisa data iripo mumazana emitsara uye chengetedza bhuku remanyoro.

Iwe unogona nyore nyore kuona mapatani mu data nerubatsiro rwe pivot tafura.

• Matafura ePivot anobatsira iwe kugadzira nyore kugadzira mishumo kubva kune yako data.

Chirongwa chemuenzaniso kugadzira pivot tafura.

Isu tichagadzira tafura yepivot kubva kune spreadsheet kugadzirisa dambudziko re hypothetical. Ngatitore maminetsi mashoma kuti tinzwisise dambudziko.

Iyi dzidziso inoshandisa template iyo inogona kubudiswa kubva pano. Iyo template inoshandiswa kuverengera garaji rinotengesa kutengesa uye kutengesa.

Mu Excel pepa rakanzi 'Item Rondedzero' isu tine anotevera makoramu:

• Column B: Kwete #.
• Column C: Item Code.
• Column D: Iri zita.
• Column E: Tsananguro.
• Column F: Muridzi.
• Column G: Kutanga Kutengesa Zuva.
• Column H: Mutengo Wemusika.
• Column I: Mutengo weSticker.
• Column J: Chaizvo Kutengesa Mutengo.
• Column K: Wakatengeswa Zuva.
• Column L: Kutengeswa.
• Column M: Runhare rweMutengi.

Ngatifungei kuti mutengesi akaronga kutengeswa kwegaraji anoda kuchengeta zvinhu zvakatengeswa. Mutengesi anoda kuziva huwandu hwese hwezvinhu zvese zvavari kutengesa uye huwandu hwese hwavakawana kubva pazvinhu zvakatengeswa.

Nhanho-nhanho-nhanho mirairo yekugadzira tafura yepivot paExcel.

Tora matanho anotevera:

1. Kutanga kugadzira tafura yepivot

Dzvanya INSERT menyu sarudzo, uye tinya Pivot Tafura.

2. Sarudza dha data uye nzvimbo yeiyo itsva pivot tafura.

Sarudza iyo data dhairekitori inosanganisira makoramu kubva ku data rauri kuda patafura yepivot. Iwe unofanirwa kuve nechokwadi chekuti makoramu ese ane musoro wedimbu.

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Nekutadza, Excel inokurudzirawo kuti ichagadzira pivot tafura mune mutsva yekushandira. Kana iwe uchida kugadzira iyo pivot tafura mune imwechete worksheet, saka unogona kusarudza iyo sarudzo. Muchiitiko ichocho, iwe unofanirwa kutsanangura nzvimbo.

3. Ongorora minda yeiyo pivot tafura kubva pane runyorwa.

Tarisa pane kurudyi-kurudyi pane pane iyo Excel inoratidza rondedzero yeminda. Iyo inoratidzawo nzvimbo dzaunogona kudhonza nekudonhedza munda. Nzvimbo idzi dzakatumidzwa seizvi:

• Mafirita.
• Columns.
• Mapfumo.
• Maitiro.

4. Dhonza uye udonhedze iyo yakakodzera minda kugadzira yako pivot tafura.

Mune dambudziko redu rekufungidzira, tinofanirwa kuwana huwandu hwezvinhu izvo mutengesi ane uye huwandu hwakazara kubva mukutengesa zvinhu izvi, uyezve kuti muridzi weavo zvinhu zvakatengeswa aive ani. Sezvo tiri kuongorora iyo data yezvinhu zvese, tinosarudza iyo Item Name ikhoramu semutsetse uri patafura yepivot. Isu tinodhonza gadheni iro Chinhu cheZita munzvimbo ye ROWS.

Ndedzipi tsika dzatiri kuongorora muchirongwa chemuenzaniso? Aya ndiwo mutengo unonamira, mutengo wemusika, uye chaiyo yekutengesa mutengo. Makolamu anoenderana mune dhetiet huru ndi Sticker Mutengo, Mutengo weMusika uye Chaizvoizvo Mutengo Wokutengesa, zvichiteerana. Aya ndiwo makoramu I, H uye J mune dhatabheti guru.

Iye zvino ngatiti iye mutengesi anoda kusefa iyi data kuti atarise huwandu hwavaikwereta muridzi. Ivo vanogona kugadzira firita yakafanana nekuwedzera iyo Muridzi munda munzvimbo ye Firita, sezvakaratidzwa mumufananidzo pazasi.

• Tinogona here kuwana chinhu chemitengo mumapesenti mazwi?
• Tinogona here kuwedzera 'chinhu che kodhi' munda kumitsara?

5. Tsvaga mhinduro dzinodiwa muzvikamu zvemapiritsi mune iyo pivot tafura.

Panzvimbo pekupa iyo mitengo muhuwandu, tinogona kutaura iyo chikamu chavanogadzira. Iwe zvino unofanirwa kuvamiririra semaperesenti ezvakawanda zvakaenzana. Dzvanya iyo yekudonha-pasi menyu pane Sum yeMusika Mutengo munda mune VALUES nzvimbo yeiyo dhiza-nekudonha pivot tafura anovaka.

Sarudza iyo Kukoshesa Minda Kuisa sarudzo, ndiyo yekupedzisira sarudzo mune yekudonha pasi runyorwa. Excel inoratidza maviri marudzi esarudzo pano. Iwe unogona kuona yekutanga mhando dzesarudzo pawebhu rakanzi Pfupisa Maitiro Na. Izvi zvine sarudzo senge Sum, Verenga, Avhareji, nezvimwe. Hatizoshandisa sarudzo idzi nedambudziko redu chairo.

Isu tinoshandisa yechipiri mhando sarudzo, idzo dzakanyorwa mu Ratidza Maitiro As tab. Excel inoratidza Hapana Kuverenga nekukanganisa pano.

Iye zvino, iwe unofanirwa kushandura Hapana Kuverenga kuenda ku % yeGrand Jumla kubva patafura yekudonha. Izvi zvinodaro nekuti iwe unoda kuwana huwandu hwechinhu chimwe nechimwe sepesenti yehuwandu hwakazara.

Tarisa uone nhamba gumi kuti uone mugumo we pivot tafura. Pano, tafura yepivot inoratidza mari yemhando yega yega yechinhu mumaperesenti. Mumuenzaniso uyu, 'Basketball neKobe Signature' ine mutengo wepamusika wepamusoro.

Zvino, zvakafanana, ngatitarisei mamwe mutengo sepesenti, nekusarudza '% yeGrand Jumla' yeViri Sticker Mutengo uye Chaizvo Kutengesa Mutengo.

6. Simbisa wongororo yako nekutsikisa mitsara.

Ko kana uchida kusabvisa chinhu kubva pakuongorora? Iwe unofanirwa kusefa mitsara iri patafura yepivot. Dzvanya runyorwa rwekudonha pasi padyo ne Row Labels.

Bvisa bhokisi rekutarisa rinopesana nechinhu chaunoda kusabvisa pane kuongororwa. Takabvisa Gitare mumuenzaniso uyu.

Paunongobvisa Gitare kubva pakuongororwa, iwe unogona kuona kuti chikamu chemamwe mitengo zvachinja, sezvo izvozvi huwandu hwese hwasiyana

7. Kuwedzera 'Item Code' munda kumisara yega yega.

Zvino, kuti titarise muzana remutengo wakazara nekodhi yechinhu chimwe nechimwe, ngatidhonhedze uye tidonhedze iyo 'Item Code' munda ku Rows nharaunda yekudhonza nekudonha pivot tafura anovaka. Tarisa pane yakaguma pivot tafura. Tafura inoratidza mupiro weumwe neumwe wemakodhi akasiyana echinhu kune iwo mutengo wakawandisa uyo chinhu chiri muhukuru hwakazara.

Mhedziso:

Microsoft Excel chishandiso chine simba. Zvakare, marekodhi akadai saExcel template anopa matemplate anobatsira kwazvo ayo anokubatsira iwe kuti uwane kukurumidza kwazvo. Pamusoro peiyo, Excel ine zvine simba zvakavakirwa-mukati matura senge pivot tafura yekuongororwa kwedata. Mune iri ratidziro, takagadzira tafura yepivot kubva kuExcel data uchishandisa nzira yakapfava, yenhanho-nhanho. Shandisa iyi ine simba Excel chishandiso kuti uite pfungwa yedata rako!

Snezhina Piskova

Snezhina inoshuva yekushambadzira proteinge neishuvo yeExcel. Iye mudzidzi weMedia neVaraidzo Management akapedza kudzidza, ane nhoroondo mukugadzirwa kwemafirimu uye chiitiko manejimendi. Munguva yake yakasununguka anofarira kudzidza mitauro mitsva, kufamba uye kuverenga.