Indlela yokudibanisa idatha ukusuka kwelinye iphepha ukuya kwelinye? Funda ukusebenza ngokufanelekileyo nge-Excel.
Unokudibanisa idatha phakathi kwespredishithi ezininzi kwincwadi yokusebenzela ye-Excel, olu nxulumaniso lukuvumela ukuba ukhuphe idatha ngokukhawuleza ukusuka kwiyure enye ukuya kwenye kwaye uya kuhlaziya idatha kwiphepha lokusingwa ngalo lonke ixesha umxholo weseli kwiphepha lomthombo utshintsha.
Ukuba ufuna ukusebenzisa iifayile ezininzi zespreadsheet ukugcina ulwazi luhlaziyiwe, zama ukudibanisa i-spreadsheet enye kwenye. Ke akunyanzelekanga ukuba ufake idatha efanayo kwispredishithi ezininzi ngalo lonke ixesha usenza utshintsho. Nokuba i-Excel iyakuvumela ukuba uqhagamshele kwifayile yeLizwi.
Kwinqaku elilandelayo sithathe umsebenzi wokukubonisa inyathelo ngenyathelo, phakathi kwendlela yokudibanisa idatha ukusuka kwelinye iphepha le-Excel ukuya kwelinye, okanye ukudibanisa amaphepha amaninzi. Hlala nje ujonge Indlela yokudibanisa idatha ukusuka kwelinye iphepha ukuya kwelinye
Amanyathelo okudibanisa iphepha le-excel kwelinye
- Vula incwadi yokusebenzela ye-Excel, ngaphakathi kwephepha ekujoliswe kulo ukusuka kwiithebhu zamaphepha, uya kubona uluhlu lwazo zonke ii-worksheets ezantsi kwe-Excel. Kuya kufuneka ukhethe leyo ufuna ukuyidibanisa nesinye isipredishithi.
- Khetha iseli engenanto kumntwana wokugqibela, le iya kuba yindawo oya kuyo. Xa uqhagamshela kwelinye ishiti le datha iya kuzilungelelanisa ngokuzenzekelayo ukuba idatha ekwiseli yemvelaphi iyatshintsha.
- Bhala kwiseli yendawo oya kuyo "=" eya kuqalisa ifomula. Cofa kwiphepha lomthombo kwiithebhu zephepha, fumana ixesha ofuna ukukhupha idatha kulo, kwaye ucofe ukuyivula.
- Khangela ibha yefomula, xa usiya kwiphepha lemvelaphi kufuneka libonise igama lespredishithi sangoku, emva koko uphawu olulinganayo kwaye lulandelwe yindawo yesikhuzo. Kungenjalo, ungabhala i-SheetName kwibha yefomula, apho kuya kufuneka ubuyisele igama le-SheetName ngegama lephepha lemvelaphi.
- Emva koko kuya kufuneka ucofe kwiphepha lomthombo, linokuba lingenanto okanye enye esele iqulethe idatha, xa udibanisa amaphepha, iseli yendawo iya kuhlaziywa kunye nedatha evela kwiseli yomthombo. Umzekelo: Ukuba ukhupha idatha kwiseli D12, eyephepha1, ifomula kufuneka ibe ngolu hlobo: =Sheet1!D12.
- Cinezela ukungena kwibhodibhodi ukuze ifomula iqale ukusebenza, ngoku uya kubona ukuba iseli yemvelaphi iya kukhupha idatha kuyo ngokuguquguqukayo.
Ungaqhagamshela njani amaphepha e-Excel
Xa sidibanisa ishidi le-Excel kwiseli kwenye i-spreadsheet, iseli equlethe ikhonkco iya kubonisa ulwazi olufanayo oluqulethwe yi-Excel sheet. Le equlathe ikhonkco, iya kufakwa kwikhathalogu njenge “iseli oxhomekeke kuye” kuba enye iseli yiyo ekunika idata ebhekisa kuwe, ke siyakuyibiza le “cell cell.
Ukuba iseli ye-Excel eyandulelayo iyatshintsha, iseli exhomekeke kuyo iya kuzitshintsha ngokuzenzekelayo. Ke ngoko, ukuba ufuna ukunxibelelana nefayile enye okanye ezininzi ze-Excel eziqulethe iifomula zokubala, ungasebenzisa i umsebenzi wematrix eyakuvumela ukuba udibanise uluhlu lweeseli ngeefomula.
Indlela yokudibanisa idatha ukusuka kumaphepha amaninzi e-excel ukuya kwelinye
Ukudibanisa okanye ukudibanisa yinkqubo esetyenziselwa ukwenza iireferensi kwezinye iincwadi zokusebenza kwi-Excel, oku kuya kusivumela ukuba sifumane ulwazi lwephepha lethu lomsebenzi. Umsebenzi oluncedo ngokwenene, kuba kuya kubakho amaxesha apho kufuneka sitshintshe ulwazi ukusuka kwincwadi yomthombo ukuya kwenye indawo ngaxeshanye.
Ngakolunye uhlangothi, ukudibanisa yinto eyenzekayo xa sidibanisa okanye sishwankathela ulwazi oluvela kumaphepha amaninzi omsebenzi. La maphepha anokuphuma kwiincwadi ezahlukeneyo, enye inketho eluncedo kakhulu xa sifuna ukudibanisa iifayile ezininzi ngexesha elinye.
Umzekelo uya kuba kukuba inkampani yakho igcina ukuthengiswa komthengisi ngamnye, unokwenza isishwankathelo sencwadi ye-Excel equlethe ulwazi oluvela kwincwadi yomthengisi ngamnye kwaye ngexesha elifanayo ubale inani leentengiso zabo.
Uqhagamshela njani amaphepha e-Excel kunye neefomula inyathelo ngenyathelo:
Ukuze udibanise amaphepha e-ecel, kufuneka siqale sidibanise umthombo wasimahla. Kwincwadi ekujoliswe kuyo siya kufumana iseli eya kuba nesiphumo sekhonkco. Ukwenza oku, sicofa ekunene kwi icon kwaye emva koko uncamathisele, silandelwa lukhetho olukhethekileyo lokuncamathisela.
Kwibhokisi yencoko yababini eya kuvela kwicandelo, sikhetha ukuncamathisela, emva koko siphawula ukhetho konke kwaye ekugqibeleni unamathisele amakhonkco.
Ngaphakathi kwebha yefomula siya kuba nombono okhululekileyo wefomula enesiphumo. Isivakalisi esinokukwazi ukuqhagamshelwa ngesandla sithi: =[BookName]SheetName!Cell. Kwimeko apho amagama anezithuba, kufuneka uwabeke kwizicatshulwa, umzekelo: =” [intengiso kaJanuwari]Pedro”!$A$1
Ukugqiba kwaye uhlele amakhonkco achazwe ngaphambili, siya kwi icon yokuHlela amakhonkco ebekwe kwiDatha tab.
Ukuba sikhetha ukuhlanganisa amaphepha e-Excel, inkqubo ilula kakhulu. Ukudibanisa yinto ebesiyikhankanyile ngaphambili, kukushwankathela ulwazi lwamaphepha amaninzi abekwe kwiincwadi ezahlukeneyo. Unokwenza lo msebenzi kwicandelo leefomyula, emva koko usebenzisa intlama ekhankanywe ngasentla. Ukuba uyakhetha, khangela udibaniso kwithebhu yeDatha yoKhetho.
Isiphelo
I-Excel sisixhobo esinemisebenzi engapheliyo, ngalo lonke ixesha sicinga ukuba kukho into esiyaziyo, sifumanisa ukuba bekukho umsebenzi omtsha ekufuneka siwufunde. Kule meko, siyathemba ukuba sele uyayazi indlela yokudibanisa idatha ukusuka kwelinye iphepha le-Excel ukuya kwelinye
Kule meko, ukusetyenziswa kokudibanisa i-spreadsheets kwi-Excel kuya kwenza umsebenzi wakho usebenze ngakumbi; ngakumbi xa ufuna ukwazi amaqhekeza amaninzi olwazi ngexesha elinye.
Khumbula ukuba kwiwebhusayithi yethu unokufumana ulwazi oluthe kratya malunga ne-Excel, iZwi, kunye neenkqubo ezininzi onokuzisebenzisa rhoqo kwaye ngokuqinisekileyo uya kufunda into entsha. Inokukunceda: Utshintsha njani ukusuka konobumba abakhulu ukuya kwabancinci kwi-Excel?