Uliguqulela njani igama kwi-Excel

  • I-Word kunye ne-Excel zizixhobo eziphambili ze-Microsoft Office, nganye ineenjongo ezahlukeneyo.
  • Kukho iindlela ezininzi zokuguqula amaxwebhu eLizwi kwi-Excel spreadsheets.
  • I-.html ifomathi yenza kube lula ukungenisa idatha ngaphandle, igcina iodolo eyiyo.
  • Khuphela kwaye uncamathisele lukhetho olulula, nangona lucotha xa kuthelekiswa nezinye iindlela.

igama elithi logo

igama y Excel Zimbini zezona zisetyenziswa kakhulu izicelo Microsoft Office ukubhala iifayile kunye nokuqulunqa kunye nokulungiselela idatha kunye neegrafu. Ukususela ekudalweni kwayo kwi-80s, kukho iinkampani ezininzi eziye zenza iinguqulelo ezifanayo ngokusekelwe kule mizekelo mibini ngenxa yoncedo olukhulu ngokubhekiselele kwidatha kunye nolawulo lwefayile. Ezi zizixhobo uninzi lwabantu abasoloko besebenzisa ikhomputha bazi indlela yokuphatha nokusetyenziswa, ukuya kuthi ga kwinqanaba elikhulu okanye elingaphantsi. Ngaphaya koko, zikhona kuzo zonke iinkampani ezinefomathi yedijithali.

Kukho ngokungathandabuzekiyo iyantlukwano phakathi kwezi zimbini ukusukela, ngelixa I-Word sisicelo sokubhala nokudala amaxwebhu okubhaliweyo, I-Excel isetyenziswa kakhulu ukwenza iitheyibhile, iigrafu, kunye nokwenza ii-akhawunti kunye nokwenza izibalo zemathematika.. Nangona ngoku bobabini banemisebenzi ephezulu kakhulu kunenguqulelo yabo yoqobo ukuze ufumane okuninzi kwiifayile zakho. Kweli nqaku siza kukubonisa indlela onokuthi ngayo guqula iifayile kwifomati yeLizwi kwi-Excel ngoko ungadlulisela idatha kunye neegrafu ngendlela elula kakhulu endaweni yokwenza uxwebhu ukusuka ekuqaleni. Ukuba unomdla koku, hlala ufunda nathi kwaye siya kukunika iingcebiso zokwenza uninzi lwezi zicelo.

Guqula i-Word ukuya kwi-Excel

Ilogo ye-Excel

Kukho iindlela ezininzi zokudlulisa idatha ukusuka kwifomati yeLizwi ukuya kwi-Excel spreadsheet. Nangona kunjalo, kuxhomekeke kuluphi uhlobo loxwebhu ofuna ukuluguqula kunye nendlela ofuna ukuba luvele ngayo ekugqibeleni kwiphepha lakho le-Excel, kubalulekile ukuba ukhethe ukhetho olwenza lula lo msebenzi kuwe. Ukukunceda kulo msebenzi, ngezantsi siza kubonisa i iindlela eziphambili zokuguqula iifayile zakho zeLizwi kwi-Excel.

idatha yokungenisa

Enye yeendlela ezikhawulezayo neziluncedo ekufuneka siguqule amaxwebhu okubhaliweyo abe yifomathi yespredishithi yile ngenisa idatha ngokuthe ngqo kwifayile yethu yeLizwi. Le yinkqubo abantu abambalwa abazi ngayo, kodwa ngokungathandabuzekiyo iyakwenza ixesha lakho lomsebenzi libe phezulu ukuba uqhele ukwenza ezi ntshukumo rhoqo. Sikubonisa inyathelo ngenyathelo ukuba ungayenza njani ngendlela elula kakhulu.

  1. Vula uxwebhu lweLizwi esifuna ukuliguqula kwaye ucofe ukhetho «Oovimba«. Emva koko ukhethe ukhetho «kuluhlu oluhlayoUkuthumela ngaphandle«. Apha kuya kufuneka sicofe ku «Guqula uhlobo lwefayile» kwaye ukhethe «Umbhalo otyhidiweyo«.
  2. Nje ukuba uxwebhu lwethu lugcinwe njengesicatshulwa esicacileyo kuya kufuneka vula ifayile ye-excel apho sifuna ukufaka khona lo mbhalo.
  3. Sikhetha kwimenyu ephezulu «Iinkcukacha«, kwaye sicofa ku «Fumana idatha > kumbhalo/CSV"kwikona ephezulu ngasekhohlo.
  4. Apha kuya kufuneka sijonge ifayile ye-Word ebesiyigcinile njengesicatshulwa esicacileyo kwaye ucofe kuyo «ukungenisa»ukuze ibe yispreadsheet.
  5. Ngaphambi kokuguqula ifayile imboniso iya kuvela kwimiqolo nemiqolo ukuze sikwazi ukuhlela ifayile phambi kokuyigcina.
  6. Nje ukuba le nkqubo igqitywe, umbhalo obhalwe kwi-Word uba yitheyibhile yemigca kunye neekholamu kwi-Excel. Emva kwexesha unokuyihlela kwaye wongeze okanye ususe idatha.

Umbhalo otyhidiweyo

Kungenzeka ukuba ngeli xesha le nkqubo ulwazi lulahlekile okanye aluhanjiswa njengoko besifuna, ngoko ke kuyathakazelisa ukwenza le nkqubo amaxesha amaninzi ukufezekisa idatha ngokuthanda kwethu.

Guqula ifomathi yeHtml

Enye indlela esinokuyisebenzisa ukuguqula uxwebhu lokubhaliweyo kwi-spreadsheet yi usebenzisa i.html ifomathi. Mhlawumbi ilula kunendlela yangaphambili kuba imiqolo kunye neentsika zibekwe kakuhle kwaye ziyalelwa. Ukwenza oku kuya kufuneka silandele la manyathelo alandelayo.

  1. Into yokuqala esiza kuyenza yile vula uxwebhu lwegama ukuba sifuna ukuguqula kwaye sijonge ukuba ichanekile kwaye icwangciswe kakuhle.
  2. Kengoku ntoni siya kuyiguqulela kwifomati yewebhu, oko kukuthi, kwi.html. Ukwenza oku sicofa ku «Ifayile > Gcina Njenge > .html»kwaye siyayikhumbula indawo esiyigcine kuyo.
  3. Sivula iMicrosoft Excel kwaye ukhethe kwimenyu «Ifayile> Vula«. Apha kufuneka sivule i.html uxwebhu ebesiligcinile ngaphambili.
  4. Xa oku kwenziwe, i-spreadsheet esitsha siya kuvula ngolwazi oluqulethwe kwiLizwi lethu lokuqala kwimiqolo kunye nefomathi yeekholamu.

Ngokukodwa, le ndlela ilula kakhulu ukuhlela kunye nokongeza ulwazi olutsha kunokongeza ifayile njengesicatshulwa esicacileyo, kuba ulwazi luya kukhutshelwa ngokulula ngokungathi uzibhalele ngokwakho.

phambili

faka into

IMicrosoft Excel ibonelela ngokunokwenzeka faka imizobo, imifanekiso kunye namaxwebhu okubhaliweyo ngqo kwi-spreadsheet. Ezi aziveli kwifomati yegridi, kodwa kunoko Zincanyathiselwe ngokungathi ngumfanekiso ukugcwalisa i-spreadsheet. Ukongeza, ngumsebenzi olula kakhulu kuba akuyi kufuneka siguqule iifomati okanye sihlele iphepha kamva ukubeka imiqolo kunye neekholamu, ngoko siya kugcina ixesha elininzi. Kwelinye icala, umbhalo owuncamathele kwi-.doc okanye .docx ifomathi iya kuvela njengomfanekiso ogqunywe ngaphezulu kwaye awuyi kukwazi ukudlala ngawo njengakwimiba yangaphambili.

  1. Ukwenza oku, kuya kufuneka gcina uxwebhu lwakho lweLizwi kwi.doc okanye .docx format, oko kukuthi, njengoko igcinwa ngokungagqibekanga kwisicelo.
  2. Emva koko vula i-Excel spreadsheet ofuna ukungenisa kuyo ifomathi yokubhaliweyo.
  3. Khetha kwimenyu ephezulu «Faka«. Apha kuya kufuneka sicofe ukhetho «Umbhalo» kwimenyu ephezulu ekhohlo.
  4. Iinketho ezahlukeneyo ziya kuvela kwaye sikhetha «Into«. Emva kokuba oku kwenziwe unako khetha ifomati ogcine ngayo uxwebhu lwakho umbhalo kwaye emva koko uyikhethe kumhloli wefayile. Ukuba unengxaki yokufumana ifayile, sicebisa ukuba uyiguqulele kuyo PDF, ekubeni maxa wambi idla ngokubangela iingxaki.
  5. Ngale nto siya kuba nefayile yethu engeniswe ngaphandle kwigridi.

Khuphela kwaye uncamathisele

Kopa uncamathisele

Indlela elula kakhulu yokuguqula iifayile zethu zeLizwi kwi-Excel yile Khuphela okubhaliweyo enomdla kuthi kwaye uyincamathisele ngqo kwimiqolo kunye neekholamu esizifunayo kwi-spreadsheet. Ngaphandle kwamathandabuzo le yinto wonke umntu owaziyo ukwenza, kodwa kwakhona kuthatha ixesha elide ngaphezu kwazo naziphi na iinkqubo esizichazile ngasentla.

Ukwenza oku ungakhetha amabinzana okanye amagama ofuna ukuwafaka kwaye usebenzise imiyalelo Khuphela "Ctrl + C" y Ncamathelisa "Ctrl + V" ukuyingenisa kwindawo ekuyiwa kuyo. Unokwenza oku ngokukhetha ngekhesa, wenze cofa ekunene kwaye ucofe ku khuphela kunye/okanye uncamathisele. Ungafumana ulwazi oluthe kratya ukuze ufumane okuninzi kwiispredishithi zakho ze-Excel kweyethu iphepha.


Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.