uhloboUqeqesho lweKlasi
umhlaSep 9, 2017
ixesha2 Days
INCWADI

Training Excel

isishwankathelo

Mfuneko

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

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- ofisi ye2007/ U2010 / 2013yaye2016 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

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