Uyafuna ukufunda okwengeziwe ngemisebenzi ye-Excel? Kuthiwani ngokufunda ukuthi ungazisebenzisa kanjani emsebenzini wakho? I-Microsoft Excel iqukethe imisebenzi eminingi kangangokuthi ngisho nabasebenzisi abanolwazi ngeke bakwazi ukuzulazula ngokucacile konke lokhu kuhlukahluka. Hhayi-ke 30 Excel isebenza ngezinsuku ezingama-30 izoba umfutho onamandla wokuzithuthukisa futhi izokufundisa ukuthi ungenza kanjani izinto ezimangalisayo ezincwadini ze-Excel.
Uma ungumsebenzisi we-Excel we-novice futhi uze kule sayithi ukuze ufunde yonke into kusukela kweziyisisekelo, ngiphakamisa ukuthi uqale ubheke Isifundo sethu se-Excel sabaqalayo. Kuyo uzothola ulwazi oluningi oluseqophelweni eliphezulu nolusizo.
Siyini lesi sifundo?
Zonke izifundo ezingama-30 ziwukuhunyushwa kwe-marathon yama-athikili eyenziwe yi-Canadian Excel guru - UDebrie Dalgleish. Nsuku zonke kusukela ngo-January 2, 2011 kuya ku-January 31, 2011, kwakukhona isihloko kubhulogi ye-Contextures echaza esinye salezi zici. Yonke imisebenzi ihlukaniswe ngezigaba: umbhalo, ulwazi, nokusesha kanye nezixhumanisi. Isigaba sohlu lwesici sihlinzeka ngezixhumanisi zokuhunyushwa kwazo zonke lezi zihloko.
I-athikili ngayinye iqukethe okulandelayo:
- Incazelo echaza ukuthi isici ngasinye sisebenza kanjani.
- Zonke izifundo ezingu-30 zihambisana nezithombe-skrini ezikuvumela ukuthi udlulisele ngokucacile ulwazi olubalulekile (izithombe zithathwe ku-Excel 2010).
- Izibonelo ezisebenzayo zokusebenzisa amafomula e-Excel kokubili eyedwa kanye neminye imisebenzi.
- Izingibe ezingase zivele lapho usebenza nemisebenzi.
- Kanye nolunye ulwazi oluwusizo ngokulinganayo.
Ngizokwenzani?
Ngosizo lwale marathon, uzokwazi ukwandisa ulwazi lwakho lwemisebenzi ye-Microsoft Excel futhi wenze izincwadi zakho zokusebenza zisebenze kahle. Funda ukuthi yiziphi izici ezisebenza kangcono ezimweni ezithile, nokuthi yiziphi izici okufanele uzigweme ngokuphelele.
Lo mhlahlandlela uzokusiza ukuthi usebenzise imisebenzi ejwayelekile ngempumelelo. Ngisho naleyo misebenzi ye-Excel osebenza ngayo nsuku zonke ingase iqukathe izici ezifihliwe nezingibe obungazi ngazo. Ungasebenzisa ngokuphepha zonke izibonelo ezethulwe emsebenzini wakho.
Uhlu lwezici:
Usuku 01 - IQINISO - ingabheka izintambo zombhalo ezimbili ukuze zifane ncamashi, futhi, ngaphezu kwalokho, zizwela kakhulu.
Usuku 02 - IZINDAWO - Ibuyisela inombolo yezindawo kusixhumanisi.
Usuku 03 - I-TRIM - Isusa zonke izikhala ochungechungeni lombhalo, ngaphandle kwesikhala esisodwa phakathi kwamagama.
Usuku 04 - ULWAZI - Ibonisa ulwazi mayelana nendawo yokusebenza yamanje.
Usuku 05 - KHETHA - Ibuyisela inani ohlwini, ikhethe ngokwenkomba yezinombolo.
Usuku 06 - OKUHLELIWE - Ifinyeza inombolo ibe inombolo ethile yezindawo zamadesimali futhi ibuyisela umphumela ngefomethi yombhalo enezinkulungwane noma ngaphandle kwezihlukanisi.
Usuku 07 - IKHODI - Ibuyisela ikhodi yezinombolo yohlamvu lokuqala lweyunithi yezinhlamvu yombhalo.
Usuku 08 – CHAR – Ibuyisela uhlamvu oluthile ikhodi yalo efana nenombolo efakiwe, ngokusekelwe kuthebula lezinhlamvu zekhompyutha yakho.
Usuku 09 – VLOOKUP – Ibheka inani kukholomu yokuqala yethebula futhi ibuyisela elinye inani kumugqa ofanayo kuthebula.
Usuku 10 – HLOOKUP – Ibheka inani kumugqa wokuqala wethebula futhi ibuyisela elinye inani elisuka kukholamu efanayo kuthebula.
Usuku 11 – IQEMBU (ISELI) – libonisa ulwazi mayelana nokufometha, okuqukethwe kanye nendawo yeseli kusixhumanisi esinikeziwe.
Usuku 12 – AMAKHOLOMU – Ibuyisela inani lamakholomu kuhlelo noma ireferensi.
Usuku 13 – TRANSPOSE – Ibuyisela ububanzi obuvundlile bamaseli njengobubanzi obuqondile noma ngokuphambene nalokho.
Usuku 14 – T (T) – Ibuyisela umbhalo uma inani kuseli liwumbhalo, noma iyunithi yezinhlamvu engenalutho uma kungewona umbhalo.
Usuku lwe-15 - REPEAT (REPT) - iphinda iyunithi yezinhlamvu zombhalo izikhathi eziningana.
Usuku 16 – LOOKUP – Ibuyisela inani elisuka kumugqa owodwa, ikholomu eyodwa, noma amalungu afanayo.
Usuku 17 – ERROR.TYPE – Ikhomba uhlobo lwephutha ngenombolo noma ibuyisela okuthi #N/A uma lingekho iphutha elitholakele.
Usuku 18 - SESHA - Ibheka iyunithi yezinhlamvu yombhalo ngaphakathi kwenye iyunithi yezinhlamvu yombhalo, futhi uma itholakele, ibika indawo yayo.
Usuku 19 – MATCH – Ibuyisela indawo yenani kumalungu afanayo, noma iphutha elithi #N/A uma lingatholwa.
Usuku 20 – IKHELI – Ibuyisela ireferensi yeseli njengombhalo ngokusekelwe kumugqa nenombolo yekholomu.
Usuku 21 – TYPE – Ibuyisela inombolo ecacisa uhlobo lwedatha.
Usuku 22 – N (N) – Ibuyisela inani eliguqulelwe enombolweni.
Usuku lwama-23 - THOLA - Uthola iyunithi yezinhlamvu zombhalo ngaphakathi kwenye iyunithi yezinhlamvu yombhalo, i-case sensitive.
Usuku 24 – INDEX – Ibuyisela inani noma ireferensi enanini.
Usuku 25 - REPLACE - Ifaka esikhundleni izinhlamvu ngaphakathi kombhalo ngokusekelwe enanini elishiwo lezinhlamvu nendawo yokuqala.
Usuku 26 - OFFSET - Ibuyisela isixhumanisi kusuka kusixhumanisi esinikeziwe ngenani elithile lemigqa namakholomu.
Usuku 27 - SUBSTITUTE - Imiselela umbhalo omdala ngombhalo omusha ngaphakathi kweyunithi yezinhlamvu yombhalo.
Usuku lwama-28 - HYPERLINK - idala isixhumanisi esivula idokhumenti egcinwe kukhompuyutha, iseva yenethiwekhi, inethiwekhi yendawo noma i-inthanethi.
Usuku 29 - CLEAN - Isusa ezinye izinhlamvu ezingaphrintiwe embhalweni.
Usuku 30 - INDIRECT - Ibuyisela isixhumanisi esinikezwe iyunithi yezinhlamvu yombhalo.