Ungasusa kanjani ku-Excel? Ngaphakathi kwalesi sihloko, sikushiyela isifundo esiphelele nesinemininingwane kuso.
Amaspredishithi e-Excel
I-Excel ingenye yezinhlelo ezinephrosesa yokubala engcono kakhulu ekhona, ngaphakathi kwayo singenza imisebenzi eminingi, kusukela kweziyisisekelo, njengokuhlanganisa, ukususa, ukuhlukanisa kanye nokuphindaphinda kwedatha, kuya kweyinkimbinkimbi kancane.
Amaspredishithi afanayo, abonakala esebenza kakhulu, njengoba esinika imiphumela enembile yokusebenza kwezinombolo, ngaphezu kwalokho singabona ukumelwa okuyingcaca kwedatha eshiwo, uma siyidinga.
Empeleni, ukwazi ukusebenzisa ithuluzi le-Excel kungaba umsebenzi onzima ekuqaleni, kodwa empeleni, ngokuzijwayeza nolwazi olutholakala ohlelweni olufanayo, singenza le misebenzi kalula futhi ngokushesha, kumakhompyutha ethu.
Futhi, kufanele sisho ukuthi asikwazi nje ukusebenzisa leli thuluzi elifanayo kumakhompyutha we-Windows, kodwa nangaphakathi kwamakhompyutha we-macOS, ngoba kukhona inguqulo ehambisana nohlelo lwe-Apple. Kodwa hey, ngaphandle kokuqhubeka kwesikhathi, ake sehlele ebhizinisini.
Ungakwazi yini ukususa ku-Excel?
Empeleni ngaphakathi kohlelo lwe-Excel, awukho umsebenzi othize esingasusa ngawo, kanye nomsebenzi othi "isamba”, ecaciswe ngaphakathi kohlelo, kodwa lokho akusho ukuthi ngeke isuswe. Ngakho ngisho noma umsebenzi ungatholakali, uma ungakwazi khipha ngaphakathi kwe-excel.
Indlela yokukhipha ku-Excel
Le ndlela esizokwethulela yona kuqala, iyona elula kakhulu ukuyisebenzisa ngaphakathi kohlelo, ngoba lokhu sizosebenzisa umsebenzi wokwengeza, sibeka kuphela inani elibi.
Isibonelo: =SUM(10,-3), ngale fomula, ungenza ukubala okulula, uthole umphumela wokususa, ithambo 7.
Kulokhu, esizobe sikuzuzile ukwenza ukususa okufihliwe, njengokungathi kuhlanganisa.
Kulula kakhulu kwesokudla? ngaleyo ndlela ungakwazi khipha ku-excel usebenzisa umsebenzi wokwengeza.
Indlela yokukhipha inamaseli amaningana
Lena enye indlela esingakhipha ngayo ku-Excel, lapho sinamaseli amaningana esizokwenza ngawo umsebenzi.
Isibonelo: =A1+B1-C1-D1, ukubeka le fomula, wonke amanani angaphakathi kwamaseli ashiwo, azokwengezwa noma akhishwe, kuye ngophawu lwenombolo, oluphambi kwawo.
Yilokho kuphela! Kulula kakhulu, akunjalo? Ngokufanayo, ungase khipha amaseli amaningi ku-excel. Ngaphandle kwesidingo sokusebenzisa umsebenzi wokwengeza, ngokumane ungeze izimpawu ezingezinhle noma ezinhle.
Indlela yokukhipha ku-Excel ngomsebenzi we-IM.SUSTR
Lena enye singasusa kanjani ku-Excel, kuyo sizosebenzisa umsebenzi we-IM.SUSTR. Ngokweqiniso, lo msebenzi awaziwa futhi usetshenziswa kancane, kodwa ngawo singakwazi ukwenza ukususa ngaphandle kwenkinga.
Kulokhu sidinga ukubhala amanani amabili kumaseli ahlukene.
Isibonelo: Ngaphakathi kweseli A1 kuzobekwa inani elingu-23, bese kuseli B1 sizobeka inani elingu-7, bese kuseli C1 sizobhala umsebenzi we-IM.SUSTR futhi sizoba nokuthile okufana nokulandelayo: = I-IMSUSTR(A1,B1).
Khona-ke uhlelo olufanayo luzokwenza umsebenzi wokukhipha womabili amaseli, nakuba kufanele sicabangele ukuthi ngale ndlela, singakwazi ukwenza imisebenzi ngezinombolo ezimbili noma amanani ngesikhathi esisodwa.
Yilokho kuphela! Kulula kakhulu, ngaleyo ndlela uzobe usuzuzile khipha ku-Excel usebenzisa umsebenzi we-IMSUSTR.
Susa izinombolo ebangeni lamaseli
Ukuze ukwazi khipha izinombolo ebangeni lamaseli ku-excel, kufanele silandele indlela yokuqala echazwe, kalula, sithatha umsebenzi wesamba, kanye nawo, sibeka inani ledatha yezinombolo, ehlukaniswe ngophawu + noma -.
Isibonelo: =SUM(33,-23,53,-13,203), ngalokhu sithatha ububanzi obuhlanganisa amanani angemuhle, bese i-Excel izocabangela ngokuzenzakalelayo uphawu ngalunye lwenombolo bese yenza ukwengeza noma ukususa, njengoba kufanele okwamanje. . Ngokufanayo, ngemva kokwenza umsebenzi, izosinika umphumela ohambisanayo, ngokuvamile umphumela uboniswa esitokisini esingezansi, lapho singene khona ukusebenza. Noma ukwehluleka lokho, esitokisini ukuthi thina ngokwethu sikhombisa umphumela.
Ilungile! Lezi yizo zonke izindlela, ongazisebenzisa noma nini lapho ufuna susa ku-excel, kukuwe ukuthi uqinisekise ukuthi iyiphi efanelana kangcono nalokho okufunayo futhi ukusebenzise.
Extra
Khona lapha futhi sikunikeza a uhlu lwezinto okufanele uzazi nge-Excel, ngaphambi kokuyisebenzisa njengendlela yakho eyintandokazi yokubala. Lezo curiosity efanayo yilezi ezilandelayo:
- Ngaphakathi kwe-Excel, ungenza zonke izinhlobo zezibalo zezezimali, ngisho neziyinkimbinkimbi kakhulu njengenani elikhona eliwuketshezi noma ubale i-Payback.
- I-Excel ingase futhi isebenzise amafomula anesimo esivumelana nezici ezikhethwa umsebenzisi esimweni ngasinye.
- Ngaphakathi kwethuluzi, ungasebenza futhi ubuke amaspredishithi ahlukene ngesikhathi esisodwa, okungaba usizo ngempela mayelana nokuthuthukisa isikhathi nomsebenzi.
- Kuyo ungenza imisebenzi ephindaphindayo ngokuzenzakalelayo, engakongela isikhathi esengeziwe, uma unemisebenzi efanayo noma ephindaphindayo.
- Omunye wemisebenzi eyinhloko ye-Excel futhi omunye ofunwa kakhulu ngabasebenzisi yikhono layo lokudala amatafula ashukumisayo, lapho singasebenza khona ngolwazi olusheshayo, olusebenzayo nolufike ngesikhathi.
- Ngaphakathi kwe-Excel, sinethuba lokudala amagrafu, abizwa ngokuthi Amadeshibhodi, abuyekezwa ngokuzenzakalelayo, njengoba idatha yengezwa noma njengoba umsebenzisi eyihlela..
Yilokho kuphela okwalesi sihloko! Sithemba ukuthi sikucacise ngakunye nokungabaza kwakho, mayelana indlela yokukhipha ku-Excel. Noma yini, ungayishiya ivezwe kumazwana.