Namathisela uLawulo lweDatha, iiKharati, kunye neFomula kwi-Excel, kwiLizwi, kwi-PowerPoint

01 ka 02

Namathisela izixhumanisi phakathi kwe-Excel kunye neefayile zegama

Ukudlulela iiNgqungquthela

Ukongezelela ukukopisha kunye nokudlula idatha kwifayili enye ye-Excel ukuya kwelinye okanye kwifayile ye-Microsoft Word, unokwenza ikhonkco phakathi kweefayile ezimbini okanye iincwadi zokusebenzela eziza kuhlaziya idatha ekopishwe kwifayile yesibini ukuba idatha yentsusa iyatshintsha.

Kwakhona kunokwenzeka ukudala unxibelelwano phakathi kwetshathi efumaneka kwi-Excel yencwadi kunye neSilayidi se-PowerPoint okanye i-Word document.

Umzekelo uboniswa kumfanekiso ongentla apha apho idatha evela kwifayile ye-Excel ifakwe kwi-Word document engasetyenziswa kwingxelo.

Ngokomzekelo, idatha idluliselwe kumqulu njengetafile, leyo ingafomathiwa ngokusebenzisa zonke iimpawu zokufometha kweLizwi.

Le nxu luyilwe ngokusebenzisa inketho yekhonkco yekhonkco . Ukuze usebenze unxibelelwano lwekhonkco, ifayile equlethe idatha yangaphambili iyaziwa njengefayile yomthombo kunye nefayili yesibini okanye incwadi yokusebenzela equkethe ifom yekhonkco ifayile yokuya kuyo .

Ukuqhagamshela iiselula eziKodwa kwi-Excel kunye neFomula

Unxibelelwano lungadalwa phakathi kweeseli nganye kwiincwadi zeencwadi ezihlukeneyo ze-Excel usebenzisa ifom. Le ndlela ingasetyenziselwa ukudala ikhonkco ephilayo kwiifomula okanye nedatha, kodwa isebenza kuphela kwiiseli ezinye.

1. Cofa kwiseli kwincwadi yencwadi yokuya apho idatha iya kuboniswa khona;
2. Cinezela uphawu olulinganayo ( = ) kwikhibhodi ukuqala ifom;
3. Shintshela kwincwadi yokusebenzela, klikha kuseli equle idatha ukuba idibaniswe;
4. Cindezela ukhiye wokungena kwikhibhodi - i-Excel kufuneka uguqule kwifayili yokuya kwindawo edibeneyo eboniswe kwiseli ekhethiweyo;
5. Ukucima kwi-data edibeneyo kuya kubonisa ifom yekhonkco - njenge = [Book1] I-Sheet1! $ A $ 1 kwibha yefomula ngaphezulu kwephepha lokusebenzela .

Qaphela : iimpawu zeedola kwiseli yeseli - $ A $ 1 - ibonisa ukuba yinkcazo yeseli epheleleyo.

Namathisela Izinketho zekhonkco kwi-Word kunye ne-Excel

Xa udlulisela umnxibelelwano wedatha, iLizwi likuvumela ukuba ukhethe ukuba uyifomathile idatha edibeneyo usebenzisa izicwangciso zangoku zonke iifayile okanye indawo eziya kuyo. I-Excel ayinikezeli olu khetho, lisebenza ngokuzenzekelayo izifomathi zokufometha zangoku kwifayile yokuya kuyo.

Ukudibanisa iDatha phakathi kweLizwi ne-Excel

1. Vula incwadi ye-Excel equkethe idatha edibeneyo (ifayile yomthombo )
2. Vula ifayile yokuya kuyo- nokuba yincwadi ye-Excel okanye uxwebhu lwegama;
3. Kwifayili yomthombo qinisa idatha ukuba ikopiwe;
4. Kwifayili yomthombo , nqakraza kwiKhokhi yeKopi kwikhaya laseKhaya lebhebhoni - idatha ekhethiweyo iya kujikelezwa yi-Ants Walking;
5. Kwifayili ekuya kuyo , nqakraza kunye nomkhomba we mouse kwindawo apho idatha edibeneyo iya kuboniswa - kwi-Excel cofa kwiseli eya kuba sekhoneni elingasentla elingasese le data edlulileyo;
6. Njengoko kuboniswe kumfanekiso ongentla, nqakraza kwiintolo ezincinci kwizantsi leKhenketho leNqakraza kwithebhu yaseKhaya yebhebhoni ukuvula iMenyu yokuNqumla phantsi
7. Ngokuxhomekeke kwiprogram yokuya kuyo, ukhetho lwekhonkco luyahluka:
   • KwiLizwi, unamathisela iqhagamshelo lifumaneka phantsi kweenketho zokunamathisela kwimenyu;
   • Kwi-Excel, unamathisela isiqhagamshelo siphezu kwezinye iindlela zokunamathisela kwimenyu.
8. Khetha inketho yokuQinisa i-Link Link ;
9. Idatha edibeneyo kufuneka ibonakale kwifayile yokuya kuyo .

Amanqaku :

• Ukuba zombini iifayile zivuliwe xa idatha ihlaziywa kwifayile yomthombo, ifayili yokuya kufuneka ihlaziywe ngokukhawuleza.
• Ukuba ifayile yokuya evaliweyo xa idatha yedatha ishintshiwe, idatha kwiiseli eziya kuyo iya kuhlaziya ngexesha elizayo ukuba ifayile ivuliwe.
• Ukuba ifayile yomthombo ivaliwe xa ifayile yefayile ivuliwe, ibhokisi yokulumkisa ingavulwa ebonisa ukuba uxwebhu luqulethe izixhumanisi kwiifayile zangaphandle kwaye zicele ukuba uhlaziywe / ungahlaziyi ii-link.

Ukujonga i-Formula ye-Link kwi-Excel

Indlela indlela ifom yekhonkco iboniswa ngayo iyahlukahluka phakathi kwe-Excel 2007 kunye neenguqu zexesha elizayo leprogram.

• Kwi-Excel 2010 kunye neenguqulelo zexesha elizayo leprogram, ukuba ucofa kwi-data edibeneyo kwifayili yokuya kuyo, ifomula efana = = [Book1] Iphepha le-1! A1 ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela;
• Ku-Excel 2007, ifomula eqhagamshelweyo iboniswa njenge: {= Excel.Sheet.12 | Book1! '! Sheet1! R1C1'} kwifom yefom.

Amanqaku:

• Ngohlobo lwama -2007, isalathisi esele ngokupheleleyo ibhaliwe kwisitayela esingu-R1C1 - emele umqolo wokuqala 1 kunye neyayilingana nesitayela esifanayo sesalathisi seSAS1
• Kuzo zombini iifomula, iNcwadi1 ibonisa igama lefayile yomthombo

Ukujonga Ikhonkco Ulwazi kwi-MS Word

Ukujonga ulwazi malunga nedatha edibeneyo - njengefayile yomthombo, idatha edibeneyo, kunye nendlela yokuhlaziya:

1. Cofa iqhosha kwi-data edibeneyo ukuvula imenyu yomongo;
2. Khetha I-Worksheetset Object Object> Izixhumanisi ... ukuvula ibhokisi yencoko yencoko kwiLizwi;
3. Ukuba kukho unxibelelwano olungaphezulu kweyodwa kumqulu okhoyo, zonke iinqonkco ziza kubalwa efestile phezulu kwibhokisi yencoko;
4. Ukuchofoza kwikhonkco kuza kubonisa ulwazi malunga nekhonkco ngaphantsi kwefestile kwibhokisi yencoko.

02 we 02

Namathisela Ikhonkco Phakathi kweeKharityhulam kwi-Excel ne-PowerPoint

Izixhumanisi zokudibanisa kunye nekhonkco kwi-PowerPoint kunye neLizwi

Njengoko kubonisiwe, ngaphezu kokudala ikhonkco yedatha yombhalo okanye ifomula, kunokwenzeka ukuba usebenzise unxibelelwano lwekhonkco ukudibanisa ishati esekweni enye ye-Excel yencwadi kunye nekopi kwincwadi yesibini okanye kwi-MS PowerPoint okanye kwiFayile yefayile.

Xa kuxhunyiwe, utshintsho kwi data kwifayile yomthombo kubonakaliswa kwiretshi yokuqala kunye nekopi ekhoyo kwifayili yokuya kuyo .

Ukukhethwa koMthombo okanye ukuFometha kweendawo

Xa udlulisa umnxibelelwano phakathi kwamashadi, i-PowerPoint, i-Word, ne-Excel ikuvumela ukuba ukhethe ukuba ifomathile ityati edibeneyo usebenzisa umxholo wokufometha wamanje kwiifayile ezivela kumthombo okanye kwindawo yokuya kuyo.

Ukudibanisa iiKharithi kwi-Excel ne-PowerPoint

Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo udala unxibelelwano phakathi kwetshathi kwincwadi yokusebenzela ye-Excel - ifayile yesibonelelo kunye nesilayidi kwisethulo se-PowerPoint-ifayile yokuya kuyo .

1. Vula ibhuku lokusebenzela eliqukethe ishati ekufuneka ikopiwe;
2. Vula ifayile yokubonisa indawo;
3. Kwincwadi ye-Excel, nqakraza kwitshathi ukuze ukhethe;
4. Cofa kwiKhowudi yeKopi kwikhaya lasekhaya lasebhanki kwi-Excel;
5. Cofa kwi-slide kwi-PowerPoint apho ibhokisi edibeneyo iya kuboniswa;
6. Kwi-PowerPoint, nqakraza kwiintolo ezincinci kwinqanaba lekhonkco - njengokuba kuboniswe kumfanekiso - ukuvula uluhlu lokuhla;
7. Cofa kwi- Use Indawo ye-Destination okanye i- Keep Source Ukufakela iimpawu kwiluhlu lokuhla ukuze unamathisele ishadi elidibeneyo kwi-PowerPoint.

Amanqaku:

• Ukuba iifayile ezimbini eziqulethe iitshathi ezidibeneyo zivulekile, ukutshintshwa kwedatha yomthombo kufuneka kuhlaziywe ngokukhawuleza kwimiqulu emibini.
  
• Xa uvula isethulo se-PowerPoint equkethe idatha edibeneyo, ibhokisi lokulumkisa lingavulwa libonisa inkxalabo enokukhusela kwaye ikubuze ukuba unqwenela ukuhlaziya idatha edibeneyo.