Namathisela Izixhumanisi Zedatha, Amashadi, namafomula ku-Excel, iZwi, i-PowerPoint

01 ngo-02

Namathisela izixhumanisi phakathi kwe-Excel namafayela e-Word

Ukudlulisela Ukubukwa Kwezixhumanisi

Ngaphezu kokumane ukukopisha nokudlulisa idatha kusuka kwefayela elilodwa le-Excel kuya kwelinye noma kwifayela leMicrosoft Word, ungenza futhi ukuxhumana phakathi kwamafayela amabili noma izincwadi zokusebenza ezizovuselela idatha ekopishiwe efayeleni yesibili uma idatha yangempela iguquka.

Kungenzeka futhi ukudala isixhumanisi phakathi kweshadi elisencwadini yokusebenzela ye-Excel kanye nesilayidi se-PowerPoint noma i-Word.

Isibonelo siboniswa esithombeni ngenhla lapho idatha evela efayeleni le-Excel ixhunywe kumqulu weZwi ongasetshenziswa embikweni.

Esikhathini, idatha idluliselwe kudokhumenti njengetafula, engabe isifomathwa ngokusebenzisa zonke izici zokufometha kweZwi.

Lesi sixhumanisi sidalwa ngokusebenzisa inketho yokuxhumanisa okunamathiselwe . Ukuxhumanisa imisebenzi yokunamathisela, ifayela eliqukethe idatha yangempela liyaziwa ngokuthi ifayela lomthombo kanye nefayela lesibili noma ibhuku lezincwadi eliqukethe ifomula yokuxhumanisa ifayela lokuphela .

Ukuxhumanisa Amaseli Angodwa E-Excel ne-Formula

Izixhumanisi zingadalwa phakathi kwamaseli ngabanye kuma-workbook ahlukile e-Excel besebenzisa ifomula. Le ndlela ingasetshenziswa ukwakha isixhumanisi esibukhoma samafomula noma idatha, kodwa isebenza kuphela amaseli angashadile.

1. Chofoza kuseli ebhokisini lokusebenzela lapho idatha ezoboniswa khona;
2. Cindezela uphawu olulinganayo ( = ) ekhibhodi ukuqala ifomula;
3. Shintshela ebhukwini lomthombo , chofoza kuseli eliqukethe idatha ukuthi lixhunywe;
4. Cindezela ukhiye wokungena kwikhibhodi - I-Excel kufanele ibuyele efonini eliya khona nedatha ehlanganisiwe ekhonjisiwe kuseli elikhethiwe;
5. Ukuchofoza idatha ehlanganisiwe kuzobonisa ifomula yokuxhumanisa - njenge = [Book1] I-Sheet1! $ A $ 1 ebhafini yefomula ngaphezulu kwephepha lokusebenzela .

Qaphela : izibonakaliso ze-dollar esitokisini se-cell - $ A $ 1 - zikhombisa ukuthi kuyinkomba yeselula ngokuphelele.

Namathisela Izinketho Zobungozi ku-Word ne-Excel

Uma udlulisa ukuxhumanisa kwedatha, i-Word ikuvumela ukuba ukhethe ukuthi ufometha idatha exhunyiwe usebenzisa izilungiselelo zamanje zamafayili omthombo noma wokuphela. I-Excel ayinikezi lezi zinketho, ivele isebenzise ngokuzenzakalelayo izilungiselelo zokufometha zamanje kwifayili yokuphela.

Ukuhlanganisa idatha phakathi kwe-Word ne-Excel

1. Vula ibhuku le-Excel equkethe idatha ezoxhunyaniswa (ifayela lomthombo )
2. Vula ifayela eliya khona - noma incwadi ye-Excel noma idokhumenti yeZwi;
3. Kufayela elivela kumthombo liqokomisa idatha okufanele ikopishwe;
4. Kufayela elivela kumthombo , chofoza inkinobho yeKopi kuthebhu yaseKhaya yebhebhoni - idatha ekhethiwe izozungezwa yizintuthwane zokuhamba;
5. Kufayela elikuyo, qhafaza nge-pointer yegundane endaweni lapho idatha exhunyiwe izoboniswa - ku-Excel chofoza kuseli elizobe likhona ekhoneni elingenhla elingakwesokunxele kwedatha edatshiwe;
6. Njengoba kuboniswe esithombeni esingenhla, chofoza umcibisholo omncane phansi kwe-inkinobho Yokunamathisela kuthebhu yasekhaya yebhande ukuze uvule izinketho zezinketho zokunamathisela.
7. Kuye ngohlelo lokuya, izinketho zokuxhumanisa okunamathiselwe zizohluka:
   • NgeZwi, unamathisela isixhumanisi sitholakala ngaphansi kwezinketho zokunamathisela kwimenyu;
   • Nge-Excel, unamathisela isixhumanisi sitholakala ngaphansi Kweminye Izinketho Zokunamathisela kwimenyu.
8. Khetha ukhetho olufanele lokuxhumanisa i-Link ;
9. Idatha exhunyiwe kufanele ivele kufayili yokuphela .

Amanothi :

• Uma kokubili amafayela evuliwe uma idatha ibuyekezwa efayeleni lomthombo , ifayela lokuphela kufanele libuyekeze ngokushesha.
• Uma ifayela lokuphela livaliwe uma idatha yomthombo ishintshiwe, idatha kumaseli okuphela izovuselela ngesikhathi esizayo lelo fayela livuliwe.
• Uma ifayela lomthombo livaliwe uma ifayela lokuphela livuliwe, ibhokisi lokuxwayisa lingavulwa libonisa ukuthi idokhumenti iqukethe izixhumanisi kumafayela angaphandle futhi ikucele ukuthi uvuselele / ungavuseleli izixhumanisi.

Ukubuka i-Formula ye-Link ku-Excel

Indlela indlela ifomula yokuxhumanisa iboniswa ngayo ihluka kancane phakathi kwe-Excel 2007 nezinguqulo zamuva zalolu hlelo.

• Ezingxenyeni ze-Excel 2010 nakamuva zaleso hlelo, uma uchofoza idatha exhunyiwe kufayela lokungena, ifomula efana ne- = [Book1] I-Sheet1! A1 ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela;
• Ku-Excel 2007, ifomula yokuxhuma iboniswa njenge: {= Excel.Sheet.12 | Book1! '! Sheet1! R1C1'} ebhasini lefomula.

Amanothi:

• Ngombomvu ka-2007, ireferensi yeseli ngokuphelele ibhaliwe ngesitayela sika- R1C1 - esivela emgqeni o-1 ikholomu 1 futhi okulingana nesitayela sesitayela esivamile SAS1
• Kuzo zombili amafomula, i- Book1 ibonisa igama lefayela lomthombo

Ukubuka Ulwazi Lokuxhumanisa ku-MS Word

Ukuze ubuke ulwazi mayelana nedatha exhunyiwe - njengefayili yomthombo, idatha exhunyiwe, kanye nendlela yokuvuselela:

1. Chofoza ngakwesokudla idatha exhunywe ukuvula imenyu yomongo;
2. Khetha Into Yomsebenzi Oxhunyiwe> Izixhumanisi ... ukuvula ibhokisi lezingxoxo zeZizakhi ku-Word;
3. Uma kunesixhumanisi esingaphezu kweyodwa kumadokhumenti wamanje, zonke izixhumanisi zizofakwa ohlwini efasiteleni phezulu kwebhokisi lebhokisi;
4. Ukuchofoza kusixhumanisi kuzobonisa ulwazi mayelana nalesi sixhumanisi ngezansi kwewindi ebhokisini lengxoxo.

02 ka 02

Namathisela i-Link Between Charts ku-Excel ne-PowerPoint

Amathrekhi wokuxhumanisa ngokunamathisela i-Link ku-PowerPoint ne-Word

Njengoba kukhonjisiwe, ngaphezu kokudala isixhumanisi sedatha yombhalo noma amafomula, kungenzeka futhi ukusebenzisa isixhumanisi sokunamathisela ukuxhuma ishadi elisendaweni eyodwa ye-Excel nekhophi ebhokisini yesibili noma kwifayela le-MS PowerPoint noma iWizwi.

Uma ixhunyaniswe, ukushintsha kwedatha efayeleni yomthombo kubonakala kokubili ishadi langempela kanye nekhophi elisefayeleni lokuphela.

Ukukhetha ukufometha komthombo noma indawo

Uma kudlulisa ukuxhumana phakathi kwamashadi, i-PowerPoint, i-Word, ne-Excel ikuvumela ukuba ukhethe ukuthi ufomathile ishadi elixhunyiwe usebenzisa isihloko samanje sokufometha noma yimaphi amafayili omthombo noma okuya kuwo.

Amashadi wokuxhumanisa ku-Excel ne-PowerPoint

Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sidala isixhumanisi phakathi kweshadi ku-Excel ibhuku - ifayela lomthombo kanye nesilayidi kwisethulo se-PowerPoint - ifayela lokuphela.

1. Vula ibhuku lokusebenzela eliqukethe ishadi okufanele likopishwe;
2. Vula ifayela lesethulo lesendaweni;
3. Encwadini ye-Excel, chofoza eshadini ukuze ukhethe;
4. Chofoza inkinobho yeKopi kuthebhu laseKhaya le- Ribbon ku-Excel;
5. Chofoza kusilayidi ku-PowerPoint lapho ishadi elixhunyiwe lizoboniswa khona;
6. Ku-PowerPoint, chofoza umcibisholo omncane ngezansi kwenkinobho yokunamathisela - njengoba kuboniswe esithombeni - ukuvula uhlu lokudonsa phansi;
7. Chofoza ku- Use Destination Theme noma Umthombo Wokugcina Ukufometha izithonjana ohlwini lokudonsa ukuze unamathisele ishadi elixhunywe ku-PowerPoint.

Amanothi:

• Uma amafayela amabili aqukethe amashadi axhunyiwe kokubili avuliwe, izinguquko kumininingwane yomthombo kufanele zibuyekeze ngokushesha kokubili amashadi.
  
• Uma uvula iphrezentheshini ye-PowerPoint equkethe idatha exhunywe, ibhokisi lokuxwayisa lingase livule libonisa ukukhathazeka okungenzeka okukuphepha nokukubuza ukuthi ufisa ukuvuselela idatha exhunyiwe.