Ungayenza njani isakhelo ekuthinjweni

Anonim

Ungayenza njani isakhelo ekuthinjweni

Inketho 1: Yongeza imida yetafile

Uninzi lwabasebenzisi lunomdla lunomdla wokudibanisa imida yetafile kwi-Excel. Oku kungathathelwa ingqalelo uhlobo lwesakhelo esifanelekileyo ngenani elikhulu leeparamitha ezibonakalayo. Fumana zonke kwaye ukhethe unikelo olufanelekileyo kumyalelo owahlukileyo kwiwebhusayithi yethu.

Funda ngakumbi: Ukwabiwa kwemida yetafile kwi-Excel

Ukudala imida yetafile xa usongeza isakhelo kwi-Excel

Ukuba olu khetho lokongeza imida yetafile ayikufaneli, ngoko nangoko ukuya kule ndlela 3 ukujongana nesakhelo sesakhelo sokungenisanga, emva koko sibekwe kwenye indawo.

Inketho 2: Ukongeza amaphepha

Amasimi amagqabi anokubangelwa yisakhelo, kodwa ayinawo umbala woyilo, kwaye isenzo sisebenza kulo lonke uxwebhu. Olu khetho lufanele ukugqiba ukulungiswa kwetafile ukuze iprinte kwaye iyimfuneko kwiimeko apho ufakelo lwemimandla ibangelwa ziimfuno zeprojekthi.

  1. Ukulungiselela ukwenza ezinye iintshukumo, sicebisa ngokukhawuleza ukuqhubeka nokumelwa "uphawu lwephepha".
  2. Tshintshela kwimowudi yokujonga iphepha lokujonga izakhelo kwimimandla e-Excel

  3. Kuyo, vula ithebhu yetabhu ngegama elifanayo.
  4. Ukuvula imenyu yephepha lephepha lokwenza imihlaba njengephepha lephepha e-Excel

  5. Yandisa iMenyu yeMihlaba ukukhetha useto olukhoyo.
  6. Ukuvula imenyu kunye nendawo ekhoyo ukuyenza njengephepha lephepha kwi-Excel

  7. Sebenzisa ukhetho olusemgangathweni okanye ukuya "kwimihlaba efihlakeleyo" ukwenza useto lwakho.
  8. Yiya kwindawo yesiko ukuze ubenzele njengephepha lephepha kwi-Excel

  9. Ifestile entsha iya kuvulwa, apho ungabeka khona ubungakanani bendawo kwicala ngalinye lephepha, uze usebenzise utshintsho.
  10. Ukuseta amasimi asindileyo ukuze ubenzele njengephepha lephepha kwi-Excel

  11. Khangela okwenzekileyo, kwaye ubuyela kwimbonakalo yesiqhelo ukuba ufuna ukwenza olunye ulungelelwano lwetheyibhile. Kule ndlela, amasimi awayi kujongwa, kuya kwenza lula umsebenzi.
  12. Ukudalwa okuphumelelayo kwentsimi njengesakhelo segqabi kwi-Excel

Inketho 3: Ukudala isakhelo sePhezulu

Isahlulo sokungenisana sibandakanya ukongeza nawuphi na amanani afumanekayo ngaphandle kokugcwalisa itafile, kodwa ngesekethe yesiseko esiqhelekileyo. Kwixa elizayo, isakhelo esinjalo sinokufuduselwa kuyo nayiphi na indawo ephekiweni ukuze ibonise imixholo okanye inike olunye uyilo olubonakalayo.

  1. Zonke ezinye iintshukumo zenziwa kwithebhu "Faka" ithebhu, ke ngoko waqhubela phambili kuyo.
  2. Yiya kwimenyu yokufaka ukwenza isakhelo sokungabinakho

  3. Yandisa "umzekeliso", apho uluhlu lweemilo zejometri ezikhoyo zikhona.
  4. Ukuvula imenyu yokufaka xa kusenziwa isakhelo sokungabinakho

  5. Vula "amanani" edle-phantsi.
  6. Ukuvula uluhlu lweemilo zejometri ukudala isakhelo sokungabinamsebenzi kwi-Excel

  7. Kuyo, fumana enye yamanani alungele wena, indlela ekufuneka uthathe isakhelo sexesha elizayo.
  8. Ukukhetha imilo ukudala isakhelo sokungabinakho

  9. Beka ubungakanani ngayo kwaye ubeke kwindawo efanelekileyo etafileni.
  10. Indawo yendawo ngaphambi kokudala isakhelo sokungabinamsebenzi kwi-Excel

  11. Cofa kumzobo ngeqhosha le mouse lasekunene kwaye uvule imemo "yefomathi" yomzobo ".
  12. Yiya kwi-10 useto ukwenza isakhelo sokungabinamsebenzi kwi-Excel

  13. Kwiparameter, kurhoxisa ukugcwalisa, ukumakisha into efanelekileyo.
  14. Rhoxisa isakhelo sekhefu lokungabinamntu kwi-Excel

  15. Kwiparadi "yombala", setha umthunzi wesakhelo.
  16. Ukuseta umbala wesakhe sesekethe kumzobo xa useto lwe-Excel

  17. Yongeza ububanzi bayo bokubonisa ubungqina obubonakalayo.
  18. Ukutshintsha ubungakanani besekethe yesakhelo xa useto lwe-Excel

  19. Buyela etafileni kwaye ususe isakhelo kwindawo oyifunayo.
  20. Indalo ephumeleleyo yesakhelo sokungabinamsebenzi sejometri kwi-Excel

Endaweni yokuba uxande, unokukhetha nayiphi na imilo yejometri kwaye ususe ukugcwalisa isakhelo esifunayo.

Inketho 4: Ukongeza isakhelo somfanekiso

Kugqityiwe, siya kuhlalutya umgaqo wokwenza isakhelo somfanekiso, ukuba ngephanyazo kubalulekile ukuba senze. Izenzo zifana nale sathetha ngazo xa kusenziwa uyilo olungagungqiyo.

  1. Ngethebhu efanayo, yongeza umfanekiso, ukuba oku kungenziwa ngaphambili.
  2. Yiya kufaka imifanekiso ukongeza isakhelo sokugqwesa kuyo

  3. Yilungelelanise ngobukhulu kwaye ukhethe indawo ephepheni.
  4. Faka imifanekiso ukongeza isakhelo kuyo kwi-Excel

  5. Yenza ilungelo lasekunene Cofa kumfanekiso owomfanekiso kwaye uye kwifomathi "yemenyu".
  6. Yiya kwindawo yepateni yokongeza isakhelo sokugqwesa kuyo.

  7. Awudingi ukuchukumisa ukugcwalisa, kodwa kwicandelo "lomgca", jonga umhlathi oqinisekileyo ".
  8. Ukujika kwi-contour kumgca ukongeza isakhelo kumfanekiso ogqwesileyo

  9. Khetha umbala ofanelekileyo kunye nobubanzi bomgca wesakhelo.
  10. Ukuhlela i-contour ukongeza isakhelo kumfanekiso ogqwesileyo

  11. Isiphumo siya kuvela ngokukhawuleza kwitafile, ubuya kuyo, ubuyela ukubukela umfanekiso.
  12. Ukuhlela i-contour ukongeza isakhelo kumfanekiso ogqwesileyo

Funda ngokugqithisileyo