UhloboUkuqeqesha ekilasini
UsukuSepthemba 9, 2017
Isikhathi2 Days
BHALISA
Ukuqeqeshwa kwe-MS Excel

Uhlolojikelele

Okudingekayo

Uhlaka Lokufunda

Uhlelo noHlelo

Certification

I-MS Excel Training Course & Certification

Ithuluzi le-Microsoft evame kakhulu futhi elinamandla kakhulu lisetshenzisiweExcel, esetshenziswa emhlabeni wonke. Futhi ngeklasi ekhethekile eyenzelwe lokhu kulula kakhulu ukuthola amakhono ukuze abe nekhono futhi usebenzise kahle kakhulu. ITSI zinezifundo ezitholakalayoMS- office 2007/2010 / 2013futhi2016kanjalo.

Okudingekayo

Abafundi kumele bazi ulwazi oluyisisekelo lwekhompiyutha.

Isikhathi sokuphuma kwesikhathi sezinkathi: Izinsuku ze-2

  1. Ukuphatha nokufometha Amabhuku Wezincwadi namakhasi Okusebenza
    • Ukuphatha & ukusetha amaSpredishithi & Izincwadi Zokusebenzela
    • Ukubuka amashidi amahle kakhulu kumathebhu amaningi
    • Ukufiphaza umzila ophezulu noma ikholomu yokuqala usebenzisa ama-Freeze Panes
    • Amasu angcono okugcina isikhathi sokuphatha izinketho zokusetha kwekhasi
    • Izindlela ezihlukahlukene zokufometha kanye nokufometha okunemibandela ngesisekelo samanani, amarekhodi aphindaphindiwe, imigoqo yedatha, njll
  2. Ukwenza imibiko ye-Excel ngefomula ehlukahlukene, Imisebenzi kanye nokuqhathaniswa
    • ImiSebenzi Yombhalo njengoLen, Concatenate, Ephezulu, Ephansi, Efanelekile & Ehlelwe.
    • Imisebenzi eqondayo ifana ne-If and Multiple Ifs
    • Imisebenzi yezibalo njenge-Sum, Abs, Round, Roundup & Rounddown
    • Imisebenzi yesitatimende njenge-Count, Counta, Countblank, Countif, Countives, Sumif, Sumifs, Average, Averageifs, Min, Max, Small and Large
    • Imisebenzi Yokungena njenge-Vlookup ne-Hlookup kumdlalo oqondile & wokulinganisa
    • Ukufiphaza ikheli leseli kufomula ngokufaka uphawu lwe $ $ (Ukuqhathaniswa okungekho emthethweni)
    • Ukuxhumanisa amashidi amaningi nezincwadi zokusebenza emsebenzini (i-3D Referencing)
  3. Ukusebenza nedatha
    • Ukudala nokuguqula uList Lists
    • Ukuhlukanisa idatha usebenzisa umbhalo kuya kumakholomu
    • Ukuhlunga idatha ku-Alfabhethi kwizinkambu ezilodwa neziningi
    • Ukuhlunga idatha ku-oda olwenziwe ngokwezifiso ngokungenisa izinhlu
    • Ukuhlunga idatha ngakwesobunxele kuya kwesokudla
    • Ukukhipha idatha usebenzisa ama-Filters & Advance Filters (Izihlungi Zombhalo, Izihlungi Zombhalo, Izihlungi Zosuku Nesikhathi, Amarekhodi Ayingqayizivele, Amarekhodi Aphindaphindiwe Nokuhlunga Umbala)
  4. Ihlaziya idatha ngemathebula we-Pivot
    • Ukukhetha ama Layouts best & wengeza amasimu
    • Ukusebenzisa imisebenzi eminingi kumatafula we-pivot
    • Ukuguqulwa kwamangqamuzana angenalutho namanani wephutha nge-0
  5. Ukumele idatha kuFomati ye-Graphical
    • Ukukhetha amashadi ahamba phambili njengedatha
    • Usebenzisa amashadi wekholomu, ishadi lamabha, amashadi womugqa namashadi wephayi
    • Amashadi wokufometha, enezela Iziqu zeThadi kanye nezindawo zokushintsha ishadi
    • Ukuxhumanisa Amashadi ngezwi ne-PowerPoint
  6. Ukusebenza ngemisebenzi ye-Advance Excel
    • Ukwenza i-lookups ensimini efanele kunokuba kwesokunxele
    • Ukwenza lookups kumathebula amaningi ngezimo ezihlukahlukene
    • Ukwenza lookups kumasimu amaningi
    • Ukwenza i-lookups ebucayi
    • Ukuhlanganisa ama-lookups angemuva neqondile ngokusebenza kwe-Match & Index
    • Imisebenzi yosuku njengamanje, manje, usuku, inyanga, unyaka, izinsuku zokusebenza namanethiwekhi
    • Imisebenzi yesitatimende njenge-Median ne-Mode
  7. Ukusebenza neRange no-Naming Convention
    • Ukusebenzisa igama esitokisini nakububanzi bamaseli
    • Ukuguqula, Ukusula Amagama Amagama & Ukwakha ngokuzenzakalelayo Amagama ngesisekelo sezihloko
  8. Ukuphatha Idatha
    • Ukuxhumanisa idatha ye-Excel nama-Word Documents, Amafayela we-PDF kanye nezinto zangaphandle ngokusebenzisa ama-Hyperlink
    • Ukungenisa Idatha kusuka Emithonjeni yangaphandle njengama-Text Files, ama-CSV Files, njll
    • Ukumelelwa kweDatha ngesakhiwo esingcono usebenzisa amathebula
    • Ukususa amarekhodi aphindaphindiwe kusuka kuDatha ye-Excel
    • Ukuklama ama-dashboards okusheshayo / amafomu ngokuvimbela idatha ethize ngokusebenzisa ukuqinisekiswa kwedatha
    • Ukuvikela ama-dashboards / amafomu ngokuLondoloza nokuvula ingxenye ethile yamashidi
    • Ukuhlanganisa imibiko evela ezincwadini ezahlukene zokusebenza ngeDatha Ukuhlanganiswa
  9. Ihlaziya idatha ye-Excel
    • Ukusebenzisa ama-Subtotals ukuhlaziya idatha emasimini angabodwa kanye amaningi
    • Ukuhlanganisa nokuhlanganisa idatha ye-Excel kumathebula we-Pivot
    • Ukwengeza Izinsimu Ezibalwa Emathebula We-Pivot
  10. Ukwenza Kuthiwani Uma Amathuluzi Wokuhlaziya
    • Ukubala I-Value Input ngesisekelo seNzuzo yokuPhuma usebenzisa i-Goal Seek
    • Ukuhlaziya Idatha ngezinhlelo eziningi ze-Scenarios Manager
  11. Ukuzenzekelayo kwemisebenzi nokumelela okunemifanekiso (njengokungathi ukutholakala kwesikhathi)
    • Emele idatha ngokuhlanganisa amashadi wekholomu namanethiwekhi kuma-axis amaningi
    • Emela iminikelo yedatha yi-pie ye-pie ishadi noma ibha yamashadi amasha
    • Ukuthuthukisa imisebenzi ngokusebenzisa izinqamuleli zekhibhodi
    • Ukuzenzekelayo kwemisebenzi ngokuqopha ama-Macros
    • Ilondoloza amabhuku okusebenza nge-Macro Izinketho ezihambisanayo

Sicela ubhalele ku- info@itstechschool.com & uxhumane nathi ku-91-9870480053 ngezindleko zemali & isitifikedi, isimiso & indawo

Siphonsa Umbuzo

Ukuze uthole olunye ulwazi ngomusa Xhumana nathi.


Izibuyekezo





Izibuyekezo





I-MSExcel Okuqukethwe kohlelo kunikezwa ngezansi