How kutendeutsa "Excel" mu "Shoko" ndiEzekieri

Chero achiputa muhofisi Suite kubva Microsoft anoziva kuti dzinokosha zvirongwa Shoko uye Excel akasiyana zvikuru zvakasimba uye magwaro zvakananga akazaruka zvakasikwa chimwe chirongwa neimwe zvisingaiti, sezvo "Shoko" kupfuura chinyorwa mupepeti, kunyange rinogona kushanda mamwe marudzi mashoko uye "Excel" akagadzirirwa kushanda matafura uye Masvomhu. Kunyange zvakadaro, mubvunzo sei kutendeutsa gwaro "Ward" mu "Excel" kana ndiEzekieri, kunokwanisika nokushandisa chinokosha date imupota mabasa. Funga zvose zvavanogona. Nechinyoreso algorithm nezviito, hazvina kuoma kugadzirisa dambudziko iri.

How kutendeutsa "Excel" mu "Shoko" ndiEzekieri: zvinokosha

Sezvo mapurogiramu siyana pakati munhu zvakakwana oneka kuti anoishandisa kazhinji chinovapo dambudziko date kutendeuka. Kunyange paaishandisa nyore nzira inofungidzirwa kuti vose zviridzwa vanofanira zvakafanana, nokuti kupinza zvinhu mamiriro avhuniwe kana kuisa.

Asi mafomu aya panewo pamungawirirana - tafura. mamiriro acho ezvinhu nyore navo. Kana iwe kupinza mashoko kubva muShoko, hazvina haruzvitsvakiri zvakadai zvakaoma sezvo Ivan Kuchin rokuchinja, saka chepakutanga pachayo ndiyo dambudziko sei kutendeutsa "Excel" mu "Shoko" zvizere mashoko chivako beginners zhinji kazhinji sezvisingakundiki.

Nzira iri nyore

Chokutanga, funga nyore nzira, inova vemunharaunda paIndaneti inonzi "kopi-namatidza" (kuwadzana yematemu Chirungu kutevedzera namatidza, kana kupfuura kungoti, - "kopi" - "namatidza").

Chokwadi, mubvunzo sei kutendeutsa munhu "Shoko" faira mu "Excel" iyi chinyakare nzira inogona kugadziriswa. Zvisinei, pane anofanira kunzwisiswa pachena kuti musimboti ichi, panongova kopi chinyorwa data, vari Shoko rinogona chete rakapinzwa chete Excel muchitokisi. Kana uchida kuisa chinyorwa muzvitokisi zvakasiyana vanofanira kutevedzera rwezuva zvimedu.

Excel mashoko muShoko nenzira iyi kunogona akaiswa Zvisinei, ivo zvichakurukurwa vari tafura, uye kwete nguva dzose ane Excel pepa Data anogona kukodzera papeji Shoko. Naizvozvo, nzira iyi kazhinji isingagamuchiriki.

Tiri kushanda matafura

Sezvo tafura "Ward" exchange kuti "Excel"? Pane zvakawanda zvaunogona kuita. Kubva bvunzo cheShoko ekisipoti Data kuna Excel anoitwa nyore chaizvo pane vakutarisire.

In nyore nyaya, iwe anongoti sarudza tafura Shoko, kutevedzera mashoko kune clipboard namatidza kuva Excel. mashoko All vachange rwoga richiparadzirwa mhiri masero, sezvinoitwa yapfuura mamiriro. Asi zvino User ari kumirira vaizoshamiswa bhowa. Somuenzaniso, mune mbiri masero nedzimwe data, izvo zvinofanira aenzane tsanangudzo mukuru. Tafura Shoko, kuti arege kupinda kukosha kaviri, masero ikashandiswa. Asi kana iwe pinza rwoga navo rwakakamukana Excel, saka kuti rondedzero kuchaita kukodzera kutanga ukoshi imwe chete. Kuti izvi zvisaitike, mune Excel inoisa parameters vanofanira kushandisa chikamu chipfuro masero zvinogona apo kuchengetedza pakutanga formatting.

Import Data "Excel" mu "Shoko"

Zvino ngationei kuti kutendeutsa "Excel" mu "Shoko." Normal kupinza nzira sezvo yatova pachena, hakusi akakodzera.

Pano, zvinotevera unyanzvi inoshandiswa. Kutevedzera mashoko kuna Excel, uye ipapo muShoko kubva faira Muterere, shandisa namatidza murayiro uye kusarudza nokusungwa kushandisa finite zvitaera neShoko 2010, kana pakaitwa bhokisi Shoko 2007 pamwe tevera kubatanidzwa. Mune nzira nokusungwa ane Excel pepa, sarudza achizviendesa «OK» bhatani.

Chimwe chidobi, izvo anobvumira kugadzirisa dambudziko sei kutendeutsa "Excel" mu "Shoko" iri kuti iri spreadsheet mupepeti kushandisa kutendeuka murayiro mundima inotaridza formatting nzira (kushandisa tabulator - kuumba chimwe partition, imwe nzvimbo - nokuti date kuparadzana ndima, etc.). Chete pashure ichi rinoumbwa uchishandisa muwedzero chinokosha muShoko.

mhedziso

Sezvinogona kuoneka kubva apa, nzira rokutendeutsa magwaro chete chikumbiro chimwe haisi kunyanya kuoma format. Pakupedzisira zvinokosha kuziva kuti pane vasina nezvenzira kuti anobvumira Somuenzaniso, kupinza tabular Data kuva chinyorwa mupepeti apo pakutanga Excel spreadsheet akaiswa kuva chinhu kwakajeka. In Pfungwa iyi, mubvunzo kuchaita rakapinzwa tafura haisi editable uye basa pamwe mashoko akadaro hazvishandi. Zvine musoro kunze zviitiko apo yekupindurwa ruzivo haina inopiwa pakutanga. Asi magadzirirwo ari kuchinjwa rimwe date mhando mumwe achishandisa nyore zvishandiso, kuratidzwa pamusoro apa, zvakakodzera chero user. Oh, uye havatendi vanoti kuti izvi mhando tishandurwe kunogona kuitwa vachishandisa converters. Zvirongwa zvakadaro havapo. Uye kana paine, zviri chinyakare kwazvo, iro zvaaida mugumisiro haingasviki kuzadzisa.