Amathebula e-Pivot awusizo ikakhulukazi ekugxiliseni ngokushesha isethi yedatha, njengokugqamisa izindawo ezithile onentshisekelo kuzo noma ukukhomba amathrendi noma amaphethini. Ngaphandle kokusebenziseka kwawo, amathebula e-pivot avame ukudala ukudideka phakathi kwabaqalayo be-Excel. Lesi sihloko sigqamisa inqubo yokudala ithebula le-pivot ngefomethi yomhlahlandlela wabaqalayo.
I-Palabras clave: I-Excel, amathebula e-pivot, umhlahlandlela wabaqalayo.
Ichaza ithebula le-pivot
Una itafula elinamandla iyithuluzi lokufingqa idatha elifakwe ku-Excel. Ivumela abasebenzisi ukuthi baqoqe futhi bafingqe idatha kuthebula elingahlelwa kabusha kalula futhi likhohliswe. Ziwusizo ekuhlaziyeni umthamo omkhulu wedatha nokuhlonza amathrendi abalulekile namaphethini.
Amathebula e-Pivot asiza inani lesikhathi esidingekayo ukuze kuhlaziywe idatha ngenxa yokuthi bethula idatha ngendlela ecacile nefushane futhi avumela izinga lokwenza ngokwezifiso ukuhlaziya idatha.
Izinyathelo okumele uzilandele ukuze udale ithebula le-pivot
Dala ithebula le-pivot phakathi Excel Akudingekile ukuba kube inqubo eyisicefe noma eyinkimbinkimbi. Eqinisweni, ngezinyathelo ezifanele, kuyinqubo elula kakhulu.
- Khetha idatha: Isinyathelo sokuqala ekudaleni ithebula le-pivot ukukhetha idatha ofuna ukuyihlaziya. Qiniseka ukuthi ukhetha lonke uhla lwedatha, njengoba i-Excel izosebenzisa lokhu kukhetha ukudala ithebula le-pivot.
- Dala ithebula le-pivot: Uma usukhethile idatha yakho, ungakha ithebula lakho le-pivot. Ukuze wenze lokhu, vakashela iribhoni ethi “Izinketho” ku-Excel bese ukhetha “Ithebula Le-Pivot.” Uzobona ibhokisi lengxoxo ekucela ukuthi uqinisekise ukukhetha kwakho nalapho ufuna ukubeka khona ithebula lakho le-pivot.
- Hlela idatha yakho: Ngemva kokudala ithebula lakho, ungakwazi ukuhlela futhi ufingqe idatha yakho nganoma iyiphi indlela oyifunayo. Ungaqoqa idatha, uhlunge idatha, futhi uguqule nokubala okusetshenziselwa ukufingqa idatha yakho.
Ukwenza ngokwezifiso ithebula le-pivot
Esinye sezici eziwusizo kakhulu zamathebula e-pivot awo ukuguquguquka nokwenza ngokwezifiso. Ungashintsha indlela idatha ethulwa ngayo ngokwezidingo zakho ezithile.
Isibonelo, uma uhlaziya ukuthengisa kwaminyaka yonke, ungakhetha ukubonisa ukuthengisa okufinyeziwe ngenyanga, ikota, noma unyaka. Ungakwazi futhi ukulungisa idatha ukuze ubonise ushintsho lwephesenti ukusuka enkathini eyodwa ukuya kwelandelayo, okungaba usizo ekuboniseni ukukhula noma ukwehla kokuthengisa.
Amathebula e-Pivot nawo akuvumela ukuthi uhlanganise imithombo yedatha eminingi. Uma uhlaziya idatha yokuthengisa futhi unedatha evela ezitolo eziningi noma izigaba, ungakwazi ukuhlanganisa yonke le datha kuthebula le-pivot elilodwa.
Ukuthuthukisa i-PivotTable enamashadi
Imvamisa amagrafu nokubonwayo Angaba usizo kakhulu lapho wethula idatha kuthebula le-pivot. Njengamathebula, amashadi ku-Excel enziwa ngendlela oyifisayo kakhulu futhi angalungiselelwa ukubonisa ulwazi ngendlela evumelana kangcono nezidingo zakho.
Ungakhetha ukusebenzisa ishadi lebha, ishadi lomugqa, ishadi likaphayi, noma i-scatter chart, kuye ngohlobo lwedatha yakho kanye nalokho ozama ukuxhumana nakho.
Ukuthuthukisa ukusebenza kahle ngamathebula e-pivot
Okokugcina, enye yezinto ezinhle kakhulu ngamathebula e-pivot ukuthi angasiza ngcono ukusebenza kahle. Ngenxa yokuguquguquka kwawo, amathebula e-pivot anganciphisa kakhulu isikhathi esingasithatha ukuhlaziya isethi enkulu yedatha mathupha.
Njengoba ujwayela ukusebenza ngamathebula e-pivot, uzothola ukuthi ayithuluzi elinamandla futhi eliguquguqukayo elizokuvumela ukuthi uphathe futhi uhlaziye idatha ngokuyimpumelelo. Uma usuqonda ukuthi amathebula e-pivot asebenza kanjani, uzowathola eyithuluzi elibalulekile ekuhlaziyeni kwakho idatha ye-Excel.
