Idatha yokucafaza kwi-spreadsheet ithetha ukuseta iimeko ukuze kuphela idatha ethile iboniswe. Yenziwe ukwenza kube lula ukugxila kwingcaciso ethile kwi dataset enkulu okanye itafile yedatha. Ukucoca akususa okanye kuguqula idatha; litshintsha nje ukuba imigqa okanye iikholomu zivela kwiphepha lokusebenzela lase Excel.
UkuCoca iiRekhodi zeDatha
Izihlungi zisebenza ngamarekhodi okanye imigca yedatha kwiphepha lokusebenzela. Iimeko ezibekwe zifaniswa nomnye omnye okanye ngaphezulu emasimini kwirekhodi. Ukuba iimeko zidibeneyo, irekhodi iboniswa. Ukuba imiqathango ayifumanekanga, irekhodi icutshulweyo ukuze kungaboniswa kunye neyezinye iirekhodi zolwazi.
Ukucoca kwedatha kulandela iindlela ezimbini ezahlukeneyo kuxhomekeke kwimiba yedatha echanekileyo-idatha okanye idatha yombhalo.
Ukucoca idatha yeNombolo
Idatha yeenkcukacha ingahlungwa ngokusekelwe kwi:
- ingaba idatha ilingana nenani elithile
- ingaba idatha ingaphezulu okanye ngaphantsi kwenani elithile
- idatha ingentla okanye ngaphantsi kwexabiso eliqhelekileyo leenkcukacha ngokupheleleyo
Ukucoca idatha yombhalo
Idatha yombhalo ingahlungwa ngokusekelwe kwi:
- ingaba umgca weedatha igama elithile
- ingaba idata lizwi eliqukethe enye ileta okanye ngaphezulu
- ingaba idata lizwi eliqala okanye eliphela ngeleta ethile yealfabhethi
Ukukopisha iiRekhodi eziHluliweyo
Ukongeza kwiirekhodi zokufihla okwethutyana, i-Excel ikunika ukhetho lokukopisha idatha efunwayo kwindawo ehlukileyo yephepha lokusebenzela . Ngokuqhelekileyo le nqubo yenziwa xa ikopi engunaphakade yoluhlu oluhlanjulweyo ihlangabezana nemfuno ethile yezoshishino.
Iindlela eziPhambili zokuCoca
Zigcine ilahleko ngokulandela izikhokelo zokusebenza ezifanelekileyo ngokusebenza kunye nedatha ecocekileyo:
- Ngaphandle kokuba kukho isizathu esihle, musa ukuhlamba ispredishithi esabelanayo kunye nezihlungi ezisebenzayo. Abanye abasebenzisi bangaboni ukuba ifayile ifakwe.
- Nangona unako ukucoca kwiikholamu eziliqela ngokufanayo, ezi zihlomelo zongezelelweyo, ezingabonakaliyo. Ngamanye amagama, ukucoca uluhlu lokudibanisa ukubonisa wonke umntu kwi-State of California kunye nabakudala kuneminyaka engama-60 baya kukunika wonke umntu ongaphezu kwama-60 eCalifornia. Uluhlu olunjalo aluyi kukubonisa abaneminyaka engama-60 ubudala okanye abaseKalifornia.
- Izicatshulwa zetekisi ezihambelana nokusebenza kunye nolwazi olusiseko luya kuvumela. Idatha "i-Messy" iya kukhokelela kwimiphumo ehlongozweyo engakhohlisa okanye engalunganga. Ngokomzekelo, ukuhlunga abantu abahlala e-Illinois abayi kubamba abantu abahlala "kwi-IL" okanye abahlala "kwi-Ilinois" okanye "i-Illenois."
- Qaphela xa uhlela idatha ehlongoziwe. Ukuhlelwa kwedatha ehlanjulweyo kuya kubakho ukuhlaziywa kwefayili yedata-imeko iqheleke ngokufanelekileyo. Ukuba kufuneka uhlele i-dataset ecocekileyo, kopisha idatha ehlungiweyo kwiphepha elitsha lomsebenzi uze uyilungise.