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

O le mea sili ona masani ma faʻaaogā faʻaaogaina a le Microsoftsili, lea e faʻaaoga i le lalolagi atoa. Ma faʻatasi ai ma se faʻatulagaga faʻapitoa, e matua faigofie tele le maua o tomai e avea ai ma tagata agavaa ma faʻaaogaina le faigofie tele. O IA ei ai vasega e mafai ona mauaMS-ofisa 2007/2010 / 2013ma2016faapena foi a'u.

Prerequisites

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

Taʻiala o le Taimi Taimi: 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