Uyigqithisa njani i-Excel ngezi ndlela

I-Excel yinkqubo esiyisebenzisa rhoqo kwiikhompyuter zethu. Ispreadsheets sisixhobo esisetyenziswa ziinkampani ezininzi, kunye nabafundi. Ke ngoko, kubalulekile ukwazi ukuba ungayilawula njani le software ngokugqibeleleyo. Umbuzo wabasebenzisi abaninzi yindlela abanokuthi baguqule ngayo kwi-Excel, ekubeni kuyinto efuna ukwenziwa ngamathuba athile.

Si iindlela ezahlukeneyo ezenza kube nokwenzeka ukudlulisa kwi-Excel, ukuze uhlale ufumana into ehambelana nento oyifunayo ngamaxesha onke. Ukuba nangaliphi na ixesha kufuneka uguqule into kwi-spreadsheet, sithathele ingqalelo ezi ndlela esinokuzisebenzisa kwaye ngaloo ndlela ukhethe enye enokuthi isetyenziswe ngokweemfuno zakho.

Kukho iindlela ezininzi, kuba indlela yokuguqula iya kuxhomekeka kwindlela oyifake ngayo idatha kwi-spreadsheet sakho, ukuba ibikwikholamu ezithe nkqo, ngokuthe tye okanye ngokwediagonally. Ke kuya kufuneka uthathele ingqalelo oku ngaphambi kokukhetha indlela ekubuzwa ngayo ukuba ugqithise loo datha kwinkqubo.

Indlela engatshintshiyo

Inketho yokuqala esinayo ukudlulisa idatha kwi-Excel yinto ebizwa ngokuba yi-static method. Njengoko igama libonisa, akusiyo indlela eguquguqukayo. Oku kuthetha ukuba xa sihlela umzobo kwikholamu ethe nkqo, ayizukuyitshintsha ngokuzenzekelayo ukuya kwindawo ethe tye, ngoko ke yinto ekufuneka siyithathele ingqalelo xa sisebenzisa le ndlela kwisicelo. Nangona oku, kuboniswa njengesisombululo esihle kuzo zonke iintlobo zeemeko, ngakumbi ukuba sifuna ukwenza into ngokukhawuleza kwaye sifuna ukudlulisa inani elincinci ledatha.

Le ndlela iyakuthi vumela ukudlulisa idatha ngokukhawuleza kwaye kulula ukusuka kumqolo ukuya kumqolo, okanye ngokuphendululekileyo. Kwakhona, indlela esinokuyisebenzisa ngayo kwi-Excel yinto elula kakhulu, ukuze nawuphi na umsebenzisi okwinkqubo akwazi ukusebenzisa le ndlela kwimeko yabo. La ngamanyathelo ekufuneka uwalandele:

1. Vula i-Excel.
2. Yiya kwi-spreadsheet ekuthethwa ngayo.
3. Gxininisa indawo ofuna ukuyihambisa kwimeko yakho.
4. Betha u-Ctrl + C ukukopa idatha kule ndawo iphawulweyo.
5. Ekunene cofa kwiseli engenanto apho ufuna ukukwazi ukubona iziphumo.
6. Yiya kwi "Cola iinketho" ukhetho.
7. Khetha Cola Okukhethekileyo.
8. Khangela ibhokisi ecaleni kwe Transpose.
9. Cofa Kulungile.
10. Idatha sele iguqulelwe kwi-spreadsheet sakho.

Njengoko ubona, inikwe njengendlela elula yokudlulisa idatha. Nangona kuyinto esimele siyenze ngokukodwa ukuba sele siyifake yonke idatha esifuna ukuyibonisa, ukuze sizigcine kufuneka senze oku kwakhona kwixesha elizayo kunye nedatha eyongezelelweyo efakwe kwiphepha.

Ifomula yotshintsho

Indlela yesibini esinokubhenela kuyo ukuba kufuneka sidlulise idatha kwi-Excel kukusebenzisa ifomula yokuguqulela. Olu lukhetho oluguquguqukayo, ngokungafaniyo nendlela engatshintshiyo kwicandelo lokuqala. Ke sisisombululo esithe kratya, esiya kulungiswa ngcono kwiimeko apho sinomthamo omkhulu wedatha. Inyaniso yokuba isisombululo esinamandla siya kuthetha ukuba iya kutshintsha idatha kwikholamu okanye umqolo kwaye iya kuyitshintsha ngokuzenzekelayo kwikholamu eguqulelweyo okanye umqolo.

Kwakhona, nangona isenokunika ingcamango yokuba yindlela entsonkothileyo, ilula ngenene. Sidinga nje Yazi ukuba yeyiphi ifomula enokusetyenziswa kwi-Excel xa sifuna ukudlulisa loo datha. Kodwa oku akusiyo into enzima, kuba siya kukuxelela ngezantsi loo fomula esinokuyisebenzisa kunye nendlela esiyisebenzisa ngayo kwi-spreadsheet kwiprogram eyaziwayo. La ngamanyathelo ekufuneka siwalandele:

1. Vula i-Excel.
2. Yiya kwi-spreadsheet apho ezi datha zikhona.
3. Cofa kwaye uphawule iqela leeseli ezingenanto.
4. Kuhlobo lwebha yefomula = transpose kwaye emva koko uqaqambise idatha ofuna ukuyihambisa.
5. Cofa u-Ctrl + Shift + Faka ukuze usebenzise le fomula.
6. Ukuba awukhethanga inani elifanayo leeseli, ifomula iyasikwa, kodwa ungayisombulula ngokucofa kwaye utsale ezantsi kweseli yokugqibela kwaye urhuqe ukuze yonke idatha ibandakanywe kuyo.
7. Buyela kwibha yefomula.
8. Cofa u-Ctrl + Shift + Faka elinye ixesha elingakumbi.
9. Ifomula ilungisiwe ngoku.
10. Idatha iboniswe ngokuchanekileyo.

Le ndlela iguquguqukayo, enokwenza kube lula ukuyisebenzisa, ngakumbi ukuba sinomthamo omkhulu wedatha. Kubalulekile ukuqwalasela inani leeseli apho sinedatha, nangona njengoko ubonile kumanyathelo, inokulungiswa ngokulula, ke siya kube sihlengahlengisa le fomyula ngamaxesha onke kwi-Excel. Ngaloo ndlela idatha iya kukwazi ukutshintshwa ngendlela elula ngokwenene xa kuyimfuneko kwinkqubo.

Ukuthunyelwa ngokuthe ngqo

Indlela yesithathu esiza kuyisebenzisa ukudlulisa idatha kwi-Excel kukusebenzisa iireferensi ezithe ngqo. Yindlela eya kusivumela ukuba sifumane kwaye sibuyisele nayiphi na ireferensi kwi-spreadsheet kunye nedatha esifuna ukuyibonisa. Le yindlela abasebenzisi abaninzi abangaziyo, kodwa isebenza kakuhle xa sifuna ukudlulisa idatha. Nangona kungcono ukuyisebenzisa ukuba isixa sedatha esifuna ukuyihambisa ayinkulu kakhulu.

Yindlela efuna amanyathelo amaninzi, enokuphindaphinda, ngoko ke ukuba kufuneka senze oku ngedatha eninzi, ingaba namava njengento enzima. Ngethamsanqa, yindlela elula esinokuyisebenzisa kwi-Excel, ngoko ke ngokungathandabuzekiyo lukhetho olulungileyo lokuqwalasela kulo mba. Amanyathelo omawulandele ukuze uyisebenzise kwiakhawunti yakho ngala:

1. Cofa kwiseli engenanto.
2. Bhala isalathiso kuloo seli kunye nendawo yeseli yokuqala ofuna ukuyitshintsha.
3. Kwiseli elandelayo (umzekelo ngezantsi kwaleya), bhala isimaphambili esifanayo kunye nendawo yeseli ekunene kwaleyo siyisebenzisileyo kwinyathelo elingaphambili.
4. Phawula zombini iiseli.
5. Tsala indawo ephawulweyo ngokucofa kwaye utsale ibhokisi eluhlaza evela ezantsi ekunene kwale datha.
6. Cinezela u-Ctrl + H ukuzisa imenyu yokukhangela kwisikrini.
7. Bhala isimaphambili esibuzwayo osisebenzisileyo kwindawo yokukhangela.
8. Kwindawo yoBuyiselo, kufuneka ubhale nje =
9. Cofa kwi Buyisela yonke iqhosha ukuze le datha itshintshwe.

Ngala manyathelo senze i-Excel ihambe ukuze idlulise le datha kwi-spreadsheet. Yindlela entsonkothileyo ngandlel’ ithile, ukutsho okuncinci, kuba ibandakanya amanyathelo angaphezulu kwaye kufuneka silumke kakhulu xa sisebenzisa ezi zimaphambili kwaye sazi ukuba masibhale ntoni kwimeko nganye. Nangona sisebenzise amaxesha ambalwa, inikezelwa njengesisombululo esisebenzayo xa uhambisa idatha kwi-spreadsheets yale nkqubo.

Yintoni injongo yokudlulisa idatha kwi-Excel

Sele sikubonisile iindlela ezintathu esinokuzisebenzisa kwiingxelo zethu ukudlulisa idatha kwi-Excel. Njengoko ubonile, akukho nanye kwezi ndlela intsonkothile kwaye kuzo zonke sifumana into esiyifunayo, ukuba idatha iya kubonwa ngendlela eyahlukileyo, ukusuka ekumeni ukuya kuthi tye okanye ngokuphambeneyo. Le yinjongo yalo msebenzi kwiprogram ye-spreadsheet.

Ingcamango emva kwalo msebenzi kukuba sinokubona idatha ngendlela eyahlukileyo. Oko kukuthi, ukuba idatha ibikwikholamu ethe nkqo, ngoku siyibeka ngokuthe tye, okanye inkqubo echaseneyo. Le yinto eyenziwayo kuba inokunceda ekwenzeni olo lwazi lufundwe okanye lutolikwe ngendlela elula kumntu wonke. Kungakhathaliseki ukuba umntu odala i-spreadsheet okanye ukuba kufuneka uyithumele kumntu, mhlawumbi ngokubonisa idatha ngenye indlela, abanye abantu baya kuba nokuqonda okungcono kule datha eboniswayo.

Ayingomsebenzi onemfihlakalo ngakumbi, ukwazi nje ukubonisa idatha ngenye indlela, enokubanceda ukuba baqonde okanye babe nomfanekiso-ngqondweni womongo othile. Xa sisenza i-spreadsheet, asisoloko siqaphela eyona ndlela ilungileyo yokubonisa ulwazi oluthile, kodwa njengoko siyilwa, sinokubona oko kusebenza kakuhle. Ukuba oko kusebenza ngcono yenye indlela, usebenzisa i-transpose kwi-Excel sinokuqhubeka nokuhlela i-spreadsheet, kodwa loo datha iya kuboniswa ngendlela esicinga ukuba ingcono. Ngumsebenzi oya kuba luncedo kuthi ngamaxesha amaninzi, njengoko ubona. Ngoko ke musa ukuthandabuza ukwenza lo msebenzi kangangoko kuyimfuneko kuwe.