Otomatiki mitsara manhamba muExcel: 3 nzira

Paunenge uchishanda muExcel, hazvina kujairika kuda mitsara nhamba mune imwe koramu yakasiyana. Izvi zvinogona kuitwa nekuisa nhamba dzesiriyamu nemaoko, nemamwe mazwi, nekudzinyora pakhibhodi. Zvisinei, kana uchishanda nehuwandu hwemashoko, kupinda nhamba nemaoko haisi nzira inofadza uye inokurumidza, iyo, uyezve, zvikanganiso uye typos zvinogona kuitwa. Neraki, Excel inobvumidza iwe kuti uite otomatiki maitiro aya, uye pazasi isu tichatarisa chaizvo kuti izvi zvinogona kuitwa sei nenzira dzakasiyana.

Nzira 1: Kuverenga Mushure mekuzadza Mitsetse Yokutanga

Iyi nzira ndiyo zvichida iri nyore. Paunenge uchizviita, iwe unongoda kuzadza mitsara miviri yekutanga yekoramu, mushure mezvo iwe unogona kutambanudza manhamba kune yasara mitsara. Zvisinei, inobatsira chete kana uchishanda nematafura maduku.

1. Chekutanga, gadzira koramu itsva yekuverenga nhamba. Musero rekutanga (tisingaverenge musoro) tinonyora nhamba 1, toenda kune yechipiri, umo tinoisa nhamba 2.
2. Iye zvino iwe unofanirwa kusarudza masero maviri aya, mushure mezvo tinofambisa mutsara we mouse pamusoro pekona yekona yekona yenzvimbo yakasarudzwa. Kana chinongedzo ichingochinja chitarisiko chayo kuita muchinjiko, bata pasi bhatani rekuruboshwe worikwevera kumutsara wekupedzisira wekoramu.
3. Isu tinosunungura bhatani rekuruboshwe rembeva, uye nhamba dzeseri dzemitsara dzichakurumidza kuoneka mumitsetse yatakafukidza kana kutambanudza.

Nzira 2: STRING mushandisi

Iyi nzira ye otomatiki mutsara manhamba inosanganisira kushandisa basa “ZVINOKOSHA”.

1. Isu tinosimuka musero rekutanga rekoramu, yatinoda kugovera serial nhamba 1. Zvadaro tinonyora chirevo chinotevera mairi: =СТРОКА(A1).
2. Patinongobhuya pinda, serial nhamba ichaonekwa musero rakasarudzwa. Iyo inoramba, yakafanana nenzira yekutanga, kutambanudza fomula kune mitsara yepasi. Asi ikozvino iwe unofanirwa kufambisa mbeva cursor kukona yekurudyi yesero neformula.
3. Zvese zvakagadzirira, isu tatozviverengera mitsara yese yetafura, yaidiwa.

Panzvimbo pekupinda nemaoko fomula, unogona kushandisa Function Wizard.

1. Isu tinosarudzawo sero rekutanga rekoromo apo tinoda kuisa nhamba. Tinobva tadzvanya bhatani "Isa basa" (kuruboshwe kweformula bar).
2. The Function Wizard hwindo rinovhura. Dzvanya pane iripo chikamu chemabasa uye sarudza kubva pane iyo rondedzero inovhura "References uye Arrays".
3. Iye zvino, kubva pane rondedzero yevashandisi vakarongwa, sarudza basa racho “ZVINOKOSHA”, ipapo shandisa OK.
4. Hwindo richaonekwa pachiratidziro rine mafungidziro ebasa ekuzadza mukati. Dzvanya pane inopinza ndima yeparameter "Mutsetse" uye tsanangura kero yesero rekutanga mukoramu yatinoda kugovera nhamba. Kero inogona kuiswa nemaoko kana kungodzvanya pane yaunoda sero. Next tinya OK.
5. Nhamba yemutsara inoiswa musero rakasarudzwa. Nzira yekutambanudza nhamba kune mamwe mitsara, takakurukura pamusoro apa.

Nzira 3: kushandisa kufambira mberi

Iyo yakaderera nzira yekutanga neyechipiri ndeyekuti iwe unofanirwa kutambanudza manhamba kune mamwe mitsara, iyo isinganyanyi kunyanyonakira kune yakakura vertical tafura saizi. Naizvozvo, ngatitarisei imwe nzira inobvisa kudikanwa kwekuita chiito chakadaro.

1. Isu tinoratidza musero rekutanga rekoramu nhamba yayo yeserial, yakaenzana nenhamba 1.
2. Chinja kune tab "Kumba", tinya bhatani “Zadza” (chikamu "Kugadzirisa") uye mune rondedzero inovhurwa, tinya pane iyo sarudzo “Kufambira mberi…”.
3. Hwindo richaonekwa pamberi pedu rine mafambiro ekufambisa anoda kugadziridzwa, mushure mezvo tinodzvanya. OK.
   • sarudza urongwa "nemakoramu";
   • tsanangura rudzi rwe "arithmetic";
   • munhanho kukosha tinonyora nhamba "1";
   • mundima ye "Limit value", ratidza nhamba yemitsara yetafura inoda kuverengwa.
4. Otomatiki mutsara manhamba anoitwa, uye isu takawana mhedzisiro yatinoda.

Iyi nzira inogona kushandiswa neimwe nzira.

1. Tinodzokorora danho rekutanga, kureva Nyora nhamba 1 musero rekutanga rekoromo.
2. Isu tinosarudza huwandu hunosanganisira maseru ese atinoda kuisa nhamba.
3. Kuvhura hwindo zvakare "Progressions". Iwo ma parameter anoiswa otomatiki zvichienderana nerudzi rwatakasarudza, saka isu tinongofanidza kudzvanya OK.
4. Uye zvakare, nekuda kwezviito zviri nyore izvi, tinowana nhamba yemitsara mumutsara wakasarudzwa.

Kureruka kweiyi nzira ndeyekuti haufanirwe kuverenga nekunyora nhamba yemitsara yaunoda kuisa manhamba. Uye iyo yakashata ndeyokuti, sekutanga uye yechipiri nzira, iwe uchafanirwa kusarudza huwandu hwemasero pachine nguva, izvo zvisiri nyore kana uchishanda nematafura makuru.

mhedziso

Kuverenga mutsara kunogona kuita kuti zvive nyore kwazvo kushanda muExcel paunenge uchishanda nehuwandu hwe data. Inogona kuitwa nenzira dzakawanda, kubva pakuzadza kwemanyorero kusvika kune yakazara otomatiki maitiro ayo anobvisa chero zvikanganiso zvinogona kuitika uye typos.