I-Excel isofthiwe evela ku-Excel Microsoft, efakwe kuphakheji le-Office. Ngalolu hlelo kungenzeka ukufometha nokuthuthukisa amaspredishithi, amele phakathi kwabanye. Izindleko zokuqalisa amaphrojekthi akho, ukusabalala kwezindleko, ukuhlaziya imidwebo. Phakathi kwemisebenzi eminingi etholakalayo, ukuthuthukiswa kwamafomula okwenza izibalo ngokuzenzekelayo kwaziswa kakhulu. Konke okokuhlela idatha nokulungiselela izinhlobo ezahlukene zamashadi.

I-Excel ivame ukusetshenziselwa ukulungiselela, ikakhulukazi:

  • Isabelomali, esifana nokwakhiwa kohlelo lokumaketha ngokwesibonelo;
  • Ukubalwa kwezimali, ngokukhohlisa izindlela zokubala kanye nezitatimende zokubala, njengokungena nokuphuma kwemali kanye nenzuzo;
  • Ukubika, ukulinganisa ukusebenza kwephrojekthi kanye nokuhlaziya ukwehluka kwemiphumela;
  • Ama-invoyisi nokuthengisa. Ngokuphathwa kwedatha yokuthengisa nama-invoyisi, kungenzeka ukuthi ucabange amafomu aguqulelwe kuzidingo ezithile;
  • Ukuhlela, ukwakhiwa kwamaphrojekthi nezinhlelo zobungcweti, njengocwaningo lokumaketha phakathi kokunye;

Yimiphi imisebenzi eyisisekelo ye-Excel:

  • Ukwakhiwa kwamatafula,
  • Ukwakhiwa kwezincwadi zokusebenza,
  • Ukufometha ispredishithi
  • Ukufakwa kwedatha nokubala okuzenzakalelayo kusipredishithi,
  • Ukuphrinta ishidi lokusebenza.

Uyenza kanjani eminye imisebenzi eyisisekelo ku-Excel?

  1. Ukudala ithebula:

Chofoza inketho Entsha bese ukhetha izifanekiso ezitholakalayo, ezingaba: ispredishithi esingenalutho, izifanekiso ezizenzakalelayo noma izifanekiso ezikhona.

Ukwakha incwadi yokusebenzela, cindezela inketho ethi Fayela (etholakala kwimenyu ephezulu), kulandele Okusha. Khetha inketho yencwadi yokusebenzela engenalutho. Uzoqaphela ukuthi idokhumenti inamashidi angu-3, ​​ngokuchofoza inkinobho yegundane engakwesokudla, kungenzeka ukususa noma ukufaka amashidi amaningi njengoba kudingeka.

  1. Faka imingcele:

Okokuqala khetha iseli, chofoza okuthi Khetha Konke inketho (etholakala kumenyu ephezulu), bese ukhetha kuthebhu Yasekhaya, inketho yefonti bese upheqa uye phansi kunketho yeBorders, manje udinga nje ukukhetha isitayela osifunayo.

  1. Ukuze ushintshe umbala:

Khetha iseli oyifunayo kanye nombhalo ofuna ukuwuhlela. Yiya kunketho yasekhaya, into encane yefonti, chofoza Umbala Wefonti bese ulandelana kokuthi Imibala Yetimu.

  1. Ukuqondanisa umbhalo:

Khetha amaseli anombhalo, chofoza Ekhaya, bese uchofoza ukuqondanisa.

  1. Ukusebenzisa i-shading:

Khetha iseli ofuna ukulishintsha, yiya kwimenyu ephezulu bese uchofoza Ekhaya, bese uye eqenjini elincane lefonti, bese uchofoza Gcwalisa Umbala. Vula inketho yemibala yetimu bese ukhetha umbala owuthandayo.

  1. Ukufakwa kwedatha:

Ukufaka idatha kuspredishithi se-Excel, vele ukhethe iseli bese uthayipha ulwazi, bese ucindezela u-ENTER noma, uma uthanda, khetha ukhiye we-TAB ukuze uye kuseli elandelayo. Ukufaka idatha entsha komunye ulayini, cindezela inhlanganisela ALT+ENTER.

  1. Ukwenza umbono:

Ngemva kokufaka lonke ulwazi, ukufometha ispredishithi kanye nezithombe ngendlela oyifunayo, ake siqhubeke siphrinte idokhumenti. Ukuze uphrinte isipredishithi, khetha iseli ozolibonisa. Chofoza kumenyu ephezulu "Ifayela" bese uchofoza kokuthi Phrinta. Uma uthanda, sebenzisa isinqamuleli sekhibhodi, yi-CTRL+P.

Ekuphethweni

Uma ufuna ukwazi okwengeziwe ngokusetshenziswa kohlelo lokusebenza lwe-Excel, ungangabazi ukuziqeqesha mahhala nge amavidiyo professional kusayithi lethu.