Lembani Zida za Data, Matima, ndi Mafomu mu Excel, Word, PowerPoint

01 a 02

Lembani Zida Pakati pa Excel ndi Mafayi A Mawu

Kupititsa Mndandanda wa Zithunzi

Kuphatikiza pa kungojambula ndi kusunga deta kuchokera ku fayilo imodzi ya Excel kupita kwina kapena ku fayilo ya Microsoft Word, mukhoza kukhazikitsa chiyanjano pakati pa mafayilo kapena mabuku ogwira ntchito omwe adzasinthidwe deta yomwe yajambula mu fayilo yachiwiri ngati deta yapachiyambi isintha.

N'zotheka kukhazikitsa mgwirizano pakati pa tchati chomwe chili mu buku la Excel ndi PowerPoint slide kapena Document.

Chitsanzo chikuwonetsedwa mu fano pamwamba pomwe deta kuchokera pa felelo ya Excel yakhala ikugwirizanitsidwa ndi chikalata cha Mawu chomwe chingagwiritsidwe ntchito mu lipoti.

Mu chitsanzo, detayi imadulidwa m'kalembedwe monga tebulo, yomwe ingakonzedwenso pogwiritsa ntchito maonekedwe onse a Mawu.

Chiyanjano ichi chimapangidwa pogwiritsa ntchito chingwe chogwiritsira ntchito. Kuti ulalo ukhale wogwira ntchito, fayilo yomwe ili ndi deta yapachiyambi imadziwika ngati fayilo yoyamba komanso fayilo yachiwiri kapena buku lothandizira lomwe lili ndi mawonekedwe oyanjanitsa ndi fayilo yopita .

Kugwirizanitsa Maselo Okhaokha ku Excel ndi Fomu

Mipangidwe ingathe kukhazikitsidwa pakati pa maselo ena m'mabuku osiyana a Excel pogwiritsa ntchito njira. Njira iyi ingagwiritsidwe ntchito popanga maulendo amoyo a ma fomu kapena deta, koma imangogwira ntchito pa maselo okhaokha.

1. Dinani mu selo m'buku lopitako komwe deta iyenera kuwonetsedwa;
2. Onetsetsani chizindikiro chofanana ( = ) pa kibokosiko kuti muyambe fomu;
3. Pitani ku gwero la ntchito, dinani selo yomwe ili ndi deta kuti igwirizane;
4. Pewani makiyi a Kulowa pa khibhodi - Excel ayenera kubwerera ku fayilo yopita komweko ndi deta yolumikizidwa yomwe ili yosankhidwa;
5. Kusinkhasinkha pa deta yolumikizidwa kungasonyeze fomu yamagwirizanowu - monga = [Book1] Sheet1! $ A $ 1 mu barra yazenera pamwamba pa tsamba .

Zindikirani : dollar zizindikiro mu selo lotanthauzira - $ A $ 1 - zikuwonetsa kuti ndilo gawo lenileni la selo.

Lembani Zosankha Zina mu Mawu ndi Excel

Pogwiritsa ntchito chiyanjano cha deta, Mawu amakulolani kuti musankhe ngati mukujambula deta yolumikizidwa pogwiritsa ntchito makonzedwe atsopano a mafayilo omwe akuchokera. Excel sakupatsani zosankha izi, zimangogwiritsidwa ntchito pokhapokha zoikidwiratu zojambula pazomwe mukupita.

Kusonkhanitsa Deta pakati pa Word ndi Excel

1. Tsegulani buku la Excel lomwe liri ndi deta kuti likhale logwirizana (fayilo yoyamba)
2. Tsegulani fayilo yopita - kaya buku la Excel kapena chikalata cha Mawu;
3. Mu fayilo yamtunduwu muwonetsetse kuti deta iyenera kukopera;
4. Mu fayilo yamtundu, dinani pazithunzi Kopanga Pakhomo la Tsamba lachitsulo - deta yosankhidwa idzazunguliridwa ndi Antsamba Oyendetsa;
5. Mu fayilo lopita , dinani ndi ndondomeko ya mouse pamalo omwe deta yolumikizidwa idzawonetsedwera - mu Excel dinani selo limene lidzakhala kumbali yakumanzere yachinsinsi ya deta yolumikizidwa;
6. Monga momwe muwonetsedwera pa chithunzi pamwambapa, dinani pamzere wang'onopang'ono pansi pa batani Panyumba pa Tsamba la Tsamba la Ribbon kuti mutsegule Zosankha Zotsitsa menyu
7. Malinga ndi pulogalamu yopita ku malo, zosakanikirana zosankha zidzakhala zosiyana:
   • Kwa Mawu, kulumikiza chiyanjano chiri pansi pa Zosankha Zolemba mu menyu;
   • Kwa Excel, kulumikiza chiyanjano chiri pansi pa Zina Zosakaniza Zosankha pa menyu.
8. Sankhani njira yoyenera Yotsatsa Link ;
9. Deta yolumikizidwa iyenera kuonekera pa fayilo yopita .

Mfundo :

• Ngati mafayilo onse atseguka pamene deta ikusinthidwa mu fayilo yamtundu, fayilo lopitako liyenera kusinthidwa mwamsanga.
• Ngati fayilo yopita kukatsekedwa pamene deta yamasinthidwe isinthidwa, deta m'maselo omwe akupita adzasintha nthawi yomwe fayilo idzatsegulidwe.
• Ngati fayilo yotsimikizika itsekedwa pamene fayilo yopita kukatsegulidwa, bokosi lodziwitse lingatsegule likuwonetsa chikalatacho chiri ndi maunjano kwa mafayi akunja akunja ndikukupemphani kuti Musinthe / Musasinthe zowonjezera.

Kuwona Makhalidwe Othandizira ku Excel

Momwe njira yothandizirayi ikuwonetserako imasiyanasiyana pang'ono pakati pa Excel 2007 ndi pulogalamu yotsatira.

• Mu Excel 2010 ndi pulogalamu yapamapeto pake, ngati inu mutsegula pazowunikirapo fayilo, fomu monga = [Book1] Sheet1! A1 ikupezeka pa barrafomu pamwamba pa tsamba;
• Mu Excel 2007, chigwirizano chogwirizanitsa chikuwonetsedwa ngati: {= Excel.Sheet.12 | Book1! '! Sheet1! R1C1'} mu bar.

Mfundo:

• Mu chiganizo cha 2007, mndandanda wa maselo olembedwa mndandanda walembedwa ndi chiwonetsero cha R1C1 - chomwe chimayimira mzere woyamba wa ndime 1 ndi chomwe chiri chofanana ndi sewero lachidziwitso cha SAS1
• Muzigawo zonse ziwiri, Book1 ikuwonetsera dzina la fayilo yoyamba

Kuwona Link Link mu MS Word

Kuti muwone zambiri zokhudza deta yolumikizidwa - monga fayilo yoyambira, deta yolumikizidwa, ndi njira yosinthidwa:

1. Dinani pazowonjezera deta kuti mutsegule zolemba;
2. Sankhani Chophatikizira Chophatikiza Ntchito> Zida ... kuti mutsegule dialog box Links mu Mawu;
3. Ngati pali zowonjezereka zokhudzana ndi chikalata chomwe chilipo, maulumikizi onse adzalembedwa pawindo pamwamba pa bokosi la dialog;
4. Kusindikiza pa chiyanjano kudzawonetsa chidziwitso cha chiyanjanochi pamunsi pazenera mu bokosi la dialog.

02 a 02

Lembani Pakati Pakati pa Makhadi mu Excel ndi PowerPoint

Kuphatikiza Malemba ndi Kuyika Link mu PowerPoint ndi Mawu

Monga tafotokozera, pambali pa kupanga chiyanjano cha deta kapena malemba, ndizotheka kugwiritsa ntchito chigwirizano chogwiritsira ntchito tchati chomwe chili mu buku limodzi la buku la Excel ndi buku lachiwiri kapena la fayilo la MS PowerPoint kapena Word.

Kamodzi kogwirizanitsidwa, kusintha kwa deta mu fayilo yoyamba kumasonyezedwa mu chithunzi choyambirira ndi kopibulo yomwe ili pa fayilo yopita .

Kusankha Chojambula Chochokera Kumalo kapena Malo

Pogwiritsa ntchito malumikizidwe, PowerPoint, Word, ndi Excel zimakulolani kuti musankhe ngati mukujambula chithunzi chogwiritsidwa ntchito pogwiritsa ntchito mitu yatsopano yopangira mafayilo.

Zolumikiza Zolemba mu Excel ndi PowerPoint

Monga momwe tawonetsera pa chithunzi pamwambapa, chitsanzo ichi chimapanga mgwirizano pakati pa tchati mu bukhu la ntchito ya Excel - fayilo ya chitsime ndikuyikapo muwonetsero wa PowerPoint - fayilo yopita .

1. Tsegulani buku lokhala ndi cholembacho kuti chikhombedwe;
2. Tsegulani fayilo yowunikira;
3. Mu bukhu lotchedwa Excel, dinani pa tchati kuti musankhe;
4. Dinani pa batani la Chithunzi Panyumba ya Tsamba ya Ribbon mu Excel;
5. Dinani pazithunzi mu PowerPoint pomwe tchati chojambulidwa chidzawonetsedwa;
6. Mu PowerPoint, dinani pamsana wawung'ono pansi pa batani la phala - monga momwe tawonetsera pa chithunzi - kutsegula mndandanda wamatsitsi;
7. Dinani pa Gwiritsirani Koyenera Kwambiri kapena Pulogalamu Yopanga Kujambula zithunzi pazithunzi zochepetsera kuti mugwirizanitse chithunzi chogwirizana mu PowerPoint.

Mfundo:

• Ngati mafayilo awiri omwe ali ndi mapulogalamu othandizira onse atseguka, kusintha kwa deta zomwe zimayambira ziyenera kusinthidwa nthawi yomweyo m'matcha onsewa.
  
• Pamene mutsegula mauthenga a PowerPoint omwe ali ndi deta yolumikizidwa, bokosi lodziwitse lingathe kutsegulira chitetezo chokhudzidwa ndikukufunsani ngati mukufuna kusinthira deta yolumikizidwa.