01 ye 05
Kuzivisa Tables Pivot muGoogle Docs
Matafura ePivot anopa simba rekuongorora dhidhiyo rakaputirwa mukati mepurogiramu yako yepasheet. Vanopa kukwanisa kuisa muchidimbu deta pasina kushandiswa kwekodhidhi yezvekodzero kana mabasa akabatanidzwa. Panzvimbo pezvo, vanopa mifananidzo yakajeka iyo inobvumira vashandisi kugadzira mhinduro dzakagadzirwa mukati mepasiteteti nekungodhonza uye kudonhedzera zvinhu zvezvinhu kumakoruwa kana mitsetse inoda. Kuti uwane mamwe mashoko pamusoro pemashandisirwo ematafura ezvinyorwa, verenga Nheyo yePivot Tables. Muchidzidzo ichi, tinoongorora nzira yekuumba tafura yepivot muGoogle Docs. Iwe unogonawo kuva nehanya nesangano redu rakafanana pamusoro pekuvaka Pivot Tables mu Microsoft Office Excel 2010 .
02 of 05
Vhura Google Docs uye Gwaro Rako Rinobudisa
Tanga nokuzarura Microsoft Excel 2010 nekufamba kune faira raunoda kushandisa patafura yako yepivot. Iyi dhiyabhorosi inofanira kunge ine minda ine chokuita nekuongorora kwako uye data yakakwana kuti upe muenzaniso wakasimba. Muchidzidzo ichi, tinoshandisa shanduro yekunyora dhigiriji yevadzidzi. Kana iwe uchida kutevera pamwe chete, unogona kuwana iyo faira uye uishandise sezvatinofamba kuburikidza nekugadzira danho retafura yepivot neshato.
03 of 05
Shandisa Pivot Yenyu
Kana wapedza kuzarura faira, sarudza Pivot Table Report kubva kuMedhi menyu. Iwe uchazobva watarira mahwindo evhavha yePivot Table, sezvaratidzwa pamusoro apa. Iwindo rinosanganisirawo Mharidzo Editor pane iyo iri kurudyi iyo inokubvumira kuti uchengetedze zviri mukati petafura yepivot.
04 of 05
Sarudza Mapuranga Nemirairo yePivot Yenyu Yepamusoro
Iwe zvino uchange uine pepa rekushanda rine tsvafura yepivot isina chinhu. Pano, iwe unofanirwa kusarudza zvikamu nemirasi yaunoda kuisa mutafura, zvichienderana nedambudziko rebhizimisi uri kuedza kugadzirisa. Mumuenzaniso uyu, tichagadzira mushumo unoratidza kubatanidzwa mune imwe dzidzo inopiwa nechikoro mumakore mashoma akapfuura.
Kuti tiite izvi, tinoshandisa Report Editor inowanikwa kurudyi rwehwindo, sezvinoratidzwa pamusoro apa. Dzvanya kuAd Add Field link pedyo nekorodhe uye zvikamu zvemaseri ewindo iri uye sarudza minda yaunoda kuisanganisira patafura yako yepivot.
Sezvaunoshandura nzvimbo yeminda, uchaona tafura yepivot ichichinja mune pepaji. Izvi zvinobatsira zvikuru, sezvo zvinokubvumira kuti uone kutaridzika kwetafura sezvo iwe uchigadzira. Kana zvisiri izvo chaizvo zvauri kuedza kuvaka, ingofambisa minda yakapoteredza uye kutarisa kuchachinja.
05 of 05
Sarudza Mutengo Wakatarira wePivot Table
Zvadaro, sarudza deta yezvinhu iwe waunoda kuishandisa sechinangwa chako. Mumuenzaniso uyu, tichasarudza sangano redzidzo. Kusarudza munda uyu muChikamu cheMagariro chigumisiro patafura yepivot inoratidzwa pamusoro - mhinduro yedu inoda!
Iwe unogonawo kusarudza kuchenesa tafura yako yepivot munzira dzakawanda. Chokutanga, unogona kugadzirisa nzira iyo masero etafura yako akaverengwa nekusvitsa museve pedyo neChirangaridzo Nechikamu cheChikamu cheZvirevo. Iwe unogona kusarudza chero humwe hwehuwandu hunotevera hunoita kuti upfupise data yako:
- Sum
- Verenga
- Nhamba Yakasiyana
- Avhareji
- Max
- Min
- Median
- Mutengo
Mukuwedzera, iwe unogona kushandisa chikamu cheMashoko Filter field kuti uwedzere mafikisi kune mushumo wako. Firimu inokubvumira kuti udzivise zvinhu zvezvinhu zvinosanganiswa mumatare ako. Somuenzaniso, iwe ungasarudza kusvina kunze kwemafundo ose akadzidziswa neumwe murayiridzi uyo akasiya chikamu. Iwe unogona kuita izvi nekugadzira firiji paInstructor munda, uye uchisarudzira mutungamiri iyeye kubva pakurongwa.