IMicrosoft Excel yinkqubo yespredishithi evumela abasebenzisi ukuba balungelelanise, bafomethe, kwaye babale idatha ngeefomula kusetyenziswa inkqubo yeeseli ezahlulwe ngemigca kunye neentsika.
Qonda ingqikelelo yoluhlu lokuhla kwi-Excel
Ngaphambi kokungena kwiinkcukacha malunga nendlela yokudala uluhlu oluhlayo kwi-Excel, kufuneka siqale siqonde kakuhle ukuba luthini uluhlu lokuhla kwi-Excel. Uluhlu oluhlayo, olukwaziwa njengebhokisi yokukhangela ukhetho okanye imenyu eyehlayo, luphawu lwe-Excel oluvumela abasebenzisi ukuba bakhethe ixabiso kuluhlu oluchazwe kwangaphambili.
Oku kuluncedo kwiimeko ezininzi. Umzekelo, ukuba ufaka idatha ngesandla kwaye kukho amaxabiso athile aqhelekileyo kwaye aphindaphindwa rhoqo, unokwenza uluhlu oluhlayo lwaloo maxabiso ukukhawulezisa inkqubo yokungena kwedatha.
Ukulungiselela idata yoluhlu lokuhla
Isinyathelo sokuqala sokwenza uluhlu oluhlayo kwi-Excel kukulungiselela idatha ofuna ukuvela kuluhlu. Olu luhlu lungabandakanya nantoni na esuka kuluhlu lwamagama, izixeko, amanani, okanye nayiphi na enye into oyifunayo.
Nanga amanyathelo okulungiselela idata yoluhlu oluhlayo:
- Vula i-Excel kwaye wenze i-spreadsheet esitsha okanye usebenzise esele ikhona.
- Kwikholamu engenanto okanye umqolo, chwetheza idatha ofuna ukuvela kuluhlu lokuhla. Ingeno ngalinye malibe kwiseli eyahlukileyo.
Emva kokuba ufake yonke idatha, ungayikhetha kwaye uyinike igama ngebhokisi yegama kwikona ephezulu ngasekhohlo.
Ukudala uluhlu oluhlayo
Xa sele uyilungisile eyakho data kwaye ubanike a -nombre, singaqalisa inkqubo yokwenza uluhlu oluhlayo:
- Khetha iseli apho ufuna ukuba noluhlu olwehlayo.
- Cofa kwi 'Data' tab kwibar yemenyu engundoqo.
- Kwiqela elithi 'Izixhobo zeDatha', cofa 'uQinisekiso lweDatha'.
Ngoku uzakunikwa iwindow 'yoQinisekiso lweDatha' apho ungaqwalasela imithetho yeseli ekhethiweyo.
Ukuqwalasela imithetho yokuqinisekisa idatha
Inyathelo lokugqibela ekudaleni uluhlu lokuhla kwi-Excel kukuqwalasela imithetho yokuqinisekisa idatha:
- Kwifestile 'yoQinisekiso lweDatha', cofa kwindawo ethi 'Useto'.
- Ngaphantsi kwesihloko esithi 'Vumela', khetha u-'Luhlu' kuhla.
- Kwindawo ethi 'Imvelaphi', chwetheza igama olinike idatha yakho kwaye ucofe u-'Kulungile'.
Ngeli xesha, kufuneka ube ne ukulahla uluhlu ngokugqwesa ebonisa idatha efakiweyo. Ungayivavanya ngokukhetha iseli apho uqwalasele uluhlu oluhlayo kwaye ucofe utolo.
Ukusebenzisa kunye nokuguqula uluhlu lwakho lokuhla
Ngoluhlu lwakho lokuhla esele lwenziwe, ungayisebenzisa ngokukhetha ngokulula nayiphi na iseli enoluhlu kwaye ukhethe ungeno. Ukulungisa uluhlu okanye ukutshintsha idatha yokuqinisekisa, phinda amanyathelo angaphambili.
Khumbula ukuba uluhlu oluhlayo kwi-Excel sisixhobo sokugcina ixesha esiphucula ukusebenza kakuhle kunye nokuchaneka kokungena kwedatha. Sisakhono esibalulekileyo ekufuneka bonke abasebenzisi be-Excel basazi.