Susa iiRows eziPhindayo zeDatha kwi-Excel

01 ka 02

Susa iiRekodi zeDatha zeDatha kwi-Excel

Iiprogram zeSpreadsheet ezifana ne-Excel zihlala zisetyenziswe njengeenkcukacha zezinto ezinjengeempahla zecandelo, iirekhodi zokuthengisa kunye neenlist zokuthumela.

Iinkcukacha ze-Excel ziqulethwe ngeetafile zedatha eziqhelekileyo zibekwe kwimigca yedatha ebizwa ngokuba yiirekhodi.

Kwirekhodi, idatha kwisisele nganye okanye kwintsimi emgceni inxulumene - njengegama lenkampani, idilesi nenombolo yefowuni.

Ingxaki eqhelekileyo eyenzeka njenge-database ekhulayo ngobukhulu yile ngxelo yirekhodi okanye imigqa yedatha.

Oku kuphinda kwenzeka xa:

• Iirekhodi zonke zifakwe kwisiseko sedatha ngaphezu kwesinye esiphumela kwiirekhodi ezimbini okanye ngaphezulu
• Amarekhodi amaninzi anomhlaba omnye okanye ngaphezulu - njengegama kunye nedilesi - equkethe idatha efanayo.

Ngayiphi na indlela, iirekhodi eziyimpembelelo zingabangela ingxaki epheleleyo-njengokuthumela iikopi ezininzi zamaphepha kumntu ofanayo xa ulwazi lweenkcukacha lusetyenziswa kwi-imeyile yokudibanisa-ngoko yinto efanelekileyo ukuyihlola kunye nokususa iirekhodi eziphindwe rhoqo siseko.

Nangona kube lula ukukhetha iirekhodi eziphindwe kabini kwisampula encinci njengowomfanekiso ongentla, iitheyibhile zedatha zingabandakanya kalula amakhulu angamawaka eirekodi ezenza kube nzima kakhulu ukukhetha iirekodi eziphindwe kabini-ngokukodwa iingxelo ezifanayo.

Ukwenza kube lula ukufeza lo msebenzi, i-Excel inokwakhiwa kwidatha yedatha ebizwayo, akumangalisi, Susa i-Duplicates , engasetyenziselwa ukufumana nokususa okufanayo kunye neirekhodi ezifanayo.

Nangona kunjalo, indlela yokuSusa iCandelo lokuPhucula idibeneyo yenzelwe, iirekhodi ezifanayo kunye neenkcukacha ezihambelana nazo maziqwalaselwe ngokwahlukileyo.

Oku kungenxa yokuba ibhokisi yencoko yebhokisi yebhokisi yebhokisi ibonisa iimpawu zengcambu kwitheyibhile ekhethiweyo yedatha kwaye ukhetha ukuba zeziphi iinkalo ezizozibandakanya ekufuneni iirekhodi ezifanayo:

• Ngamarekhodi afanayo, khangela zonke iinkalo - shiya amanqaku okutshekisha kuwo onke amagama ekholomu okanye kwimihlaba;
• Ukufumana iirekhodi ezihambelana nekhefu - shiya amanqaku amatshekishe ekufutshane kuphela nalawo masimi afanelekileyo.

Amagama omhlaba kunye neeNcwadi zeKholamu

Njengoko kuthethwe, i-Remove Removal tool iquka ibhokisi yencoko apho ukhetha ukuba yiyiphi imimandla ehambelana nayo yokukhangela ngokukhangela indawo efunwayo yamagama okanye iikholomu.

Ulwazi olubonisa ibhokisi yencoko yababini - amagama ensimi okanye iileta zekholomu - kuxhomekeke ekubeni ingaba idatha yakho iqulethe uluhlu lwezihloko - okanye iintloko - phezulu kwetafile yedata njengoko kuboniswe kumfanekiso ongentla.

Ukuba yenza - qinisekisa ukuba ukhetho kwicala lasekunene lebhokisi yencoko - Idatha yam enehloko - ihlolwe kwaye i-Excel iya kubonisa amagama kuloluhlu njengamaagama ensimelo kwibhokisi yencoko.

Ukuba idatha yakho ayinayo umgca we-header, ibhokisi yencoko iya kubonisa iifolda ezifanelekileyo kwiibhokisi yencoko kwibarti ekhethiweyo yedatha.

Ulungelelwaniso lweeNkcukacha

Ukukhutshwa kwezixhobo zokusebenza ngokufanelekileyo, itafile yedata kufuneka ibe luhlu lweedatha - lufanelekile ukuba lube nemigca engenanto, iikholomu, kwaye, ukuba kunokwenzeka, akukho iiseli ezingenanto ezingekho kwitafile.

Ukungenazo izikhalazo ngaphakathi kwetafile yedata yinto efanelekileyo xa kufikelele ekulawuleni kwedatha ngokubanzi kwaye kungekhona nje xa ufuna idatha yedatha. Ezinye izixhobo zedatha ze-Excel - ezifana nokuhlunga nokucoca - sebenze kakuhle xa itheyibhile yedata liluhlu lweedatha.

Susa iReporter Data Records Records

Kulo mfanekiso ngasentla, itafile yedata iqulethe iirekhodi ezimbini ezifanayo ze-A. Thompson kunye neefayile ezimbini ezihambelana ne-R. Holt-apho zonke iinkalo zidibanisa ngaphandle kwenani labafundi.

Amanyathelo adweliswe apha ngezantsi malunga nendlela yokusebenzisa iCandelo lokuSusa iCandelo lokuCoca .

1. Susa isibini kwiirekhodi ezimbini ezifanayo ze-A. Thompson.
2. Susa eso sibini irekhodi elincinci le-R. Holt.

Ukuvula Ikhupha Ibhokisi yeDialog

1. Cofa kwiyiphi na iseli equlethwe idatha kwisiseko seenkcukacha.
2. Cofa kwiTebhu yedatha kwibhoni.
3. Cofa kwiCandelo lokuSusa ukuPhinda ukugqamisa yonke idatha kwitafile yedata kwaye uvula ibhokisi yencoko yebhokisi yencoko.
4. Ibhokisi yencoko yebhokisi yencoko ibonisa zonke izihloko zekholomu okanye amagama ensimi kwisampuli yethu yedatha
5. Amanqaku okukhangela ecaleni kwamagama endle abonisa ukuba yeyiphi iikholomu ze-Excel eza kuzama ukufanisa ekufuneni iirekhodi eziphindwe kabini
6. Ngokungagqibekanga, xa ibhokisi yencoko ibonisa onke amagama ensimi ahlolwe

Ukufumana iiRekhodi eziLwazi

1. Ekubeni sifuna iirekhodi ezifanayo ngokupheleleyo kulo mzekelo siya kushiya zonke izihloko zekholomu zihlolwe
2. Chofoza OK

Kule ngongoma ezi zilandelayo zimele zibonwe:

• Ibhokisi yencoko yababini ifanele ifake kwaye ithathelwe indawo ngomyalezo ngokuthi: 1 ixabiso lempendulo elifunyenweyo kwaye lisuswe; 7 iimpawu ezizodwa zihlala.
• Umqolo oqulethe i-duplicate A. Ingxelo ye-Thompson iya kususwa kwisiseko sedatha
• Nangona kukho iirekhodi ezimbini ezihambelana ne-R. Holt, kuba akuzona zonke iinkalo ezihambelanayo-inani labafundi kwiirekhodi ezimbini ezihlukileyo - i-Excel ibona ukuba yirekhodi yeenkcukacha ezikhethekileyo

02 we 02

Fumana kwaye Susa iiRekodi eziHlanganayo ngokuSusa iziPhumo

Ukuhlola enye iNdawo ngexesha

Ekubeni i-Excel isusa kuphela iirekhodi zolwazi ezihambelana ngqo neendawo ezikhethiweyo zedata, indlela engcono yokufumana zonke iirekhodi zedatha ehambelana ncamnye kukususa uphawu lokutshekisha kwintsimi enye ngexesha, njengoko lenziwa kumanyathelo angezantsi.

Ukutshintshwa kweengxelo ezilandelelanayo kuzo zonke iinkalo ngaphandle kwegama, ubudala, okanye inkqubo iya kususa yonke inhlanganisela enokwenzeka ukuba idibanise ngokulandelanayo.

Ukufumana iiRekhodi eziHlanganayo

1. Cofa kunaliphi iseli equlethe idatha kwitheyibhile yedata xa kuyimfuneko
2. Cofa kwiTebhu yedatha kwibhoni .
3. Cofa kwiCandelo lokuSusa ukuPhinda ukugqamisa yonke idatha kwitafile yedata kwaye uvula ibhokisi yencoko yebhokisi yencoko.
4. Wonke amagama ensimu okanye izihloko zekholomu zeetafile yedatha zikhethiweyo.
5. Ukufumana nokususa iirekhodi ezingenalo umdlalo kuzo zonke iintsimi, susa uphawu lokukhangela ngaphandle kwalawo magama ensimi ukuba i-Excel ayiyihoywa.
6. Kulo mzekelo klikha kwibhokisi yokutshekisha ecaleni kwikholam ye- ID yomfundi ekujoliswe kuyo ukususa uphawu lokukhangela.
7. I-Excel ngoku iya kukhangela kuphela kwaye isuse iirekhodi ezineenkcukacha ezihambelanayo kwiGama lokugqibela , i- Initial , ne- Programme .
8. Chofoza OK
9. Ibhokisi yencoko yababini ifanele ifake kwaye ithathelwe indawo ngomyalezo ngokuthi: 1 ixabiso lempendulo elifunyenweyo kwaye lisuswe; 6 iimpawu ezizodwa zihlala.
10. Umqolo oqulethe irekhodi yesibini ye-R. Holt kunye ne-ID ye-Student ye- ST348-252 iya kususwa kwisiseko sedatha.
11. Cofa u-OK ukuvala ibhokisi lomyalezo

Kule ngongoma, umzekelo wedata yedata kufuneka ibe yinto ekhululekile kuyo yonke idatha yedatha.