Isikhokelo sokuqala kwiMicrosoft Excel
Kufuneka ufunde indlela yokusebenzisa iMicrosoft Excel, ispredishithi esithandwa kakhulu kwihlabathi iminyaka? Nangona kunjalo, kunokusongela kakhulu xa uqala ukuqalisa isofthiwe. Indlela yokusebenzisa i-Excel yinkqubo yokuqeqesha i-tutorials eyenzelwe ngumqali oqalayo engqondweni. Le miyalelo ibandakanya imizekelo yesinyathelo-ngeyinyathelo malunga nendlela yokusebenzisa i-Excel ukudala ispredishithi esisiseko; khetha uqeqesho ukuze uqalise!
Excel Screen Elements
Isifundo se- Excel Screen Elements sichaza izinto eziphambili zephepha lokusebenzela lase Excel, egxininise kulo:
- Iseli kunye neselula esebenzayo
- Yongeza uphawu lwephepha
- Iileta zekholomu
- Amanani omvuzo
- Ibha yomumo
- Ibha yefomula
- Ibhokisi legama
- Iibhanki kunye neetabhondi
- Fayile ithebhu
Isispredishithi seSiseko seSiseko
I- Basic Excel Spreadsheet tutorial ihlanganisa iziseko zokudala nokufometha ispredishithi esisiseko kwiinguqulelo zakutsha ze-Excel. Izihloko ezibandakanyiweyo ziquka:
- Ukufaka idatha
- Ukudala amafomula alula
- Ukuchaza uluhlu olukhankanyiweyo
- Ukukopisha amafomula kunye nesibambo sokuzalisa
- Ukusebenzisa ifowuni kunye nokufometha kweseli kwiphepha lokusebenzela
- Ukongeza ifomathi yokufomatha
Excel Math
Funda ukudibanisa, ukususa, ukuphindaphinda nokwahlula amanani kule khokelo ye- Excel Math . I-tutorial ibandakanya kwakhona ukutshintsha umyalelo wemisebenzi kwiifomula, iimbonakalo kunye nemisebenzi yezibalo ze-Excel.
Isihloko ngasinye siquka umzekelo wenyathelo ngamanyathelo malunga nendlela yokwenza ifom eza kuqhuba enye okanye ngaphezulu kwezinto ezine ezisisiseko zezibalo kwi-Excel.
Ukongeza Amanani Aphezulu NgeSUM Umsebenzi
Imiyalelo yesinyathelo ngesinyathelo malunga nendlela yokusebenzisa umsebenzi we- Excel . Ekubeni ukongeza imiqolo kunye neenkomfa zamanani enye yezona zinto ziqhelekileyo kwi-Excel, iMicrosoft ifakile le ndlela yokufutshane yokumisela ukwenza umsebenzi ube lula. Uqeqesho lubandakanya:
- Umsebenzi we-SUM syntax kunye neengxabano
- Ukufaka umsebenzi we-SUM
- AutoSUM
- Ibhokisi yencoko yencoko ye-SUM
Hambisa okanye Kopisha idatha
Kule khokelo, funda indlela yokusebenzisa izitshixo ezimfutshane zokunquma , ukukopa nokunamathisela idatha kwi-Excel . Hambisa idatha kwindawo entsha okanye uyiphindwe ngeendlela ezininzi. Uqeqesho lubandakanya:
- Iindlela zokukopa idatha
- I-clipboard kunye nedatha yokudlula
- Ukusebenzisa izitshixo ezimfutshane zokukopa nokunamathisela
- Ukusebenzisa imenyu yomxholo ukukopisha idatha
- Ukusebenzisa ukhetho lwemenyu kwikhaya laseKhaya ukukopisha idatha
- Ukuhambisa idatha ngefowuni zotshintsho
- Ukuhambisa idatha kunye nemenyu yesimo kunye nokusebenzisa ithebhu yaseKhaya
Yongeza / Susa iiKholamu kunye neeRows
Ngaba kufuneka ulungise utshintshi lweedatha yakho? Kunokuba nje uhambise idatha, kutheni ungafaki, okanye ususe iikholomu kunye nemigqa yokwandisa okanye ukunciphisa indawo yomsebenzi njengoko kuyimfuneko? Funda iindlela ezilungileyo zokungeza okanye ukususa iikholomu okanye ezininzi kunye nemigqa usebenzisa i-shortcuts yebhodibhodi okanye imenyu yomongo.
Fihla / udibanise iikholam kunye neendalo
Ungafihla iikholomu kunye nemigqa equlethe idatha kwispredishithi. Ukwenza oko kunokwenza kube lula ukugxila kwezinye iindawo, ezibalulekileyo kwiphepha lokusebenzela kwaye kulula ukubabuyisa xa ufuna ukufumana idatha efihliweyo kwakhona.
Ukungena Umhla
Funda indlela yokusebenzisa ikratshi yokukhawuleza ukuba ufake ngokukhawuleza umhla nomhla kwi-spreadsheet ye-Excel. Ukuba unqwenela ukuba ube nomhla wokuhlaziya kumhla okhoyo rhoqo xa iphepha lokusebenzela livuliwe, sebenzisa umsebenzi we-TODAY endaweni yoko.
Ukufaka iDatha kwi-Excel
Ungaphuthelwa ezi ngcebiso eziyisixhenxe kwiindlela ezifanelekileyo zokufaka idatha kwiphepha lokusebenzela kuquka:
- Ukucwangcisa iphepha lokusebenzela
- Ukubeka idatha
- Ukufaka izihloko kunye neeyunithi zeedatha
- Ukukhusela iifomula zomsebenzi
- Ukusebenzisa izikhokelo zeseli kwiifomula
- Hlela idatha yakho
Ishadi lekholamu
Eyaziwa nangokuthi iigrafu zebar, iikhotshana zekholamu zisetyenziselwa ukubonisa ukuthelekiswa phakathi kwezinto zedatha. Ikholomu nganye kwitshathi imele ixabiso leenkcukacha ezahlukeneyo ukusuka kwiphepha lokusebenzela. Funda indlela yokuwasebenzisa ngokufanelekileyo kule tutorial.
Igrafu yomgca
Iigrafu zamagama okanye iitshathi zomgca zisetyenziselwa ukubonisa ukuhamba kwexesha. Umgca ngamnye kwigrafu ubonisa utshintsho kwixabiso lexabiso lwedatha enye ukusuka kwiphepha lokusebenzela.
Itshathi yephayi
Iitshathi zepiyi zisetyenziselwa ukubonisa ipesenteji. Uchungechunge olulodwa lweedatha lucebiswe kwaye isahlulo ngasinye se-pie simelela ixabiso lwedatha elilodwa ukusuka kwiphepha lokusebenzela.