Sida "Eksele" dhigi nooca kooban miiska

shaxano koobaya waa bandhigay interactive macluumaad u ogolaanaya dadka isticmaala si ay u falanqeeyaan kooxaha iyo caddad badan oo xogta qaab la soo koobay, tabular waayo, warbixinta iyo falanqaynta fudud. Faa'iidada of this shaqo ee Excel waa in ay kuu ogolaanaya in aad edit, qarin iyo tusin qaybaha kala duwan ee file hal si ay u bixiyaan view kale ee xogta. In this article waxaad ka akhrisan kartaa tilmaamaha ku saabsan sida loo "Eksele" dhigi miis.

Tallaabada 1 of 3: configuring ka xoq

Bilow Microsoft Excel.

Riix furidda shayga "Data", ka dibna dooro miiska kooban (note: in versions of Excel 2007/2010, oofin "Insert"> miiska kooban).

Sheeg si aad u hesho xogta ah in aad doonayso in aad guud. Haddii macluumaadkan waa in liiska Excel in haatan waa uu furan, software si toos ah u doorta kala duwan ee unugyada. Riix "Next".

Hubi in doorasho "liiska New" ee la doorto ka dib markii riixaya ee "Next" ka tallaabo hore. Marka aad samayn in, guji "Finish".

Tallaabada 2 of 3: Sida loo abuuro miiska ee "Eksele"

Haddii loo baahdo, la qabsato kala duwan ee sanduuqa qoraalka. sifooyinka waxay ku yaalaan soo furidda shayga "Dooro miiska." Haddii isha macluumaadka miiska waa dibadda ah, abuuray barnaamij gaar ah (tusaale ahaan, Access), riix "Isticmaal ilo xog dibadda." Ka dib markii in, ka heli furidda shayga "Dooro Connection" ka dibna riix on sanduuqa wada hadal cinwaan looga dhigay "Connections jira".

Samee doorashada ee goobta si ay u abuuraan PivotTable ah. By default, hab Excel waxay abuurtaa sidii bog cusub in lagu daro buugga. Ka hadalka ku saabsan sida loo "Eksele" dhigi miiska si ay u muuqday on sheet la siiyo, waxaad u baahan tahay riix xulashada "List jira" button, ka dibna sheeg meesha uu gacanta ugu horeysay ee sanduuqa qoraalka "Location" ah.

Click "OK". Markaas, ku dar a Roobka cusub maran for PivotTable ah, ka dibna waxay u baahan yihiin inay muujiyaan Murayaad hawsha "Field List PivotTable." guddi Tani waxaa loo kala qaybiyaa laba qaybood.

Fur furidda shayga "Dooro beeraha in lagu daro in warbixinta" oo buuxi dhammaan magacyada beeraha xogta isha.

buuxintii

Sida "Eksele" dhigi miis? Sii si ay u fuliyaan tilmaamaha, waa inaad heshaa sanduuq shaashadda, kala qaybiyaa afar qaybood shaqada, kaas oo ay tahay sheeg filter ah, sumadaha column, khadadka iyo qiimaha.

Ka dhig beerta in hawsha "PivotTable Field List" ee qaybo kala duwan. Jiid magaca field of item menu ah 'Dooro beeraha in lagu daro in warbixinta "mid kasta oo ka mid ah afar qaybood.

Samee hagaajin markii loo baahdo ilaa aad ka aragto natiijooyinka ugu fiican.

Tallaabada 3 of 3: Fahamka shuruudaha asalka ah, ama sida loo sameeyo miis ee "Eksele" sahlan

First of dhan isku day inaad fahanto qeexidaha muhiimka ah. Waxaa jira dhawr erey oo laga yaabo in, at jaleecada hore, u muuqdaan kuwo dahsoon.

Waa maxay filter a? gobolka waxa uu ka koobanyahay beeraha si aad u raadiso wixii macluumaad ah ee ku qeexan miiska kooban, iyaga oo dabaqii by calaamad kasta. Waxay u adeegaan sida calamado warbixinta. Tusaale ahaan, haddii aad u dhigay, "Year" sida filter a, aad usoo saari karnaa xogta kooban ee miiska muddo waqti go'an ama dhammaan sano ah.

Saxiixa tiirar - arrintan leedahay beer qeexaya meesha uu xogta ku qeexan shaxda miiska kooban.

saf Saxiixyo - sheegay in Gobolka waxaa ka mid ah beer qeexaya meesha uu xogta ka mid ah line ah.

Fields ku jira qiimaha in la qeexo waxa xogta matalayo in unugyada PivotTable ah. In si kale loo dhigo, waa macluumaad ah in waxa lagu soo koobay column ee la soo dhaafay (ururiyey by default).

Field ka data isha in aad ku wareejiso bog (ama filter) waxaa soo bandhigay warbixinta PivotTable.

Understanding oo ka mid ah qiimaha kor ku xusan, iyo sidoo kale qaar ka mid ah goobaha kale ee kuu ogolaaneysaa in aad si fiican u fahmaan sida ay u "Eksele" dhigi miis. Maskaxda ku hay in versions kala duwan ee barnaamijka, alaabta menu qaar ka mid ah kala duwanaan karaan.