Ngemuva kokuthi udale Ithebula le-Pivot futhi ulisebenzise ukuze udale izifundo, cishe uzodinga ukulisusa. Ngezansi uzothola izinyathelo zokususa ithebula le-pivot ku-Excel ezimweni ezintathu ezihluke ngokuphelele.
Susa ithebula le-pivot ku-Excel
Indlela esheshayo yokususa ithebula le-pivot ku-Excel ukususa ishidi lokusebenzela eliqukethe ithebula le-pivot.
Cindezela inkinobho yespredishithi kahle nge-Pivoting Desktop bese uchofoza ku- Delete kumenyu yokuchofoza kwesokudla evelayo.
Enye indlela yokususa ithebula le-pivot ku-Excel ukukhetha noma yiliphi iseli ehhovisi le-Pivot bese usebenzisa isinqamuleli sekhibhodi i-Mand + A.
Kodwa-ke, ngayinye yalezi zinketho ikhetha kuphela amaseli abonwa ku-Pivot Desktop futhi ayikwazi ukusetshenziswa uma izihlungi zisetshenziswa ku-Pivot Desktop.
Ukwengeza, amasu angenhla awakwazi ukusetshenziswa uma ufuna ukususa i-Pivot Desktop ngenkathi ugcina isifinyezo esidalwe yi-Pivot Desktop.
Ngakho-ke, siphakamisa izinyathelo ezilandelayo: susa i-Pivot Desk ngolwazi lwakho, susa i-Pivot Desk ngenkathi uvikela ulwazi lwakho, futhi ususe imininingwane ye-Pivot Desk kuyilapho ugcina Ideski Le-Pivot.
1. Susa i-Pivoting Table kanye nolwazi lwakho
Landela lezi zinyathelo ezingezansi ukuze ususe i-Pivot Desk nalo lonke ulwazi lwayo.
1. Khetha noma yiliphi iSeli endlunkulu.
2. Chofoza inkinobho ethi Ukuhlaziywa kwe-PivotTable kubha yemenyu ephezulu > chofoza Izenzo > Khetha > I-PivotTable Egcwele.
Qaphela: Ithebhu ethi Ukuhlaziywa kwe-PivotTable ibonakala kuphela uma ukhetha iseli ku-PivotTable.
3. Uma ithebula le-pivot lonke selikhethiwe, cindezela inkinobho ethi Susa kukhibhodi ye-laptop yakho ukuze ususe ithebula le-pivot nolwazi lwalo.
2. Kopisha ulwazi lwethebula le-pivot bese ususa ithebula le-pivot
Isimo esivamile senzeka lapho udinga ukwethula kuphela isifinyezo noma ulwazi oluwumphumela olukhiqizwe i-Pivot Desk futhi awulokothi ufake i-Pivot Desk esethulweni sakho.
1. Khetha noma yiliphi iSeli endlunkulu.
2. Chofoza inkinobho ethi Ukuhlaziywa kwe-PivotTable kubha yemenyu ephezulu > chofoza Izenzo > Khetha > I-PivotTable Egcwele.
3. Uma ideskithophu ye-Full Pivot ikhethiwe, chofoza kwesokudla kunoma yiliphi iseli ku-Pivot Table bese uchofoza okuthi Kopisha.
4. Okulandelayo, chofoza kwesokudla kuseli kuspredishithi bese uchofoza inkinobho yenketho ethi Namathisela ku-Private.
Qaphela: Unganamathisela ngisho nolwazi oluvela ehhovisi elikhulu kuspredishithi esisha.
5. Ebhokisini lengxoxo ethi "Specific Paste", khetha inketho ethi "Values" bese uchofoza u- OK.
6. Njengoba ubona ngezansi, kunamathiselwe isifinyezo noma ulwazi olulandelanayo kuphela oludalwe yi-Pivot Desk.
Ngemva kokunamathisela ulwazi lwethebula le-pivot, ungasusa ithebula le-pivot ngokuphinda izinyathelo zokukhetha lonke ithebula le-pivot bese uchofoza inkinobho ethi Susa.
3. Susa ulwazi lwethebula le-pivot kodwa gcina ithebula le-pivot
Kulesi simo, uzama ukususa isifinyezo noma ulwazi oluwumphumela oludalwe i-Pivot Desktop, kuyilapho ulondoloza i-Pivot Desktop ukuze iphinde isetshenziswe.
1. Khetha noma yiliphi iSeli endlunkulu.
2. Chofoza inkinobho ethi Ukuhlaziywa kwe-PivotTable kubha yemenyu ephezulu > chofoza Izenzo > Sula > Sula Konke.
3. Lokhu kungasula ngokuphelele ulwazi oludalwe yi-Pivoting Desktop, kukushiye ne-Pivoting Desktop ehlanzekile.
Ungasebenzisa kabusha ithebula le-pivot elingenalutho ukuze wakhe omunye umbiko futhi uhlaziye ulwazi ngendlela ehlukile.
- Funda indlela yokudala ithebula le-pivot kusuka kumaspredishithi ambalwa
- Funda indlela yokwengeza noma ukususa amanani angaphansi kuthebula le-pivot
- Funda ukuthi ungashintsha kanjani ukunikezwa nokuhluka kolwazi lweDeski le-Pivot
Igama lami ngingu-Javier Chirinos futhi ngizifela ngobuchwepheshe. Kusukela kudala, ngangithanda ama-computer nemidlalo ye-video futhi leyo nto yokuzilibazisa yagcina isiwumsebenzi.
Bengilokhu ngishicilela mayelana nobuchwepheshe namagajethi ku-inthanethi iminyaka engaphezu kwe-15, ikakhulukazi ku- mundobytesPlay
Ngiphinde ngibe uchwepheshe kwezokuxhumana kanye nokumaketha ku-inthanethi futhi nginolwazi lokuthuthukiswa kwe-WordPress.