Umhlahlandlela Osheshayo Wokukopisha idatha yePivot Table ku-Excel

Indlela Yokukopisha Idatha YePivot Table ku-Excel Worksheet

Amatafula we-Pivot ayisici esinamandla ku-Excel. Bafaka amandla okuguquguquka nokuhlaziya ezandleni zakho. Usebenzisa amatafula we-pivot ukuze ukhiphe ulwazi kusuka kumatafula amakhulu wedatha ngaphandle kokusebenzisa amafomula.

Lesi sihloko sihlanganisa imiyalo yokukopisha idatha yesampula eboniswe ngezansi kwipheshethi lokusebenzela le-Excel. Idatha ihambisana nesinyathelo ngesinyathelo sokufundisa se-Excel Pivot Table .

Indlela Yokukopisha Umbhalo Wokufundisa

Ngaphambi kokuba uqale isifundo, landela lezi zinyathelo ukukopisha idatha yesampula efayeleni lakho le-Excel:

1. Qinisekisa idatha etafuleni elingezansi. Qinisekisa ukuthi ukhethe esihlokweni esithi "Ukuthengisa kwe-cookie ngesiFunda" kuya kwinombolo "$ 69,496" phansi kwetafula.
2. Khetha Hlela > Kopisha kusuka kwimenyu kusiphequluli sakho sewebhu.
3. Chofoza kuseli le- A1 kusikripthi se-Excel esingavumelekile ukwenza iseli elisebenzayo .
4. Chofoza kuthebhu yasekhaya .
5. Chofoza umcibisholo ophansi eceleni kweBhodi yokunamathisela kwi- Ribbon ukuvula imenyu ehlayo.
6. Khetha Namathisela Okukhethekile kusuka kwimenyu ukuvula ibhokisi lokubhalela elikhethekile lokunamathisela .
7. Khetha Ukunamathisela Nombhalo kusuka kokukhethwa kukho ebhokisini lengxoxo.

Uhlu ngalunye lwedatha lufakwe esitokisini esithile kuphepha lokusebenzela. Idatha kufanele igcwalise uhla lwe-A1 kuya ku-D12.

Idatha yesinyathelo ngesinyathelo Excel Pivot Table Tutoria l

Manje usulungele ukusebenza nge- Pivot Table Tutorial .