Ungabelana kanjani ngefayela le-excel ngesikhathi esifanayo

Kuhlelo lokusebenza kudokhumenti ye-Excel, kuvame ukudingeka ukuthi abantu abambalwa baxhume kuyo ngesikhathi esisodwa. Futhi kaningi inani labo lingabalwa emashumini amaningana. Ngakho-ke, indaba yokusebenzisana ayigcini nje ngokuxhumanisa abantu, ngoba ngokuvamile bangenza izinguquko ezingqubuzanayo ezidinga ukufunda ukuhlela ngokushesha nangempumelelo.

Ubani ongakwenza? Umuntu onesimo somsebenzisi oyinhloko. Ngamafuphi, yini okudingeka yenziwe ukwenza umsebenzi ohlangene ngedokhumenti hhayi nje kuphela, kodwa futhi uphumelele?

Izici zokusebenza ngefayela le-Excel elabelwe

Ukusebenza ngefayela okwabelwana ngalo ku-Excel kunezici zako. Ngakho, ezinye izenzo azitholakali kubasebenzisi:

1. Ukudala amatafula.
2. Ukuphathwa kwesimo, okuhlanganisa ukuwabuka.
3. Ikhipha amashidi.
4. Abasebenzisi abanalo ikhono lokuhlanganisa amaseli ambalwa noma, ngokuphambene, bahlukanise lawo ahlanganiswe ngaphambilini. 
5. Noma yimiphi imisebenzi enedatha ye-XML.

Le mikhawulo ingaqiniswa kanjani? Udinga nje ukususa ukufinyelela okuvamile, bese ukukubuyisela lapho kuphakama isidingo.

Nasi esinye isipredishithi esinemisebenzi ethile okungenzeka noma ingenzeki uma usebenza nabantu abaningi kusipredishithi esifanayo.

Ungabelana kanjani ngefayela le-Excel

Okokuqala udinga ukuqonda ukuthi yiliphi ifayela elidinga ukwenziwa litholakalele ukuhlelwa abantu abambalwa ngesikhathi esisodwa. Kungaba ifayela elisha noma elikhona kakade. 

Amasethingi

Konke okudingeka ukwenze ukuze wabelane ngefayela ku-Excel kusengxenyeni ethi Ukwabelana Ngencwadi, engatholwa ngokuya kuthebhu ethi Buyekeza.

Iwindi lizovela elinamathebhu amabili. Sinentshisekelo kweyokuqala, evula ngokuzenzakalelayo. Kudingeka sikhethe ibhokisi eliseduze kwento emakwe esithombeni-skrini ngonxande obomvu. Ngayo, senza abasebenzisi abaningi bakwazi ukuphatha idokhumenti.

Ngemva kokuvula ukufinyelela kokuhlela, sidinga ukukumisa. Ukuze wenze lokhu, vula ithebhu yesibili.

Ngemva kokufaka imingcele, siqinisekisa izenzo zethu. Ukuze wenze lokhu, chofoza kwesokunxele inkinobho "OK". Ukwabelana kungavulwa kunoma iyiphi incwadi, entsha nekhona. Esimweni sokuqala, uzodinga ukuza negama lakhe. 

Ngemva kwalokho, udinga ukulondoloza ifayela kukhompyutha yakho.

Kubalulekile! Ifomethi kufanele ibe ngendlela yokuthi ifayela lingavulwa umsebenzisi ngamunye ngenguqulo yakhe yamaspredishithi.

Ivula ifayela okwabelwana ngalo

Kufanele ulondoloze ifayela ekwabelaneni kwenethiwekhi noma ifolda elikwazi ukufinyelela ababambiqhaza abafuna ukusebenzisa ifayela. Ngemuva kokuthi inkomba isikhethiwe, kufanele sichofoze inkinobho ethi "Gcina".

Nokho, akuvunyelwe ukusebenzisa iseva yewebhu ukuze ulondoloze ifayela okwabelwana ngalo. 

Ngemva kokwenza yonke imisebenzi echazwe ngenhla, udinga ukuhlola ukuthi kungenzeka yini ukuxhuma abanye abantu. Ukuze wenze lokhu, vula ithebhu "Idatha" futhi uthole into ethi "Connections" ngezansi kwayo ngqo. Uma uchofoza kuyo, uzokwazi ukushintsha izixhumanisi noma izixhumanisi. Uma ingekho inkinobho ehambisanayo, awekho amafayela ahlobene.

Okulandelayo, ithebhu ethi "Isimo" iyavula, ngosizo okungenzeka ngalo ukuhlola ukuxhumana. Iqiniso lokuthi konke kuhamba kahle lingabonwa ngokuba khona kwenkinobho ethi "KULUNGILE".

Ungayivula kanjani i-Excel Workbook eyabiwe

I-Excel futhi ikuvumela ukuthi uvule ibhuku lokusebenza okwabelwana ngalo. Ukuze wenze lokhu, udinga ukuchofoza inkinobho ye-Office. Uma kuvela iphaneli ye-pop-up, sidinga ukukhetha into ethi "Vula" bese sikhetha ibhuku elizosetshenziselwa ukwabelana. Ngemva kwalokho, phinda uchofoze inkinobho ye-Office, bese uvula iwindi elithi “Izinketho ze-Excel”, elingatholakala ngezansi.

Ngakwesokunxele kwewindi elivelayo, uzokwazi ukukhetha isigaba sezilungiselelo, kodwa sinentshisekelo kweyokuqala, equkethe imingcele ejwayelekile kakhulu.

Okulandelayo, hamba entweni "Isilungiselelo somuntu siqu", lapho udinga ukucacisa idatha evumela ukuthi ukuhlunga abasebenzisi - igama lomsebenzisi, isiteketiso.

Ngemva kokwenza le misebenzi, kuyenzeka ukuthi uhlele ulwazi olukudokhumenti noma wengeze idatha ethile. Ungakhohlwa ukulondoloza izinguquko zakho ngemva kokuzenza.

Lokhu ngezinye izikhathi kungabangela izinkinga uma ulondoloza. Isibonelo, ukwabelana kutholakala kuphela ekuvuleni kokuqala, futhi uma uzama ukuvula idokhumenti okwesibili, uhlelo luphonsa iphutha. Lokhu kungenzeka ngenxa yezizathu ezilandelayo:

1. Uma abahlanganyeli abambalwa bafaka idatha ngesikhathi esisodwa kuseli efanayo. Noma iyiphi enye ingxenye.
2. Ukukhiqiza i-changelog eyenza incwadi yokusebenzela ikhule ngosayizi. Lokhu kuholela ezinkingeni.
3. Umsebenzisi ususiwe ekwabelaneni. Kulokhu, ukulondoloza izinguquko ngeke kusebenze kukhompyutha yakhe kuphela. 
4. Insiza yenethiwekhi igcwele kakhulu.

Ukuze ulungise inkinga, udinga ukuthatha izinyathelo ezilandelayo:

1. Susa i-changelog noma sula ulwazi olungafuneki kuyo. 
2. Susa ulwazi olungafuneki ngaphakathi kwedokhumenti ngokwayo.
3. Qala kabusha ukwabelana. 
4. Vula idokhumenti ye-Excel kwesinye isihleli sehhovisi, bese uyigcina futhi ngefomethi ye-xls.

Yiqiniso, ezinguqulweni zakamuva leli phutha alenzeki kaningi njengakwezindala.

Ungawubuka kanjani umsebenzi welungu

Phakathi nomsebenzi ohlanganyelwe, udinga ukuqapha njalo ukuze omunye wabahlanganyeli angoni okuthile. Ngakho-ke, udinga ukufunda ukuqonda ukuthi yiziphi izenzo ezenziwa omunye wabo. Ukuze wenze lokhu, kufanele wenze lezi zinyathelo ezilandelayo.

1. Yiya kuthebhu ethi "Buyekeza", bese uthola into ethi "Ukulungisa". Kumenyu, khetha into ethi "Khetha ukulungisa".
   

   

2. Okulandelayo, kuzovela iwindi lapho ungathola khona ukuthi yiziphi izinguquko ezenziwe ngabasebenzisi. Lolu hlu lwenziwa ngokuzenzakalelayo. Ungaqinisekisa ukuthi lokhu kunjalo ngempela ngokubheka ibhokisi lokuhlola eduze kwento ehambisanayo kuleli bhokisi lengxoxo.
   

   

    Kulokhu, lezo zinguquko kuphela ezenziwe kusukela ekugcinweni kokugcina zizoboniswa ohlwini olusekhoneni eliphezulu kwesokunxele. Lokhu kwenzelwa ukuthi kube lula, ungakwazi njalo ukubona ukuhlela kwangaphambilini kujenali.

3. Umhlanganyeli ngamunye unikezwa umbala othize, ongaqonda ngawo ukuthi ubani owenze izinguquko. Amalebula asekhoneni eliphezulu kwesokunxele. Ungakwazi futhi ukusetha izinguquko zokulandelela ngesikhathi, umsebenzisi othile noma ngebanga elithile, futhi ukhubaze isibonisi sabo.
   

   

4. Lapho uzulazula phezu kweseli elinophawu olunjalo, kuvela ibhulokhi elincane ongakwazi ukuqonda kulo ukuthi ubani owenze izinguquko.
   

   

5. Ukuze wenze izinguquko emithethweni yokubonisa izilungiso, udinga ukubuyela efasiteleni lezilungiselelo, bese uthola inkambu ethi "Ngesikhathi", lapho ungasetha khona isiqalo sokubuka izinguquko. Okusho ukuthi, isikhathi lapho ukulungiswa kuzoboniswa khona. Ungasetha isikhathi kusukela ekugcinweni kokugcina, usethe ukuthi ubonise zonke izinguquko zaso sonke isikhathi, ezingabukwanga ngokukhethekile, noma ucacise idethi ezizokhonjiswa ngayo.
   

   

6. Ungakwazi futhi ukulawula ukuboniswa kwezilungiso ezenziwe yilungu elithile kuphela.
   

   

7. Usebenzisa inkambu ehambisanayo, ungasetha ububanzi beshidi lapho kuzongena khona izenzo zomyalo.

Ungakwazi futhi ukwenza ezinye izinguquko ngokubheka amabhokisi okuhlola afanelekile ezindaweni ezifanele.

Uhlu lwezinguquko alusona isisindo esifile. Umsebenzisi oyinhloko angabuyekeza ukuhlelwa kwabanye ababambiqhaza, akuqinisekise noma akunqabele. Kwenziwa kanjani?

1. Yiya kuthebhu ethi “Buyekeza”. Kukhona imenyu "Yokulungisa" lapho umsebenzisi angaphatha khona ukulungisa. Kuphaneli ye-pop-up, udinga ukukhetha inketho ethi "Yamukela / yenqaba ukulungiswa", ngemuva kwalokho kuzovezwa iwindi lapho kuboniswa khona izilungiso.
   

   

   

2. Ukukhethwa kokuhlela kungenziwa ngokuya ngemibandela efanayo njengoba kuchazwe ngaphambili: ngesikhathi, ngomsebenzisi othile, noma ngaphakathi kwebanga elithile. Ngemva kokusetha amapharamitha adingekayo, cindezela inkinobho ethi KULUNGILE.
3. Okulandelayo, zonke izinguquko ezihlangabezana nemibandela ezisethwe esinyathelweni sangaphambilini zizoboniswa. Ungavumelana nokuhlela okuthile noma ukunqabe ngokuchofoza inkinobho efanelekile ezansi kwewindi. Kuyenzeka futhi ukuthi inqwaba yamukele noma yenqabe izinguquko.
   

   

Manje ukulungiswa okudingekayo kushiywe, futhi okungeziwe kususiwe.

Ungamkhipha kanjani umsebenzisi kufayela le-Excel

Ngokuhamba kwesikhathi kuba nesidingo sokususa abasebenzisi ekubhaleni ngokubambisana. Kungaba nenani elikhulu lezizathu: banikezwa omunye umsebenzi, umhlanganyeli waqala ukwenza ukuhlela kusuka kwenye ikhompyutha, njalonjalo. Ukwenza lo msebenzi ku-Excel akunzima nhlobo.

Okokuqala, vula ithebhu "Buyekeza". Kukhona iqembu elithi "Izinguquko", lapho kukhona inketho "Ukufinyelela encwadini".

Ngemva kwalokho, iwindi elifanayo esilibone ngaphambili lizovela esikrinini. Uhlu lwabo bonke abantu abangakwazi ukwenza izinguquko kuthebula lungatholakala kuthebhu ethi Hlela. Ukuze ususe umsebenzisi esingamdingi okwamanje, udinga ukukuthola kulolu hlu, ukhethe ngokucindezela inkinobho yegundane engakwesokunxele bese uchofoza inkinobho ethi "Susa", etholakala ngezansi.

Okulandelayo, i-Excel izoxwayisa umsebenzisi ukuthi izilungiso ezenziwe yilo mhlanganyeli zingase zingalondolozwa uma okwamanje enza izinguquko encwadini yokusebenzela. Uma uvuma, bese uchofoza okuthi “KULUNGILE”, futhi umsebenzisi ngeke kusabiwa.

Unganciphisa kanjani ukusetshenziswa kwencwadi yokusebenzela okwabelwana ngayo

Indlela engcono kakhulu yokukhawulela ukusetshenziswa kweleja okwabelwana ngayo ukususa umsebenzisi. Uma lokhu kungafaneleki, ungasetha ilungelo lokubuka noma lokuhlela ibhuku ngumhlanganyeli othile.

Sekushiwo lokho, kubalulekile ukukhumbula ukuthi eminye imikhawulo yakhelwe ekwabelaneni ngokuzenzakalelayo. Ziye zachazwa ngenhla. Masibakhumbule, ngoba ukuphindaphinda kungumama wokufunda.

1. Akuvunyelwe ukwenza amathebula ahlakaniphile abuyekeza idatha ngokuzenzakalelayo futhi abe nezinye izici eziningi.
2. Awukwazi ukuphatha imibhalo. 
3. Kunomkhawulo owakhelwe ngaphakathi ekususeni amashidi, ukuxhuma noma ukunqamula amaseli.
4. Yenza yonke imisebenzi kudatha ye-XML. Ngamagama alula, kunemikhawulo ekuhlelweni kwenani elikhulu ledatha, okuhlanganisa nokuhlela amalungu afanayo awo. I-XML ingenye yezinhlobo zamafayela ezingacacile kakhulu zabaqalayo, kodwa ilula ngempela. Ngalolu hlobo lwefayela, ungadlulisela idatha ngokwenza izinguquko zeqoqo kudokhumenti. 

Kalula nje, ukubhala ngokubambisana kukuvumela ukuthi wenze imisebenzi ejwayelekile kudokhumenti, kodwa izinketho eziningi zobungcweti zitholakala kumuntu oyedwa kuphela. Lokhu kungenxa yokuthi izinguquko ezifanayo zama-macros noma iqoqo le-XML zinzima kakhulu ukuzibuyisela emuva. 

Ukukhubaza ukwabelana bese ukuphinda kunikwe amandla kungenye indlela yokukhawulela lokho abasebenzisi be-Excel abangakwenza. Ungenza izinguquko ezidingekayo ngokwakho, ngaleyo ndlela uncishe abanye abantu ithuba lokuhlela okuthile.

Ukuze wenze lokhu, kufanele ulandele lezi zinyathelo.

1. Vula ithebhu ethi “Buyekeza”, hamba entweni ethi “Ukulungisa” bese ukhetha into ethi “Gqamisa izibuyekezo” kumenyu ye-pop-up.
2. Ngemuva kwalokho, kuvela iwindi lapho udinga ukususa ukumaka amabhokisi eduze kwezinto "Umsebenzisi" kanye "Kububanzi".
3. Ngemuva kwalokho, kuvela i-changelog, edingekayo ukuze wenze isipele idatha.

Ngemva kwalokho, ungavala ukwabelana. Ukuze wenze lokhu, kuthebhu efanayo kuribhoni, khetha into ethi “Finyelela encwadini” bese ususa ukumaka okuthi “Vumela abasebenzisi abaningi ukuthi balungise ifayela.”

Yilokho nje, manje ukwabelana kukhutshaziwe.

Ngakho-ke kulula kakhulu ukusetha ukubhala ngokubambisana ku-Excel. Yebo, kunemikhawulo ethile engakuvumeli ukuthi usebenzise idokhumenti ngokugcwele. Kodwa zixazululwa kalula, kwanele ukuvala ukwabelana okwesikhashana, bese uyivula lapho izinguquko ezidingekayo zenziwe.