Enye yeemeko eziqhelekileyo esijongana nazo xa siphatha idatha kwi-Excel sheets kukuba nezinto eziphindwe kabini.. Le nto yinto ethi, kuxhomekeke kumsebenzi esiwenzayo, inokuthintela ukuqokelela idatha kunye nenkqubo yokuhlalutya, ngoko kufuneka sihlale sithatha umsebenzi wokuyisusa. Le yinto enokuthi ibe lula okanye inzima njengobungakanani bedatha equlethwe kwiphepha ekuthethwa ngalo. Ngaloo ndlela, siza kukubonisa into onokuyenza ukuze ufumane kwaye ususe iimpinda kwi-Excel, xa inani leeseli ezihlala kwiphepha lakho lininzi kakhulu ukuba ungalenza ngesandla.
I-Excel igcwele izixhobo ezisivumela ukuba sinciphise umsebenzi weeyure ukuya kwimizuzu embalwa, kwaye ke siza kukufundisa ukuba wenze njani ukuze wonge ixesha emsebenzini wakho.
Amanyathelo okufumana kunye nokususa idatha ephindwe kabini kwi-Excel
Ehlabathini le-Excel akuqhelekanga ukufumana amaxwebhu kunye namawaka eerekhodi, apho kufuneka sisebenzise izixhobo ezinikezelwa yiprogram yokuphonononga nokulawula.. Umzekelo, ukukhangela igama kwezi ntlobo zamaphepha akuyona into elula njengokujonga kwikholamu equlethwe ukuze uwafumane. Ngokuchasene noko, kufuneka sisebenzise umsebenzi othile ukukhangela okanye ukhetho lokukhangela olunikezelwa yi-Excel.
Kwenzeka into efanayo xa sifuna ukucoca iphepha ledatha eliphindwe kabini. Ukuba ilayishwe ngeerekhodi, iya kuba ngumsebenzi odinisayo ngokwenene ukungqinisisa uxwebhu ukuphelisa uphinda-phindo nganye nganye.. Iindaba ezimnandi zezokuba kwi-"Data" ithebhu sinokhetho "Susa ii-duplicates" oluya kusivumela ukuba sisuse iirekhodi eziphindwe kabini kwi-stroke.
Ukuqala ngalo msebenzi, into yokuqala omawuyenze kukukhetha ikholamu enoluhlu lweeseli apho okuphindiweyo kufunyanwa khona, ukuqala ngentloko. Okulandelayo, cofa kwithebhu «Iinkcukacha"Ke ngoku"susa iimpinda", eya kubonisa iwindow ephumayo echonga umhlathi okhethiweyo. Cofa ku «ukwamukela» kwaye i-Excel iya kukhupha ngokukhawuleza umyalezo obonisa inani leekopi ezifunyenweyo kunye nokuqinisekisa ukususwa kwazo.
Susa iimpinda ezineentsika ezininzi
Oku kungasentla ibingumzekelo ngeyona meko isisiseko yokudityaniswa kwedatha kwi-Excel, kuba iincwadi zomsebenzi ezintsonkothileyo zihlala zisingathwa emsebenzini nakwiindawo zokufunda. Ngale ndlela, kuqhelekile ukuba noluhlu olukhulu olwenziwe luninzi lwedatha kunye neerekhodi, nto leyo eyenza nzima ngakumbi ukupheliswa kokuphindaphinda. Nangona kunjalo, i-Excel sisixhobo esibonakaliswe ngokuququzelela iinkqubo kwaye kwezi meko, i «susa iimpinda»inendlela elula yokusingatha oku.
Ukuqala le nkqubo yokucima iikholamu ezininzi, kufuneka sikhethe zonke iitheyibhile ezibandakanyekayo kwincwadi yomsebenzi. Okulandelayo, cofa kwithebhu «Iinkcukacha"Ke ngoku"Susa iikopi", eya kubonisa iwindow ephumayo apho uya kubona iiheader zemiqolo eyahlukeneyo yetafile yakho. Ngoku, kuya kufuneka ukhethe kuphela iikholamu apho ufuna ukuphinda kuqwalaselwe kwaye ucofe ku «ukwamukela«. Ngokukhawuleza emva koko, uya kubona umyalezo ovela kwi-Excel obonisa idatha ephindwe kabini efunyenweyo kunye nenani lamaxabiso asusiweyo.
Ngokwenza ngale ndlela, uya kuba nethuba lokugcina ixesha elininzi xa ukhangela kwaye ususa iimpinda kwi-Excel. Kwakhona, kuba iyinkqubo elula, iya kukunika ithuba lokucoca idatha ephindwe kabini kuzo zonke iincwadi zokusebenza ze-Excel onazo. Oku kuya kukuvumela ukuba ube noluhlu oluthembekileyo ngakumbi ukuze uvelise izibalo kunye neengxelo ezivela kwiseti yedatha ecocekileyo ngaphandle kokuphindaphinda.
Isiphelo
Ngokuqhelekileyo, ukufumana kunye nokususa iirekhodi eziphindwe kabini kwi-Excel yinkqubo ekufuneka yenziwe nguye nabani na osebenza ngedatha.. Ubukho bolwazi oluphindaphindiweyo lunokukhokelela kwiziphumo ezingachanekanga nezingachanekanga, ngoko kubalulekile ukubhaqa kunye nokususa ukuze kuqinisekiswe ukuthembeka kwedatha. Ngale ndlela, ukupheliswa kwezinto eziphindwe kabini kuba ngumsebenzi ophambili wokufikelela kulawulo lolwazi olusebenzayo kunye nokwenza izigqibo ezichanekileyo.
Kubalulekile ukuqwalasela ukuba, ngaphambi kokukhangela kunye nokuphelisa iirekhodi eziphindwe kabini, kuyimfuneko ukuchaza ngokuchanekileyo oko kuthathwa njengento ephindwe kabini ngokusekelwe kwiimfuno ezithile kunye neenjongo zokusingqongileyo.. Ukongezelela, kuyimfuneko ukuqinisekisa ukuba ulwazi luqulunqwe kakuhle kwiphepha le-Excel kwaye lihambelana, ukuphepha iimpazamo kunye nokudideka.
Ekugqibeleni, ukufumana kunye nokususa iimpinda kwi-Excel kunokugcina ixesha kunye nokuthintela iimpazamo, nto leyo ephucula umgangatho wedatha kunye nokuthembeka. Ngezixhobo ezifanelekileyo kunye nobuchule, nawuphi na umsebenzisi angakwazi ukuwulawula lo msebenzi kwaye aqinisekise ukuchaneka kunye nokuphelela kolwazi lwabo.