Wakuba ugqibile ukuhlela incwadi yomsebenzi, ungabeka izithintelo zokufunda kuphela kuyo kwaye nabani na owabelana naye ngayo uya kukwazi ukuyifunda, kodwa abayi kukwazi ukuhlela uxwebhu nangayiphi na indlela. Nangona kunjalo, ukusebenzisa ukufunda kuphela kunokuba ngumqobo xa ufuna ngokwenene ukwenza utshintsho kuxwebhu. Mhlawumbi umhlobo okanye umntu osebenza naye wabelane nawe ngencwadi yokusebenza ye-Excel yokufunda kuphela kwaye walibala ukwabelana nawe ngendlela yokususa esi sithintelo.
I-Excel inokusetwa kukufunda-kuphela ngeendlela ezininzi. Kweli nqaku, sidwelisa zonke iimeko ezinokwenzeka kunye nezisombululo ezinxulumene nazo ukuze wazi indlela yokususa ukufunda kwi-excel kwiimeko ezininzi.
I-Excel yenziwe ukuba ifundeke kuphela kusetyenziswa "Phawula njengowokugqibela"
Esinye sezizathu zokuba kutheni uxwebhu lwe-Excel onalo lufundeka kuphela kukuba luphawulwe lokugqibela ngumhleli. Ukuba oku kunjalo, kuya kufuneka ubone umyalezo phezulu kuxwebhu othi "Iphawulwe njengeyokugqibela."
Nje ukuba uxwebhu luphawulwe njengelokugqibela, kuya kuba nzima ukwenza utshintsho kulo. Awukwazi ukubhala, ukuhlela okanye ukuvavanya uxwebhu kweli lizwe. Kodwa kwakhona kulula ukususa. Cofa nje iqhosha elithi "Hlela kunjalo" ekupheleni komyalezo kwaye unokucima into yokufunda kuphela kwi-Excel.
Ifayile ye-Excel iba yifayile yokufunda kuphela ecetyiswa ngu "Gcina njenge"
Enye imeko yokwazi ukuba uxwebhu lwe-Excel lukwimowudi yokufunda kuphela kukuba uya kucelwa ukuba uvule uxwebhu ngendlela yokufunda kuphela ngaphandle kokuba ufuna ukwenza utshintsho kulo. Ukuba awufuni ukwenza utshintsho kuxwebhu, nqakraza ngokulula "Ewe." Kwaye ukuba ufuna ukuhlela uxwebhu, nqakraza ngokulula "Hayi" ukuyivula.
Ukuba ufuna ukuvula ifayile egqwesileyo yokufunda kuphela, landela la manyathelo alula:
Inyathelo loku-1: Xa uqala ukuvula uxwebhu lwe-Excel kwaye ufumane umyalezo okunika iindlela ezintathu zokuvula uxwebhu lokufunda kuphela, nqakraza ngokulula u-"Ewe" ukuvula ifayile kwimowudi yokufunda kuphela.
Inyathelo lesi-2: Ukuba wenza naluphi na utshintsho kumxholo woxwebhu kwaye uzame ukugcina utshintsho, umyalezo omtsha uvela ucela ukuba ugcine ikopi yefayile kwaye uyinike igama ngokutsha. Cofa u-"Kulungile" ukuvula ibhokisi yencoko ethi "Gcina njenge", emva koko ucofe "Izixhobo> Iinketho ngokubanzi."
Inyathelo lesi-3: Kwibhokisi yencoko yababini ethi “Ukhetho ngokubanzi” evelayo, sukukhangela “Ufundo olucetyiswayo kuphela” kwaye ucofe u-“Kulungile.”
Inyathelo lesi-4: Emva kwibhokisi yencoko ethi “Gcina njenge”, cofa u “Gcina.” Oku kuya kwenza ikopi yefayile ye-Excel yoqobo. Ifayile ekhutshelweyo ayizukufundwa-kuphela kwaye ungaqhubeka nokuyihlela ngendlela onqwenela ngayo.
Oku kuya kususa isithintelo sokufunda-kuphela kuxwebhu lwe-Excel.
Ubume bamaphepha e-Excel kunye neencwadi zokusebenza zitshixiwe kwaye zifundwa kuphela
Ukuba ifayile ye-Excel ikwimowudi yokufunda kuphela ngenxa yokuba iphepha lomsebenzi okanye isakhiwo sencwadi yomsebenzi sitshixiwe, unokukwazi ukususa isithintelo sokufunda kuphela se-Excel ukuba uyayazi igama eligqithisiweyo. Nantsi indlela oyenza ngayo:
Inyathelo loku-1: Vula ifayile ye-Excel ekhuselweyo, ukuze ukwazi ukubona onke amaphepha okusebenzela kunye nomxholo wawo.
Inyathelo lesi-2: Cofa u-"Jonga kwakhona" kwimenyu ephambili kwaye ukhethe "Iphepha elingaKhuseli" phantsi ko "Utshintsho." Ngenisa igama lokugqithisa ukuze ugqibezele inkqubo.
Inyathelo lesi-3 : Ukuba yincwadi yomsebenzi ekhuselweyo, cofa u-"Unprotect Workbook" uze ufake igama eliyimfihlo ukuze ususe isithintelo.
Gcina uxwebhu kwaye uthintelo lokufunda-kuphela luya kususwa.
Ifayile ye-Excel inegama lokugqitha lithintelwe njengokufunda kuphela
Ngamanye amaxesha xa uvula ifayile efihliweyo ye-Excel, uya kucelwa ukuba ufake igama lokungena ukuze ubhale okanye uyivule ukufunda kuphela. Cofa kwindawo ethi "Funda kuphela" kwaye ifayile ye-Excel iya kuthintelwa ukulungiswa kunye nokufunda. Landela la manyathelo ukuvula ifayile ye-Excel yokufunda kuphela:
Inyathelo loku-1. Gcina ifayile yangoku ye-Excel yokufunda-kuphela ngokucofa iFayile> Gcina njenge.
Inyathelo lesi-2. Yigcine nje njengoxwebhu olwahlukileyo lwe-Excel kwaye ucofe u-“Gcina” ukuze uqhubeke.
Ngoku unokuvula ikopi yefayile ye-Excel kwaye wenze utshintsho kuyo.
Ingcebiso yeBhonasi: Susa i-Excel Funda kuphela ngaphandle kwegama lokugqithisa (Kuzo zonke iimeko ezingentla)
Ukuba ufuna ukususa imowudi "yokufunda kuphela" ye-Excel isetwe ngazo zonke iinketho ngocofa nje olunye ngaphandle kwegama lokugqitha , ke enye yeendlela ezilungileyo zokwenza oku kukusebenzisa isixhobo sokususa igama lokugqitha le-Excel njenge Ipasile le-Excel .
Ipasile le-Excel sisixhobo esikuvumela ukuba ususe iisetingi zokufunda kuphela usebenzisa uPhawu njengolokuGqibela kwaye Gcina njenge, susa izithintelo kwisakhiwo samaphepha e-Excel kunye neencwadi zokusebenza, kwaye ususe igama lokugqitha lokuvula kulo naluphi na uxwebhu olutshixiweyo lwe-Excel.
Ngoko ke, sisixhobo esiluncedo kakhulu xa ungakwazi ukuvula okanye ukuhlela uxwebhu lokufunda kuphela lwe-Excel. Ezi zezinye zeempawu zayo:
Ipasile ye-Excel: Susa ukufunda i-Excel ngemizuzwana emi-2:
- Zonke iimeko zigutyungelwe: Ukuphelisa okanye ukuvala ukufunda i-Excel kuzo zonke iimeko ezinokwenzeka.
- Elona zinga lempumelelo: I-algorithm ephezulu iqinisekisa a 100% izinga lokususa .
- Kulula ukuyisebenzisa : Kwakhona kulula kakhulu ukuyisebenzisa. Ngayo, unokubuyisela igama eligqithisiweyo lokuvula ngamanyathelo ambalwa alula kwaye ususe izithintelo ngokucofa kanye.
Uzivula njani iiFayile ze-Excel eziFundayo kuphela ezinePasi ye-Excel
Nantsi indlela yokusebenzisa iPasser ye-Excel ukususa izithintelo zokufunda kuphela kuxwebhu lwe-Excel:
Inyathelo loku-1: Khuphela kwaye ufake Ipasile le-Excel kwikhompyuter yakho kwaye emva koko uyivule. Kwifestile engundoqo, khetha «Susa izithintelo «.
Inyathelo lesi-2: Cofa "Yongeza" ukungenisa uxwebhu oluthintelweyo kwiPasspers.
Inyathelo lesi-3: Nje ukuba uxwebhu longezwe ngempumelelo kwinkqubo, cofa "Susa » kwaye naziphi na izithintelo zokufunda kuphela kuxwebhu lwe-Excel ziya kususwa ngempumelelo.
Iingcebiso: Njengoko besesitshilo ngaphambili, iPasser ye-Excel isenokusetyenziswa ukubuyisela amagama ayimfihlo okuvula. Ukuba uphulukene negama lokugqitha ukuze uvule ifayile yakho ye-Excel okanye ukuba ufumene ifayile ye-Excel ekhuselweyo ngephasiwedi yokuvula, unokuzama nayo.
Ukuqukumbela
Ezi zingentla zezona ndlela zi-5 zingcono kuwe ukuba awuyazi indlela yokususa ukufunda kwi-excel . Nceda uqaphele ukuba kunokubakho izizathu ezininzi zokuba awukwazi ukufikelela kuxwebhu lwe-Excel, nangona enye yezona ziqhelekileyo kuxa uxwebhu "luphawulwe okokugqibela." Ipasile le-Excel ikuvumela ukuba ufikelele ngokulula kuxwebhu ngaphandle kwezithintelo ezibekiweyo, ukuquka uxwebhu olukhuselweyo lokugqitha.
