Iindlela ezi-6 zokuvala ukufunda kwi-Excel 2016

Ifayile ye-Excel inokufakwa kwimowudi yokufunda kuphela xa ifayile imakishwa njengeyokugqibela, xa igcinwe njengefundwayo kuphela, okanye xa i-spreadsheet okanye isakhiwo sencwadi yomsebenzi sitshixiwe, njl. Nangona kunjalo, njengoko ukufunda kunokuba luncedo, kunokuba ngumqobo, ngakumbi xa ungayazi indlela yokususa isithintelo.

Kweli nqaku, siza kujonga ezinye zeendlela zoku khubaza ukufunda kwi-Excel Ngo-2016 ukuba unayo okanye awunayo i-password.

Icandelo 1. Indlela eqhelekileyo yokuKhubaza ukuFunda kwi-Excel 2016 Ngaphandle kwePassword

Ukukhubaza umsebenzi wokufunda kuphela kwi-Excel kunokuba nzima, nokuba akunakwenzeka, xa ungayazi igama eligqithisiweyo elisetyenziselwa ukubeka uthintelo. Nangona kunjalo, kukho izixhobo ezithile kwimarike ezinokukunceda ukuba uphelise ukufunda kwi-Excel 2016 ngokulula. Enye yezona zilungileyo Ipasile le-Excel .

Ezi zilandelayo zezinye zeempawu ezibonelelwa ngePasser ye-Excel:

• Ixhasa ukususa zonke iintlobo kwindlela yokufunda kuphela akukho magama ayimfihlo.
• Susa amagama ayimfihlo okuvula kwaye isusiwe ukhuseleko lwe funda kuphela ngaphakathi amaphepha okusebenzela/iincwadi Excel 2016 ngaphandle kokuchaphazela idatha yoxwebhu.
• Vula amaxwebhu e-Excel xa ulibele igama eligqithisiweyo, awukwazi ukukopa i-spreadsheet okanye idatha yencwadi yomsebenzi, awukwazi ukuprinta i-spreadsheet/incwadi yokusebenzela, okanye awukwazi ukuhlela umxholo woxwebhu.
• Ngaphezu koko, kunjalo kulula kakhulu ukuyisebenzisa , ekubeni ikuvumela ukuba ucime ufundo ngokucofa kanye.
• Ixhasa zonke iinguqulelo zamaxwebhu e-Excel, kuquka i-Excel 96-Excel 2019.

Yizame simahla

Nantsi indlela yokusebenzisa iPasser ye-Excel ukususa ukufunda kulo naluphi na uxwebhu lwe-Excel:

Inyathelo loku-1: Khuphela kwaye ufake iPasser ye-Excel kwikhompyuter yakho kwaye emva koko uqalise inkqubo.

Inyathelo lesi-2: Cofa u-"Susa iMithintelo" kwaye emva koko ucofe u-"Yongeza" ukufumana uxwebhu olunothintelo lwe-Excel kwinkqubo.

Inyathelo lesi-3: Xa ifayile yongezwe kwinkqubo, cofa u- "Delete" kwaye iPassper ye-Excel iya kuqalisa kwangoko ukususa izithintelo kwifayile. Kwimizuzwana embalwa, uya kukwazi ukufikelela kuxwebhu lwe-Excel 2016 ngaphandle kwezithintelo.

Yizame simahla

Icandelo 2. 5 Iimeko ezahlukeneyo zokuKhubaza ukuFunda kwi-Excel 2016

Kukho ubukhulu becala iimeko ezi-5 ezahlukeneyo apho i-Excel 2016 yakho iphawulwe njengeyokufunda kuphela kwaye isisombululo sabo esihambelanayo kukukhubaza into yokufunda kuphela.

Ityala 1: Xa uxwebhu lwenziwe lufundeka kuphela ngexesha lokugcinwa

Ungasebenzisa inqaku elithi "Gcina njenge" lingezantsi ukucima indlela yokufunda kwi-Excel 2016:

Inyathelo loku-1: Qala ngokuvula incwadi yokusebenza ye-Excel uze ufake igama eliyimfihlo ukuba kuyimfuneko. Cofa "Ifayile> Gcina njenge" kwaye ukhethe indawo efanelekileyo kwikhompyuter yakho ukugcina ifayile.

Ipasile 2: Cofa utolo oluhlayo ecaleni kweqhosha "Izixhobo » kwaye emva koko ukhethe «Ukhetho ngokubanzi «.

Ipasile 3: Cima igama lokugqitha elivela kwibhokisi ethi “Password to modify” kwaye ucofe u-“Kulungile” ukuphakamisa isithintelo sokufunda kuphela. Cofa "Kulungile."

Ipasile 4: Ekugqibeleni, cofa "Gcina" ukugqiba inkqubo.

Ityala lesi-2: Xa uxwebhu luphawulwe njengolokugqibela

Ukumakisha uxwebhu lwakho lwe-Excel 2016 njengolu “Final” kunokubeka umda wokufunda kuphela kuxwebhu. Nantsi indlela yokuvala esi sithintelo kuxwebhu oluphawulwe njengolokugqibela.

Inyathelo loku-1: Vula uxwebhu olunothintelo lwe-Excel 2016 kwikhompyuter yakho.

Inyathelo lesi-2: Phezulu koxwebhu, kufuneka ubone iqhosha «Hlela kunjalo «. Nqakraza kwaye uthintelo lokufunda-kuphela luya kuphakanyiswa, likuvumela ukuba uhlele uxwebhu.

Ityala lesi-3: Xa i-spreadsheet okanye isakhiwo sencwadi yomsebenzi sitshixiwe

Izithintelo zokufunda kuphela zinokuthi zenzeke xa umbhali we-Excel 2016 uxwebhu evalele isakhiwo sephepha lomsebenzi okanye incwadi yokusebenzela, ukuthintela ukuhlelwa kwephepha lomsebenzi. Kule meko, unokusombulula ingxaki ngala manyathelo alula alandelayo:

Inyathelo loku-1: Vula uxwebhu lwe-Excel ngothintelo lokufunda kuphela, kwaye emva koko ucofe «Jonga kwakhona > Iphepha elingakhuselekanga «.

Inyathelo lesi-2: Ngenisa igama eligqithisiweyo kwibhokisi efanelekileyo kwaye ucofe "Kulungile" ukunyusa umda.

Ityala lesi-4: Xa uxwebhu lunemo yokufunda kuphela

Ukufunda kunokukhutshazwa kwi-Excel 2016 usebenzisa iiPropati zeFayile ukhetho kwiWindows File Explorer. Nantsi indlela oyenza ngayo:

Inyathelo loku-1: KwiFayile Explorer, yiya kwifayile ye-Excel ethintelweyo. Cofa ekunene uxwebhu, uze ukhethe "Iipropati" phakathi kokhetho olunikiweyo.

Inyathelo lesi-2: Sukukhangela ukhetho "Funda uqhubeleke " kwicandelo «Iimpawu » kwaye ucofe u-"Kulungile" ukuvala izithintelo zokufunda kuphela.

Ityala lesi-5: Xa uxwebhu lwe-Excel 2016 lufuna igama eliyimfihlo

Xa ufuna ukufaka igama lokugqitha ukuze ufikelele kwaye uhlele uxwebhu lweExcel 2016, ungalandela la manyathelo alula ukunyusa esi sithintelo:

Inyathelo loku-1: Qala ngokuvula uxwebhu lwe-Excel 2016 ofuna ukulucima uphawu lokufunda kuphela.

Inyathelo lesi-2: Xa kuvela ibhokisi yegama lokugqitha, cofa "Funda uqhubeleke » endaweni yoko kwaye uxwebhu luya kuvula kwindlela yokuFunda Kuphela.

Inyathelo lesi-3: Ngoku cofa "Gcina > Yigcine njenge »kwaye ngenisa igama lefayile elahlukileyo. Cofa ku « Gcina »ukugcina ikopi entsha yefayile yoqobo.

Ifayile entsha eyenziweyo iya kuthatha indawo yoxwebhu lokufunda kuphela kwaye ayisayi kuba nayo nayiphi na imiqobo yoqobo.

Izisombululo ezingentla zenza kube lula kuwe ukukhubaza ukufunda-kuphela kwi-Excel 2016 nokuba unayo igama lokugqitha okanye awunalo. Khetha indlela efanele iimfuno zakho kunye nemeko yakho ethile. Sazise ukuba uyakwazi ukuphakamisa isithintelo sokufunda kuphela kwicandelo lamagqabaza apha ngezantsi.

Yizame simahla