Emva kokwenza iDesika yePivot, unokufumanisa ukuba ayikho kwindawo echanekileyo okanye unganqwenela ukuyidlulisela kwiphepha lomsebenzi elahlukileyo. Unokufumana ngaphantsi kwamanyathelo okuqhuba iDesika yePivot kwi-Excel.
Dlulisa iDesika yePivot kwi-Excel
Njengoko unokubona kumfanekiso ongezantsi, iDesika yePivot isukela kumqolo wesi-8 (iCell A8) eneMiqolo engenanto engenanto kwiprime. Lo mngeni unokulungiswa ngokulula ngokutshintshela iDesika yePivot kwiCell A2.
Ngokulinganayo, unokuza kuyo yonke imfuneko yokutshintshela iDesika yePivot kwiPhepha lomsebenzi elitsha kraca ngaphakathi kweNcwadi yoMsebenzi efanayo okanye kwiPhepha lokusebenzela eNtsha kwenye iNcwadi yoMsebenzi.
Yonke le misebenzi inokufezekiswa ngokulula ngokusebenzisa iTransfer PivotTable command njengoko ifumaneka kwiMicrosoft Excel.
1. Dlulisa iDesika yePivot Ngaphakathi kwePhepha loMsebenzi elifanayo
Jonga amanyathelo angezantsi ukuhambisa iDesika yePivot kwindawo eyahlukileyo kwiphepha lomsebenzi elifanayo.
1.1. Cofa naphi na apho kwi Idesika yePivot.
1.2. Emva koko, cofa iqhosha Cubungula isithuba phakathi kwebar yemenyu ephambili kwaye ucofe Dlulisa iPivotTable kunokwenzeka.
1.3. Kwi-Transfer PivotTable dialogue field, cofa ngaphakathi kwi Indawo umhlaba emva koko nqakraza kwi Indawo entsha indawo onqwenela ukuyidlulisela iPivot Desk kwaye ucofe kuyo OK.
Kulo mzekelo ungasentla, sicofe kwiCell A2 ukuze sitshintshele iDesika yePivot kule ndawo.
2. Dlulisela iDesika yePivot kwiNtsha okanye kwelinye elinye iPhepha lokuSebenza
Rhoqo kunokungabikho, unokuza kuyo yonke imfuneko yokutshintshela iDesika yePivot kwiPhepha loMsebenzi elitsha. Ngale ndlela iPivot Desk iyakutshata kwiphepha layo lokusebenza elahlukileyo.
2.1. Cofa naphi na apho kwi Idesika yePivot.
2.2. Emva koko, cofa iqhosha Cubungula isithuba phakathi kwebar yemenyu ephambili emva kokuba ucofe kuyo Dlulisa iPivotTable kunokwenzeka.
Qaphela: Utshintshelo lwePivotTable enokwenzeka nayo isenokuba phantsi kwePivotTable Choices Tab.
2.3. Kwi-Transfer PivotTable dialog dialog, khetha Iphepha Lokusebenzela elitsha kunokwenzeka kwaye ucofe ku OK.
I-Excel iya kuvula ngerobhothi icwecwe elitsha lomsebenzi kwaye iDesika yePivot mhlawumbi iya kusiwa kwiPhepha loMsebenzi elitsha.
3. Ukutshintshela iDesika yePivot kwenye iNcwadi yoMsebenzi enye
Kusenokungabikho nto inokwenzeka kwi-Excel yokuqhuba iDesika yePivot kwincwadi yomsebenzi eyahlukileyo. Nangona kunjalo, iyakwazi ukuphinda iDesika yePivot kwaye uyincamathisele kwenye incwadi yomsebenzi.
3.1. Cofa naphi na apho kwi Idesika yePivot.
3.2. Emva koko, cofa iqhosha Cubungula ithebhu ebekwe kwibar yemenyu ephambili> cofa kwi khetha emva koko cofa kwi Iyonke iPivotTable kunokwenzeka kwimenyu eyehlayo.
Qaphela: Amathuba kukuba uya kufumana iTransfer PivotTable enokwenzeka ekhoyo ngaphantsi Ukhetho lwePivotTable Isithuba.
3.3. Nje ukuba iDesika yePivot ikhethiwe, cofa ekunene kuyo kwaye ucofe kuyo ikopi kunokwenzeka.
3.4. Ngoku yiya kwelinye icala Incwadi yomsebenzi > cofa ekunene kwiseli apho ufuna iDesika yePivot ukuqala emva koko ucofe kuyo Ncamathelisa yaBucala inokwenzeka ngaphakathi kwemenyu ebonakala ngathi.
3.5. Kwi- Cola ngokukodwa isikrini sokubonisa, qinisekisa ukuba "Konke" kukhethiwe kwaye ucofe ku- OK.
Uzakubona ngoko nangoko iDesika yePivot incamatheliswa kwiNcwadi yoMsebenzi eNtsha. Idesika yePivot encamathisiweyo kufuneka igcine uninzi lwefomathi yayo kwaye ungafuneka kuphela ukuba ulawule ububanzi bekholamu.
- Iindlela ezilula zokutshintsha uBonelelo loLwazi lweDesika yePivot kwaye iyahluka
- Iindlela ezilula zokongeza okanye ukuThatha iitotali ezingaphantsi kwidesika yePivot
Igama lam nguJavier Chirinos kwaye ndiyayithanda itekhnoloji. Ebudeni bexesha endikhumbula ngalo, ndandizithanda iikhompyutha nemidlalo yevidiyo yaye loo ndlela yokuzonwabisa yaphelela ekubeni ndifumane umsebenzi.
Bendipapasha malunga netekhnoloji kunye nezixhobo kwi-Intanethi ngaphezulu kweminyaka eyi-15, ngakumbi kwi mundobytes.com
Ndikwayingcali yonxibelelwano lwe-intanethi kunye nokuthengisa kwaye ndinolwazi lophuhliso lwe-WordPress.