ituaigaAoaoga a le potuaoga
asoSetema 9, 2017
taimiAso 2
Tusi Resitala

MS Excel Training

lagona

Prerequisites

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Polokalame aʻoaʻoga a MS Excel ma faʻamaoniga

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-ofisa 2007 / 2010 / 2013 ma 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

E tatau i sui candiditia ona iloa malamalama masani i le komepiuta.

Course Outline Duration: 2 Days

  1. Puleaina ma le Faʻasalalau o Polokalama ma Pepa o Galuega
    • Puleaina ma le faia o Pepa ma Galuega
    • Vaʻavaʻai i le itulau e tasi i itulau tele
    • Faʻafefeina o le Lisi i luga po o le Uluaʻi Kolisi e faʻaaoga ai le Pulu Vaʻa
    • Taimi sili ona laveaʻiina auala o le puleaina o filifiliga o le Seti
    • Faʻasologa o faiga faʻavae ma le Faʻavasegaina o Tuutuuga i luga o le Faʻatonu, Faʻasologa faʻamaumauga, Faʻamaumauga o Fesoʻotaʻiga, ma isi
  2. Faia o lipoti Excel e ala i le tele o Formulas, Functions and Referencing
    • Galuega e pei o Len, Concatenate, Maualuga, Lalo, Taʻo ma Toto.
    • Galuega Faʻatino e pei o le tele ma isi
    • Galuega Tau Matematika e pei o Sum, Abs, Round, Roundup & Rounddown
    • Fuainumera Faamaumauga e pei o Count, Counta, Countblank, Fautuaga, Fesoasoani, Auiliiliga, Aotelega, Faatatauga, Faatatau, Min, Max, Laiti ma Tele
    • Galuega Mataʻitu e pei o le Vlookup ma le Hlookup i luga o le fetaui tonu ma fetaui
    • Faʻasalaina o se tuatusi o le cell i se fua faʻatatau e ala i le tuʻuina o le $ sign (Faʻamatalaga Aloaia)
    • Faʻafesoʻotaʻi pepa ma laupepa i le faʻatulagaga (3D Faʻamatalaga)
  3. Galulue ma Faʻamatalaga
    • Fausia ma Faʻataʻatia Lisi Faʻasinomaga
    • Tuʻuina o faʻamatalaga e faʻaaoga ai le Text i koluma
    • Totoina o faʻamaumauga i le faasologa Faʻamaufaʻailoga i nofoaga taʻitasi ma le tele
    • Totoina o faʻamaumauga i le Faʻasalalauga faʻapitoa e ala i le faʻauluina mai o lisi
    • Totoina o faʻamatalaga i le agavale i le faasologa saʻo
    • Aveese faʻamatalaga e faʻaaoga ai Filters & Filtress Advances (Faʻasalaga numera, Faʻasalaga o Fetuʻaiga, Aso & Faʻasalaga o Taimi, Faʻamaumauga Faʻatasi, Faʻamaumauga Faʻamaumauga & Faʻamaʻaina o Lanu)
  4. Iloiloina o faʻamatalaga e ala i laulau Pivot
    • Filifilia o Taʻaloga sili ona lelei ma faaopoopo i ai fanua
    • Faʻaaogaina tele galuega i luga o laulau
    • Faʻaliliuina o vailaau avanoa ma faʻamaoni mea sese faʻatasi ma 0
  5. Faʻamatalaga o Faʻamaumauga i le Pepa Faataʻitaʻi
    • Filifilia o siata sili e pei o faʻamatalaga
    • Faʻaaogaina o Lisi Faʻasologa, Siata Faʻasologa, Laina Faʻasologa ma Palemene
    • Faʻataʻatiaina o Siata, faʻaopoopo Siata o Suafa & suia Chart Locations
    • Fesoʻotaʻiina o Siata ma le Upu ma le PowerPoint
  6. Galulue ma Agaʻi i luma Galuega Matagofie
    • Faia o suega i le itu saʻo nai lo le tauagavale
    • Faia o suʻesuʻega i luga o laulau e tele ma tulaga eseese
    • Faia o suega i le tele o fanua
    • Faia o suʻesuʻega maʻaleʻale mataupu
    • Faʻatasiina o le faʻasaga ma le faʻasalalau e ala i Match & Index Functions
    • Aso faigaluega e pei o le Aso Nei, Aso, Aso, Masina, Tausaga, Aso faigaluega ma Networkdays
    • Faʻailoga Faʻamaumauga e pei o Median ma Mode
  7. Galulue faʻatasi ma le Nofoaga ma le Igoa o igoa
    • Faʻaaogāina o se Igoa i se cell ma le tele o siama
    • Fesuiaiga, Aveese Igoa o le Nofoaga ma Faʻasaʻoina Igoa i le faʻavae o Ulutala
  8. Faʻamaumauga Faʻamaumauga
    • Fesoʻotaiga o Faʻamatalaga Excel faʻatasi ai ma Faʻamatalaga o Upu, PDF Faʻamatalaga ma mea i fafo atu e ala i Lisiituaua
    • Faʻaulufaleina mai o Faʻamatalaga mai Atunuʻu mai fafo e pei o Faʻamatalaga o Tusitusiga, Faʻatonu a le CSV, ma isi
    • Sui o le Faʻamaumauga i se faʻalelei sili atu e faʻaoga ai laulau
    • Aveese faʻamaumauga mai le faʻamatalaga Excel
    • Faʻatulagaina o lisi laupapa viliva / fomu e ala i le taofiofia o faʻamatalaga patino e ala i Faʻamaumauga o Faʻamaumauga
    • Puipuia o lapisi / fomu e ala i le Lokaina & Tatalaina o vaega faapitoa o pepa
    • Tuufaatasia lipoti mai le tele o fale faigaluega e ala i le Faʻamaumauga Faʻamaumauga
  9. Iloiloina o le Excel Data
    • Faʻaaogaina Subtotals e suʻe faʻamatalaga i luga o le tasi ma le tele o fanua
    • Faʻatasi ma le Faʻamāopoopoina o le Excel Data i laulau Pivot
    • Faʻaopoopoina o Faʻamaumauga Faʻatulagaina i Laulau Pivot
  10. Faatinoina O a mea pe a fai o Faʻamatalaga Faʻamatalaga
    • Iloiloina o le Faʻamaumauga o Faʻamaumauga i luga o le Faʻatatau o le Faʻatinoga o Galuega e faʻaaogaina ai Sini
    • Iloiloina o Faʻamatalaga ma le tele o Scenios e faʻaaoga ai le Scenarios Manager
  11. Faʻaaogaina o Tasks & Representative Representative (E pei o le avanoa o le taimi)
    • Faʻailoa faamatalaga e ala i le tuʻufaʻatasia o Polokalama & Laina Faʻamau i luga o le tele o axis
    • Faʻailoa saofaga o loʻo tuʻuina atu e le Pepa Pie Pie poʻo le Bar o Pie Siata
    • Faʻaleleia o galuega e ala i Keyboard Shortcuts
    • Faʻataugaina o galuega e ala i Tusitala Macros
    • Faʻasaoina o api ma Macro Fesoʻotaʻiga talafeagai

Faamolemole tusi mai ia i matou i le info@itstechschool.com & faʻafesoʻotaʻi i matou i le 91-9870480053 mo le tau aʻoaʻoga & tusi tau tusi, faʻasologa ma le nofoaga

Tuʻu mai ia i matou se Fesili

Mo nisi faʻamatalaga agalelei Faafesootai matou.


iloiloga





iloiloga





MSExcel Faʻamatalaga vasega o loʻo tuʻuina atu i lalo