noocaTababar Fasalka
TaariikhdaSep 9, 2017
Time2 Days
DIIWAANGELI
Tababarka MS Excel

Guudmarka

shuruudaha

Tusmada Koorsada

Jadwalka & Khidmadaha

Certification

MS Excel Koorsada Tababarka & Shahaadada

Qalabka ugu badan ee loo adeegsado Microsoft waa qalabExcel, oo loo isticmaalo adduunka. Iyo koorso gaar ah oo loogu talagalay tani waa mid aad u fudud in la helo xirfadaha si ay u noqdaan kuwo karti leh iyo si sahlan loo isticmaalo. ITS waxay leeyihiin koorsooyin laga heli karoMS-office 2007/2010 / 2013iyo2016sidoo kale.

shuruudaha

Musharrixiinta waa in ay yaqaanaan aqoon aasaasi ah ee kombiyuutarka.

Mawduuca Muujinta Duration: 2 Maalmaha

  1. Maaraynta iyo qaabaynta buug-yada Workbooks iyo Worksheets
    • Maaraynta & qabashada Xaashiyaha & Shaqooyinka
    • Eegida xaashiyo isku mid ah oo ka mid ah waraaqaha kala duwan
    • Xoraynta Roodka ugu sarreeya ama Qodobka Koowaad iyadoo la adeegsanayo "Freeze Panes"
    • Farsamooyinka ugu fiican ee wakhtiga kaydinta ee maareynta fursadaha dejinta bogga
    • Farsamooyinka farsamaynta kala duwan oo ay weheliyaan Shuruudaha Shuruudaha ku saleysan Qiimeeyaha, Diiwaanada Duubka, Baararka Xogta, iwm.
  2. Samaynta warbixinnada Excel iyada oo la adeegsanayo qaabab kala duwan, Tilmaamo iyo Soo-jeedin
    • Waxqabadka qoraalka sida Len, Concatenate, Upper, Hoose, Raacdid & Dhar.
    • Functions Functions sida If iyo Multiple Ifs
    • Hawlaha Xisaabaadka sida Sum, Abs, Round, Roundup & Rounddown
    • Hawlaha tirakoobka sida Count, Counter, Countblank, Countif, Countifs, Sumif, Sumifs, celcelis, Averageifs, Min, Max, yar yar iyo weyn
    • Functions Functions sida Vlookup iyo Hlookup oo ku saabsan ciyaar sax ah iyo qiyaasta
    • Iska xoqista cinwaanka unugga qaab-qaacida adigoo ku qoraya $ calaamad
    • Calaamadinta waraaqo iyo buugag kala duwan oo caan ah (3D Referencing)
  3. La shaqeynta Macluumaadka
    • Abuurista iyo Bedelida Liisaska Qaaska ah
    • Kala soocida macluumaadka iyadoo la adeegsanayo Text to Columns
    • Ku kala-soocida xogta ku qoran amarrada Alphabetical ee hal ama goobo badan
    • Ku kala-soocida xogta ku-meel-gaarka ah adigoo soo dejinaya liisaska
    • Ku kala-soocida xogta Left ilaa amar
    • Ka saarida xogta adoo isticmaalaya Filters & Filters Advance Filters (Filters, Filters, Date & Time Filters, Diiwaanka Diiwaangelinta, Diiwaanada Duubka & Filtarinta Midabka)
  4. Falanqaynta xogta iyada oo loo marayo Miisaanka Pivot
    • Doorashada Layoutska ugu fiican iyo ku darista beeraha
    • Codso shaqooyin kala duwan oo ku saabsan miisaska isku-dhiska
    • Kala sheekeysiga unugyada banaan & qalad qalad leh 0
  5. Wakiilinta Macluumaadka Foomka Sawirka
    • Doorashada jaantusyada ugu fiican sida xogta
    • Isticmaalida Jaantusyada Qaybta, Jaantus Bar, Qeybaha Qadka & Calaamadaha Candy
    • Fadlan qoraalka jaantusyada, ku darey Naqshadeynta Chart & Beddelka Goobaha
    • Xiriirinta jaantusyada leh Word iyo PowerPoint
  6. La shaqaynta Hawlaha Horumarinta Excel
    • Sameynta goobaha ku yaala goobta saxda ah halkii aad ka hadhsan lahayd
    • Sameynta raadinta miisaska kala duwan oo leh xaalado kala duwan
    • Hirgalinta raadinta meelo badan
    • Hirgalinta keeska keeska ee xasaasiga ah
    • Isku-dubbarididda shabakada & garaafka tooska ah ee loo yaqaan 'Match & Index Functions'
    • Taariikhda wuxuu u shaqeeyaa sida Maanta, Hada, Maalinta, Bisha, Sanadka, Maalmaha Shaqada iyo Maalmaha Shabakada
    • Hawlaha tirakoobka sida Dhexe iyo Mode
  7. La shaqeynta Range iyo Heshiiska Magacaabidda
    • Codsashada Magaca unugyada iyo unugyada kala duwan
    • Isbedelka, Tirtirista Magacyada Rugaha & Si toos ah u sameeya Magacyada iyaga oo ku saleysan Mawduuca
  8. Macluumaadka Daryeelka
    • Isku-xirka Macluumaadka Excel oo leh dokumentiyada Word, Faylasha PDF & walxaha dibadda iyada oo loo marayo Hyperlinks
    • Iibinta Xogta laga helo ilo dibadeed sida Qoraalka Faylka, Faylka CSV, iwm
    • Wareegga Macluumaadka ee qaab-dhismeed ka wanaagsan oo isticmaalaya jadwal
    • Ka-saarista diiwaanka duplicate-dii diiwangelinta xogta Excel
    • Qorsheynta boodhadhka degdegga ah / foomamka iyagoo xaddidaya xog gaar ah iyada oo loo marayo Xaqiijinta Macluumaadka
    • Ilaalinta joodariyeyaasha / foomamka iyadoo la adeegsanayo Qalabka & Furitaanka qeybo gaar ah ee xaashida
    • Isu-dubarinta warbixinnada buug-gacmeedyada kala duwan adoo isticmaalaya Iskuxidhka Macluumaadka
  9. Falanqaynta Excel Data
    • Codsashada Miisaaniyado si ay u falanqeeyaan xogta ku saabsan hal ama dhowr goobood
    • Isu-geynta iyo Isku-uruurinta Xogta Muuqaalka ee Miisaanka Miisaanka
    • Ku darista Bannaanka La Xisaabiyay ee Miisaanka
  10. Haysashada Waxyaabaha Hormariska ah
    • Xisaabinta Qiimaha Qodobbada oo ku saleysan Qiimaha Natiijada adigoo isticmaalaya Ujeedada Goolka
    • Falanqaynta Xogta ee leh Scenarios kala duwan iyadoo la isticmaalayo Maareeyaha Sare
  11. Awoodsiinta Hawlaha iyo Wakiil garaafka (Sida helitaanka wakhtiga)
    • Wakiilinta xogta iyadoo la isku darayo Sumcada & Xirmooyinka Qaabka ee ku yaala xagal badan
    • Wakiilinta xogta xogta ee Pie of Pie ama Bar of Pie Charts
    • Hagaajinta hawlaha loo marayo Keyboard Shortcuts
    • Xaqiijinta hawlaha ayadoo kaydinaysa Macros
    • Buug-shaqeedka qorista Macro-ga oo la isku waafajiyo

Fadlan noogu soo qor cinwaanka info@itstechschool.com & nagala soo xiriir + 91-9870480053 qiimaha iyo qiimeynta koorsada, jadwalka & goobta

Na soo qaado su'aal

Wixii macluumaad dheeraad ah si naxariis leh Nala soo xiriir


Reviews





Reviews





Macluumaadka koorsada ee MSExcel hoos ayaa lagu siiyaa