Kamar yadda a cikin "Eksele" yi tebur kumshin irin

Takaitacciyar alluna ne m nuni da bayanai da cewa ba masu amfani don bincika kungiyoyin da ya fi girma yawa na data a dunkule, tabular form don sauki rahoto da kuma bincike. Daya amfani da wannan aikin a Excel ne cewa shi ba ka damar shirya, boye da kuma nuna daban-daban Categories a guda fayil don samar da wani m view na bayanai. A cikin wannan labarin za ka iya karanta umarnin game da yadda za "Eksele" yin tebur.

Mataki na 1 na 3: harhadawa daga karce

Fara Microsoft Excel.

Click a kan menu abu "Data" sannan kuma zaɓin da summary tebur (note: a versions na Excel 2007/2010, yi "Saka"> summary tebur).

Saka samu data cewa ku yi nufin magana take. Idan wannan bayani ne a Excel jerin cewa shi ne a halin yanzu bude, da software ta atomatik zaban kewayon Kwayoyin. Danna "Next".

Tabbatar cewa wani zaɓi "New jerin" da aka zaba bayan danna kan "Next" daga baya mataki. Da zarar ka yi cewa, danna "Gama".

Mataki 2 na 3: Yadda za a ƙirƙiri tebur a "Eksele"

Idan ya cancanta, daidaita cikin kewayon a cikin rubutu akwatin. Wadannan halaye an located a karkashin menu abu "Zaži tebur." Idan tushen bayanai ga tebur ne da wani waje, halitta a raba shirin (misali, Access), danna "Yi amfani da external data kafofin." Bayan haka, sami menu abu "Zaži Connection" sai kuma ka danna a kan maganganu akwatin mai taken "Data kasance Connections".

Make da zabi na wuri don ƙirƙirar da PivotTable. By tsoho, Excel yanayin halitta shi a matsayin sabon page da za a kara wa littafin. Magana game da yadda za "Eksele" yi tebur saboda haka ya bayyana a kan wani ba sheet, kana bukatar ka danna a kan selection "Data kasance List" button, sa'an nan saka da wuri na farko cell a cikin rubutu akwatin "Location".

Danna "Ok". Sa'an nan, ƙara wani sabon blank Grid ga PivotTable, sa'an nan bukatar nuna aiki ayyuka "Field List PivotTable." Wannan panel ne zuwa kashi biyu sassa.

Bude menu abu 'Zabi filayen don ƙara zuwa ga rahoton "da kuma cika a duk sunayen da filayen cikin tushen bayanan.

cika

Kamar yadda a cikin "Eksele" yin tebur? Ci gaba da gudanar da wani da umarnin, ya kamata ka sa a akwatin a kan allo, zuwa kashi hudu aikin yankunan, abin da ya kamata saka da tace, shafi tasirin, Lines da dabi'u.

Sanya filin a cikin aiki "PivotTable Field List" a sassa daban-daban. Ja filin sunan menu abu 'Zabi filayen don ƙara zuwa ga rahoton "a kowane na hudu zones.

Make sabawa kamar yadda dole sai ka gan ka manufa sakamakon.

Mataki na 3 na 3: Fahimtar asali sharuddan, ko yadda za a yi a tebur a cikin "Eksele" sauki

Da farko kokarin fahimtar key ma'anar. Akwai da dama sharuddan da za su iya, a duban farko, ze m.

Mene ne wani tace? Wannan yankin ya ƙunshi filayen don neman bayani a kayyade a cikin summary tebur, ta hanyar tace su ta wani alama. Sun zama alamomi na rahoton. Alal misali, idan ka saita "Shekara" kamar yadda tace, za ka iya nuna summary data a tebur ga wasu lokaci na lokaci ko ga duk shekaru.

ginshikan sa hannu - wannan yanki yana da wani filin fassara da wuri daga data kayyade a cikin summary tebur ginshikan.

Sa hannu layuka - ya ce yankin hada da wani filin fassara da wuri daga data kunshe a cikin layi.

Filayen dauke da dabi'u cewa saka abin data ake wakilta a cikin sel da PivotTable. A wasu kalmomin, shi ne bayanin da aka takaita a cikin makon shafi (harhada by default).

Field daga tushen bayanan da ka sanya wani page (ko tace) da aka nuna a cikin PivotTable rahoton.

Fahimtar sama dabi'u, kazalika da wasu sauran saituna zai ba ka damar fi gane yadda za a "Eksele" yin tebur. Ka tuna cewa daban-daban versions na shirin, wasu menu abubuwa iya bambanta.