mhandoChikoro Kudzidzisa
zuvaSep 9, 2017
nguva2 Days
nyoresa

Taura nesu

Minda yakaiswa ne * zvinodiwa

 

MS Excel Training

tsananguro

Zvinotarisirwa

Course Outline

Purogiramu nemitengo

kutaura kuti ichokwadi

MS Excel Training Course & Certification

Microsoft’s most commonly & powerful used tool is  Excel, iyo inoshandiswa pasi rose. Uye nedzimwe nzira yakanyatsogadzirirwa izvi zviri nyore kwazvo kuwana ruzivo kuti uwane unyanzvi nekushandisa zvakanyanya nyore. ITS ine dzidzo dziripoMS- ofisi 2007/2010 / 2013uye2016naizvo.

Zvinotarisirwa

Vadzidzi vanofanira kuziva ruzivo rwekombiyuta.

Nzira Yokubuda Nenguva Inguva: 2 Days

  1. Kugadzirisa nekugadzirisa mabhuku emabasa uye mapepa ekushanda
    • Kugadzirisa & kuisa Mapepa nemabhuku
    • Kuona mafiropu akaisvonaka mumatambi akawanda
    • Kunyoresa Row Rwokutanga kana Pakutanga Kwekutanga uchishandisa Freeze Panes
    • Nzira dzakanakisisa dzekuchengetedza nguva yekugadzirisa zvigadziriro zvekugadzirisa Peji
    • Maitiro akasiyana-siyana ekugadzirisa mafungiro pamwe chete neChimiro chekugadzirisa maitiro maererano nemitemo, Duplicate records, Data bars, nezvimwewo
  2. Kuita Excel nheyo kuburikidza nemhando dzakasiyana-siyana, Mabasa uye Referencing
    • Mhemberero Inoshanda seLen, Concatenate, Kumusoro, Pasi, Yakakodzera & Tsika.
    • Manzwiro Anoshandiswa akaita seAi uye Multiple Ifs
    • Mathematical Mabasa akaita Sum, Abs, Round, Roundup & Rounddown
    • Nheyo dzeStatistical dzakadai sokuverenga, Counta, Countblank, Mazano, Mazano, Sumif, Sumifs, Average, Averageifs, Min, Max, Small and Large
    • Lookup Mabasa akaita seVlookup neHookup pamusana chaiyo neyokuenzanisa
    • Kusunungura kero yesero mune imwe nzira yekuisa $ $ (Absolute Referencing)
    • Kubatanidza mapepa akawanda uye mabhuku ekushanda mu formula (3D Referencing)
  3. Kushanda neData
    • Kuumba nekugadzirisa MaList Lists
    • Kuparadzanisa deta uchishandisa Text kuColumns
    • Kuronga dhidhiyo muArafabheti pane imwechete & multiple fields
    • Kuronga dheta muGadziriro yakarongeka nekuisa mazita
    • Kuronga dhesi kuruboshwe kuenda kurudyi
    • Kuchenesa dhidhiyo uchishandisa Filters & Advance Filters (Nyora Filters, Text Filters, Date & Time Filters, Zvinyorwa zvakasiyana, Duplicate zvinyorwa & Rudzi Ruchenesa)
  4. Kuongorora dhidhiyo kuburikidza nePivot Tables
    • Kusarudza Mazano Akanakisisa & kuwedzera minda
    • Kushandisa mabasa akawanda pamatafura epivot
    • Kutendeuka kwemasero asina kuvharika uye maonero ekukanganisa ne 0
  5. Inomiririra Dhidhiyo muChipalomu Form
    • Kusarudza mazano akanakisisa maererano neda data
    • Kushandisa Column Charts, Chati Bharati, Line Charts & Pie Charts
    • Kugadzira Zvinyorwa, kuwedzera Dhairidzo dzeChirati & Kuchinja Chati Mzvimbo
    • Kubatanidza Chirati neShoko uye PowerPoint
  6. Kushanda neAvantance Excel Mabasa
    • Kuchengetedza maitiro panzvimbo yakarurama panzvimbo yekusiyiwa
    • Kuita zvinyorwa pamatafura akawanda nemamiriro akasiyana-siyana
    • Kuita zvitsva pane dzimwe nzvimbo
    • Kuita nyaya yacho seneteps
    • Kubatanidza zvitsvene zvisinganzwisisiki uye zvakajeka kuburikidza neMatch & Index Functions
    • Zuva rinoshanda seNhasi, Iye zvino, Zuva, Mwedzi, Gore, Mazuva Anoshanda & Networkdays
    • Statistical Functions seMedian uye Mode
  7. Kushanda neRange uye Naming Convention
    • Kushandisa Zita kune imwe sero uye mapoka emasero
    • Kugadzirisa, Kubudisa Range Mazita & Kuzvinyora kusika Mazita maererano nesheji
  8. Kugadzirisa Dhiyabhorosi
    • Kubatanidza Excel Data neShoko Documents, PDF Files & zvinhu zvekunze kuburikidza neHyperlinks
    • Kuisa Dhiyabhorosi kubva kunze Sources seMagwaro Files, CSV Files, etc
    • Mumiririri weData mune imwe sarudzo iri nani uchishandisa Tables
    • Kubvisa Duplicate zvinyorwa kubva kuDex data
    • Kugadzira dashboards zvakakurumidza / mafomu nekudzivirira dheinhe rakadzama kuburikidza neDataredzi Dhidhiyo
    • Kudzivirira dashbhoards / mafomu kuburikidza nekuvhara & Kuzarura chikamu chakati chemashizha
    • Kubatanidza nhoroondo kubva kumabhuku akasiyana-siyana emabasa kuburikidza neData Consolidation
  9. Kuongorora Excel Data
    • Kushandisa Subtotals kuti iongorore deta pane imwechete & multiple fields
    • Kubatanidza uye Kubatanidza Excel Data muPivot Tables
    • Kuwedzera Mavharo Akaverengwa muPivot Tables
  10. Kuita Zvakadini kana Zvishandiso Zvishandiso
    • Kuverenga Input Value kuburikidza neKubudisa Kwekushandisa uchishandisa Goal Seek
    • Kuongorora Dhiyabhorosi neZvinyorwa Zvinyorwa zvinoshandisa Scenarios Manager
  11. Kushandura kweMabasa uye Kuenzanisira Kwemifananidzo (Sezvakaitika pakuwanikwa kwenguva)
    • Inomiririra deta nekubatanidza Column & Line Charts pane zvakanyanyisa
    • Kuratidzira zvipo zvepaDa Pie chati kana Bhar of Pie Charts
    • Kuvandudza mabasa kuburikidza neKeyboard Shortcuts
    • Automation of the works by Recording Macros
    • Kuchengetedza mabhuku ebasa neMacro Maitiro akaenderana

Ndapota nyorera kwatiri pane info@itstechschool.com & taura nesu pa + 91-9870480053 pamutengo wemari uye chechivimbiso, purogiramu & nzvimbo

Dhidzai Mhinduro

Kuti uwane mamwe mashoko nemutsa Taura nesu.


Reviews



Reviews



MSExcel Zvidzidzo zvinopiwa pasi apa