Nyora Links for Data, Charts, uye Zvigadzirwa mu Excel, Shoko, PowerPoint

01 ye 02

Paste Links pakati pe Excel neShoko Files

Pasting Links Overview

Mukuwedzera pakunyora uye kudhonza data kubva kune imwe Excel file kuenda kune imwe kana kuIndaneti yeMicrosoft Word, unogonawo kuumba ukama pakati pefaira mbiri kana mabhuku ebasa anozovandudza data yakakopiwa mufaira rechipiri kana data yepakutanga ichichinja.

Zvinogonawo kugadzira kubatana pakati pechati iri mune rimwe bhuku reku Excel uye PowerPoint slide kana Dhiyabhorosi.

Muenzaniso unoratidzwa mumufananidzo pamusoro apa apo mashoko kubva kuEfcel file akabatanidzwa kune rimwe gwaro reShoko rinogona kushandiswa mumushumo.

Mumuenzaniso, dheta yacho inopindirwa muchigwaro setafura, iyo inogona kuenzanisirwa kuburikidza neshoko rose rekufambisa.

Izvi zvinoshandiswa kuburikidza nekushandisa pakanyora chikwata chinosarudza. Nokuda kwekubatanidza kushanda, faira ine data yepakutanga inozivikanwa seyo faira faira uye yechipiri faira kana bhuku rebhuku rinoshandisa fomu yekubatanidza ndiyo iyo nzvimbo yekuenda .

Kubatanidza Mamwe Cells muEexcel neFormula

Zvisungo zvinogonawo kusikwa pakati pemasero ega ega ega eEbook mabhuku ekushandisa achishandisa fomu. Iyi nzira inogona kushandiswa kugadzira mararamiro anorarama mazwi kana data, asi inoshanda chete kumasero masere.

1. Dzvanya pane sero mubhuku rebasa rinosvika uko data inofanira kuiswa;
2. Dhinda chiyero chakaenzana ( = ) pakibhodi kuti utange rondedzero;
3. Dzokera kubhuku rebasa rinobva , tsvaga pane sero rine data kuti ibatanidzwe;
4. Dhinda pikicha yoKuisa pabhobhoyo - Excel inofanira kudzokera kumaseri ekuenda kune imwe data yakabatana inoratidzwa musero yakasarudzwa;
5. Kushidzira pamusoro pechirongwa chekubatanidza kucharatidza chibatanidza chekubatanidza - chakadai = [Bhuku1] Sheet1! $ A $ 1 mubhadharo yepamusoro pane pepa pepaji .

Cherechedza : dollar inopenya muchikamu chechitsauko - $ A $ 1 - inoratidza kuti iyi ndiyo mhedzisiro yakakwana.

Nyora Link Options muShoko uye Excel

Paunenge uchinge uchinge wakabatanidza deta, Shoko rinokubvumira kuti usarudze kana kuenzanisa data yakabatanidzwa uchishandisa zvirongwa zvemazuva ano kune mamwe mavara kana kuenda kune mafaira. Excel haisi kupa izvi zvingasarudzwa, inongoshanda chete ikozvino mafaira ekugadzirisa munzvimbo yekufaira.

Kubatanidza Data pakati peShoko neExcel

1. Vhura bhuku rebhuku re Excel rine data kuti ibatanidzwe (iyo inotora faira)
2. Vhura faira yekuenda -ingava bhuku rebhuku reExcel kana kuti chikwata cheShoko;
3. Mufaira rekushandisa inonyanya kuisa data inogona kunyorwa;
4. Mune faira yefaira, tora paKikanda konhi paImba yebhu yebhoni - data yakasarudzwa ichakomberedzwa neMarching Ants;
5. Mune faira yekuenda , sarudza pamwe nemuvara wepinzvimbo pane nzvimbo iyo data yakabatana icharatidzwa - mu Excel chengeta pane sero iyo ichava mune imwe kona yepamusoro yakasara yedata rakadhindwa;
6. Sezvinoratidzwa mumufananidzo uri pamusoro, chengetedza museve muduku uri pasi peBhotela reKutanga paImba yebhu yebhoni kuti uzarure Nyaya Yezvokudya inodonha pasi
7. Zvichienderana nechirongwa chekuenda, pasi pekubatanidza zvinosarudzwa zvichasiyana:
   • Nokuda kweShoko, paste link inowanikwa pasi pePatani Options mumenyu;
   • For Excel, paste link iri pasi Pamwe Zvimwe Zvinyorwa mumenyu.
8. Sarudza zvakakodzera Paste Link sarudzo;
9. Nhamba yakabatanidzwa inofanira kuonekwa kune faira yekuenda .

Notes :

• Kana mafaira acho maviri akazaruka kana dhidhiyo ichivandudzwa mune faira refaira, iyo faira yekuenda inofanira kuvandudzwa pakarepo.
• Kana iyo faira yekuenda yakavharwa apo dhesi ye data inoshandurwa, iyo data mumasero ekuenda ichadzokorora nguva inotevera iyo faira inosvinudzwa.
• Kana iyo faira yavharwa iyo yakavharwa apo iyo nzvimbo yekuenda yakazarurirwa, bhokisi rekucherechedza rinogona kuzarura rinoratidzira dhidhiyo rine zvigungano kune mafaira ekunze uye kukumbira kuti Uvandudze / Usavandudza hukama.

Kuona Link Link muExcel

Nzira iyo chibatanidzwa chekubatanidza chinoratidzwa chinopesana zvishoma pakati peExcel 2007 uye gare gare shanduro yepurogiramu.

• MuExcel 2010 uye mushure mekushandurwa kwepurogiramu, kana iwe ukanyora pane zvakabatanidzwa nedzimwe nzvimbo iri kuenda kune faira, fomu yakadai se = [[Book1] Sheet1! A1 inowanikwa mubhairi yepamusoro pane pepa rekushanda;
• MuExcel 2007, iyo inogadzirisa maitiro inoratidzwa se: {= Excel.Sheet.12 | Book1! '! Sheet1!! R1C1'} mumutsetse webha.

Notes:

• Muchikamu cha2007, mhedziso yakazara yakanyorwa yakanyorwa mumutauro weR1C1 - iyo inomira mumutsara 1 chinyorwa 1 uye iyo yakaenzana neinozivikanwa zvikuru sero reference style SAS1
• Mune mibvunzo mbiri, Book1 inoratidza zita refaira rekushandisa

Kuona Link Link mu MS Word

Kuti uone ruzivo pamusoro pemashoko akabatanidzwa - akadai sefaira rekushandisa, data yakabatana, uye nzira yekuvandudza:

1. Kungofa padivi re data yakabatanidzwa kuti uzarure mamiriro ekutenderera;
2. Sarudza Chibvumirano Chekushanda Chekubatanidza> Links ... kuti uzarure Lialog dialog box muShoko;
3. Kana paine huwandu hwekubatanidza mune zvinyorwa zvino, zvese zvinowanikwa zvinowanikwa muhwindo kumusoro kwebhokisi rebhokisi;
4. Kushandura pahutano kucharatidza ruzivo pamusoro pekubatanidza ikoko pasi pehwindo mubhokisi rebhokisi.

02 of 02

Nyora Chibvumirano Pakati Pevheti mu Excel uye PowerPoint

Kubatanidza Mifananidzo neKunyora Link mu PowerPoint uye Shoko

Sezvakataurwa, kunze kwekusika kwekubatana kwemashoko emashoko kana mazano, zvinogona zvakare kushandisa hubatanidza chekubatanidza kubatanidza chati iri mune rimwe bhuku reExcel nekopi mubhuku rechipiri rebhuku kana mune MS PowerPoint kana Word file.

Pane imwe nguva yakabatanidzwa, kuchinja kune data iri mufaira rekuona kunoratidzwa mune zvose chati yekutanga uye kopi iri munzvimbo yekuenda .

Kusarudza Chinyorwa kana Kuenda Kunyoresa

Kana uchinge unobatanidza pakati pemasharuti, PowerPoint, Word, uye Excel inokubvumira kuti usarudze kana kuenzanisa chibatanidzwa chekushandisa uchishandisa mharidzo yemazuva ano inowanikwa pane imwe nzvimbo kana kuti mafaira ekuenda.

Kubatanidza Charts muExcel uye PowerPoint

Sezvinoratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unobatanidza pakati pechati mubhuku rebhuku re Excel - faira rekushandisa uye slide muhurukuro yePowerPoint - iyo nzvimbo yekuenda .

1. Vhura bhuku rebhuku rine chati inofanira kunyorwa;
2. Vhura iyo firimu inopihwa faira;
3. Muchikamu chebhuku re Excel, tora pa chati kuti uzvisarudze;
4. Dzvanya paKopi kopi paImba yebhu yebhoni mu Excel;
5. Dzvanya pane slide mu PowerPoint apo chati yakabatana icharatidzwa;
6. Mune PowerPoint, tora pamutsara muduku pasi pebhatani rekunamatira - sezvinoratidzwa mumufananidzo - kuti uzarure pasi rezasi;
7. Dzvanya paShandisa Destination Theme kana kuti Chengetedza Mifananidzo Kuisa zvidhori pakuderera pasi kuti ubatanidze chati yakananga ku PowerPoint.

Notes:

• Kana iyo mafaira maviri ane mapurati akabatanidzwa ose ari maviri akazaruka, kushanduka kune zvinyorwa zvinyorwa zvinofanira kuvandudza pakarepo mumatafa maviri.
  
• Kana uzarura hurukuro yePowerPoint ine data yakabatana, bhokisi rekucherechedza rinogona kuzarura rinoratidza kuve kwekuchengeteka kunobvunza uye kukubvunza iwe kana uchida kuvandudza data yakabatana.