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

Chigadzirwa cheMicrosoft chinonyanya kushandiswa uye chakasimbaExcel, 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




KEYWORDS FUNGA TERM

  • Microsoft Excel kudzidzisa mu gurgaon
  • Microsoft Excel certification inodhura muGurgaon
  • Institute for Microsoft Excel mu gurgaon
  • Microsoft Excel muGurgaon
  • Microsoft Excel certification mu gurgaon
  • Microsoft Excel course muGurgaon
  • Best Microsoft Excel Training Online
  • Microsoft Excel kudzidzisa


Reviews




KEYWORDS FUNGA TERM

  • Microsoft Excel kudzidzisa mu gurgaon
  • Microsoft Excel certification inodhura muGurgaon
  • Institute for Microsoft Excel mu gurgaon
  • Microsoft Excel muGurgaon
  • Microsoft Excel certification mu gurgaon
  • Microsoft Excel course muGurgaon
  • Best Microsoft Excel Training Online
  • Microsoft Excel kudzidzisa


MSExcel Zvidzidzo zvinopiwa pasi apa