iruIkẹkọ ikoko
ọjọSep 9, 2017
Time2 ọjọ
Forukọsilẹ

Ikẹkọ MS Excel

Akopọ

Prerequisites

Ilana Akoso

Iṣeto & Owo

iwe eri

Ilana Ikẹkọ ti MS Excel & Iwe-ẹri

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-ọfiisi 2007 / 2010 / 2013 ati 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

Awọn oludije yẹ ki o mọ imoye ipilẹ ti kọmputa.

Course Outline Duration: 2 Days

  1. Ṣiṣakoṣo ati Ṣiṣatunkọ Awọn iṣẹ-iṣẹ ati Awọn iṣẹ iṣẹ
    • Ṣiṣakoso & Ṣeto Awọn iwe & Awọn iṣẹ iṣe
    • Wiwo awọn iwe fifẹ kanna ni awọn taabu pupọ
    • Gigun awọn Iwọn oke tabi Awọn Akọkọ Akọkọ nipa lilo Panes Pipo
    • Awọn imuposi awọn igbasilẹ ti o dara ju ti sisakoso awọn aṣayan awọn aṣayan Page
    • Awọn ilana imuposi oriṣiriṣi pẹlu Ipilẹ kika ti o ni ibamu lori Awọn idiyele, Awọn igbasilẹ iwe-ẹda, Awọn ifiwe data, ati be be lo
  2. Ṣiṣe awọn iroyin iyasọtọ nipasẹ orisirisi Awọn agbekalẹ, Awọn iṣẹ ati Ifọrọwọrọ
    • Awọn iṣẹ ọrọ gẹgẹbi Len, Ọja, Oke, Iwọn, Dara & Gbangba.
    • Awọn iṣẹ iṣeeṣe bi Ti ati Ifs Ti ọpọlọpọ
    • Awọn iṣẹ Iṣii bi Sum, Abs, Yika, Akojọpọ & Akojọpọ
    • Awọn iṣiro iṣiro gẹgẹbi kika, Counta, Countblank, Countif, Countives, Sumif, Sumifs, Average, Averageifs, Min, Max, Small and Large
    • Awọn iṣẹ Ṣiṣayẹwo bi Vlookup ati Hlookup lori gangan & isọdọmọ to baramu
    • Gigun adirẹsi adanẹẹsi ni agbekalẹ nipa gbigbe $ ami (Ifọrọranṣẹ to dara)
    • Pipọ awọn awoṣe ati awọn iwe-iṣẹ pupọ ni agbekalẹ (Akọsilẹ 3D)
  3. Nṣiṣẹ pẹlu Data
    • Ṣiṣẹda ati Ṣatunṣe Awọn akojọ Aṣa
    • Pipin data nipa lilo Text si Awọn ọwọn
    • Itọsẹ awọn data ni Ilana ti itọnisọna lori aayekan & ọpọ aaye
    • Ṣiṣipọ awọn data ni Eto ti a ṣe ni idaniloju nipa gbigbe awọn akojọ wọle
    • Ṣiṣipọ awọn data ni Osi si eto ọtun
    • Sita awọn data nipa lilo Awọn Ajọ & Awọn Ajọ Ilọsiwaju (Awọn Ajọ Awọn Ọṣọ, Awọn Ajọ ọrọ, Ọjọ & Awọn Ajọ Aago, Awọn Akọsilẹ Aami, Awọn akilẹ iwe-ẹda & Ṣatunkọ awọ)
  4. Itupalẹ awọn data nipasẹ awọn tabili Pivot
    • Ti yan awọn Ilana ti o dara ju & fifi aaye kun
    • Nlo awọn iṣẹ pupọ lori awọn tabili tabili
    • Awọn iyipada ti awọn eeka òfo & aṣiṣe tọ pẹlu 0
  5. Awọn Data Asoju ni Fọọmu Iyaworan
    • Yan awọn shatọti ti o dara ju fun data
    • Lilo awọn iwe ẹda, Awọn akọle ti o wa, Awọn Ẹrọ Ilaini & Awọn iwe-ẹṣọ
    • Sisọ kika Awọn iyasọtọ, fifi awọn akọle Awọn aworan & iyipada ipo Awọn apẹrẹ
    • Sopọ awọn iyasọtọ pẹlu Ọrọ ati PowerPoint
  6. Nṣiṣẹ pẹlu awọn iṣẹ Excel iwaju
    • Ṣiṣe awọn oluwari lori aaye ọtun ju osi
    • Ṣiṣe awọn oluwari lori tabili pupọ pẹlu awọn ipo pupọ
    • Ṣiṣe awọn oluwari lori aaye pupọ
    • Ṣiṣe awọn oluwo idanwo elegbe
    • Darapo awọn wiwa petele & itọnisọna nipasẹ Awọn iṣẹ Awọn ibaraẹnisọrọ & Awọn Ifihan
    • Awọn ọjọ ọjọ bi Oni, Nisisiyi, Ọjọ, Oṣu, Odun, Awọn ọjọ iṣẹ & Awọn iṣẹ nẹtiwọki
    • Awọn iṣiro iṣiro bi Median ati Ipo
  7. Ṣiṣẹ pẹlu Adehun ati Adehun Nkan pẹlu
    • Npe orukọ kan si alagbeka ati orisirisi awọn sẹẹli
    • Ṣatunṣe, Paarẹ awọn orukọ ibiti o n ṣe orukọ ati Ṣiṣẹda laifọwọyi si Awọn orukọ lori ipilẹ Awọn akọle
  8. Awọn data muṣiṣẹ
    • Sopọ Data ti o pọ pẹlu awọn iwe Ọrọ, Awọn faili PDF ati awọn ohun ita lati awọn Hyperlinks
    • Ṣe akowọle Data lati Awọn orisun ita bi Awọn faili ọrọ, Awọn faili CSV, bbl
    • Aṣoju ti Data ni ipele ti o dara julọ nipa lilo awọn tabili
    • Yọ awọn igbasilẹ Duplicate lati awọn alaye Excel
    • Ṣiṣeto awọn oju-iwe afẹfẹ kiakia / awọn fọọmu nipasẹ ihamọ data kan pato nipasẹ Awọn Imudara Data
    • Idabobo awọn oju-iwe / awọn fọọmu nipasẹ Ibora & Ṣiṣi apakan apakan kan pato
    • Ṣiṣeto awọn iroyin lati awọn iwe iṣẹ-ṣiṣe pupọ nipasẹ Isọtọ Data
  9. Ṣiṣe ayẹwo Data Tutu
    • Ṣiṣe Awọn Ikọja lati ṣe itupalẹ awọn data lori awọn aayekan & ọpọ aaye
    • Ṣiṣẹpọ ati Gbigba Alaye Ti o pọ si Awọn tabili Pivot
    • Fifi awọn aaye ti a ṣe iṣiro sinu awọn tabili tabili
  10. Ṣiṣe Ohun ti o ba jẹ Awọn Ṣiṣe Iwadi
    • Ṣiṣayẹwo Iye Iye titẹ lori ipilẹ Ọja Ṣiṣe ti nlo Iwadi Goalẹ
    • Ṣiṣayẹwo awọn Data pẹlu Awọn oju-iṣẹlẹ Aami nipa lilo Oluṣakoso Awọn Aworan
  11. Aifọwọyi ti Awọn iṣẹ-ṣiṣe & Asoju Ayika (Bi fun wiwa akoko)
    • Awọn data Asoju nipa sisopọ Iwe & Awọn itọka Leta lori ipo pupọ
    • Awọn ifilọlẹ ti awọn aṣoju Asoju nipasẹ apẹrẹ Pie ti Pie tabi Bar ti Pie Charts
    • Ṣiṣe ilọsiwaju awọn iṣẹ-ṣiṣe nipasẹ Keyboard Awọn ọna abuja
    • Aifọwọyi ti awọn iṣẹ-ṣiṣe nipasẹ Awọn Akọsilẹ Ntọju
    • Fifipamọ awọn iṣẹ-ṣiṣe pẹlu awọn aṣayan ibaramu Macro

Jowo kọ si wa ni info@itstechschool.com & kan si wa ni + 91-9870480053 fun iye owo-owo & iwe eri iwe, iṣeto & ipo

Mu Wa Iwadi Kan

Fun alaye diẹ ẹ sii daradara Pe wa.


Reviews





Reviews





MSExcel Lakoko akoonu ni a fun ni isalẹ