Uyihlaziywa njani i-Excel

Uyihlaziywa njani i-Excel: Uyigcina njani iSpreadsheet sakho sihlaziyiwe

Xa kuziwa ekusebenzeni ngeespredishithi kunye nohlalutyo lwedatha, i-Excel sisixhobo esimele sibe nayo kubantu abaninzi. Nangona kunjalo, ukwenza uninzi lwazo zonke imisebenzi yayo kunye neempawu, kubalulekile ukuba uhlale usexesheni ngeenguqulelo zamva nje kunye nohlaziyo lwenkqubo.

Kweli nqaku lobugcisa, siza kuphonononga imiba eyahlukeneyo enxulumene nokuhlaziya i-Excel. Uya kufunda indlela yokuhlaziya i-Excel kwikhompyuter yakho, indlela yokusebenzisa iimpawu zohlaziyo ezibandakanyiweyo kwinkqubo, kunye nendlela yokukhuphela inguqulelo ekhoyo yamva nje. Ukongeza, siya kukukhokela kwinkqubo yongqamaniso lwe-Excel kunye ezinye i zicelo, ikuvumela ukuba udibanise kwaye wabelane ngedatha ngokufanelekileyo.

Siza kugubungela ukuseta uhlaziyo oluzenzekelayo, inqaku eliluncedo kakhulu kwabo bafuna ukuhlala begcina i-Excel isexesheni ngaphandle kokukhathazeka ngokujonga ngesandla kunye nokukhuphela uhlaziyo. Ukongeza, siya kukubonelela ngezisombululo kwiingxaki ezinokuvela ngexesha lohlaziyo.

Ukongeza, siza kukunika iingcebiso malunga nokwenza uninzi lohlaziyo lwe-Excel ukuphucula umsebenzi wakho, sikubonise amanqaku amatsha kunye nokusebenza okunokwenza ubomi bakho bube lula kwaye kuphucule ukusebenza kakuhle kwemisebenzi yakho yemihla ngemihla.

Okokugqibela, siza kukubonisa indlela yokusingatha utshintsho kwiinguqulelo ezintsha ze-Excel kunye nendlela yokufumana ulwazi oluthembekileyo malunga nohlaziyo kwi-intanethi.

Ukuba ukulungele ukuthatha izakhono zakho ze-Excel ukuya kwinqanaba elilandelayo kwaye ugcine i-spreadsheets zakho zihlaziyiwe kwaye zilungiswe, eli nqaku lenzelwe wena ngokukodwa!

11. Uzisebenzisa njani iifitsha ezintsha zohlaziyo lwe-Excel

Uhlaziyo lwamva nje lwe-Excel luza nezinto ezininzi ezinokukunceda wenze imisebenzi yakho yemihla ngemihla kwaye ukhawulezise umsebenzi wakho. Kweli nqaku, siya kukunika isikhokelo inyathelo ngesinyathelo ngendlela yokwenza uninzi lwezi mpawu zintsha:

1. Jonga ithebhu "yeDatha".: Enye yezinto ezingundoqo ezintsha kolu hlaziyo yithebhu "yeDatha", ekuvumela ukuba wenze uhlalutyo oluphambili kwaye ufumane ulwazi oluthe vetshe malunga nedatha yakho. Qinisekisa ukuba uphonononga zonke iinketho ezikhoyo kule thebhu, ezifana nezihluzi, iitafile zepivot, kunye nezixhobo zokuhlela.
2. Sebenzisa iimpawu ezintsha: I-Excel yazise amanqaku amatsha amaninzi kolu hlaziyo anokwenza umsebenzi wakho ube lula. Ezinye zezi mpawu ziquka umsebenzi "CONCATENATE", okuvumela ukuba udibanise isicatshulwa kwiiseli ezahlukeneyo mnye kuphela, kunye nomsebenzi "IF.ERROR", okuvumela ukuba uphathe iimpazamo ngokufanelekileyo kwiifomula zakho. Funda indlela yokusebenzisa ezi mpawu kwaye ulinge ngazo ukuze ufumane iziphumo ezichanekileyo nezisebenzayo.
3. Lungiselela iribhoni yakho: Ukuba kukho iimpawu ezithile ozisebenzisa rhoqo, unokwenza i-Excel iribhoni ibe nofikelelo olukhawulezayo kwezi zixhobo. Cofa nje ekunene kwiribhoni kwaye ukhethe “Yenza ngokwezifiso iRibhoni.” Okulandelayo, unokongeza, ucime okanye utshintshe iodolo yeenketho ezahlukeneyo ngokweemfuno zakho.

12. Uyenza njani i-backup phambi kokuhlaziya i-Excel

Ngaphambi kokuhlaziya i-Excel, kubalulekile ukwenza i yokugcina de iifayile zakho ukuphepha ilahleko data. Apha sikubonisa indlela yokwenza inyathelo ngenyathelo:

1. Vula i-Excel kwaye ucofe ithebhu ethi "Ifayile" engasentla ekhohlo kwesikrini.

• 2. Kwiphaneli yasekhohlo, khetha "Gcina njenge" ukuvula ifestile yokugcina.
• 3. Kwifestile yokugcina, khetha indawo ofuna ukugcina kuyo ukhuphelo lwakho.
• 4. Kwindawo ethi "Igama leFayile", faka igama elichazayo logcino lwakho.
• 5. Kwindawo ethi “Gcina njengohlobo”, khetha u-“Macro-enabled Excel Workbook (*.xlsm)” ukhetho.
• 6. Cofa iqhosha elithi "Gcina".

Nje ukuba ulandele la manyathelo, uya kuba udale ikopi yokhuseleko yakho Ifayile ye-Excel. Khumbula ukugcina le kopi kwindawo ekhuselekileyo, njenge drive yangaphandle okanye efini, ukunqanda ilahleko yedatha enokwenzeka xa kukho nayiphi na ingxaki ngexesha lohlaziyo lwe-Excel.

13. Ulubuyisela njani umva uhlaziyo lwe-Excel ukuba kuvela ingxaki

Ukuba ukhe wahlaziya i-Excel kwaye ungene engxakini, ungakhathazeki, kukho indlela yokubuyisela umva uhlaziyo kwaye ulungise naziphi na iimpazamo ezinokuthi zivele. Nantsi inyathelo ngenyathelo inkqubo yokubuyisela umva uhlaziyo lwe-Excel:

1. Into yokuqala ekufuneka uyenzile kukuvula i-Excel kwaye uye kwithebhu ethi "Ifayile". Okulandelayo, cofa "Ukhetho" kwaye ukhethe "Iziko loLawulo lokuThemba" kwindawo esekhohlo yefestile ephumayo.

• A
• 2

2. KwiZiko loLawulo lweTrasti, cofa “Iisetingi zeZiko loLawulo lweTrust” uze ukhethe “Iisetingi ezinkulu.”

• A
• 2

3. Emva koko, khetha "Musa ukwenza nayiphi na i-macros ngaphandle kwesaziso" kwaye ucofe "Kulungile" ukugcina utshintsho. Oku kuya kuthintela naziphi na iimacros ekusebenzeni ngokuzenzekelayo xa uvula ifayile ye-Excel. Ngoku ungavala iinketho zefestile.

• A
• 2

14. Uzenza njani iinketho zokuhlaziya kwi-Excel

Enye yeenzuzo ze-Excel kukukwazi ukwenza iinketho zohlaziyo ukuze zihambelane neemfuno zethu ezithile. Ngamanye amaxesha amaxabiso angagqibekanga awafikeleli kwiimfuno zethu, ngoko ke kubalulekile ukwazi ukuba ungaluguqula njani olu khetho ngokufanelekileyo. Apha siza kukubonisa inyathelo ngenyathelo ukuba uzenza njani ezi zikhetho kwi-Excel.

Inyathelo lokuqala ukwenza ukhetho lohlaziyo kwi-Excel kukuvula ithebhu ethi "Ifayile" kuyo isixhobo se bar. Emva koko, khetha u- "Options" kwi-drop-down menu. Emva koko, iwindow eneendidi ezininzi iya kuvula kwicala lasekhohlo. Cofa ku "Iifomula" ukufikelela kwiinketho zohlaziyo.

Kanye kudidi "lweeFomula", uya kubona iindlela ezininzi onokukhetha kuzo ukwenza uhlaziyo kwi-Excel. Olunye lolona khetho lubalulekileyo luyi-“Manual calculation”. Ngokwenza olu khetho, i-Excel ayiyi kuhlaziya ngokuzenzekelayo iifomyula xa utshintsho lwenziwa kwidatha, enokuba luncedo xa usebenza ngeeseti zedatha enkulu kwaye ufuna ukulawula xa iifomyula zihlaziywa. Unokwenza ngokwezifiso ireyithi yokuhlaziya kwinketho ethi "Yonke" ecaleni "Vuselela ukubala." Apha ungakhetha ixesha lokuphumla elifunekayo ukuze uhlaziye ngokuzenzekelayo iifomula kwi-spreadsheet sakho.

Ngamafutshane, ukuhlaziya i-Excel kwikhompyuter yakho ngumsebenzi obalulekileyo wokuqinisekisa ukuba usebenzisa inguqulelo yamva nje yesoftware kwaye uthatha inzuzo yazo zonke iimpawu kunye nophuculo. Kulo lonke eli nqaku, siye saphonononga imiba eyahlukeneyo enxulumene nokuhlaziya i-Excel, ukusuka kwindlela yokukhuphela inguqulelo yamva nje ukuya kwindlela ukusombulula iingxaki hlaziya kwaye uqwalasele uhlaziyo oluzenzekelayo.

Ukongeza, sixoxe ngendlela yokuthatha ithuba lohlaziyo lwe-Excel ukuphucula umsebenzi wakho, nokuba kukusebenzisa iimpawu zohlaziyo, ulungelelwaniso lwe-Excel. nezinye izicelo okanye ukugcina ispredishithi sakho sihlaziyiwe.

Sikwagubungele indlela yokusingatha utshintsho kwiinguqulelo ezintsha ze-Excel kunye nendlela yokufumana ulwazi malunga nohlaziyo lwe-Excel kwi-intanethi. Ezi zixhobo kunye nolwazi luya kukunceda uhlale uphezulu kuhlaziyo lwamva nje kwaye wenze uninzi lwezinto ezinokwenzeka ze-Excel kumsebenzi wakho wemihla ngemihla.

Khumbula ukuba ukugcina isoftwe yakho ihlaziywa akukuniki nje ukufikelela kwiimpawu ezintsha kunye nophuculo, kodwa kuqinisekisa ukhuseleko lwedatha yakho kunye nokuzinza kweefayile zakho. Ke ungathandabuzi, hlaziya i-Excel kwikhompyuter yakho kwaye ufumane yonke into le software inamandla no kuyenza yeyakho. Ukusebenza!