Ungalivikela kanjani ishidi le-Excel

Okubaluleke kakhulu kunoma ubani owabelana nabanye ngamadokhumenti abalulekile ubumfihlo nokuvikeleka. Ngenhlanhla, ziningi izindlela zokwenza vikela amafayela ethu ngamaphasiwedi nezinye izinhlelo, kodwa ngezinye izikhathi sizodinga ukwazi ukuthi singasiphakamisa kanjani leso sivikelo, ngokuphelele noma kancane. Kule post sizobona ungalivikela kanjani i-Excel sheet, noma okungenani ingxenye ethile yayo, nokuthi kungani kuthakazelisa ukukwenza ngezikhathi ezithile.

Akwanele njalo ukwazi iphasiwedi yokukhiya ukwenza lo msebenzi. Kuyadingeka futhi ukwazi ukuthi iyini inqubo. Sizobhekana nalokho ezigabeni ezilandelayo.

Okulandelayo, sizobona ukuthi yiziphi izinyathelo okufanele uzilandele ukuze ungalivikeli ishidi le-Excel sazi iphasiwedi yokukhiya esetshenziswe ngaphambilini kanye nendlela okufanele siyilandele uma singazi ukuthi iyiphi leyo phasiwedi. Njengoba kunengqondo, esimweni sokuqala yonke into izoba lula kakhulu kuneyesibili.

Ungalivikeli ishidi le-Excel (ukwazi iphasiwedi)

Ngokusobala, ukuba negama eliyimfihlo ezandleni zethu elisetshenziswe ukubethela idokhumenti kwenza izinto zibe lula kakhulu kithi. Noma kunjalo, indlela yokuqhubeka Kuya ngokuthi iyiphi inguqulo ye-Excel esiyifakile kukhompyutha yethu..

Izinguqulo ze-Excel ngemuva kuka-2010

Kungenzeka kakhulu, iphakheji ye-Microsoft Office esiyisebenzisa njalo ibuyekezwa ngenguqulo okungenani ngemva kuka-2010. Uma kunjalo, yilokhu okumelwe sikwenze ukuze singavikeli ishidi le-Excel lazi igama-mfihlo:

1. Siqala i-Excel bese uchofoza inkinobho "Faka kungobo yomlando", etholakala kubha yamathuluzi.
2. Ngemuva sivula ifayela elikhiyiwe.
3. Asiye kuthebhu "Buyekeza".
4. Phakathi kwezinketho ezivuleka ngezansi, sikhetha eyodwa yazo "Ishidi elingavikelekile".
5. Ekugcineni, kufanele nje faka iphasiwedi futhi ishidi lizovulwa ukuze senze izinguquko okudingeka sizenze.

Kufanele kuqashelwe ukuthi kunezindlela eziningana zokukhiya noma ukuvikela ingane ye-Excel. Isibonelo, ungasetha isivikelo kuyo yonke idokhumenti noma kuphela ochungechungeni lwamaseli noma ububanzi obuthile. Uma sifuna ukuvula okuqondile (okungenzeka kuphela ezinguqulweni ezintsha ze-Excel), nakhu okumele sikwenze:

1. Okokuqala sikhetha isipredishithi esifuna ukusivikela.
2. Asiye kuthebhu "Hlola"ikakhulukazi eqenjini "Izinguquko".
3. Lapho sikhetha inketho "Vumela abasebenzisi ukuthi balungise ububanzi".
4. Okulandelayo siya esithombeni "Ububanzi buvulwe ngephasiwedi uma ishidi livikelekile" bese uchofoza inkinobho "Shintsha".
5. Kuhlaka Isihloko, sibhala igama lebanga ofuna ukulivula, ngenkathi usebhokisini elihambisana ne Amaseli sibhala uphawu olulinganayo (=) kanye nereferensi yobubanzi ofuna ukuyivula.
6. Ekugcineni, sifaka iphasiwedi bese uqhafaza "Ukwamukela".

Izinguqulo ezindala ze-Excel

Uma, nganoma yisiphi isizathu, ikhompuyutha yakho ibambekile esikhathini esedlule futhi usasebenzisa inguqulo endala ye-Excel (ngokwesibonelo, ngo-2003), izinyathelo okufanele uzilandele zihluke kancane:

1. 1. Siqala i-Excel bese uchofoza inkinobho "Faka kungobo yomlando", etholakala kubha yamathuluzi.
   2. Ngemuva sivula ifayela elikhiyiwe.
   3. Bese sikhetha inketho "Amathuluzi" futhi kumenyu ekhonjiswayo, sichofoza "Ukuvikelwa".
   4. Sakhetha ukhetho "Ishidi lokusebenzela elingavikeli".
   5. Ekugcineni, sifaka iphasiwedi ukuze uvule idokhumenti.

Ungalivikeli ishidi le-Excel (uma singazi iphasiwedi)

Kulezi zimo kukhona nezixazululo. Ngaphezu kwalokho, kulula kangangokuthi akukho okunye okunye ngaphandle kokungabaza ukusebenza kwezinhlelo zokuvikela nezokuphepha ze-Microsoft. Nazi ezinye zezindlela ezilula nezisebenza kahle kakhulu:

Groupdocs

Isixazululo esilula se-inthanethi sokungavikeli ishidi le-Excel. Okufanele sikwenze ukufinyelela iwebhusayithi ye Groupdocs futhi ulayishe kuyo idokhumenti evikelwe esingayazi iphasiwedi yayo. Bese, cindezela inkinobho ethi "Vula" noma "Vula" futhi sizothola ifayela elivuliwe, elilungele ukudawuniloda futhi.

I-Groupdocs isebenza ngokumangalisayo, futhi futhi iyashesha kakhulu, nakuba abanye abasebenzisi bengakuncomi ukuyisebenzisela imibhalo ebalulekile noma ulwazi olubucayi, njengoba kungase kube nezikhala zokuphepha.

AmaSpredishithi e-Google

Uma indlela yangaphambilini ikwenza ube nokungabaza, lena iphephe kakhulu. Singafinyelela i-Google AmaSpredishithi ebhokisini lamathuluzi esinalo ekhoneni eliphezulu kwesokudla sesiphequluli (uma sixhumeke ne-akhawunti ye-Google) noma ngokuqondile ngesixhumanisi esilandelayo: AmaSpredishithi e-Google.

Kwenziwa kanjani? Lezi yizinyathelo:

1. Esikrinini esikhulu, kufanele chofoza uphawu lokuhlanganisa ("+"), ngemva kwalokho kuvuleke ispredishithi esingenalutho esifana kakhulu ne-Excel.
2. Khona-ke kufanele siye kumenyu "Faka kungobo yomlando" futhi, phakathi kwezinketho eziqukethwe, khetha eyodwa yazo "Ukuvula".
3. Okulandelayo sichofoza ithebhu "Khulisa", etholakala kwesokudla, ukulayisha ishidi esifuna ukulivikela.
4. Ekugcineni, sibuyela ku landa lelo shidi elifanayo kumenyu ethi “Ifayela”, ngezinketho ozifunayo. Ishidi elisanda kulandwa ngeke lisaba naso isivikelo.