Indlela yokukopa idatha yePivot Table kwi-Excel Worksheet
Iitafile zePivot ziyinxalenye enamandla kwi-Excel. Bafaka amandla oguquguqukayo kunye nohlalutyo esandleni sakho. Usebenzisa iitafile zepivot ukuze ukhiphe ulwazi oluvela kwiithebula ezinkulu zeedatha ngaphandle kokusebenzisa ifomula.
Eli nqaku liquka imiyalelo yokukopisha idatha yesampulu iboniswe ngezantsi kwiphepha lokusebenzela lase Excel. Idata ihamba neNyathelo ngeSigaba se-Excel Pivot Table Tutorial .
Indlela yokukopa itekisi yeTutorial
Ngaphambi kokuba uqale uqeqesho, landela le nyathelo ukukopisha idatha yesampuli kwifayile yakho ye-Excel:
- Khankanya idatha kwitafile engezantsi. Qiniseka ukuba ukhethe kwisihloko esithi "Cookie Sales by Region" ukuya kwinani "$ 69,496" phantsi kwetafile.
- Khetha Hlela > Kopisha kwimenyu kwisiphequluli sakho sewebhu.
- Cofa kwifowuni A1 kwiphepha lokusebenzela elingaxelwanga kwi-Excel ukuze lenze iseli elisebenzayo .
- Cofa kwiTebhu yeKhaya .
- Cofa kwinqolo engezantsi kwinqanaba lokunamathisela kwi- Ribbon ukuvula imenyu ehlayo.
- Khetha i- Paste ekhethekileyo kwimenyu ukuvula ibhokisi yencoko yebhokisi ekhethekileyo.
- Khetha Umxhasi kunye Nombhalo ukusuka kwiinketho kwibhokisi yencoko.
Icandelo ngalinye leenkcukacha lifakwe kwisisele esahlukileyo kwiphepha lokusebenzela. Idata kufuneka izalise udidi lwe-A1 ukuya kwi-D12.
Idatha yeSinyathelo ngeSiteli Excel Pivot Table Tutoria l
| Cookie Ukuthengisa ngeNgingqi | |||
| Ummeli zintengiso | Ummandla | # Imiyalelo | Intengiso Iyonke |
| Yilwayo | Bucala ngasekunene | 217 | $ 41,107 |
| UFrank | Bucala ngasekunene | 268 | $ 72,707 |
| UHarry | Mantla | 224 | $ 41,676 |
| UJanet | Mantla | 286 | $ 87,858 |
| Joe | Mazantsi | 226 | $ 45,606 |
| UMarta | Bucala ngasekhohlo | 228 | $ 49,017 |
| Mariya | Bucala ngasekunene | 234 | $ 57,967 |
| Ralph | Bucala ngasekhohlo | 267 | $ 70,702 |
| Sam | Bucala ngasekhohlo | 279 | $ 77,738 |
| Tom | Mazantsi | 261 | $ 69,496 |
Ngoku ulungele ukusebenza ngePivot Table Tutorial .