Shoko kuExcel shanduko. Maitiro ekushandura faira reIzwi kuExcel - 4 nzira

Kazhinji, vashandisi vanofanirwa kuendesa chikamu cheruzivo kubva kuMicrosoft Word gwaro kuenda kuExcel fomati kuitira kuti gare gare vagokwanisa kuita mamwe mabasa neiyi data. Nehurombo, basa iri rinoda rimwe basa, tenda Mwari, kwete rakakura kwazvo, kana iwe ukatevera kurudziro yakapihwa mune ino chinyorwa.

Chii chichadiwa? Chekutanga pane zvese, iyo Microsoft Excel application pachayo, pamwe neakasarudzika masevhisi epamhepo anoita kuti kutamisa kuve nyore uye nekukurumidza. Ngatitarisei zvakanyanya nzira dzese dzinogona kushandura faira mu doc(x) fomati kuita xls(x).

Shandura iro Shoko gwaro kuExcel

Dzimwe nzira dzakatsanangurwa haigoni kunzi kutendeuka kwakazara, dzimwe dzadzo dzakanyatsokodzera. Izvo zvinofanirwa kucherechedzwa kuti hapana nzira yakanaka yekuita basa racho, mushandisi anofanira kusarudza iyo ichave yakanakira iye.

Shoko kuExcel shanduko uchishandisa online masevhisi

Mukana wakakura wemasevhisi epamhepo nderekuti unogona kuita shanduko mumaminitsi mashoma, uye izvi hazvidi kuisirwa kwesoftware yakaoma pakombuta yako. Uyezve, izvi zvinogona kuitwa pane chero chinhu chakangwara, kubva kune yakajairwa komputa kuenda kune smartphones uye mahwendefa anomhanyisa chero inoshanda sisitimu. Kune mabasa akawanda akasiyana. Mumwe nomumwe wavo ane basa rakafanana. Isu tichatsanangura mechanics ezviito tichishandisa Convertio chishandiso, asi unogona kushandisa chero yakafanana. Kutevedzana kwezviito kunotevera:

1. Vhura browser. Izvo zvakakwana kushandisa imwe inoshanda pahwaro hweChromium injini.
2. Enda kune peji https://convertio.co/en/
3. Tumira faira kuchirongwa. Izvi zvinogona kuitwa nenzira dzakawanda:
   1. Dzvanya zvakananga pa "Kubva paKombuta" bhatani uye sarudza iyo faira nenzira yakafanana mune chero imwe chirongwa.
   2. Dhonza faira kubva pafolda kuenda kuchirongwa neyakajairwa mbeva kufamba.
   3. Tora mafaera kubva kuGoogle drive kana Dropbox sevhisi.
   4. Shandisa chinongedzo chakananga kudhawunirodha faira.
4. Tichashandisa nzira yekutanga. Dzvanya bhatani re "Kubva kombiyuta" uye bhokisi rehurukuro richazarura ratinofanira kusarudza faira yatiri kufarira.
5. Mushure mekunge tasarudza gwaro rinoda kushandurwa kuita Excel fomati, chirongwa chinokuita kuti usarudze zvakananga rudzi rwefaira raunoshandura. Iwe unofanirwa kudzvanya pane iyi menyu uye sarudza yakakodzera mhando mumenyu kana kushandisa yekutsvaga.
6. Mushure mezvose zvigadziriso zvaitwa, tinya pane orenji "Shandura" bhatani, iro rinotanga maitiro aya.

Inongosara chete kudhawunirodha faira iri nenzira imwechete yekuita chero imwe kurodha kubva paInternet.

Kushandura Shoko kuExcel kuburikidza neTatu Bato Zvishandiso

Sezvo mutemo, masevhisi akadaro epamhepo ane miganhu pahuwandu hwemafaira anogona kugadziriswa mukati meimwe nguva. Kana iwe uchida kugara uchishandura mafaera kuti aite fomati yespredishiti, zvinokurudzirwa kuisa nyanzvi software pakombuta yako. Imwe yakadaro ndeye Abex Shoko kune Excel Converter. Iyo interface ine intuitive. Naizvozvo, chirongwa ichi chiri nyore kudzidza. Mushure mokunge tazarura, hwindo rakadaro richaonekwa pamberi pedu.

Isu tinofanirwa kudzvanya bhatani re "Wedzera Mafaira", uye hwindo rimwe chete richazaruka pamberi pedu senge nzira yapfuura. Mushure mekusarudza faira, tinoda kuseta iyo yakabuda faira fomati pazasi pehwindo. Kana uchida, iwe unogona zvakare kugadzirisa iyo folda iyo ichachengetwa mairi. Kushandura kune yekare uye itsva faira mhando iripo. Mushure mezvirongwa zvatsanangurwa, tinya "Shandura".

Inoramba ichingovhura faira mushure mekunge kutendeuka kwapera.

Shandura Shoko kuExcel kuburikidza neAdvanced Copy

Iyi nzira inoita kuti zvikwanise kushandura nemaoko kubva kuIzwi kuenda kuExcel fomati uye panguva imwechete pre-kugadzirisa iyo yekupedzisira kuratidzwa kwedata. Kutevedzana kwezviito kunotevera:

1. Vhura faira inodiwa.
2. Baya bhatani kuti uratidze mavara asingadhindke.
3. Bvisa ndima dzisina chinhu. Iwo anooneka zvakajeka mushure mekubatidza kuratidzwa kwemavara asina kudhinda.
4. Sevha faira semavara akajeka.
5. Muhwindo rinoonekwa, tinya OK uye vhura Excel.
6. Mushure meizvozvo, kuburikidza ne "Faira" menyu yeExcel, vhura iyo yakachengetwa mameseji faira.
7. Tevere, tichishandisa iyo text import wizard, tinoita zviito zvinopihwa nechirongwa. Mushandisi anogona kufanoona tafura. Mushure mekuita zvigadziriso zvinodiwa, tinya bhatani re "Pedzisa".

Iyo text file yava muspreadsheet format.

Izwi kuExcel shanduko kuburikidza nekukopa kuri nyore

Chinetso chikuru mukushandura fomati imwe kuenda kune imwe misiyano yakakura muchimiro. Kana iwe ukaedza kukopa data kubva mugwaro rezvinyorwa muspredishiti, ndima imwe neimwe ichaiswa pamutsara wakasiyana, izvo zvisiri nyore nguva dzose. Hongu, uye mamwe mafomati angangoda imwe nguva nesimba. Zvisinei, nzira iyi inogonawo. Kuti ushandise nzira iyi, unofanirwa kuita zvinotevera:

1. Vhura gwaro ratinoda kushandura kuExcel.
2. Sarudza mavara ese nekudzvanya kiyi musanganiswa Ctrl + A.
3. Mushure mazvo, kopira chinyorwa ichi. Izvi zvinogona kuitwa uchishandisa Ctrl + C kiyi musanganiswa, iyo yemukati menyu, kana nekutsvaga yakakosha bhatani pane iyo toolbar.
4. Tevere, vhura nyowani Excel spreadsheet uye tinya pane sero yatinoisa ichi chinyorwa. Izvi zvinogona zvakare kuitwa nenzira nhatu: kushandisa kiyi musanganiswa Ctrl + V, bhatani hombe riri kuruboshwe chaiko kweKumba tebhu, kana nekudzvanya pane yakakosha bhatani mune yemukati menyu.
5. Mushure meizvozvo, kutumira mameseji kunogona kunzi kwakabudirira. Tinoona kuti, sezvinotarisirwa, ndima imwe neimwe inotevera inotanga pamutsara wakasiyana. Tevere, unofanirwa kugadzirisa chinyorwa ichi zvichienderana nezvaunoda.

Ehe, iyo yakanyanya nyore nzira ndeye kushandisa yakakosha online masevhisi. Asi munhu wese wepamberi anoziva nzira dzese dzinobvira uye anosarudza iyo inokodzera imwe mamiriro.