typeAikin Kwalejin
kwananSep 9, 2017
Time2 Days
rajistar

Tuntube Mu

Ƙungiyoyi da aka lakafta da wani * ana buƙatar

 

Ƙaramar MS Excel

Overview

abubuwan da ake bukata

Jagoran Bayanan

Jadawalin & Kudin

Certification

Harkokin Kasuwancin MS Excel da Takaddun shaida

Abinda Microsoft ya fi amfani dashi da karfi shineExcel, wanda aka yi amfani da shi a dukan duniya. Kuma tare da tsari mai mahimmanci wannan yana da sauƙi don samun basira don zama mai hankali & amfani da sauƙin sauƙi. KASHI yana da darussa a kanMS-ofishin 2007/2010 / 2013kuma2016da.

abubuwan da ake bukata

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

Ra'ayin Zuwa 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