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

Microsoft’s Excel is most commonly & powerful used tool which is used worldwide. Innovative technology solutions is having a pool of trainers on Excel who can deliver Microsoft Excel trainings from Basic to Advance level. ITS has delivered more than 1000+ batches on Excel. Delivering training on VBA for Excel is our specialization. ITS is keep on running trainings on Excel in Corporate and for individual as well. Our specially designed course on Microsoft Excel is very easy to learn and it helps to acquire skills to become proficient in excel. ITS do have trainings available on MS- office 2007 / 2010 / 2013 futhi 2016 as well. We are expert in Excel Online training and can be customize as per participant need. For more enquiry on Excel training, please call @ : + 91-9870480053

Okudingekayo

Abafundi kumele bazi ulwazi oluyisisekelo lwekhompiyutha.

Course Outline Duration: 2 Days

  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