Iitheyibhile zepivot kwi-Excel. Ngale posi uya kufunda ukwenza kunye nokumisela iitafile ezinamandla ngokulula okukhulu, qhubeka ufunda kwaye ufumane amanyathelo.
Itafile zepivot Excel.
Ukufunda ukwenza Iifayile Amandla ku Excel?
Uhlobo lwegridi ye-Excel, ngokukhululeka okukhulu ivumela ukugcina kunye noku-odola ulwazi oluninzi, le ndlela ibizwa ngokuba yi "Database". Apho umntu anokusebenza ngamathuba angenasiphelo ukwenza imisebenzi yamanani yalo naluphi na uhlobo.
Abantu abaninzi abayazi indlela yokusebenzisa izixhobo ezinikezelwa yi-Excel kakuhle, apha vidabytes.com Sikubonisa ukuba zintoni na "iitafile zepivot ezinzima".
Uyenza njani ngokulula itafile yeepivot kwi-Excel?
Ukuyila, kufuneka kuqala sicace malunga nokuba yintoni: isebenza njengomququzeleli wolwazi ngendlela eshwankathelweyo ngaphandle kokulahla iinkcukacha ezibalulekileyo.
Ukwenza, uthotho lweenkcukacha eziqokelelweyo kufuneka ziqokelelwe, ingcinga yokuba ayenziwa nangayiphi na indlela, kuba le nkqubo ihamba inyathelo ngenyathelo.
Ukubonisa umzekelo wokuba yi Itafile zepivot ye-Excel, Unokwakha ithebhulethi ngokulungiselela kunye nedatha katitshala wesikolo saseprayimari kwiiveki ezithile.
Iintsuku awayenika ngazo iiklasi, izihloko, imisebenzi awayeyithumele ekugqibeleni kunye nemisebenzi awayeyenza kwigumbi lokufundela iya kuchazwa.
Ukwazi iitafile zepivot Excel
Kuya kufuneka ucinge ukuba ungazi ngokwahlukeneyo kwimisebenzi oyingenisileyo emva kwemisebenzi emibini. Njengokuba sinokuthi sithathe amaxesha apho umntu atyale imali enkulu ekuphelelweni kwiiseshoni zemfundo.
Ukukhangela idatha esele ikhankanyiwe, kufuneka sicinezele nayiphi na indawo yetafile okanye ispredishithi. Kwicala elingasekunene lephaneli ye-Excel, kufuneka siklikhe ku- «Uyilo» kunye «Shwankathela ngetafile yepivot».
Ngokukhawuleza le nkqubo isibuza umbuzo: Ufuna ukuyibeka phi le tafile? Cofa ku "Yamkela", eqhubeka ngokuvelisa elinye iphepha le-Excel.
Sele kwiphepha lethu elitsha, ngesiqhelo asizukubona nto, kodwa yonke into imhlophe, njengakulo mzekelo ulandelayo. Ingabonakala inzima, nangona kunjalo, kulula kakhulu.
Kuya kufuneka sijonge isitshixo setafile eguqukayo, oku kubheke ezantsi, ngasekunene, kanye apho ithi "Iifilitha, iikholamu, imiqolo kunye namaxabiso".
Ngoku ngalo mzuzu, ngemouse sirhuqa amasimi esiwaqwalaselayo kwinxalenye ephezulu (abo bathi, usuku, isihloko, imisebenzi kunye nemisebenzi); Oku kukufundisa into esifuna ukuyibona etafileni. Ngoku siqhubeka nomzekelo olula.Ngowuphi owona msebenzi ububandakanya eyona mininzi?
Kummandla ongasentla ungabona itafile eguqukayo ethi "Umsebenzi" kwimiqolo kunye namaxabiso "omndilili womsebenzi". Kwindawo apho unxantathu ubonakalisiwe ngomgca obomvu, sicinezela ukukhetha i-avareji.
Xa uyikhetha, singena "Uqwalaselo lweNdawo yeXabiso". Kule menyu sinokukhetha phakathi kwezibalo, iiakhawunti, ubuncinci, ii-maximum okanye ezinye. Ukuba ujonga ngasekhohlo uza kubona ukulula kwetafile yeepivot.
Ukudalwa kweeTafile zePivot ze-Excel ezinobungakanani obahlukeneyo!
Ngexesha lesampulu yomzekelo wangaphambili sikwazile ukubona indlela yokudibanisa amasimi kwitafile yepivot, ukwakha ubumbano oluyimfuneko.
Kuphela ngamanyathelo ambalwa sikwazile ukubona inani eliqhelekileyo lemisebenzi yomsebenzi ngamnye owenziweyo. Ukucaca malunga nosuku eklasini ezazifundiswa ngalo, kufuneka songeze kuphela umsebenzi "uSEM Day".
Kwimizekelo enikiweyo, umsebenzi uhlanganiselwe kwiikholamu ukuze kube lula ukubona, oko kukuthi, kuncinci kwezi kuneentsuku eziqwalaselweyo. Ngendlela efanayo, ixesha liyakhethwa endaweni yemisebenzi, kuba oku kufundisa ulwazi olungcono.
Kuya kufuneka sazi ukuba, ukuba netafile ye-pivot eyalelweyo, kufuneka siqwalasele ukuba yeyiphi eyona datha ilungileyo yokubonisa, kuba ezinye iindlela zokudibanisa idatha yethu zinokusidida okanye zingabonisi isishwankathelo esihle. Andiyiqondi itafile yam yeepivot?
Ukuqonda itheyibhile yepivot
Xa siqhuba umzekelo, siyaqaphela ukuba ngombala otyheli ngumndilili wemizuzu etyalwe ngutitshala eklasini. Kwimbala eluhlaza, njengakelo tyheli, sinokubona idatha yomsebenzi ngokulandelelana.
Kwingwevu, kwicala lasekunene, uya kuyibona imyinge yemihla ngemihla edityaniswe nemisebenzi emibini. Okokugqibela, ngombala oluhlaza okwesibhakabhaka unokubona ukuba yeyiphi imizuzu yemidlalo eya kuba ngokwahlukeneyo, kodwa ukudibanisa iintsuku.
Umqolo ngamnye unolwazi oluchanekileyo, ngokukhangela amatyeli aliqela kunye nokuyifunda, uya kukuqonda ngokulula ngakumbi okubonisiweyo kubo. Eyona nto ibaluleke kakhulu, ezinye izinto malunga neepateni zeklasi zinokufunyanwa ngokupheleleyo kule nkqubo.
Iitafile zepivot sesinye sezixhobo ezenza lula umsebenzi okanye iodolo nasekhaya, izinto esizithandayo nezinye, eminye imizekelo ingaba yeyiphi Abathengi abanyanisekileyo? Yeyiphi imveliso enenzuzo ephezulu? Ngaba ishishini lam lixesha lonyaka?
Ezi theyibhile zisebenza nakwezinye iindawo ezinje ngomsebenzi wasekhaya.Iintsuku zokucoca? Zifanele ukuhlawulwa nini iinkonzo?
Konke oku kungagqitywa ngokwenza iitafile ze-Excel, apho idatha iya kuba sisakhiwo esiya kuthi emva kokuqokelela ulwazi, sibonise imiqolo ethile apho uya kuba nakho ukujonga oko kuluncedo kwishishini lakho, emsebenzini nakwabanye.
Mhlawumbi yonke imisebenzi yahlukile kodwa ukusetyenziswa kweetafile ezinamandla kuzo, ezilungelelaniswe neemfuno zomsebenzi ngamnye, zinokuphucula kwizinga elikhulu zonke ezi zibonelelo zenkampani ukuze zikwazi ukusebenza kakuhle, ukusuka kwinkqubo eluncedo njenge-Excel.
Ngaba ungumlandeli wekhompyuter kwaye ufuna ukwazi iindaba? Siyakumema ukuba ufunde Cloud Computing: Izibonelelo kunye nezinto ezingalunganga yale ndawo ingabonakaliyo kunye neendawo ezikude ezibonelela ngeenkonzo zedijithali kwi-Intanethi.