Uma usuqedile ukuhlela ibhuku lokusebenza, ungakwazi ukubeka imikhawulo yokufunda kuphela futhi noma ubani owabelana naye uzokwazi ukuyifunda, kodwa ngeke akwazi ukuhlela idokhumenti nganoma iyiphi indlela. Nokho, ukusebenzisa ukufunda kuphela kungaba yisithiyo lapho udinga ngempela ukwenza izinguquko kudokhumenti. Mhlawumbe umngane noma osebenza naye wabelane nawe ngencwadi yokusebenzela ye-Excel yokufunda kuphela futhi wakhohlwa ukwabelana nawe ngokuthi uwususa kanjani lo mkhawulo.
I-Excel ingasethelwa ekufundeni kuphela ngezinketho ezimbalwa. Kulesi sihloko, sibala wonke amacala angenzeka kanye nezixazululo zawo ezihlobene ukuze wazi Ungakususa kanjani ukufunda ku-Excel ezimweni eziningana.
I-Excel yenziwa ukuthi ifundeke kuphela kusetshenziswa okuthi “Mark as Final”
Esinye sezizathu zokuthi kungani idokhumenti ye-Excel onayo ifundwa kuphela ukuthi imakwe njengokugcina ngumhleli. Uma kunjalo, kufanele ubone umlayezo phezulu kwedokhumenti othi "Imakwe njengokugcina."
Uma idokhumenti imakwe njengokugcina, ngeke ukwazi ukwenza izinguquko kuyo. Awukwazi ukubhala, ukuhlela noma ukuhlola idokhumenti kulesi simo. Kodwa futhi kulula ukususa. Vele uchofoze inkinobho ethi "Hlela noma kunjalo" ekugcineni komlayezo futhi ungavala isici sokufunda kuphela ku-Excel.
Ifayela le-Excel liba ifayela elifundwayo kuphela elinconywe “Londoloza Njenge”
Esinye isimo sokwazi ukuthi idokhumenti ye-Excel ikumodi yokufunda kuphela ukuthi uzocelwa ukuthi uvule idokhumenti ngemodi yokufunda kuphela ngaphandle uma udinga ukwenza izinguquko kuyo. Uma ungafuni ukwenza izinguquko kudokhumenti, mane uchofoze okuthi "Yebo." Futhi uma ufuna ukuhlela idokhumenti, mane uchofoze okuthi "Cha" ukuze uyivule.
Uma ufuna ukuvula ifayela le-excel elifundwayo kuphela, landela lezi zinyathelo ezilula:
Isinyathelo 1: Lapho uqala ukuvula idokhumenti ye-Excel futhi uthola umyalezo okunikeza izinketho ezintathu zokuvula idokhumenti efundwa kuphela, mane uchofoze okuthi “Yebo” ukuze uvule ifayela ngemodi yokufunda kuphela.
Isinyathelo sesi-2: Uma wenza izinguquko kokuqukethwe yidokhumenti bese uzama ukugcina izinguquko, kuvela umyalezo omusha okucela ukuthi ulondoloze ikhophi yefayela bese uliqamba kabusha. Chofoza okuthi “KULUNGILE” ukuze uvule ibhokisi lengxoxo elithi “Londoloza Njenge”, bese uchofoza okuthi “Amathuluzi > Izinketho Ezivamile.”
Isinyathelo sesi-3: Ebhokisini lengxoxo elithi “Izinketho Ezivamile” elivelayo, susa ukumaka inketho ethi “Ukufunda Okunconyiwe kuphela” bese uchofoza okuthi “KULUNGILE.”
Isinyathelo sesi-4: Emuva kubhokisi lengxoxo elithi “Londoloza Njenge”, chofoza okuthi “Londoloza.” Lokhu kuzokwenza ikhophi yefayela lokuqala le-Excel. Ifayela elikopishiwe ngeke lifundwe kuphela futhi ungaqhubeka nokulihlela ngendlela ofisa ngayo.
Lokhu kuzosusa umkhawulo wokufunda kuphela kudokhumenti ye-Excel.
Ukwakheka kwamakhasi e-Excel nezincwadi zokusebenza kukhiyiwe futhi kufundeka kuphela
Uma ifayela le-Excel likumodi yokufunda kuphela ngenxa yokuthi ishidi lokusebenzela noma isakhiwo sencwadi yokusebenzela sikhiyiwe, ungase ukwazi ukususa umkhawulo wokufunda kuphela we-Excel uma ulazi igama eliyimfihlo. Ukwenza kanjena:
Isinyathelo 1: Vula ifayela le-Excel elivikelwe, ukuze ukwazi ukubona wonke amaphepha okusebenza nokuqukethwe kwawo.
Isinyathelo sesi-2: Chofoza okuthi “Buyekeza” kumenyu eyinhloko bese ukhetha “Ishidi Elingavikeli” ngaphansi kokuthi “Izinguquko.” Faka iphasiwedi ukuze uqedele inqubo.
Isinyathelo sesi-3 : Uma kuyisakhiwo sencwadi yokusebenzela esivikelwe, chofoza okuthi “Ungavikeli Ibhuku Lokusebenza” bese ufaka igama-mfihlo ukuze ususe umkhawulo.
Londoloza idokhumenti futhi umkhawulo wokufunda kuphela uzosuswa.
Ifayela le-Excel linephasiwedi likhawulelwe njengelifundwayo kuphela
Kwesinye isikhathi uma uvula ifayela le-Excel elibethelwe, uzocelwa ukuthi ufake igama-mfihlo ukuze ufinyelele ukubhala noma ulivule ukufunda kuphela. Chofoza inketho ethi “Funda kuphela” futhi ifayela le-Excel lizokhawulelwa ekulungisweni nasekufundeni. Landela lezi zinyathelo ukuze uvule ifayela le-Excel elifundwayo kuphela:
Isinyathelo 1. Londoloza ifayela lamanje le-Excel elifundwayo kuphela ngokuchofoza okuthi Ifayela > Londoloza Njenge.
Isinyathelo sesi-2. Vele uyigcine njengedokhumenti ehlukile ye-Excel bese uchofoza okuthi “Londoloza” ukuze uqhubeke.
Manje usungakwazi ukuvula ikhophi yefayela le-Excel futhi wenze izinguquko kulo.
Ithiphu Yebhonasi: Khipha i-Excel Funda Kuphela Ngaphandle Kwephasiwedi (Kuzo Zonke Izimo Ezingenhla)
Uma ufuna ukususa imodi "yokufunda kuphela" ye-Excel isethwe yizo zonke izinketho ngokuchofoza okukodwa nje ngaphandle kwephasiwedi , enye yezindlela ezingcono kakhulu zokwenza lokhu kwenzeke ukusebenzisa ithuluzi lokususa iphasiwedi le-Excel njenge I-Passer ye-Excel .
I-Passer ye-Excel iyithuluzi elikuvumela ukuthi ususe izilungiselelo zokufunda kuphela usebenzisa Maka njengeFinal and Save As, susa imingcele esakhiweni samakhasi e-Excel nezincwadi zokusebenza, futhi ukhiphe iphasiwedi yokuvula kunoma iyiphi idokhumenti ye-Excel ekhiyiwe.
Ngakho-ke, iyithuluzi eliwusizo kakhulu lapho ungakwazi ukuvula noma ukuhlela idokhumenti ye-Excel efundwayo kuphela. Lezi ezinye zezici zayo:
Iphasishi le-Excel: Susa ukufunda i-Excel ngemizuzwana emi-2:
- Wonke amacala ahlanganisiwe: Susa noma ukhubaze ukufunda i-Excel kuzo zonke izimo ezingaba khona.
- Izinga eliphezulu lempumelelo: I-algorithm ethuthukisiwe iqinisekisa a 100% izinga lokususwa .
- Kulula ukuyisebenzisa : Futhi kulula kakhulu ukuyisebenzisa. Ngayo, ungabuyisa iphasiwedi yokuvula ngezinyathelo ezimbalwa ezilula futhi ususe imikhawulo ngokuchofoza okukodwa.
Ungawavula Kanjani Amafayela E-Excel Okufunda Kuphela Nge-Passer ye-Excel
Nansi indlela yokusebenzisa i-Passer ye-Excel ukususa imikhawulo yokufunda kuphela kudokhumenti ye-Excel:
Isinyathelo 1: Landa futhi ufake I-Passer ye-Excel kukhompuyutha yakho bese uyivula. Efasiteleni elikhulu, khetha «Susa imikhawulo «.
Isinyathelo sesi-2: Chofoza okuthi “Engeza” ukuze ungenise idokhumenti ekhawulelwe ku-Passer.
Isinyathelo sesi-3: Uma idokhumenti seyengezwe ngempumelelo ohlelweni, chofoza "Susa » kanye nanoma imiphi imikhawulo yokufunda kuphela kudokhumenti ye-Excel izosuswa ngempumelelo.
Amathiphu: Njengoba sishilo ngaphambili, i-Passer ye-Excel ingasetshenziswa futhi ukuthola amaphasiwedi okuvula. Uma ulahlekelwe yiphasiwedi yokuvula ifayela lakho le-Excel noma uma uthole ifayela le-Excel elivikelwe ngephasiwedi yokuvula, ungalizama futhi.
Isiphetho
Okungenhla izindlela ezi-5 ezingcono kakhulu kuwe uma ungazi Ungakususa kanjani ukufunda ku-Excel . Sicela uqaphele ukuthi kungase kube nezizathu ezimbalwa zokuthi kungani ungakwazi ukufinyelela idokhumenti ye-Excel, nakuba esinye esivame kakhulu yilapho idokhumenti "imakwa njengokugcina." I-Passer ye-Excel ikuvumela ukuthi ufinyelele kalula kudokhumenti ngaphandle kwemikhawulo ebekiwe, okuhlanganisa idokhumenti evikelwe ngephasiwedi.
