uhloboUqeqesho lweKlasi
umhlaSep 9, 2017
ixesha2 Days
INCWADI

Qhagamshelana nathi

Iimimandla ezimakwe kunye * zifunwa

 

Training Excel

isishwankathelo

Mfuneko

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

MS Excel Training Course & Certification

Microsoft’s most commonly & powerful used tool is  Excel, esetyenziswa emhlabeni jikelele. Kwaye ngeklasi eyenzelwe ngokukhethekileyo oku kulula kakhulu ukufumana izakhono ukuze ube nobuchule kunye nokusebenzisa i-excel kalula. ZINAKHO izifundo ezikhoyoMS- ofisi ye2007/ U2010 / 2013yaye2016njengokuba.

Mfuneko

Abaviwa bafanele bazi ulwazi olusisiseko lwekhompyutha.

Ixesha loKhutshwa kweNkundla: Iintsuku ze-2

  1. UkuLawula nokuFometha iiWebhu zeeNcwadi kunye neesebenzi
    • Ukulawula & ukuseta iiSpredishithi kunye neeNcwadi zeeNcwadi
    • Ukujonga iifayile eziphambili kwiimathebhu ezininzi
    • Ukukhupha iRow Row okanye iKholam yokuQala usebenzisa i-Freeze Panes
    • Izindlela zokugcina ixesha elifanelekileyo zokulawula ukhetho lwekhasi
    • Izindlela ezahlukeneyo zokufomatha kunye neFomathi yokuFomathiza ngokweMigangatho, iiRekhodi eziphindaphindiweyo, iirejista zeenkcukacha, njl
  2. Ukwenza iingxelo ze-Excel ngeefomula ezahlukeneyo, imisebenzi kunye nokuBhekisela
    • ImiSebenzi YemiSebenzi njengoLen, iConcatenate, Ephezulu, ephantsi, efanelekileyo neyokuCoca.
    • Imisebenzi enengqiqo njenge-If and Multiple Ifs
    • Imisebenzi yeMathematika njengeSum, Abs, Round, Roundup & Rounddown
    • ImiSebenzi yokuSitatisti njenge-Count, Counta, Countblank, Countif, Counti, Sumif, Sumifs, Umyinge, Umyinge wokuPhakamisa, iMin, uMax, Omncinane kunye Omkhulu
    • Imisebenzi yokuLookup njengeVlookup kunye neHlookup kumdlalo othe ngqo kunye nendawo
    • Ukukhupha idilesi yeseli kwifomula ngokufaka uphawu lwe $
    • Ukudibanisa amanqaku amaninzi kunye neencwadi zokusebenzela kwifom (3D Reference)
  3. Ukusebenza ngeDatha
    • Ukudala nokuguqula iiList Custom
    • Ukwahlula idatha usebenzisa i-Text kuya kwiikholam
    • Ukuhlela idatha kwi-Alphabetical order kwimimandla eyodwa kunye neqela
    • Ukuhlelwa kwedatha ngohlobo olumiselweyo ngokuthumela izintlu
    • Ukuhlela idatha kwi-Left ukuya kwi-oda elungileyo
    • Ukukhipha idatha ngokusebenzisa i-Filters ne-Advance Filters (Izihlungi zeenombolo, izihlungi zemiyalezo, i-Date & Time Filters, iiRekhodi eziZodwa, iiRekodi zeDeplicate kunye nokuHlukisa imibala)
  4. Ukuhlalutya idatha ngokusebenzisa iifayile zePivot
    • Ukukhetha iZakhiwo ezifanelekileyo kunye nokongeza iindawo
    • Ukusebenzisa imisebenzi emininzi kwietafile eziphambili
    • Ukuguqulwa kwamaseli angenanto kunye neempazamo zephutha kunye ne-0
  5. Ukumela iDatha kwiFomu leMpawu
    • Ukukhetha iitshathi ezona zifanelekileyo njengedatha
    • Ukusebenzisa i-Charts Charts, iTharthi yeBharti, iiKharati zeeNqaku kunye neeCharts zePee
    • Iifomathi zoFomathi, ukongeza iiTyitile zeTyati kunye neendawo zokutshintsha ishadi
    • Ukudibanisa iiKharithi ngeLizwi kunye nePowerPoint
  6. Ukusebenza kunye neMisebenzi yasePrese Excel
    • Ukwenza i-lookups kwindawo elungileyo endaweni yekhohlo
    • Ukwenza i-lookups kwietafile ezininzi ngeemeko ezahlukeneyo
    • Ukwenza i-lookups kwiindawo ezininzi
    • Ukwenza ityala elijongene nolwaphulo
    • Ukudibanisa i-lookups kunye ne-vertical lookups ngokusebenzisa iMats & I-Index Imisebenzi
    • Imisebenzi yemihla efana Namhlanje, ngoku, imini, inyanga, unyaka, ii-Workdays & Daydays
    • Imisebenzi yeSatisatisti njengeMedian kunye neMode
  7. Ukusebenzisana neNgqungquthela yeRange kunye negama
    • Ukusebenzisa igama kwiiseli kunye nohlu lweeseli
    • Ukuguqula, ukususa amaGama amaninzi nokudala ngokuzenzekelayo amagama ngokweSiseko
  8. Ukusingatha idatha
    • Ukuqhagamshelanisa i-Excel Data kunye namaxwebhu e-Word, iiFayile zePail kunye nezinto zangaphandle ngokusebenzisa iiHlinklink
    • Ukungenisa iDatha kwiMithombo yangaphandle efana neFayile yeeFayile, iiFayile ze-CSV, njl
    • Ukumelwa kweDatha kwisakhiwo esingcono usebenzisa iiTables
    • Ukususa iirekhodi eziphindaphindiweyo kwi-Excel yedatha
    • Ukuqulunqa ideshibhodi ezikhawulezayo / iifom ngokukhawulela idatha ethile ngokusebenzisa iziqinisekiso zeData
    • Ukukhusela iifashishoni / iifom ngeTlocking & Ukuvula inxalenye ethile yamaphepha
    • Ukuhlanganiswa kweengxelo ezivela kwiincwadi ezahlukeneyo zokusebenzela ngeDatha yokuQinisa
  9. Ukuhlalutya i-Excel Data
    • Ukusebenzisa ii-Subtotals ukuhlalutya idatha kwiinkalo ezifanayo kunye ezininzi
    • Ukuqoqa kunye nokuqokelela i-Excel Data kwii-Pivot Tables
    • Ukongeza iiNdawo eziQingqiweyo kwiiTable Tiv
  10. Ukwenza ntoni ukuba Uluhlu lwezoHlolo
    • Ukubala Ixabiso lokungena ngokweSiseko soPhuculo usebenzisa i-Goal Seek
    • Ukuhlalutya iDatha ngeenkqubo ezininzi ze-Scenarios Manager
  11. Ukuzenzekelayo kweeMisebenzi kunye nokuBaliswa koMfanekiso (njengokuba kukho ukufumaneka kwexesha)
    • Ukumela idatha ngokudibanisa iKholam kunye neeLathisi zeMida kwi-axis multiple
    • Ukumela umrhumo wedatha ngePie yeTyiti yetshisi okanye iBhar of Pie Charts
    • Ukuphucula imisebenzi ngokusebenzisa iifomaththi zekhibhodi
    • Ukuzenzekelayo kwemisebenzi ngokuBhala iMacros
    • Ukugcina iincwadi zokusebenzela kunye nee-Macro ezihambelanayo

Nceda ubhalele apha info@itstechschool.com & xhumana nathi kwi-91-9870480053 kwixabiso lekhosi kunye neendleko zokuqinisekisa, ishedyuli kunye nendawo

Usilahle Umbuzo

Ukufumana ulwazi olungakumbi Qhagamshelana nathi.


Reviews



Reviews



Umxholo we-MSExcel Inqaku linikezelwa ngezantsi