Funda ukuthi ungasusa kanjani ithebula le-pivot ku-Excel

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 ngendlela efanele ispredishithi nge-Pivoting Desktop bese uchofoza ku- Susa kumenyu yokuchofoza kwesokudla evelayo.

Enye indlela yokususa ithebula le-pivot ku-Excel ukukhetha noma iyiphi Iseli ehhovisi le-Pivot kanye nokusetshenziswa Ukuphatha + A Isinqamuleli sekhibhodi.

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 yikuphi Iseli endlunkulu.

2. Cindezela inkinobho I-PivotTable Analysis kubha yemenyu ephezulu > chofoza Acciones > Khetha > Qedela ithebula le-pivot.

Qaphela: Ithebhu yokuhlaziya ye-PivotTable ivela kuphela uma ukhetha iseli kuthebula le-pivot.

3. Lapho nje i-turntable ephelele isikhethiwe, cindezela inkinobho Susa kukhibhodi yakho ephathekayo 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 yikuphi Iseli endlunkulu.

2. Cindezela inkinobho I-PivotTable Analysis kubha yemenyu ephezulu > chofoza Acciones > Khetha > Qedela ithebula le-pivot.

3. Ngokukhethiwe kwedeskithophu ye-Pivot Egcwele, chofoza kwesokudla kunoma iyiphi Iseli kusuka kuthebula le-Pivot bese uchofoza Copia.

4. Okulandelayo, chofoza kwesokudla ku-a Iseli kusipredishithi bese uchofoza inkinobho Namathisela ngasese ukukhetha.

Qaphela: Ungakwazi nokunamathisela ulwazi lwehhovisi elikhulu kusipredishithi esisha.

5. Ebhokisini elithi Namathisela Specific, khetha inketho Amanani bese uchofoza OK.

6. Njengoba ubona ngezansi, kuphela isifinyezo noma ulwazi olulandelanayo oludalwe i-Pivot Desk olunamathiselwe.

Ngemva kokunamathisela ulwazi lwethebula le-pivot, ungasusa ithebula le-pivot ngokuphinda izinyathelo zokukhetha ithebula le-pivot eligcwele neliphuthumayo. Susa inkinobho.

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 yikuphi Iseli endlunkulu.

2. Cindezela inkinobho I-PivotTable Analysis kubha yemenyu ephezulu > chofoza Acciones > Susa > Borrar todo.

3. Lokhu kungasula ngokuphelele ulwazi oludalwe i-Pivot Desktop futhi uzosala ne-Pivot 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