Ukulawula incwadi ye-akhawunti kunokuthatha ixesha, kwaye ezi zenziwa ukudala umbutho kuyo nayiphi na indawo yobomi. Ngenxa yoku, ngumbono olungileyo ukwazi ukuba njani funda i-Excel ngokukhawuleza kwaye ulawule yonke imeko kwenzekani.
Kwabo basathandabuzayo. IMicrosoft Excel sisixhobo esiyilelwe ukukhathalela kunye nokuqulunqa iimpendulo ngaphambi kokuba idatha iphakanyiswe. Ukongeza, yahlulwe yangamaphepha eencwadi ukugcina umbutho opheleleyo malunga nemisebenzi.
Ukuba kunokwenzeka ukugcina idatha efana nalokhu: amagama, izifundo, imisebenzi, ii-invoyisi, amanqaku okuhanjiswa, iintlawulo ezenziweyo okanye eziza kwenziwa. Kwakhona, yimodeli efanelekileyo ukufumana iimpendulo zemathematika ukusuka kusebenziso olulula.
Zeziphi izinto ezisisiseko eziphathwa yi-Excel?
Enye yezinto ethe yatsala umdla ka Abasebenzisi beMicrosoft zezo zicwangciso zabo kunye neemveliso zinokuphathwa ngaphandle kwesidingo sexesha elingaka lokufunda. Akunyanzelekanga ukuba abantu baye kwizifundo ezibanzi ukuze baziqonde.
Ngoko ke, ithetha ukuba Excel njengazo zonke izixhobo iphatha iinketho ezisisiseko ezenzelwe umntu ngamnye.
- Imiqolo yahlulwe ngeeseli ukuze nganye ibenokusebenza okwahlukileyo.
- Imiqolo emininzi okanye iiseli zinokudityaniswa ukuze zenze iziphumo ezinkulu zokufomatha.
- Xa uprinta imisebenzi, izahlulo zeeseli aziyi kuvela.
- Imali ethile inokongezwa kwimisebenzi ukufumana iziphumo zoqoqosho.
- Nje ukuba ifayile igcinwe ingasetyenziswa kwakhona.
- Nabani na one-Excel uya kuba nethuba lokuyisebenzisa kwikhompyuter yakhe.
- Kunokwenzeka ukwenza umbutho wamaxwebhu kunye nolwazi olusekelwe kwi-alfabhethi.
Uyisebenzisa njani iExcel ngempumelelo?
Ukujoyina ulwazi olusebenzayo lwe-Excel, kuyafuneka ukuba uphumelele kwi iikhowudi esiphathwa sisixhobo. Okubandakanya ukulungelelanisa kwindibaniselwano yealphanumeric ukumisela ukuba ngowuphi na umsebenzi oya kusebenza kakhulu.
- Ctrl + A: Nikeza ibhokisi ukuvula uxwebhu
- Ctrl + B: Yizisa isikhangeli sefayile kwi-Excel
- Ctrl + C: Ngendlela ekhawulezayo iphatha ikopi yeeseli ezikhethiweyo
- Ctrl + D: Ikuvumela ukuba ukhuphele ekunene ifomula yemathematika yoluhlu olukhethiweyo
- Ctrl + E: Inika ithuba lokukhetha iseli nganye yephepha elisetyenzisiweyo
Ngezi zishunquleli zebhodibhodi kulula ukufumana uncedo olubalaseleyo kwindawo yokuphatha i-Excel ngokukhawuleza.
Yiba yingcali ye-Excel
Ngokucacileyo, ngobusuku nje, umntu akayi kukwazi ukubakho ingcali egqwesileyo iyonke. Nangona kunjalo, ukuba kukho ithuba lokulawula imixholo evezwe ngexesha lawuphi na umsebenzi kwisixhobo.
Kwelinye icala, ukuba kukho amanyathelo ekufuneka uwalandele ukuphatha i-Excel ngokugqibeleleyo ngokukhawuleza kwaye ulawule yonke imiba ye le mowudi evela kuMicrosoft.
- Kufuneka ufunde imiyalelo ngeseli ukuze ufumane iziphumo zokusebenza
- Lungisa okokuqala uhlobo lweakhawunti eza kuzotywa
- Yenza iifomathi zephepha ukufaka ngokuthe ngqo umsebenzi
- Lungiselela ngokwealfabhethi imisebenzi oza kuyibonisa
- Sukudala ukubhideka phakathi kwee-invoyisi kunye neeodolo zokuhanjiswa
- Gcina eminye imisebenzi ukuze ube nee-invoyisi
Ukongeza, kuyafuneka ukuba uqaqambise into ekufuneka uyijonge izifundo zokusebenzisa i-Excel nayo iya kunceda ngempumelelo.