Ziva aya mafomula ekutanga kudzidza mashandisiro eExcel

Excel

Kudzidza Excel ndechimwe chezvakakosha izvo zvatinofanira kusangana nazvo kuti tifambise kwete chete kupinda kwedu munyika yebasa, asiwo maitiro mazhinji ehupenyu hwedu hwezuva nezuva. Iyo Microsoft spreadsheet chishandiso chine simba chaizvo chinobatanidzwa munzvimbo dzakawanda, kubva kubasa kuenda kuvadzidzi uye kunyangwe muzvirongwa zvemunhu. Nenzira iyo, kana iwe uri kufunga kutanga nzira yako nechirongwa ichi, tinoda kukubatsira kutora matanho ekutanga. Naizvozvo, isu tichaongorora mafomula akakosha aunofanira kuziva kuti udzidze kushandisa Excel.

Aya mafomula anokubatsira kufamba zvakanaka kuburikidza nechishandiso, kuita arithmetic mashandiro, kuodha zvinhu, kuverenga uye mamwe mabasa anokupa iwe mukana wekuita akasiyana mabasa.

Chii chinonzi formula muExcel?

Kana zvasvika kuExcel, kunyangwe iwe usina ruzivo munharaunda, zvirokwazvo wakanzwa nezvemafomula. Kuwanda kwekushanda muchirongwa ichi kunofambiswa nefomati, iyo isiri chinhu kunze kwekodhi yakakosha kana equation yatinoisa kuita chiito. Zviito zviri mubvunzo zvinogona kubva pahuwandu huri nyore, kurongeka kwezvinhu pabepa kana kuverengerwa kwezvinhu zvakaita senzvimbo, nzvimbo nezvimwe.

Excel ine kabhuku kakakura kemari, zvine musoro, masvomhu uye trigonometric mafomula, pamwe nekutsvaga uye mareferensi mafomula. Saizvozvo, iwe unowana sarudzo dzakanangana kune manhamba, engineering uye zvakare neruzivo manejimendi.

Nenzira iyi, kana iwe uri pakati pebasa rinosanganisira chero yeiyi nzvimbo, zvichave zvakakwana kuti uve nedhata inodiwa uye pinda iyo fomula iri mubvunzo, kuti uwane iyo chaiyo mhedzisiro.  Nenzira iyo, isu tichakurumidza kuongorora kuti ndeapi mafomula ekutanga atinofanira kubata kuti tidzidze Excel.

Maformula aunoda kuziva kuti utange kudzidza Excel

Basic masvomhu mabasa

Chekutanga pane zvese, isu tiri kuzokuratidza maitiro ekuita iwo ekutanga masvomhu mashandiro ekuwedzera, kubvisa, kuwanda uye kupatsanura. Chaizvoizvo, iyo chete ine chaiyo fomula fomati ndiyo Sum formula, nepo mamwe achingobva pakushandiswa kwezviratidzo zvakatemerwa basa rega rega..

Sum

Sum function

Kuti tiite Excel sum isu tinofanirwa kuisa inotevera fomula:

=SUM(A1:A2) kana =SUM(2+2)

Sezvatinoona, fomula inotsigira mamodhi maviri, imwe yekuwedzera masero maviri akasiyana uye imwe yekuwedzera nhamba mbiri mukati mesero rimwe chete.

Kubvisa

bvisa excel

Kune rimwe divi, kubvisa maitiro kuri nyore nekuti unongofanira kushandisa chiratidzo che "-". Muchiitiko chino, tichava nechimwe chinhu chakadai:

=A1–A3

Nenzira iyi, isu tinobvisa kukosha kwemasero maviri, kunyangwe zvichikwanisika kuzviita nenhamba mukati mayo.

Kuwanza

Sekubvisa, kuwanda muExcel kunobva pakushandisa asterisk sechiratidzo. Saka, kuwedzera maviri kana anopfuura maelementi tinenge tine chimwe chinhu chakadai:

=A1*A3

Zvinokosha kuziva kuti, semuzviitiko zvakapfuura, tinogona kuwanza maitiro maviri mukati mesero rimwe chete.

Chikamu

Kuparadzanisa muExcel

Pakupedzisira, kuita mabasa ekuparadzanisa, tichashandisa bhari sechiratidzo. Nenzira iyi tine:

= A1/A3

Zvakare, iwe unogona kushandisa fomula imwechete kugovera nhamba mbiri musero.

AVERAGE

kupfuura pakati

Iyo AVERAGE formula inobatsira zvakanyanya muminda yakawanda uye sezita rayo rinoratidza, inotibatsira kuwana avhareji kukosha mukati meiyo yakasarudzwa seti yenhamba. Zvinofanira kucherechedzwa kuti oparesheni iyi inowanzozivikanwa seMean kana Arithmetic Mean uye iripo zvakanyanya mumunda wezvidzidzo uye zvakare muhuwandu.

Kuti uishandise unofanira kuisa:

=AVERAGE(A1:B3)

SI

Basa Hongu

Iyo IF basa chikamu chemacondition formulas, anobatsira chaizvo patinenge tichida kutarisa kana imwe mamiriro ari echokwadi kana kwete.. Izvi zvinonyanya kushandiswa munzvimbo dzakaita sevadzidzisi, semuenzaniso, kwatinogona kuve nerondedzero yevadzidzi vane mamakisi avo uye padivi payo chaipo chinyorwa chinoratidza kuti vakapasa here kana kuti kwete. Nenzira iyi, isu tinofanirwa kuseta iyo fomula kuitira kuti isimbise kana mamiriro asangana.

Mupfungwa iyoyo, syntax yakaita seiyi:

= IF(Chimiro, Kukosha kana ichokwadi, Kukosha kana kusiri chokwadi)

Saka, kana giredhi rekupasa riri makumi mashanu, isu tingave nemuenzaniso wakadai:

= HONGU(B2>=50, PASS, FAIL)

ZVICHAVERENGA

COUNTA basa

COUNTA ndeimwe yemafomula ekutanga ekudzidza mashandisiro eExcel yatinofanira kubata nekuda kwekushandisa kwayo kukuru. Nayo, unogona kuverenga nhamba yemasero ane data iripo mune yakapihwa renji. Nenzira iyi, kana iwe uchida kuziva huwandu hwezvinhu mukoramu uye kuti zvakare inogadziridzwa, saka unogona kuishandisa.

Kuti uite izvi, syntax ndeiyi inotevera:

COUNTA (A1:B3)

Mukati memaparentheses iwe unogona kupinda muyero yemasero aunoda kusimbisa uye iwe unobva wawana mhedzisiro.

HYPERLINK

isa hyperlink

Kunyangwe Excel ichiziva zvinongedzo kana tikaaisa uye nekukasira kuashandura kuita chinongedzo chinowanikwa kubva pakudzvanya, iyo HYPERLINK formula inotora mukana uyu zvishoma kumberi. Mupfungwa iyoyo, isu tinokwanisa kugadzirisa iyo hyperlink zvinyorwa, zvichiita kuti mamwe mavara aoneke panzvimbo yekubatanidza.

Iyo fomula iri seinotevera:

=HYPERLINK(link, zvinyorwa)

=HIPERVINCULO(“www.windowsnoticias.com”, “Conoce nuestra web”)

VLOOKUP

FindV Excel

VLOOKUP nderimwe reanonyanya kufarirwa mabasa muExcel uye rinokutendera kuti uwane kukosha kwaunoda mukati mechikamu chemasero.. Nenzira iyi, iwe unozogona kudzivirira kuenda nesero rega rega kuti uwane iyo data yaunoda uye panzvimbo pezvo, zvichave zvakakwana kushandisa fomula iri mubvunzo. Syntax iri sezvinotevera:

=KUTARIRA(KUTSVAGA KUKOSHA, ZVINHU ZVEMASERO, NHAMBA YECOLUMN PANOWANIKWA DATA ROKUTARIRA, AKAOREDWA)

Nenzira iyi, yekutanga parameter yekupinda kukosha kwakatsvakwa, iyo isiri chinhu kunze kwereferensi yatichashandisa kutsvaga data iri mubvunzo. Zvadaro, iko kutendeuka kwehuwandu hwemasero uko kutsvaga kuchaitwa uye wobva wawedzera nhamba yekoramu uko data ratinoda kuwana rinowanikwa.. Makolamu anotanga kuita manhamba kubva pane yawasarudza. Chekupedzisira, Sorted inoreva kuti kutsvaga kuchadzosa chaiyo kana fungidziro yemutambo. Pamachisi chaiwo, isa FALSE.


Iva wekutanga kutaura

Siya yako yekutaura

Your kero e havazobvumirwi ichibudiswa. Raida minda anozivikanwa ne *

*

*

  1. Inotarisira iyo data: Miguel Ángel Gatón
  2. Chinangwa cheiyo data: Kudzora SPAM, manejimendi manejimendi.
  3. Legitimation: Kubvuma kwako
  4. Kutaurirana kwedata
  5. Dhata yekuchengetedza: Dhatabhesi inobatwa neOccentus Networks (EU)
  6. Kodzero: Panguva ipi neipi iwe unogona kudzora, kupora uye kudzima ruzivo rwako