Tafura dzePivot muExcel inoshandiswa pakushandura zvigadzirwa zvigadzirwa zvinoita kuti zvive nyore kubvisa ruzivo kubva kumatafura makuru e data pasina kushandiswa kwemafomu.
Matafura epivot anonyanya kushandiswa nevashandi mune izvozvo kuburikidza nekufamba, kana kuchinja, minda yedata kubva kune imwe nzvimbo kuenda kune imwe achishandisa kuruka uye kudonhedzera tinogona kutarisa dhata imwechete nenzira dzakasiyana-siyana.
Iyi tutori inosanganisira kugadzira nekushandisa tafura yepivot kuti ibvise ruzivo rwakasiyana kubva pane imwe sampuro yedata (shandisa mashoko aya kudzidzisa).
01 of 06
Pinda Pivot Table Data
Nhanho yekutanga mukugadzira tafura yepivot ndeyokuisa dhidhi mune pepaji .
Paunenge uchidaro, chengetedza pfungwa dzinotevera mupfungwa:
- Zvimwe zvitatu zvemashoko zvinodiwa kuti zvigadzire tafura yepivot.
- Zvakakosha kuisa data nenzira yakarurama. Zvikanganiso, zvichikonzerwa nekupinda kwakashata kwemadhina, ndizvo zvinokonzera matambudziko mazhinji ane chokuita nekugadzirisa deta.
- Siya mitsara isina kana mahwendefa kana uchinge waisa data. Izvi zvinosanganisira kusarega mutsara usina chinhu pakati pehurukuro yemusoro uye mutsara wekutanga wedata.
Isa data mumasero A1 kusvika kuD12 sezvinoonekwa mumufananidzo uri pamusoro.
02 of 06
Kuumba Pivot Table
- Simbisai masero A2 kusvika D12.
- Dzvanya pa Inser tab yebhoni.
Dzvanya pamusana weveve museve pasi pebato rePivot Table kuti uzarure rondedzero. - Dzvanya paPivot Table muzorongwa kuti uzarutse Padzira Pivot Table dialog box.
Nokugadzirira kusarudza dhesi yekutarisa A2 kusvika F12, Tarisi / Range rutsanga mubhokisi rebhokisi rinofanira kuzadzirwa kwatiri. - Sarudza Pepa Rokushandira riripo pane nzvimbo yefuraji yepivot.
Dzvanya paIndaneti mutsara mubhokisi rebhokisi. - Dzvanya pane cell D16 mune pepa rekushandisa kuti uise iyo seferensi iri munzvimbo inowanikwa.
Dzvanya OK.
Tafura yepivot isina ruvara inofanira kuoneka pane pepa rekushandisa nechokumusoro kwekona yekona yetafura yepivot muchitokisi D16.
Iyo Pivot Table Field List pane iyo inofanira kuzarura kuruoko rworudyi rweWexcel hwindo.
Pamusoro pePivot Table Field List pane mapepa emumunda (mutsara mutsara) kubva patafura yedu yedhadha. Nzvimbo dze data pasi pepaneti dzakabatanidzwa patafura yepivot.
03 of 06
Kuwedzera Data kuPivot Table
Cherechedza: Kuti ubatsire nemirayiridzo iyi ona muenzaniso wemufananidzo pamusoro apa.
Iwe une zvisarudzo zviviri kana zvasvika pakuwedzera data kuPivot Table:
- Dragisa mazita emunda kubva pane Pivot Table Field List pane uye uwaise paPivot Table mubasa rekushanda.
- Dragisa mazita emunda kusvika pasi pePivot Table Field List pane uye uaise pasi munzvimbo dze data.
Nzvimbo dze data munzvimbo yePivot Table Field List dzakabatanidzwa kune zvinyorwa zvinotarirwa patafura yepivot. Sezvaunowedzera mazita mazita kune nzvimbo dze data, data yako yakawedzerwa patafura yepivot.
Zvichienderana nezvedzimwe nzvimbo dzinoiswa mune imwe nzvimbo yedhara, mhinduro dzakasiyana dzinogona kuwanikwa.
Dragisa mazita emunda kune idzi data data:
- Yese Yatengeserana KuNyaya yeFirter area
- Nharaunda kusvika kunzvimbo dzeMakoromendi
- Sales Rep kuRow Labels nzvimbo
- Mirairo kune nzvimbo dzeVhu
- Kana imwe nguva yapera, Pivot Table inofanira kunge ine data yakarongeka muchirongwa chimwechete seyamuenzaniso mudanho rekutanga remudzidzi uyu.
04 of 06
Kuchengeta Pivot Table Data
Iyo Pivot Table yakagadziridza mukati-yekushandisa yekunyora iyo inogona kushandiswa kugadzirisa mhinduro inoratidzwa nePivot Table.
Kuchengetedza dambudziko kunosanganisira kushandiswa kutsvaga zvingagadziriswa kugadzirisa kuti chii chinoratidzwa nePivot Table.
- Dzvanya pamusana pemusara uri pedyo neChechi iri kutungamira muPivot Table kuti uzarure urusiro hwekuderedza pasi.
- Dzvanya pabhokisi rinotevera pedyo neKusarudza Kwose sarudzo kuti ubvise check check kubva mumabhokisi ose ari apa.
- Dzvanya pamabhokisi ekutsvaga pedyo neEast neNorth options kuti uwedzere kuongorora mabhokisi aya.
- Dzvanya OK.
- Iyo Pivot Tafura inofanira kuratidzira chete nhamba dzehurumende dzekutengesa reps dzinoshanda kumabvazuva nekuMadokero.
05 of 06
Kuchinja Pivot Table Data
Kuti uchinje zvawanikwa zvinoratidzwa nePivot Table:
- Gadzirisai tafura yepivot nekukwevera data data kubva pane imwe nzvimbo yedunhu kuenda kune imwe muPivot Table Field List pane.
- Isa sekutsvaga kuti uwane zvaunoda.
Dragisa mazita emunda kune idzi data data:
- Mirairo kuNyaya yeFuta nzvimbo
- Sales Rep kuIndaneti Mavara Mavara
- Nharaunda kusvika kuRow Labels nzvimbo
- Zvose Kuenda kune Values nzvimbo
- Dzvanya pamusana pemusara uri pedyo neChechi iri kutungamira muPivot Table kuti uzarure urusiro hwekuderedza pasi.
- Dzvanya kaviri pane bhokisi rinotarisana neChina Chese Sarudzo yokutanga kuwedzera uye kubvisa matanho okuongorora kubva mumabhokisi ose ari apa.
- Dzvanya pabhokisi riri pedyo neWest option kuti uwedzere cheki kubhokisi rino.
- Dzvanya OK.
- Iyo Pivot Tafura inofanira kunge ichiratidza kutengesa kwese kwezvinhu izvo chete zvekutengesa reps zvinoshanda kumadokero kwenharaunda.
06 of 06
Pivot Table Example
Heano muenzaniso wekuti tafura yako yepivot inogona kutarisa sei.