I-Excel yisoftware evela kwi-Excel Microsoft, efakwe kwiphakheji yeOfisi. Ngale nkqubo kunokwenzeka ukufomatha nokuphuhlisa i-spreadsheets, emele phakathi kwabanye. Iindleko zokuphumeza iiprojekthi zakho, ukwanda kweendleko, uhlalutyo lomzobo. Phakathi kwemisebenzi emininzi ekhoyo, uphuhliso lweefomula zokuzenza ukubala ngokuzenzekelayo luxatyiswa kakhulu. Konke ukulungiselela idatha kunye nokuqwalasela iintlobo ezahlukeneyo zeetshathi.

I-Excel ihlala isetyenziselwa ukulungiselela, ngakumbi:

  • Uhlahlo lwabiwo-mali, olufana nokudalwa kwesicwangciso sokuthengisa umzekelo;
  • Ubalo-mali, ngokuguqulwa kweendlela zokubala neengxelo zocwangciso-mali, ezifana nokungena kwemali neengeniso;
  • Ukunika ingxelo, ukulinganisa ukusebenza kweprojekthi kunye nokuhlalutya umahluko weziphumo;
  • Ii-invoyisi kunye neentengiso. Kulawulo lweentengiso kunye nedatha ye-invoyisi, kunokwenzeka ukucinga iifom ezilungiselelwe iimfuno ezithile;
  • Ukucwangcisa, ekudalweni kweeprojekthi kunye nezicwangciso zobungcali, ezifana nophando lwentengiso phakathi kwabanye;

Yeyiphi imisebenzi esisiseko ye-Excel:

  • Ukwenziwa kweetafile,
  • Ukwenziwa kweencwadi zokusebenza,
  • Ukufomatha i-spreadsheet
  • Ukungena kwedatha kunye nokubala okuzenzekelayo kwi-spreadsheet,
  • Ukuprintwa kwephepha lomsebenzi.

Uyenza njani imisebenzi esisiseko kwi-Excel?

  1. Ukwenza itafile:

Cofa kwinketho eNtsha kwaye emva koko ukhethe iitemplates ezikhoyo, ezinokuthi: i-spreadsheet engenanto, itemplates engagqibekanga okanye iitemplates ezintsha ezikhoyo.

Ukwenza incwadi yomsebenzi, cofa iFayile ukhetho (ebekwe kwimenyu ephezulu), ilandelwa nguNtsha. Khetha incwadi yokusebenzela engenanto. Uya kuqaphela ukuba uxwebhu lunamaphepha ama-3, ngokucofa iqhosha lemouse ekunene, kunokwenzeka ukususa okanye ukufaka amaphepha amaninzi njengoko kuyimfuneko.

  1. Faka imida:

Kuqala khetha iseli, cofa ku Khetha Konke ukhetho (ebekwe kwimenyu ephezulu), emva koko ukhethe kwi eKhaya thebhu, i Font ukhetho kwaye uskrolele ezantsi kwi Borders ukhetho, ngoku ufuna nje ukukhetha isitayile oyifunayo.

  1. Ukutshintsha umbala:

Khetha iseli efunekayo kunye nombhalo ofuna ukuwuhlela. Yiya kuKhetho lwaseKhaya, umba ophantsi wefonti, cofa Umbala wefonti kunye nolandelelwano kwiMibalo yoMxholo.

  1. Ukulungelelanisa umbhalo:

Khetha iiseli ezinombhalo, cofa eKhaya, uze ucofe Ulungelelwaniso.

  1. Ukufaka i-shading:

Khetha iseli ofuna ukuyitshintsha, yiya kwimenyu ephezulu kwaye ucofe eKhaya, emva koko uye kwiqela elincinane lefonti, kwaye ucofe Gcwalisa Umbala. Vula inketho yeMibala yoMxholo kwaye ukhethe umbala owuthandayo.

  1. Ukufaka idatha:

Ukufaka idatha kwispredishithi se-Excel, khetha ngokulula iseli kwaye uchwetheze ulwazi, emva koko ucinezele u-ENTER okanye, ukuba ukhetha, khetha iqhosha le-TAB ukuya kwiseli elandelayo. Ukufaka idatha entsha komnye umgca, cofa i ALT+ENTER indibaniselwano.

  1. Ukwenza umbono:

Emva kokufaka lonke ulwazi, ukufomatha i-spreadsheet kunye nemizobo ngendlela efunwayo, masiqhubeke siprinte uxwebhu. Ukuprinta i-spreadsheet, khetha iseli oza kuyibonisa. Cofa kwimenyu ephezulu "Ifayile" kwaye emva koko ucofe ku Shicilela. Ukuba ukhetha, sebenzisa indlela emfutshane yebhodi yezitshixo, nguCTRL+P.

Ukuququmbela

Ukuba ufuna ukwazi ngakumbi malunga nokusetyenziswa kwenkqubo yomsebenzi we-Excel, ungathandabuzi ukuziqeqesha simahla nge iividiyo zobuchwephesha kwindawo yethu.