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?
-
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.
-
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.
-
Ukutshintsha umbala:
Khetha iseli efunekayo kunye nombhalo ofuna ukuwuhlela. Yiya kuKhetho lwaseKhaya, umba ophantsi wefonti, cofa Umbala wefonti kunye nolandelelwano kwiMibalo yoMxholo.
-
Ukulungelelanisa umbhalo:
Khetha iiseli ezinombhalo, cofa eKhaya, uze ucofe Ulungelelwaniso.
-
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.
-
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.
-
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.