Amathebula wePivot ku-Excel. Ngalokhu okuthunyelwe uzofunda ukwakha nokulungisa amatafula ashukumisayo kalula okukhulu, qhubeka ufunda futhi uthole izinyathelo.
Amathebula we-Pivot Excel.
Ukuze ufunde ukwenza Amathebula Amandla ku Excel?
Isitayela samagridi e-Excel, ngokukhululeka okukhulu kuvumela ukonga nokuhlela imininingwane eminingi, lesi sitayela sibizwa nge- "Database". Lapho umuntu angasebenza ngamathuba angenamkhawulo wokwenza imisebenzi yezinombolo yanoma yiluphi uhlobo.
Abantu abaningi abazi ukuthi basebenzise kanjani amathuluzi anikezwa i-Excel kahle, lapha vidabytesPlay Sikukhombisa ukuthi ngisho "namatafula anzima we-pivot" kanjani.
Ngabe ulakha kalula kanjani ithebula le-pivot ku-Excel?
Ukuyakha, kufanele siqale sicacelwe ukuthi iyini: isebenza njengomhleli wemininingwane ngendlela efingqiwe ngaphandle kokulahlekelwa imininingwane ebalulekile.
Ukwenza, uchungechunge lwedatha eliqoqiwe kufanele luqoqwe, umqondo ukuthi akwenziwa nganoma iyiphi indlela, ngoba le nqubo ihamba igxathu negxathu.
Ukwenza isibonelo ngomqondo wokuthi iyi- Ithebula le-pivot le-Excel, Ungakha ithebhulethi ngokulungiselela kanye nedatha yothisha wesikole sabaqalayo phakathi namasonto athile.
Izinsuku abenikeza ngazo amakilasi, izihloko, imisebenzi agcine eyithumele futhi nakanjani nemisebenzi ayenza ekilasini izocaciswa.
Ukwazi amatafula we-pivot Excel
Kufanele ucabange ukuthi ukwazi ngokwehlukile kwimisebenzi oyithumele ngemuva kwemisebenzi emibili. Njengoba singabona nezikhathi lapho umuntu atshale khona ukuphelelwa isikhathi okukhulu ezikhathini zemfundo.
Ukucinga imininingwane eshiwo ngenhla, kufanele sicindezele noma iyiphi indawo yetafula noma yespredishithi. Ohlangothini olungaphezulu kwesokudla sephaneli le-Excel, kufanele sichofoze ku- «Design» kanye no- «Fingqa ngetafula le-pivot».
Ngokushesha uhlelo lusibuza umbuzo: Ufuna ukubeka kuphi lelo tafula ?; Sichofoza ku- "Yamukela", eqhubeka nokwenziwa kwelinye ishidi le-Excel.
Kakade kushidi lethu elisha, imvamisa ngeke sabona lutho, kepha konke kumhlophe, njengasesibonelweni esilandelayo. Kungabonakala njengokuyinkimbinkimbi, noma kunjalo, kulula kakhulu.
Kumele sibheke ukhiye wetafula elinamandla, lokhu kubheke ezansi, ngakwesokudla, lapho ithi khona "Izihlungi, amakholomu, imigqa namanani".
Manje ngalowo mzuzu, ngegundane sihudula izinkambu esizibona engxenyeni engenhla (lezo ezithi, usuku, isihloko, imisebenzi nemisebenzi); lokhu ukufundisa esifuna ukukubona etafuleni. Manje siqhubeka nesibonelo esilula. Yimuphi umsebenzi obuyiyo obandakanya imisebenzi eminingi?
Endaweni engenhla ungabona itafula elinamandla elithi "Umsebenzi" emigqeni kanye namanani "Wezilinganiso zomsebenzi". Endaweni lapho kuboniswe khona unxantathu ngomugqa obomvu, sicindezela ukukhetha isilinganiso.
Lapho sikhetha, sifaka "Ukulungiswa Kwenkambu Yenani". Kule menyu singakhetha phakathi kwezibalo, ama-akhawunti, ubuncane, ama-maximum noma abanye. Uma ubheka ngakwesobunxele uzobona ukulula kwetafula le-pivot.
Ukudalwa kwamathebula e-Excel Pivot anobukhulu obuhlukahlukene!
Ngesikhathi sesampula lesibonelo esedlule sikwazile ukubona ukuthi singawahlanganisa kanjani amasimu etafuleni le-pivot, ukwakha ukuhlanganiswa esikudingayo.
Izinyathelo ezimbalwa kuphela sikwazile ukubona inani elijwayelekile lemisebenzi yomsebenzi ngamunye owenziwayo. Ukucaca ngosuku olwafundiswa ngalo amakilasi, kufanele nje sengeze umsebenzi othi "SEM Day".
Ezibonelweni ezinikeziwe, umsebenzi uhlanganisiwe wabhekisa kumakholamu ukuze kube lula ukubona, okungukuthi, okuncane kwalokhu kunezinsuku okubonwayo. Ngendlela efanayo, isikhathi siyakhethwa esikhundleni semisebenzi, ngoba lokhu kufundisa imininingwane engcono.
Kumele sazi ukuthi, ukuze sibe netafula le-pivot eli-odiwe, kufanele sicabangele ukuthi iyiphi idatha enhle kakhulu esingayibonisa, ngoba ezinye izindlela zokuhlanganisa idatha yethu zingasidida noma zingakhombisi isifinyezo esihle. Angiqondi itafula lami le-pivot?
Ukuqonda ithebula le-pivot
Lapho senza isibonelo, siyabona ukuthi ophuzi yisilinganiso semizuzu uthisha ayitshale ekilasini. Embala oluhlaza, njengombala ophuzi, singabona idatha yomsebenzi ngokulandelana kwayo.
Okumpunga, ngakwesokunene, uzobona izilinganiso zansuku zonke ezihlanganiswe nemisebenzi emibili ethile. Ekugcineni, ngombala oluhlaza okwesibhakabhaka ungabona ukuthi imizuzu emaphakathi yemisebenzi ingaba yiphi ngokwehlukana, kepha ukuhlanganisa izinsuku.
Umugqa ngamunye unemininingwane eqondile, ngokuyihlola kaningana bese uyifunda, uzoqonda kalula okuboniswa kuyo. Okuhle kunakho konke, ukuthi ezinye izinto mayelana namaphethini ekilasi zingatholwa ngokuphelele kule nqubo.
Amatafula e-pivot angelinye lalawo mathuluzi enza umsebenzi ube lula noma ukuhleleka ngisho nasekhaya, izinto zokuzilibazisa nokunye, ezinye izibonelo zingaba Yimaphi amakhasimende athembeke kakhulu? Yimuphi umkhiqizo onenzuzo ephezulu kakhulu? Ingabe ibhizinisi lami lisesikhathini?
Lawa matafula asebenza nakwezinye izindawo ezifana nomsebenzi wasendlini.Izinsuku zokuhlanza? Izinsizakalo kufanele zikhokhwe nini? Ngisho noku-oda imindeni emikhulu.
Konke lokhu kunganqunywa ngokwakha itafula le-Excel, lapho imininingwane ezoba yisakhiwo sokuthi ngemuva kokuqoqa imininingwane, izosikhombisa imigqa ethile lapho uzokwazi khona ukuhlola ukuthi yini ewusizo ebhizinisini lakho, emsebenzini nakwabanye.
Mhlawumbe yonke imisebenzi yehlukile kepha ukusetshenziswa kwamatafula ashukumisayo kuyo, aguqulelwe izidingo zomsebenzi ngamunye, angathuthuka ngezinga elikhulu zonke lezi zinzuzo ezinkulu ukuze inkampani isebenze kahle, kusukela kuhlelo oluzuzisa njenge-Excel.
Ungumlandeli wekhompyutha futhi ufuna ukwazi izindaba? Sikumema ngomusa ukuba ufunde I-Cloud Computing: Izinzuzo nezinkinga yaleyo ndawo engabonakali futhi eqhelile enikezela ngezinsizakalo zedijithali nge-Intanethi.