TypeHo Koetlisa Sekolo
letsatsiSep 9, 2017
Time2 Matsatsi
Ngodisa

Koetliso ea Excel ea MS

Overview

batlehang

Tlhahiso ea Tlhahlobo

Kemiso le Litefiso

tiiseletswe

MS Excel Koetliso ea Koetliso le Koetliso

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 2007 / 2010 / 2013 'me 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

batlehang

Bakhethi ba lokela ho tseba tsebo ea motheo ea k'homphieutha.

Course Outline Duration: 2 Days

  1. Ho Laola le ho Fetola Libuka tsa Mosebetsi le Li-Worksheets
    • Ho laola & ho beha Liqephe le Libuka tsa Mosebetsi
    • Ho sheba lipampiri tse tsoileng matsoho ho li-tab tse ngata
    • Ho khabisa Top Row kapa Column First ho sebelisa Freeze Panes
    • Mekhoa e metle ea ho boloka nako ea ho laola mekhoa ea ho ipehela leqepheng
    • Mekhoa e fapaneng ea mokhoa oa ho etsa litšoantšo hammoho le ho ikamahanya ka mokhoa o ikemetseng ka lebaka la Melao ea boitšoaro, litlaleho tsa boitsebiso, Li-data tse joalo, joalo-joalo
  2. Ho etsa litlaleho tsa Excel ka litlhahlobo tse fapa-fapaneng, mesebetsi le ho hlalosa
    • Mongolo o Sebetsa joaloka Len, Concatenate, ka holimo, ka tlase, e loketseng le e hloekileng.
    • Mesebetsi e utloahalang e kang If and Multiple Ifs
    • Mesebetsi ea Mathematical e kang Sum, Abs, Round, Roundup & Rounddown
    • Mesebetsi ea Statistical e kang Count, Counta, Countblank, Countif, Likarolo, Sumif, Sumifs, Average, Averageifs, Min, Max, Small and Large
    • Mesebetsi ea ho batla e kang Vlookup le Hlookup ka papiso e nepahetseng le ea approximate
    • Ho pholletsa le aterese ea sele ka mokhoa o itseng ka ho beha $ sign (Referencing Absolute)
    • Ho kopanya maqephe a mangata le libuka tsa mosebetsi ka foromo (3D Referencing)
  3. Ho sebetsa le Data
    • Ho theha le ho fetola Lists tsa Litomoro
    • Ho arola data ho sebelisa Text to Columns
    • Hlophisa boitsebiso ka Alfabeta ka masimo a le mong le a mangata
    • Hlophisa boitsebiso ka tatellano e hlophisitsoeng ka ho kenya lintlha
    • Hlophisa data ka ho le letšehali ho ea ka tatellano e nepahetseng
    • Ho tlosa lintlha ka lihlopha tsa Filters & Advance Filters (Filter Number, Filter Text, Date & Time Filters, Libuka tse ikhethang, Litlaleho tsa boitsebiso le Sefahleho sa Marotholi)
  4. Ho hlahloba data ka Tables ea Pivot
    • Ho khetha Lijo tse ntlehali le ho eketsa masimo
    • Ho sebelisa mesebetsi e mengata ka litafole tsa pivot
    • Liphetoho tsa lisele tse se nang letho le litekanyetso tsa phoso ka 0
  5. Ho emela Ditaba ka Foromong e Ntle
    • Ho khetha lichate tse ntle ka ho fetisisa ka data
    • U sebelisa li-Charts Charts, Chate ea Bar, Line Charts & Pie Charts
    • Litlhaloso tsa ho fetola, ho eketsa Lihlooho tsa Chate le Liphetoho tsa Chate e fetohang
    • Ho kopanya Charts le Lentsoe le PowerPoint
  6. Ho sebetsa le mesebetsi ea Advance Excel
    • Ho etsa lipapali sebakeng se nepahetseng ho e-na le ho le letšehali
    • Ho etsa likhetho ho litafole tse ngata tse nang le maemo a mangata
    • Ho etsa lintlha tse ngata masimong
    • Ho etsa linyeoe tse utloisang bohloko
    • Ho kopanya likhetho tse sa hlakang le tse totobetseng ka Match & Index Functions
    • Letsatsi le sebetsa joaloka Kajeno, Hona joale, Letsatsi, Khoeling, Selemo, Matsatsi a Matsatsi le Matsatsi
    • Mesebetsi ea Statistical e kang Median le Mode
  7. Ho sebetsa le Range le Naming Convention
    • Ho sebelisa Lebitso ho seleng le lisele tse ngata
    • Ho fetola, Ho tlosa Range Mabitso & Ho iketsetsa Mabitso ka botlalo ho latela lihlooho
  8. Ho Sebelisa Ditaba
    • Ho kopanya Excel Data le Word Documents, Files PDF le lintho tse ka ntle ho li-Hyperlink
    • Ho fetisa Data ho tswa ho Mehloli ea External e kang Text Files, CSV Files, joalo-joalo
    • Boemeli ba Ditaba ka mokhoa o ntlafetseng o sebelisang Mathala
    • Ho tlosa litlaleho tsa Duplicate tse tsoang ho Excel data
    • Ho theha lipatlisiso tsa lipatlisiso ka potlako / liforomo ka ho thibela data e itseng ka Litlhaloso tsa Data
    • Ho sireletsa li-dashboards / liforomo ka ho koala le ho bula karolo e itseng ea maqephe
    • Ho hokahanya litlaleho tse tsoang libukeng tse fapaneng tsa mosebetsi ka Data Consolidation
  9. Ho hlahloba Letoto la Excel
    • Ho sebelisa likarolo tse nyenyane ho hlahloba lintlha tsa masimo a le mong le a mangata
    • Ho kopanya le ho kopanya Excel Data ka Tables Pivot
    • Ho eketsa masimo a lekanyelitsoeng ka Tables ea Pivot
  10. Ho Etsa'ng Haeba Lisebelisoa tsa Tlhahlobo
    • Ho lekanya Phallo ea Bohlokoa ho latela Motheo oa Phallo ho sebelisa Sepheo sa ho Batla
    • Ho hlahloba Dintlha ka di-Scenarios tse ngata ho sebelisa Scenarios Manager
  11. Ho iketsetsa mesebetsi le ho emela litšoantšo (ho latela ka nako ea nako)
    • Ho emela dintlha ka ho kopanya Column & Line Charts ho tse ling tse ngata
    • Ho emela menehelo ea dintlha ka pie ea pie kapa Bar ea Pie Charts
    • Ho ntlafatsa mesebetsi ka liqeto tsa Keyboard
    • Ho iketsetsa mesebetsi ka ho rekota Macros
    • Ho boloka libuka tsa mosebetsi le Macro dikgetho tse lumellanang

Re kopa o re ngolle info@itstechschool.com 'me re ikopanye le rona ka + 91-9870480053 bakeng sa tefo ea tefo le tekanyetso, kemiso le sebaka

Re Tlisetsa Potso

Bakeng sa lintlha tse ling ka mosa Iteanye le rona.


Reviews





Reviews





MSExcel Thuto ea thuto e fanoa ka tlase