Sezvo mu "Eksele" kuti tafura ematongerwo mhando

Summary pamatafura vari vatambi kuratidzwa mashoko kuti unobvumira vanoshandisa kuongorora mapoka uye hombe uwandu mashoko ari pfupi, tabular chimiro kuti nyore nhau uye ongororo. Mumwe mukana basa iri Excel ndechokuti kunoita kuti aongorore, undovanda uye kuratidza Mapato siyana mune rimwe faira kugovera imwe maonero mashoko. Munyaya ino unogona kuverenga mirayiridzo sei kuti "Eksele" kugadzira tafura.

Step 1 of 3: Configuring kubva muvare

Tanga Microsoft Excel.

Click on Muterere chacho "Data" uye zvadaro sarudza tafura pfupiso (katsamba: mushanduro Excel 2007/2010, kuita "Insert"> pfupiso tafura).

Zvakanyatsonanga kuwana mashoko kuti unoda generalize. Kana mashoko aya ari Excel mazita kuti pari rakazaruka, usashandisa rwoga anosarudza kuwanda masero. Click "Next".

Iva nechokwadi chokuti nezvechisarudzo "zvakarongwa New" anosarudzwa pashure nekudzvanya pamusoro "Next" kubva yapfuura danho. Kamwe rawakaita kuti, baya "Finish".

Danho 2 of 3: Sei kusika tafura mu "Eksele"

Kana zvakakodzera, chinja kuwanda mundima bhokisi. unhu izvi dziri pasi Muterere chacho "Sarudza tafura." Kana mashoko nokuda tafura chinhu zvokunze, akasikwa ari oga chirongwa (somuenzaniso, Access), tinya "Shandisa kwokunze mashoko zvinyorwa." Pashure paizvozvo, kuwana Muterere chacho "Sarudza Connection" uye zvadaro tinya nhaurirano bhokisi vanoda "aivapo Connections".

Ita kusarudza nzvimbo kuti kusika PivotTable. By default, Excel nzira pave rive peji itsva inofanira kuwedzerwa kuti bhuku. Kutaura kuti "Eksele" kugadzira tafura zvokuti akazviratidza pamusoro jira wakapiwa, unofanira tinya Kusarudzwa "aivapo List" bhatani, uye ipapo kutaridzwa nzvimbo foni rokutanga chinyorwa bhokisi "Location".

Click "OK". Zvadaro, wedzera mutsva varara afoot nokuda PivotTable, uye ipapo vanofanira kuratidza basa the pane "Field List PivotTable." mapuranga iri muzvikamu zviviri.

Vhurai Muterere chinhu 'Sarudzai minda kuwedzera mashoko "uye zadza zvose mazita kumunda panobva Data.

zvekupfakira

Sezvo mu "Eksele" kugadzira tafura? Kuramba kuita mirairo, unofanira kuwana bhokisi riri chidzitiro, muzvikamu zvina basa munzvimbo, izvo zvinofanira kutaridzwa Sefa, mbiru Labels, mitsetse uye tsika.

Ipa munda mu basa "PivotTable Field List" aro siyana. Anodhonzera munda zita Muterere chinhu 'Sarudzai minda kuwedzera nomushumo "mumwe nomumwe zvikamu zvina.

Kuchinja sezvo zvakafanira kusvikira maona akanaka migumisiro yenyu.

Step 3 of 3: Kunzwisisa yepakutanga mashoko, kana kuti kuita chokudya "Eksele" nyore

Chekutanga edza kunzwisisa tsanangudzo dzinokosha. Pane mazwi akawanda kuti, pakutanga tingaona sokuti risinganyatsozivikanwi.

Chii chinonzi firita? nharaunda iyi ine minda kutsvaka ruzivo raanotaura patafura Muchidimbu, kuburikidza inonzwika apo kwavari chero chiratidzo. Vanoshanda Sezviratidzo nokuda mushumo. Somuenzaniso, kana iwe akaisa "Year" somunhu Sefa, unogona kuratidza pfupiso Data iri tafura vamwe nguva kana vose kwemakore.

mbiru siginicha - iyi ine munda nokududza nzvimbo nemashoko raanotaura pfupiso tafura pembiru.

Vakasaina misara - akati nharaunda rinosanganisira munda nokududza nzvimbo nemashoko zvaisanganisira mumutsara.

Fields ane tsika tsanangurai chii Data anomiririrwa ari mumasero PivotTable. Mune mamwe manzwi, ndiye ruzivo kuti waitsanangura mumakore mbiru (rakanyorwa nokuda default).

Field kubva kupi Data kuti kurongera peji (kana Sefa) unoratidzwa mune PivotTable mushumo.

Kunzwisisa pamusoro tsika, uyewo dzimwe zviruva kuchaita kuti tinzwisise zviri nani sei kuti "Eksele" kugadzira tafura. Yeuka kuti mushanduro dzakasiyana chepurogiramu, vamwe Muterere zvinhu zvingasiyana.