ụdịỌzụzụ klas
ỤbọchịSep 9, 2017
Time2 Days
Deba aha

Ọzụzụ MS Excel

Overview

Prerequisites

Ihe ndepụta

Nhazi & Ụgwọ

Asambodo

MS Excel Ọzụzụ Agụmakwụkwọ & Asambodo

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 Office MSN na MSNUMX / 2010 / 2013 na 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

Prerequisites

Ndị Candidates kwesịrị ịma ihe ọmụma dị mkpa banyere kọmputa.

Course Outline Duration: 2 Days

  1. Ijikwa Akwụkwọ na akwụkwọ nhazi
    • Ijikwa & mpempe akwụkwọ & Akwụkwọ akwụkwọ
    • Na-ele otu ihe ahụ dị iche iche na ọtụtụ taabụ
    • Na-etinyefe Nkọwa Elu ma ọ bụ Ntọala Mbụ site na iji Panzigharị
    • Oge kachasị mma ịchekwa usoro nke ijikwa nhọrọ ntọlite ​​Page
    • Usoro usoro nhazi dị iche iche na nhazi usoro nke dabeere na Ụkpụrụ, Nkọwapụta akwụkwọ, Ogwe data, wdg
  2. Ịmepụta Excel na-ede site n'ụdị Usoro, Ọrụ na Ntugharị
    • Ọrụ ederede dịka Len, Concatenate, Upper, Lower, Kwesịrị Ekwesị & Kwee.
    • Ọrụ dị mgbagwoju anya dịka ma ọ bụrụ na ọ bụrụ na ọ bụrụ na ọtụtụ
    • Ọrụ mgbakọ na mwepụ dịka Sum, Abs, Round, Roundup & Rounddown
    • Ọrụ nchịkọta akụkọ dịka agụ, ndụmọdụ, Countblank, ndụmọdụ, ndụmọdụ, Sumif, Sumifs, Nkezi, Averageifs, Min, Max, Small and Large
    • Ọrụ nyochaa dị ka Vlookup na Hlookup na kpọmkwem & nke egwuregwu
    • Inyefe otu adreesị cell n'otu usoro site na itinye ihe $ $ (Ntụle zuru ezu)
    • Ijikọta ọtụtụ ederede na akwụkwọ ọgụgụ na usoro (Nkọwa 3D)
  3. Na-arụ ọrụ na Data
    • Ịmepụta ma gbanwee Ndepụta ọdịda
    • Ịhapụ data site na iji ederede na ogidi
    • Inye data na Alphabetical order on single & multiple fields
    • Ịpụta data na usoro ahaziri site na ịbubata ndepụta
    • Inye data na aka ekpe gaa n'usoro ziri ezi
    • Wepụ data site na iji nzacha & Nzacha n'ihu (Ntọala Nhọrọ, Nkọwa ederede, Ụbọchị & Nchịkọta Oge, Ihe Nlekọta Na-enweghị Ihe, Akọrọ Duplicate & Ntụcha Ncha)
  4. Inyocha data site na Pivot Tables
    • Ịhọrọ Okirikiri nhọrọ kacha mma & na-agbakwunye ubi
    • Na-etinye ọtụtụ ọrụ na tebụl dị mkpa
    • Mgbanwe nke mkpụrụ ndụ oghere na ụkpụrụ njehie na 0
  5. Nwepụta data na ụdị eserese
    • Ịhọrọ nsonaazụ kacha mma dị ka data
    • Iji chaatị mpempe akwụkwọ, chaatị chaatị, eserese eserese & eserese
    • Ịhazi chaatị, na-agbakwụnye Chart Titles & na-agbanwe Chart Ọnọdụ
    • Ijikọta Atụmatụ na Okwu na PowerPoint
  6. Na - arụ ọrụ n'ihu Ọrụ Excel
    • Ịmegharị nlele na mpaghara aka nri kama n'aka ekpe
    • Ịmegharị nlele na tebụl ọtụtụ dị iche iche
    • Ịmegharị nlele na ọtụtụ mpaghara
    • Na-eme nchọpụta nyocha nke ikpe
    • Na-ejikọta ntaneti & ntaneti anya site na Nkọwa & Index Ọrụ
    • Ụbọchị dị ka Taa, Ugbu a, Ụbọchị, Ọnwa, Afọ, Ọrụ Ụbọchị & Networkdays
    • Ọrụ nchịkọta akụkọ dị ka Median na Mode
  7. Na-arụ ọrụ na Gburugburu na Nkwekọrịta Nkwekọrịta
    • Na-etinye Aha na cell na ọtụtụ nke sel
    • Mgbanwe, Ihichapụ aha nchịkwa & Na-akpaghị aka na-eke aha dịka ndabere nke Isi
  8. Nweta data
    • Ịnweta Data Excel na Ihe Odide, PDF faịlụ & ihe ndị ọzọ site na Hyperlinks
    • Ịbubata data sitere na isi ebe dị ka faịlụ ederede, faịlụ CSV, wdg
    • Ndi nnochite nke Data na nhazi di nma site na iji tebụl
    • Wepu ihe ndekọ ederede site na data Excel
    • Ịmepụta mpempe akwụkwọ ngwa ngwa / ụdị site na igbochi data kpọmkwem site na Data Validations
    • Chebe mpempe akwụkwọ / ọdịdị site na kpochidoro> Wepuchi akụkụ ụfọdụ nke mpempe akwụkwọ
    • Idebe akụkọ sitere na akwụkwọ ndekọ dị iche iche site na Consolidation Data
  9. Inyocha Data Excel
    • Na-etinye Subtotals iji nyochaa data na otu & otutu ubi
    • Ịkpakọta na iwepu Data Excel na tebụl Pivot
    • Na-agbakwụnye Ubi Okpadoro na Tebụl Pivot
  10. Ịme ihe ma ọ bụrụ na Ngwaọrụ Nyocha
    • Ịchọta Nhọrọ Ntinye na-adabere na Nhọrọ Nhọrọ site na iji Nchọgharị Mgbaru
    • Nyochaa Data na Mpaghara ntanetịime site na iji njikwa ihe ngosi
  11. Akwụsị nke Ihe aga-eme & Nnọchite anya na-ese onyinyo (Dịka ọ bụrụ na oge ahụ dị)
    • Na-anọchite anya data site na ijikọta Kọlọtọ & Ntọala Ntugharị na otutu axis
    • Na-anọchite anya onyinye data site na paịl Pie Pie ma ọ bụ Bar nke Pie
    • Ịkwalite ọrụ site na Keyboard Ụzọ mkpirisi
    • Akwụsị nke ihe aga-eme site na Ndekọ Ndekọ
    • Ịchekwa akwụkwọ ọrụ na nhọrọ Macro

Biko dee anyị na info@itstechschool.com & kpọtụrụ anyị na + 91-9870480053 maka ụgwọ ọnụahịa & asambodo ụgwọ, oge & ọnọdụ

Wepụ Anyị Ajụjụ

Maka ozi ndị ọzọ Kpọtụrụ anyị.


Nyocha





Nyocha





E nyere MSExcel Agụmakwụkwọ ọdịnaya n'okpuru