Indlela yokusebenzisa i-Excel-Excel Tutorials kubaqalayo

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:

Isispredishithi seSiseko seSiseko

I- Basic Excel Spreadsheet tutorial ihlanganisa iziseko zokudala nokufometha ispredishithi esisiseko kwiinguqulelo zakutsha ze-Excel. Izihloko ezibandakanyiweyo ziquka:

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:

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:

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:

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.