Kule khosi yasimahla, uya kufunda:
- Uyenza njani iitafile zepivot kwisiseko sedatha.
- Indlela yokuvavanya nokuhlalutya oovimba beenkcukacha.
- Indlela yokubonisa idatha, kuquka iitotali, i-avareji, kunye nezibalo.
- Indlela yokubonisa idatha njengepesenti.
- Uyihlaziya njani idatha.
- Le vidiyo isebenzisa ulwimi olulula nolucacileyo olunokuqondwa nguye nabani na.
Yintoni iTheyibhile yePivot kwi-Excel?
Itafile yepivot yi-Excel (okanye enye i-spreadsheet) isixhobo esisetyenziselwa ukuhlalutya iseti yedatha (idatha yomthombo).
Ezi theyibhile ziqulethe idatha enokuthi ikhawuleze kwaye ihlelwe ngokulula, ithelekiswe kwaye idityaniswe.
Isimaphambili "esitshintshayo" sithetha ukuba yonke itheyibhile ihlaziywa ngokuzenzekelayo xa isiseko sedatha sitshintsha, ngoko sihlala sisexesheni.
Ikholamu nganye yesiseko sedatha yinxalenye yetafile yepivot, kunye nefomula (ukubala kwemathematika) kwitheyibhile yepivot ingasetyenziswa kwiikholamu ezidibeneyo.
Ngamanye amazwi, itafile yepivot yitheyibhile yesishwankathelo kwisiseko sedatha ekulula kwaye ngokukhawuleza ukuyifunda nokutolika enkosi kwiifomula.
Zisetyenziselwa ntoni iitafile zepivot?
Iitafile zePivot zihlala zisetyenziselwa ukwenza iingxelo. Inzuzo ephambili yeetafile zepivot kukuba zigcina ixesha elininzi. Oku kuthetha ukuba awunyanzelekanga ukuba wenze iifomula ezintsonkothileyo okanye ufihle imiqolo kunye neekholamu kuvimba weenkcukacha. Ngesi sixhobo, unokwenza itafile ngokucofa nje okumbalwa.
Oovimba beenkcukacha abakhulu ke ngoko kulula ukuziqonda nokusetyenziswa.
Ngeetafile ze-pivot, unokwenza ngokulula kwaye uhlalutye iitheyibhile kwaye ulandele izitayela ngokutshintsha ixesha kwisiseko sedatha (umzekelo, ukuba uhlalutya ukuthengiswa kwempahla kwivenkile, unokubona ngokuchofoza okukodwa ukuba yiyiphi ixesha elifanelekileyo).
Eyona njongo yokusebenzisa iitafile zepivot kukwenza izigqibo ngokukhawuleza. Umsebenzi wakho kukudala itafile eyilwe kakuhle kunye neefomula ezihlangabezana neemfuno zakho.
Iitafile zePivot zamashishini amancinci naphakathi: zilungele ntoni?
Ii-TCDs zihlala zisetyenziswa kolu hlobo lwezakhiwo ezincinci kwezi njongo zilandelayo:
- Yenza iitshathi kunye needeshibhodi zengqikelelo.
- Landelela kwaye uhlalutye ishishini okanye idatha enxulumene nentengiso.
- Landelela ixesha lomsebenzi kunye nomsebenzi.
- Landela kwaye uhlalutye ukuhamba kwemali.
- Lawula amanqanaba oluhlu.
- Hlalutya izixa ezikhulu zedatha ekunzima ukuyiqonda.
