Kulesi sifundo samahhala, uzofunda:
- Ungawakha kanjani amathebula e-pivot kusuka kusizindalwazi.
- Indlela yokuhlola nokuhlaziya imininingwane yolwazi.
- Ibonisa kanjani idatha, okuhlanganisa amanani, ama-avareji, nezibalo.
- Indlela yokwethula idatha njengephesenti.
- Uyibuyekeza kanjani idatha.
- Le vidiyo isebenzisa ulimi olulula, olucacile olungaqondwa yinoma ubani.
Liyini Ithebula Le-Pivot ku-Excel?
Ithebula le-pivot iyithuluzi le-Excel (noma esinye isipredishithi) elisetshenziselwa ukuhlaziya isethi yedatha (idatha yomthombo).
Lawa mathebula aqukethe idatha engaqoqwa ngokushesha futhi kalula, uma iqhathaniswa futhi ihlanganiswe.
Isiqalo "esishintshayo" sisho ukuthi lonke ithebula libuyekezwa ngokuzenzakalelayo lapho isizindalwazi sishintsha, ngakho lihlala lisesikhathini samanje.
Ikholomu ngayinye yesizindalwazi iyingxenye yethebula le-pivot, futhi ifomula (isibalo sezibalo) kuthebula le-pivot ingasetshenziswa kumakholomu ahlanganisiwe.
Ngamanye amazwi, ithebula le-pivot yithebula lesifinyezo kusizindalwazi okulula futhi esisheshayo ukulifunda nokuhumusha ngenxa yamafomula.
Amathebula e-pivot asetshenziselwa ini?
Amathebula e-Pivot avame ukusetshenziselwa ukudala imibiko. Inzuzo enkulu yamathebula e-pivot ukuthi asindisa isikhathi esiningi. Lokhu kusho ukuthi akudingeki udale amafomula ayinkimbinkimbi noma ufihle imigqa namakholomu kusizindalwazi. Ngaleli thuluzi, ungakha ithebula ngokuchofoza okumbalwa nje.
Imininingo egciniwe emikhulu kulula ukuyiqonda nokusebenzisa.
Ngamathebula e-pivot, ungakwazi ukudala nokuhlaziya amathebula kalula futhi ulandele amathrendi ngokushintsha isikhathi kusizindalwazi (isibonelo, uma uhlaziya ukuthengiswa kwezingubo esitolo, ungabona ngokuchofoza okukodwa ukuthi yisiphi isikhathi esingcono kakhulu).
Inhloso yangempela yokusebenzisa amathebula e-pivot ukwenza izinqumo ngokushesha okukhulu. Umsebenzi wakho uwukwenza ithebula eliklanywe kahle namafomula ahlangabezana nezidingo zakho.
Amathebula e-Pivot amabhizinisi amancane naphakathi nendawo: alungele ini?
Ama-TCD avame ukusetshenziswa kulolu hlobo lwezakhiwo ezincane ngezinjongo ezilandelayo:
- Dala amashadi namadeshibhodi esibikezelo.
- Landelela futhi uhlaziye idatha yebhizinisi noma yokuthengisa ehlobene.
- Landelela isikhathi somsebenzi nomsebenzi.
- Landelela futhi uhlaziye ukuhamba kwemali.
- Phatha amaleveli e-inventory.
- Hlaziya amanani amakhulu edatha okunzima ukuyiqonda.
