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

Sesebelisoa se sebelisoang ka ho fetisisa le se matla sa Microsoft keipabole, e sebelisoang lefatšeng lohle. 'Me ka thupelo e entsoeng ka ho khetheha sena se bonolo haholo ho fumana tsebo ea ho ba le tsebo le ho sebelisa tse ntle haholoanyane. Li-SES li na le lithuto tse fumanehangMS- ofisi 2007/2010 / 2013le2016hape.

batlehang

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

Nako ea Nako ea Tlhahlobo: Matsatsi a 2

  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