Ungaliguqula kanjani iZwi libe yi-Excel

iZwi y Excel Zimbili izinhlelo zokusebenza ezisetshenziswa kakhulu I-Microsoft Office ukubhala amafayela nokuhlanganisa nokulungisa idatha namagrafu. Kusukela ekudalweni kwayo ngawo-80, kube nezinkampani eziningi ezidale izinguqulo ezifanayo ngokusekelwe kulawa mamodeli amabili ngenxa yosizo lwazo olukhulu mayelana nokuphathwa kwedatha nokuphathwa kwamafayela. Lawa amathuluzi iningi labantu abavamise ukusebenzisa ikhompuyutha abakwaziyo ukuyiphatha nokuyisebenzisa, ngokwezinga elikhulu noma elincane. Ngaphezu kwalokho, akhona cishe kuzo zonke izinkampani ezinefomethi yedijithali.

Kukhona ngokungangabazeki umehluko phakathi kokubili kusukela, ngenkathi I-Word uhlelo lokusebenza lokubhala nokudala imibhalo yombhalo, I-Excel isetshenziswa kakhulu ukwakha amathebula, amagrafu, kanye nokucubungula ama-akhawunti nokwenza izibalo zezibalo.. Nakuba okwamanje zombili zinemisebenzi ethuthuke kakhulu kunenguqulo yazo yasekuqaleni ukuze ukwazi ukuthola okuningi kumafayela akho. Kulesi sihloko sizokukhombisa ukuthi ungakwenza kanjani guqula amafayela ngefomethi ye-Word abe yi-Excel ukuze ukwazi ukudlulisa idatha namagrafu ngendlela elula kakhulu esikhundleni sokuthi udale idokhumenti kusukela ekuqaleni. Uma unentshisekelo kulokhu, hlala ufunda nathi futhi sizokunikeza amathiphu okusebenzisa lezi zinhlelo zokusebenza ngokugcwele.

Guqula iZwi libe yi-Excel

Kunezindlela ezimbalwa zokudlulisa idatha isuka kufomethi ye-Word iye kuspredishithi se-Excel. Kodwa-ke, kuye ngokuthi yiluphi uhlobo lwedokhumenti ofuna ukuyiguqula nokuthi ufuna ivele kanjani ekugcineni eshidini lakho le-Excel, kubalulekile ukuthi ukhethe inketho eyenza lo msebenzi ube lula kuwe. Ukukusiza kulo msebenzi, ngezansi sizokwethula i izindlela eziyinhloko zokuguqula amafayela akho e-Word abe yi-Excel.

ngenisa idatha

Enye yezindlela ezisheshayo newusizo kakhulu esinazo zokuguqula amadokhumenti ombhalo abe ifomethi yesipredishithi yile ngenisa idatha ngokuqondile efayeleni lethu le-Word. Lena inqubo abantu abambalwa kakhulu abazi ngayo, kodwa lokho ngokungangabazeki izokwengeza isikhathi sakho somsebenzi sibe phezulu uma uvamise ukwenza lezi zenzo njalo. Sikubonisa isinyathelo ngesinyathelo ukuthi ungakwenza kanjani ngendlela elula kakhulu.

1. Vula idokhumenti ye-Word esifuna ukuyiguqula bese uchofoza inketho «Faka kungobo yomlando«. Bese ukhetha inketho «kusuka kumenyu yokudonsela phansiThumela«. Lapha kuzodingeka sichofoze ku-«Shintsha uhlobo lwefayela»bese ukhetha «Umbhalo wethafa".
2. Uma idokhumenti yethu isilondoloziwe njengombhalo ongenalutho kuyodingeka senze vula ifayela le-excel lapho sifuna ukufaka khona lo mbhalo.
3. Sikhetha kumenyu ephezulu «Idatha«, bese sichofoza ku-"Thola idatha > kumbhalo/CSV"ekhoneni eliphezulu lesokunxele.
4. Lapha kuzodingeka sibheke ifayela le-Word esiligcine njengombhalo ongenalutho bese sichofoza kulo «ukungenisa»ukuze sibe yispredishithi.
5. Ngaphambi kokuguqula ifayela kuzovela ukubuka kuqala wemigqa namakholomu ukuze sikwazi ukuhlela ifayela ngaphambi kokuligcina.
6. Uma le nqubo isiqediwe, umbhalo obhalwe nge-Word uba yithebula lemigqa namakholomu ku-Excel. Kamuva ungayihlela futhi wengeze noma ususe idatha.

Kungenzeka ukuthi phakathi nale nqubo ulwazi alubekwanga kahle noma alusatshalaliswa ngendlela ebesiyifuna ngayo, ngakho kuyathakazelisa ukwenza le nqubo izikhathi eziningana ukuze sifinyelele idatha ngendlela esiyithandayo.

Guqula ifomethi ye-Html

Enye indlela esingayisebenzisa ukuguqula idokhumenti yombhalo ibe isipredishithi yile usebenzisa ifomethi ethi .html. Mhlawumbe ilula kunendlela yangaphambilini njengoba imigqa namakholomu abekwe kahle futhi ayalwa. Ukuze senze lokhu kuzodingeka silandele izinyathelo ezilandelayo.

1. Into yokuqala esizoyenza vula idokhumenti yegama ukuthi sifuna ukuguqula futhi sihlole ukuthi ilungile futhi ihleleke kahle.
2. Ngezansi kwalokho sizoyiguqulela kufomethi yewebhu, okungukuthi, ku-.html. Ukwenza lokhu sichofoza ku- «Ifayela > Londoloza Njenge > .html»futhi sikhumbula indawo lapho siyigcine khona.
3. Sivula iMicrosoft Excel bese ukhetha kumenyu ethi «Ifayela> Vula«. Lapha kufanele sivule idokhumenti ye-.html esiyilondoloze ngaphambilini.
4. Uma lokhu sekwenziwe, isipredishithi esisha sizovuleka ngolwazi oluqukethwe eZwini lethu lokuqala ngefomethi yemigqa namakholomu.

Ikakhulukazi, le ndlela ilula kakhulu ukuhlela ngisho nokwengeza ulwazi olusha kunokwengeza ifayela njengombhalo ongenalutho, njengoba ulwazi luzokopishwa nje kube sengathi uzibhalele wena.

faka into

I-Microsoft Excel inikeza amathuba okuthi faka imidwebo, izithombe ngisho namadokhumenti ombhalo ngokuqondile kusipredishithi. Lokhu akuveli kufomethi yegridi, kodwa kunalokho Zinamathiselwe njengokungathi isithombe ukugcwalisa ispredishithi. Ngaphezu kwalokho, kuwumsebenzi olula kakhulu njengoba ngeke kudingeke ukuthi siguqule amafomethi noma sihlele ishidi kamuva ukuze sibeke imigqa namakholomu, ngakho-ke sizokonga isikhathi esiningi. Ngakolunye uhlangothi, umbhalo owunamathiselayo ngefomethi ethi .doc noma .docx uzovela njengesithombe esimboziwe futhi ngeke ukwazi ukudlala ngaso njengoba kwenzeka ezimeni zangaphambilini.

1. Ukuze wenze lokhu, kuzodingeka gcina idokhumenti yakho ye-Word ngefomethi ethi .doc noma .docx, okungukuthi, njengoba igcinwa ngokuzenzakalelayo kusuka kuhlelo lokusebenza.
2. Bese uvula ispredishithi se-Excel ofuna ukungenisa kuso ifomethi yombhalo.
3. Khetha kwimenyu ephezulu «Faka«. Lapha kuzodingeka sichofoze inketho «Umbhalo»kumenyu ephezulu kwesokunxele.
4. Izinketho ezihlukene zizovela futhi sikhetha «Into«. Uma lokhu sekwenziwe ungakwazi khetha ifomethi ogcine ngayo idokhumenti yakho umbhalo bese uwukhetha kusihloli sefayela. Uma unenkinga yokuthola ifayela, sincoma ukuthi uliguqulele kulo PDF, njengoba ngezinye izikhathi ivame ukudala izinkinga.
5. Ngalokhu sizoba nefayela lethu elingenisiwe kugridi.

Kopisha bese unamathisela

Indlela elula yokuguqula amafayela ethu e-Word abe yi-Excel kopisha umbhalo esithakaselayo futhi sikunamathisele ngqo kumigqa namakholomu esiwafunayo kusipredishithi. Ngaphandle kokungabaza lokhu kuyinto wonke umuntu azi ukuthi kwenziwa kanjani, kodwa futhi kuthatha isikhathi eside kakhulu kunanoma yiziphi izinqubo esizichazile ngenhla.

Ukwenza lokhu ungakhetha imishwana noma amagama ofuna ukuwafaka futhi usebenzise imiyalo Kopisha "Ctrl + C" y Namathisela u-"Ctrl + V" ukuyingenisa endaweni oya kuyo. Ungakwenza futhi lokhu ngokukhetha ngekhesa, ngokwenza Qhafaza kwesokudla bese uchofoza ku kopisha futhi/noma unamathisele. Ungathola ulwazi olwengeziwe ukuze uthole okuningi kumaspredishithi akho e-Excel kweyethu ikhasi.