noocaTababar Fasalka
TaariikhdaSep 9, 2017
Time2 Days
DIIWAANGELI

Tababarka MS Excel

Guudmarka

shuruudaha

Tusmada Koorsada

Jadwalka & Khidmadaha

Certification

MS Excel Koorsada Tababarka & Shahaadada

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-office 2007 / 2010 / 2013 iyo 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

shuruudaha

Musharrixiinta waa in ay yaqaanaan aqoon aasaasi ah ee kombiyuutarka.

Course Outline Duration: 2 Days

  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