Izindlela ezi-6 zokukhubaza ukufunda ku-Excel 2016

Ifayela le-Excel lingafakwa kumodi yokufunda kuphela lapho ifayela limakwa njengeligcina, lapho lilondolozwe njengelifundwayo kuphela, noma lapho isipredishithi noma isakhiwo sencwadi yokusebenzela sikhiyiwe, njll. Nokho, nakuba ukufunda kungaba wusizo kangakanani, kungase futhi kube yisithiyo, ikakhulukazi uma ungazi ukuthi uwususa kanjani umkhawulo.

Kulesi sihloko, sizobe sibheka ezinye zezindlela zokuthi khubaza ukufunda ku-Excel 2016 ukuthi unayo iphasiwedi noma cha.

Ingxenye 1. Indlela Ejwayelekile Yokukhubaza Ukufunda ku-Excel 2016 Ngaphandle Kwephasiwedi

Ukukhubaza isici sokufunda kuphela ku-Excel kungaba nzima, ngisho kungenzeki, uma ungalazi igama-mfihlo elisetshenziswa ukubeka umkhawulo. Kodwa-ke, kukhona amathuluzi athile emakethe angakusiza ukuthi uqede ukufunda ku-Excel 2016 kalula. Enye yezinto ezinhle kakhulu I-Passer ye-Excel .

Okulandelayo ezinye zezici ezinikezwa i-Passer ye-Excel:

• Isekela ukususa zonke izinhlobo kumodi yokufunda kuphela awekho amaphasiwedi.
• Susa amaphasiwedi okuvula futhi kuqedwe ukuvikelwa kwe funda kuphela ku amaphepha okusebenzela/izincwadi I-Excel 2016 ngaphandle kokuthinta idatha yedokhumenti.
• Vula amadokhumenti e-Excel uma ukhohlwe iphasiwedi, awukwazi ukukopisha isipredishithi noma idatha yencwadi yokusebenzela, awukwazi ukuphrinta isipredishithi/incwadi yokusebenzela, noma awukwazi ukuhlela okuqukethwe kwedokhumenti.
• Ngaphezu kwalokho, kunjalo kulula kakhulu ukusebenzisa , njengoba ikuvumela ukuthi ususe ukufundwa ngokuchofoza okukodwa.
• Isekela zonke izinguqulo zemibhalo ye-Excel, okuhlanganisa i-Excel 96-Excel 2019.

Yizame mahhala

Nansi indlela yokusebenzisa i-Passer ye-Excel ukususa ukufunda kunoma iyiphi idokhumenti ye-Excel:

Isinyathelo 1: Landa futhi ufake i-Passer ye-Excel kukhompyutha yakho bese uqalisa uhlelo.

Isinyathelo sesi-2: Chofoza okuthi “Susa Imikhawulo” bese uchofoza okuthi “Engeza” ukuze uthole idokhumenti ye-Excel ekhawulelwe ohlelweni.

Isinyathelo sesi-3: Lapho ifayela lengeziwe kuhlelo, chofoza okuthi “Susa” futhi i-Passer ye-Excel izoqala ngokushesha ukususa imikhawulo efayeleni. Emizuzwaneni embalwa, uzokwazi ukufinyelela idokhumenti ye-Excel 2016 ngaphandle kwemikhawulo.

Yizame mahhala

Ingxenye 2. 5 Izimo Ezihlukene Zokukhubaza Ukufunda ku-Excel 2016

Ikakhulukazi kunezimo ezi-5 ezihlukene lapho i-Excel 2016 yakho imakwe njengefundwayo kuphela futhi isisombululo sazo esihambisanayo kuwukukhubaza isici sokufunda kuphela.

Icala 1: Uma idokhumenti yenziwe ukuthi ifundeke kuphela ngesikhathi sokulondoloza

Ungasebenzisa isici esithi “Londoloza Njengesingezansi” ukuvala imodi yokufunda ku-Excel 2016:

Isinyathelo 1: Qala ngokuvula incwadi yokusebenzela ye-Excel bese ufaka igama-mfihlo uma kunesidingo. Chofoza okuthi “Ifayela > Londoloza Njenge” bese ukhetha indawo efanelekile kukhompyutha yakho ukuze ulondoloze ifayela.

Kuphasisiwe 2: Chofoza umcibisholo wokudonsela phansi eduze kwenkinobho "Amathuluzi »bese ukhetha «Izinketho ezijwayelekile «.

Kuphasisiwe 3: Susa iphasiwedi evela ebhokisini elithi "Iphasiwedi ozoyishintsha" bese uchofoza okuthi "KULUNGILE" ukuze uphakamise umkhawulo wokufunda kuphela. Chofoza "KULUNGILE."

Kuphasisiwe 4: Ekugcineni, chofoza okuthi “Londoloza” ukuze uqedele inqubo.

Icala lesi-2: Uma idokhumenti imakwa njengokugcina

Ukumaka idokhumenti yakho ye-Excel 2016 njengokuthi “Okokugcina” kungase kubeke umkhawulo wokufunda kuphela embhalweni. Nansi indlela yokukhubaza lo mkhawulo kudokhumenti emakwe njengokugcina.

Isinyathelo 1: Vula idokhumenti ye-Excel 2016 ekhawulelwe kukhompyutha yakho.

Isinyathelo sesi-2: Phezulu kwedokhumenti, kufanele ubone inkinobho «Hlela noma kunjalo «. Yichofoze futhi umkhawulo wokufunda kuphela uzosuswa, okukuvumela ukuthi uhlele idokhumenti.

Icala 3: Uma isipredishithi noma isakhiwo sencwadi yokusebenzela sikhiyiwe

Imikhawulo yokufunda kuphela ingase yenzeke lapho umbhali wedokhumenti ye-Excel 2016 ekhiyile ukwakheka kwephepha lomsebenzi noma incwadi yokusebenzela, evimbela ukuthi ishidi lokusebenza lihlelwe. Kulokhu, ungakwazi ukuxazulula inkinga ngezinyathelo ezilandelayo ezilula:

Isinyathelo 1: Vula idokhumenti ye-Excel enomkhawulo wokufunda kuphela, bese uchofoza «Buyekeza > Ishidi elingavikeli «.

Isinyathelo sesi-2: Faka iphasiwedi ebhokisini elifanele bese uchofoza okuthi "KULUNGILE" ukuze uphakamise umkhawulo.

Icala lesi-4: Uma idokhumenti inesimo sokufunda kuphela

Ukufunda kungakhutshazwa ku-Excel 2016 kusetshenziswa inketho ye-File Properties ku-Windows File Explorer. Ukwenza kanjena:

Isinyathelo 1: Ku-File Explorer, zulazula uye kufayela le-Excel elinomkhawulo. Chofoza kwesokudla idokhumenti, bese ukhetha "Izakhiwo" phakathi kwezinketho eziveziwe.

Isinyathelo sesi-2: Susa ukumaka inketho "Funda kuphela " esigabeni «Izimfanelo » bese uchofoza okuthi «KULUNGILE» ukuze ukhubaze imikhawulo yokufunda kuphela.

Icala 5: Uma idokhumenti ye-Excel 2016 idinga iphasiwedi

Uma udinga ukufaka iphasiwedi ukuze ufinyelele futhi uhlele idokhumenti ye-Excel 2016, ungalandela lezi zinyathelo ezilula ukuze uphakamise lo mkhawulo:

Isinyathelo 1: Qala ngokuvula idokhumenti ye-Excel 2016 ofuna ukucisha isici sokufunda kuphela.

Isinyathelo sesi-2: Lapho ibhokisi lephasiwedi livela, chofoza "Funda kuphela » esikhundleni salokho futhi idokhumenti izovuleka ngemodi ethi Funda Kuphela.

Isinyathelo sesi-3: Manje chofoza "Faka kungobo yomlando > Igcine njenge »bese ufaka igama lefayela elehlukile. Chofoza ku-« Gcina »ukugcina ikhophi entsha yefayela lokuqala.

Ifayela elisha elidaliwe lizongena esikhundleni sedokhumenti yokufunda kuphela futhi ngeke libe nanoma yimiphi imikhawulo yelokuqala.

Izixazululo ezingenhla zenza kube lula kuwe ukukhubaza ukufunda kuphela ku-Excel 2016 noma ngabe unephasiwedi noma cha. Khetha indlela evumelana kangcono nezidingo zakho kanye nesimo sakho esithile. Sazise uma ukwazi ukususa umkhawulo wokufunda kuphela esigabeni samazwana esingezansi.

Yizame mahhala