Ukufometha okunemibandela ku-Excel kuyinketho engasisiza sigaye ulwazi oluphakanyiswa yi-spreadsheet ngendlela enobungane kakhulu.. Amadokhumenti e-Excel avame ukugcwala izibalo kanye nezibalo ezizobonwa noma zihlaziywe nguwe noma abanye, ngakho-ke kungaba kuhle ukuba nenye indlela esivumela ukuthi sisheshise le nqubo. Ithuluzi le-Microsoft liphawulwe ngokuhlanganisa inqwaba yemisebenzi evumela noma yini ukuthi yenziwe ngokushesha iye ekuzenzekeleni. Ngakho-ke, namuhla sizokukhombisa konke okudingeka ukwazi ukuze uqale ukusebenzisa ifomethi enemibandela emsebenzini wakho.
Ngale ndlela, uzokwazi ukuthuthukisa ukuba wusizo kwetafula lakho le-Excel futhi wonge isikhathi esiningi emisebenzini yokugqamisa ulwazi nokuhlaziya.
Kuyini ukufometha okunemibandela ku-Excel?
I-Excel wuhlelo olugcwele amathuluzi angagcini nje ngokuhlanganisa indawo yokubala, kodwa nokuthi yini ebhekisela kufomethi kanye nendlela idatha nolwazi okwethulwa ngayo eshidini.. Lokhu kwakamuva kubalulekile, uma kucatshangelwa ukuthi izincwadi zokusebenza ze-Excel ngokuvamile azigcinelwa zona, kodwa ngokuvamile zithunyelwa kwabanye abantu ukuze zibuyekezwe futhi zihlaziywe. Ngenkathi kwenziwa lokhu kwakamuva, kuvamile ukuthi izibalo ezithile zigqanyiswe kuye ngokuthi yiziphi izici ezibhekwayo, nokho lokhu kubuye kuvule umnyango wamaphutha omuntu. Singase sigeje kalula iseli ebalulekile noma sigqamise engahlangabezani nesikufunayo.
Ukuqeda le nkinga, ifomethi enemibandela ivela ku-Excel, okuthi, njengoba negama layo libonisa, isivumela ukuthi sifomethe iseli noma ububanzi bamaseli, ngokusho kokugcwaliseka kwesimo esithile.. Isibonelo, uma ubuncane benhloso yokuthengisa yebhizinisi lakho ingu-€500, maka amaseli amanani awo angafiki kule nombolo ngokubomvu. Ngale ndlela, ishidi le-Excel lizozikhulumela ngokwalo ngale khodi yokufometha oyibekele izinkambu ezibalulekile.
Ukusetshenziswa ongakunikeza kulo msebenzi kuningi futhi njengoba sishilo ngaphambili, kuzonikeza usizo olukhulu kakhulu kusipredishithi.. Ukuqhubeka nesibonelo sokuthengisa, uma uhlanganisa okwenziwayo ngakunye kosuku futhi usebenzisa ifomethi enemibandela kuseli ebonisa inani, izoshintsha umbala uma nje ufinyelela umgomo omncane. Lokhu kusebenza njengenkomba ebonakalayo ekhangayo yombhalo olula we-Excel.
Izinto zokufometha okunemibandela
Indawo yefomethi enemibandela ku-Excel ibanzi kakhulu futhi kufanelekile ukuyazi ukuze usebenzise izinketho ezihlanganisayo nezisinikeza ithuba lokunikeza impilo kuspredishithi sethu. Kodwa-ke, singasho ukuthi ukusetshenziswa kwayo kulula ngempela futhi kwanele ukwazi izingxenye zayo ezintathu eziyinhloko ukuze uzijwayeze ngokugcwele. Yilezi: izimo, imithetho kanye namafomethi.
Izimo
Isimo asiyona into engaphezu kwesici esisisebenzisa njengereferensi yokuchaza ukuthi okuthile kuzokwenzeka noma cha.. Isibonelo, uma lina, ngizothatha isambulela, okusho ukuthi ukuthatha isambulela kunombandela wokuthi liyana. Okufanayo kwenzeka ku-Excel ngefomethi enemibandela, isimo sisungulwa ngokusekelwe ekutheni iseli linenombolo ethile, umbhalo noma idethi futhi uma kunjalo, kuzosetshenziswa umthetho.
Imithetho
Imithetho yileyo esungula ukuthi kuzokwenzekani uma kufezwa umbandela oshiwo ngaphambilini.. Ukuqhubeka nesibonelo sesambulela, umthetho kuleli cala ukuthatha nawe, uma lina. Ngalo mqondo, uma siyisa ku-Excel, umthetho uzokhombisa ifomethi ezosetshenziswa emthethweni lapho isimo sifinyelelwa.
Amafomethi
Ngaphakathi kwe-Microsoft Office suite, amafomethi amelela yonke into ehlobene nengxenye yobuhle nebonwayo yedokhumenti esisebenza kuyo. Lokhu kusuka kufonti, kuya kusayizi wayo, umbala nombala wangemuva, ngakho ukufometha okunemibandela akuyona into engaphezu kwethuluzi elikuvumela ukuthi usebenzise konke lokhu, ngokusekelwe ezimeni nemithetho esiyichazile ngaphambili.
Ungakusebenzisa kanjani ukufometha okunemibandela ku-Excel?
Izinyathelo zokusebenzisa ukufometha okunemibandela okuyisisekelo
Uma usuvele unombono wokusebenzisa ukufometha okunemibandela eshidini lakho le-Excel, kufanele wazi ukuthi ukwenza kanjalo kulula kakhulu. Ukuze siqalise, kufanele siqale sikhethe iseli noma uhla lwamaseli esifuna ukulifometha ngokuya ngesimo. Bese uchofoza kokuthi «Ifomethi enemibandela»bese uye kokuthi «Imithetho Yeseli", ezobonisa lonke uchungechunge lwezinketho ongazisebenzisa. Lezi zisukela ekuboneni amanani amakhulu, amancane noma alinganayo, emibhalweni nezinsuku.
Ngokuchofoza, isibonelo, kokuthi «Kudala kuno", kuzovela iwindi elincane le-popup elinezinkambu ezimbili. Kowokuqala, kuzodingeka ufake isibalo sereferensi futhi okwesibili uzokwazi ukukhetha phakathi kwamafomethi ambalwa achazwe ngaphambilini noma wengeze engokwezifiso.
Ekugcineni, chofoza okuthi «ukwamukela»futhi sekuphelile, manje izinombolo ezinkulu kunalena oyikhombisile ngaphambilini zizomakwa ngefomethi ekhethiwe.
Ukufometha Okunemibandela Nezithonjana
Kuyaphawuleka ukuthi ukufometha okunemibandela akusebenzi nje kuphela ngokushintsha umbala wokugcwalisa wamaseli nezinhlamvu, kungenzeka futhi ukubonisa izithonjana esikhundleni semibala yakudala. Lokhu kuyathakazelisa kakhulu ngoba kukhulisa amandla okuxhumana nawokuhlaziya eshidi le-Excel, okwenza kube lula ukubona ukuthi kwenzekani ngento ngayinye.
Ukusebenzisa lolu hlobo lokufometha okunemibandela, sizoqala ngokukhetha iseli noma ifomethi yeseli ofuna ukuyifometha. Bese uchofoza kokuthi «Ifomethi enemibandela«, hamba esigabeni semithetho bese ukhetha ukuthi yini ofuna ukusetha umbandela ozohlangatshezwana nawo.
Bese uchofoza futhi kokuthi "Ifomethi enemibandela»kodwa, kulokhu iya ku-"isethi yesithonjana»bese ukhetha okufunayo.
Ngokushesha, uzobona ukuthi zivela kanjani kwesokunxele seseli ngalinye ezinombala ozikhombayo.
Ukufometha Okunemibandela Ngebha Yedatha
Ngendlela efanayo naleyo esisebenzisa ngayo izithonjana noma imibala kumaseli, singasebenza futhi ngamabha edatha. Lokhu kuwusizo ikakhulukazi uma sakha izibalo ezidinga ukuqhathaniswa nezinye. Amabha wedatha azosivumela ukuthi sibe nendlela ebonakalayo ecacile kakhulu kulokhu kuqhathaniswa, okwenza ulwazi lufinyeleleke kalula.
Uma ufuna ukusebenza ngamabha edatha ekufometheni okunemibandela kwe-Excel, kufanele ulandele izinyathelo ezifanayo esixoxe ngazo ngenhla. Okusho ukuthi, khetha iseli noma uhla lwamaseli, chofoza okuthi «Ifomethi enemibandela»bese ukhetha umthetho ofuna ukuwusebenzisa kumenyu yemithetho. Bese, phinda inqubo ngokuya kokuthi “Ifomethi enemibandela»bese ufaka «amabha wedatha»ukukhetha uhlobo lwebha ofuna ukuyengeza. Uma usichofoza, zizobe sezingeziwe kuspredishithi sakho.
Njengoba sibona, ukufometha okunemibandela kuyisimangaliso sangempela esizothuthukisa isipredishithi sakho, ukusebenzisa kwakho i-Excel, nomsebenzi wokugqamisa idatha nokwenza ukuhlaziya. Kuyindlela elula ngempela ukuyisebenzisa, ngakho-ke kufanelekile ukuyizama kunoma iyiphi yezincwadi zakho zokusebenza ze-Excel.