Umhlahlandlela wokuqala we-Microsoft Excel
Udinga ukufunda indlela yokusebenzisa i-Microsoft Excel, ispredishithi ethandwa kakhulu emhlabeni iminyaka? Noma kunjalo, kungase kusabe kancane lapho uqala ukuqala isofthiwe. Indlela yokusebenzisa i-Excel yi-roundup of tutorials eklanyelwe ngomuntu oqala ukuqala engqondweni. Lezi ziqondiso zihlanganisa izibonelo zenyathelo ngesinyathelo sokusebenzisa i-Excel ukudala ispredishithi eyisisekelo; khetha isifundo ukuze uqalise!
I-Excel Screen Elements
Lesi sifundo se- Excel Screen Elements sibona izakhi eziyinhloko zephepha lokusebenzela le-Excel, egxile ku:
- Iseli esebenzayo futhi esebenzayo
- Engeza isithonjana seshidi
- Izinhlamvu zekholomu
- Izinombolo zamarowu
- Ibha yomumo
- Ibha yefomula
- Ibhokisi legama
- Amathebhu we Ribhoni namabhoni
- Ithebhu yefayela
I-Basic Excel Spreadsheet
Isifundo se- Basic Excel Spreadsheet sihlanganisa izinto eziyisisekelo zokwakha nokufometha ispredishithi eyisisekelo ezinguqulweni zakamuva ze-Excel. Izihloko ezihlanganisiwe zihlanganisa:
- Ukufaka idatha
- Ukudala amafomula alula
- Ukuchaza ububanzi obuqanjwe
- Ukukopisha amafomula ngesibambo sokugcwalisa
- Ukusebenzisa inombolo nokufometha kweseli kukhasi lokusebenzela
- Ukwengeza ukufometha kweseli
I-Excel Math
Funda ukwengeza, ukususa, ukwandisa futhi uhlukanise izinombolo kulolu hlelo lwe- Excel Math . I-tutorial iphinde ihlanganise ukushintsha ukuhleleka kwemisebenzi emafomulini, iziboniso kanye nemisebenzi yezibalo ze-Excel.
Isihloko ngasinye sihlanganisa isibonelo sesinyathelo nesinyathelo sendlela yokwakha ifomula ezokwenza eyodwa noma ngaphezulu kwezibalo ezine eziyisisekelo zezibalo ku-Excel.
Ukwengeza Izinombolo Eziphezulu Ngomsebenzi We-SUM
Isinyathelo ngesinyathelo iziqondiso zendlela yokusebenzisa umsebenzi we-Excel we-SUM . Njengoba ukwengeza imigqa namakholomu ezinombolo kungenye yezinto ezivame kakhulu ku-Excel, iMicrosoft ifaka phakathi le ndlela yokunqamulela yefomula ukwenza umsebenzi ube lula. Isifundo sihlanganisa:
- Umsebenzi we-SUM syntax nezimpikiswano
- Ukufaka umsebenzi we-SUM
- I-AutoSUM ngokuzenzakalelayo
- Ibhokisi lengxoxo ye-SUM
Hambisa noma Kopisha Idatha
Kulesi sifundo, funda ukusebenzisa izinkinobho zokunqamulela ukusika, ukukopisha nokunamathisela idatha ku-Excel . Hambisa idatha endaweni entsha noma uyiphindise ngezindlela eziningana. Isifundo sihlanganisa:
- Izindlela zokukopisha idatha
- Ibhodi lokunamathisela kanye nedatha yokunamathisela
- Ukusebenzisa izinkinobho zokunqamulela ukukopisha nokunamathisela
- Ukusebenzisa imenyu yesimo ukukopisha idatha
- Usebenzisa izinketho zemenyu kuthebhu lasekhaya ukuze ukopishe idatha
- Ukuhambisa idatha ngezinkinobho zesinqamuleli
- Ukuhambisa idatha ngemenyu yesimo bese usebenzisa ithebhu yasekhaya
Engeza / Susa ama-Columns kanye nemigqa
Udinga ukulungisa ukuhlela kwedatha yakho? Kunokuba nje uhambise idatha, kungani ungangeze, noma ususe amakholomu nemigqa yokwandisa noma ukunciphisa indawo yomsebenzi njengoba kudingeka? Funda izindlela ezingcono zokufaka noma ukususa amakholomu amaningi noma amaningi kanye nemigqa usebenzisa isinqamuleli sekhibhodi noma imenyu yokuqukethwe.
Fihla / Hamba Amakholomu Nemizila
Ungafihla amakholomu nemigqa equkethe idatha kuspredishithi. Ukwenza kanjalo kungenza kube lula ukugxila kwezinye izindawo, ezibalulekile zephepha lokusebenzela futhi kulula ukubabuyisa uma udinga ukubona idatha efihliwe futhi.
Ukufaka Usuku
Funda ukuthi ungasebenzisa kanjani isinqamuleli sekhibhodi ukuze ufake ngokushesha usuku nesikhathi samanje kwi-spreadsheet ye-Excel. Uma ungathanda ukuthi ube nosuku lwangosuku olusha lwamanje njalo uma ishidi lomsebenzi livuliwe, sebenzisa umsebenzi we-TODAY kunalokho.
Ukufaka idatha ku-Excel
Ungaphuthelwa lawa mathiphu ayisikhombisa ngemikhuba engcono yokufaka idatha kufomethe lokufaka okubandakanya:
- Ukuhlela ishidi lokusebenzela
- Ukubeka idatha
- Ukufaka izihloko nezinyathelo zedatha
- Ukuvikela amafomu amafomethi okusebenza
- Usebenzisa amareferensi wesitokisi ngamafomula
- Hlunga idatha yakho
Ishadi lamakholomu
Eyaziwa nangokuthi ibrafu yebha, amashadi ekholomu asetshenziselwa ukubonisa ukufaniswa phakathi kwezinto zedatha. Ikholomu ngayinye eshadini limelela inani lemininingwane ehlukile kusuka ekhasini lokusebenzela. Funda ukuthi ungayisebenzisa kanjani ngokuphumelelayo kulesi sifundo.
Igrafu yombhalo
Amagrafu womugqa noma amashadi womugqa asetshenziselwa ukukhombisa izitayela ngokuhamba kwesikhathi. Umugqa ngamunye kugrafu ubonisa izinguquko enenani lenye idatha yedatha kusuka kwiphepha lokusebenzela.
Ishadi lePiyi
Amashadi wephayi asetshenziselwa ukubonisa amaphesenti. Uchungechunge olulodwa lwedatha luhlelwe futhi ingxenye ngayinye ye-pie imelela inani elilodwa lwedatha kusuka kwiphepha lokusebenzela.