typeAikin Kwalejin
kwananSep 9, 2017
Time2 Days
rajistar

Ƙaramar MS Excel

Overview

abubuwan da ake bukata

Jagoran Bayanan

Jadawalin & Kudin

Certification

Harkokin Kasuwancin MS Excel da Takaddun shaida

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-ofishin 2007 / 2010 / 2013 da kuma 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

abubuwan da ake bukata

Ya kamata 'yan takara su san ilimin asali na kwamfuta.

Course Outline Duration: 2 Days

  1. Sarrafa da Tsarin Ayyukan Ayyuka da Ayyuka
    • Sarrafawa & Shirya Takardu da Ayyuka
    • Dubi ɗayan shafuka masu yawa a cikin shafuka masu yawa
    • Gudurar layi na sama ko Ƙungiyar farko ta amfani da Ƙunƙarar Ruwa
    • Mafi kyawun lokacin ceton hanyoyin da za a gudanar da zaɓin saitin Page
    • Daban-daban dabarun tsarawa tare da Tattaunawar Yanayi bisa Dalantaka, Rubutun kalmomi, Bayanan bayanai, da dai sauransu
  2. Samar da Excel ta hanyar daban-daban Formulas, Ayyuka da Fifkantarwa
    • Ayyukan rubutu kamar Len, Concatenate, Ƙananan, Ƙananan, Ƙira & Gyara.
    • Ayyuka masu mahimmanci kamar su da ƙananan idans
    • Ayyukan ilmin lissafi kamar Sum, Abs, Round, Roundup & Rounddown
    • Ayyukan bayanan kididdiga kamar Count, Counta, Countblank, Countif, Countives, Sumif, Sumifs, Matsayi, Average, Min, Max, Small da Large
    • Ayyuka dubawa kamar Vlookup da Hlookup akan ainihin & kimanin wasa
    • Sauke bayanan salula a cikin wata takarda ta wurin sanya alamar $ (Abinda ke nunawa)
    • Haɗin zane-zane masu yawa da kuma littattafan aiki a cikin tsari (3D Referencing)
  3. Yin aiki tare da Bayanan
    • Samar da kuma Sauyawa Lists na Custom
    • Raba bayanai ta amfani da Rubutu zuwa ginshiƙai
    • Bayar da bayanai a cikin tsari na Alphabetical a kan sauƙaƙe da nau'o'in
    • Bayar da bayanan da aka tsara ta hanyar sayo lissafin
    • Bayar da bayanai a Hagu zuwa dama
    • Ana cire bayanai ta amfani da Filters & Filters na gaba (Filin Matakan, Fitaccen Rubutun, Kwanan wata & Kwanan lokaci, Fassara Na Musamman, Rubutun Kwafi da Tacewa Daga Launi)
  4. Binciken bayanan ta hanyar Pivot Tables
    • Zaɓi mafi kyawun Layouts & ƙara filin
    • Aiwatar da ayyuka masu yawa a kan tebur
    • Kuskuren Kwayoyin Kullun da ƙananan dabi'u tare da 0
  5. Ma'aikatar Bayyanawa a Fayil
    • Zabi mafi kyawun sigogi kamar yadda bayanai suke
    • Amfani da Shafin Shafi, Sigar Bar, Lissafin Lissafi & Kayan Shafi
    • Sanya Shafin, ƙara Chart Titles & canza Chart Locations
    • Ƙulla Sharuɗa tare da Kalma da PowerPoint
  6. Yin aiki tare da Ayyukan Ayyukan Excel
    • Yi ninkin a filin da ya dace maimakon hagu
    • Yin bincike a ɗakunan Tables masu yawa tare da yanayi daban-daban
    • Yin bincike a ɗakunan filayen
    • Aiwatar da binciken da ya dace
    • Haɗa ayyukan da aka yi a kwance & tsaye ta hanyar Match & Index Functions
    • Kwanan wata ayyuka kamar Yau, Yanzu, Ranar, Watan, Shekara, Ranar Wuta da Ranar Daydays
    • Ayyukan ilimin lissafi kamar Median da Mode
  7. Yin aiki tare da Range da Yarjejeniyar Naming
    • Neman Sunan zuwa sel da kewayon sel
    • Sauyawa, Share Names Names kuma Samar da atomatik Names bisa Dalili
  8. Ana sarrafa bayanai
    • Sadar da Bayanan Excel tare da Rubutun Maganganu, Fayilolin PDF da abubuwan waje ta hanyar Hyperlinks
    • Ana shigo da bayanan daga Sources Sources kamar Fayilolin Fayiloli, Fayilolin CSV, da dai sauransu
    • Ma'aikatar bayanai a cikin tsari mafi kyau ta amfani da Tables
    • Cire takardun rubutun daga bayanan bayanan
    • Zayyana akwatunan sauri / siffofi ta hanyar taƙaita takamaiman bayanai ta hanyar Bayanan Bayanan
    • Kare kullun / siffofi ta kulle & cire wani ɓangare na zanen gado
    • Samar da rahotanni daga wasu takardun aiki ta hanyar Haɗin Bayanan Data
  9. Binciken Bayanan Excel
    • Aiwatar da Subtotals don nazarin bayanan da ke kunshe a wuri ɗaya da maɓalli
    • Ƙungiyoyi da Ƙasashe Bayanan Hanyoyi a Tables na Pivot
    • Ƙara Ƙididdigar Firaye a cikin Tables
  10. Yin Ayyukan Mene ne idan Kayan Ayyukan Masarufi
    • Ana kirga darajar shigarwa ta hanyar amfani mai kyau ta amfani da nema na neman
    • Yin nazari da bayanai tare da na'urori masu mahimmanci ta amfani da mai gudanarwa
  11. Ayyukan aiki da Ayyuka & Zane-zane na Hotuna (Kamar yadda aka samu lokacin)
    • Bayyana bayanai ta hada hada-hadar shafi da layi a kan hanyoyi masu yawa
    • Nuna bayyayyun bayanan bayanan rubutun Pie na Pie ko Bar na Pie Charts
    • Inganta ayyuka ta hanyar Keyboard Shortcuts
    • Ɗauki na ayyuka ta hanyar rikodin Macros
    • Ajiye takardun aiki tare da Zaɓuɓɓukan Maɓallin Macro

Don Allah a rubuta mana a info@itstechschool.com & tuntube mu a + 91-9870480053 don farashin farashin & farashin takardun shaida, tsarawa & wuri

Drop Us a Query

Don ƙarin bayani mai kyau Tuntuɓi Mu.


reviews





reviews





An ba da matsala na MSExcel a kasa