I-Excel ayinawo amandla okulawula idatha kwiinkqubo zesiseko sedatha ezifana neSQL Server kunye ne-Microsoft Access. Into enokuyenza, nangona kunjalo, isebenza njenge-database elula okanye efayili-fayile egcwalisa iimfuno zolawulo lweenkcukacha kwiimeko ezininzi.
Kwi-Excel, idatha ihlelwe kwiibhile ezisebenzisayo usebenzisa imigqa kunye neikholomu zephepha lokusebenzela. Iinguqulelo zakutshanje zeprogram zinesici setafile , esenza kube lula ukungena, ukuhlela, nokusebenzisa idatha .
Icandelo ngalinye leenkcukacha okanye ulwazi malunga nesifundo - njengenombolo yenxalenye okanye idilesi yomntu - igcinwe kwiseli yomsebenzi ohlukeneyo kwaye ichazwe njengentsimi.
Imigaqo yedatha: Itheyibhuli, iiRekhodi kunye neeNdawo kwi-Excel
Idatha yolwazi luqokelela ulwazi oludibeneyo olugcinwe kwiifayile enye okanye ezininzi kwiikhompyutheni ezihlelekile.
Ngokuqhelekileyo ulwazi okanye idatha ihlelwe kwiibhile. Idatha elula okanye ephathekayo-fayile, njenge-Excel, inamalungelo onke malunga nesifundo esinye kwitafile enye.
Ngolunye uhlangothi, ulwalamano olunxulumene nolunye, lubandakanya inani lamatafula kunye netafile nganye equlethe ulwazi malunga nezifundo ezahlukeneyo, kodwa ezihlobene.
Ulwazi olusetafile luhlelwe ngendlela enokuba lula ukuba:
- Ukuhlaziywa
- Uhlobo
- Ukulungiswa
- Ukucoca okanye ukukhangela ulwazi oluthe ngqo
Iirekhodi
Kwigama lesigama sesigcaziso, irekhodi ligcina yonke ingcaciso okanye idatha malunga nento ethile efakwe kwisiseko sedatha.
Kwi-Excel, iirekhodi ziqhelekelelwe kumgca wephepha lomsebenzi kunye neseli nganye kumqolo oqulethe inkcazelo enye okanye ixabiso.
Fields
Inqaku ngalinye lomntu kwingxelo yedatha - njengenombolo yocingo okanye inombolo yesitalato - ibhekiselwa kuyo njengentsimi.
Kwi-Excel, iiseli ngalinye lomsebenzi wenziwe njengemida, kuba iseli nganye sinokuqulatha iqela elilodwa lenkcazelo malunga nento.
Amagama aseMasimini
Kubalulekile ukuba idatha ingeniswe ngendlela ehleliweyo kwi-database ukuze ihlelwe okanye ifakwe ukufumana ulwazi oluthe ngqo.
Ukuqinisekisa ukuba idatha efakwe kwimiyalelo efanayo kwirekhodi nganye, izihloko zongezwa kwikholamu nganye yetafile. Ezi zihloko zekholomu zibhekiswa njengamagama ensimu.
Ku-Excel, umgca ophezulu wetafile uqulethe amagama asemazantsi etafile. Lo mqolo uvame ukubhekwa njengomgca wekhloko .
Umzekelo
Kulo mfanekiso ngasentla, lonke ulwazi oluqokelelwe umfundi omnye lugcinwe kumqolo omnye okanye irekhodi kwitheyibhile. Umfundi ngamnye, kungakhathaliseki ukuba ubuncinane kangakanani okanye ulwazi oluncinane luqokelelwe njani lunomqolo ohlukileyo etafileni.
Isinye ngasinye kwisalathisi yintsimi eneenkcukacha enye. Amagama ensimi kumqolo weentloko unceda ukuqinisekisa ukuba idatha ihlala ihlelwe ngokugcina yonke idatha kwisihloko esithile, njengegama okanye ubudala, kwikholamu efanayo kubo bonke abafundi.
I-Excel's Data Tools
IMicrosoft ifakiwe iinkcukacha ezininzi zeenkcukacha ukwenzela ukuba kube lula ukusebenza kunye nemali eninzi egcinwe kwiithebula ze-Excel kwaye uncede ukuyigcina imeko efanelekileyo.
Ukusebenzisa Ifomu yamaRekhodi
Esinye sazo zixhobo ezenza kube lula ukusebenza kunye neirekodi ngamnye yifom yedatha. Ifom ingasetyenziselwa ukufumana, ukuhlela, ukungena, okanye ukucima iirekhodi kwiitheyibhile ezineenkalo ezi-32 okanye iikholomu.
Ifom yangasemva iquka uluhlu lwamagama ensimi ngokulandelelana ukuba luhlelwe etafileni, ukuqinisekisa ukuba iirekhodi zifakwe ngokuchanekileyo. Eceleni kwegama ngalinye lentsimi ibhokisi yombhalo yokungena okanye ukuhlela indawo nganye yedatha.
Nangona kunokwenzeka ukudala ifom yangokwezifiso, ukudala nokusebenzisa ifom yangasese kulula kakhulu kwaye kaninzi kukho konke okufunekayo.
Susa iiRekodi zeDatha zeDatha
Ingxaki eqhelekileyo kuyo yonke yolwazi impazamo yedatha. Ukongeza kwimpazamo yokupelisa elula okanye iindawo ezingekho phantsi kwedata, iirekhodi zeedata zingaphinda zixhalabe njengokuba itafile yedatha ikhula ngobukhulu.
Olunye lwezixhobo zedatha ye-Excel lungasetyenziselwa ukususa ezi rekhodi eziphindwe kabini- nokuba zichanekileyo okanye zikhethiweyo.
Uludwe lweDatha
Ukuhlelwa kwindlela kuthetha ukulungiswa kwakhona kwedatha ngokubhekiselele kwipropati ethize, njengokukhetha itafile ngegama elingu-alfabhethi ngegama elidlulileyo okanye ngokukhawuleza ukusuka kwidala ukuya kumncinci.
Izinketho zohlobo lwe-Excel ziquka ukuhlenga enye indawo okanye ngaphezulu, ukuhlenga ngokwezifiso, njengomhla okanye ixesha, nokuhlenga ngemigqa eyenza kube lula ukulungisa kwakhona iindawo kwitafile.