Maitiro ekuisa kukosha kwakazara muExcel? Mukati meichi chinyorwa tichakudzidzisai, nematanho ari nyore.
Zvinonyatsozivikanwa, kuti Excel is a ssoftware, inokwanisa kuronga, kuchengeta uye kurongedza marudzi ese e data neruzivo. Zvakanyanya kuoma kushandisa, asi zvinobatsira zvikuru kana tichida kuchengetedza sangano rose rebhizimisi, nzvimbo, nhoroondo, pakati pezvimwe zvakawanda.
Excel, sechishandiso chakangwara, inotibvumirawo kuita masvomhu asingaperi, mamwewo atinowanzoda, mukati mezvirongwa zvedu, mabasa, kana zvinyorwa zvataurwa pamusoro apa.
Saka pakupedzisira, Excel inogona kutibatsira kuverenga kukosha kwakakwana, nokuda kwaizvozvi unofanira kuzvizivawo. Kuti kune chikamu chayo, kukosha kwakakwana ndiyo chinhambwe chiripo pakati penhamba yakapihwa uye zero, izvi zvinoreva kuti mhedzisiro yakawanikwa ichagara iri nhamba yakanaka, kunyangwe kukosha kwacho kwakashata.
Nenzira iyi, Excel inotibvumirawo kuwedzera huwandu hwese kana runyorwa rwenhamba dzakanaka uye dzisina kunaka mukati memapepa ebasa.
Kana iwe uchida kuziva, kuti ungaita sei zvese izvo, gara mukati meiyi tutori, apo isu tichakudzidzisa iwe kuisa kukosha kwakazara muExcel.
Excel mabasa anotitendera kuti tiise iyo yakakwana kukosha
Chaizvoizvo Excel, ine mabasa akasiyana, ayo anotibvumira kuverenga nekuwedzera kukosha kwakakwana kwenhamba, mukati memashizha ayo, mabasa aya ndeaya anotevera:
ABS basa
Iri ndiro rimwe remabasa ekutanga, anokurudzirwa kana tichida wedzera kukosha kwakazara muexcel spreadsheet. Mukati mayo, kukosha kwakakwana kwenhamba kunotangwa, mukati meimwe sero chaiyo. Iri ibasa rekutanga, iro risingakwanise kunyatso kuwedzera mhedziso maitiro otomatiki, asi rinotitendera kuti tizviite nemaoko.
Kuti tiite, tinofanira kuita zvinotevera:
Vhura bepa reExcel risina chinhu uye tanga kupinda -3454 muchitokisi B3, wobva wasarudza sero rinotevera, B4, uri pariri dzvanya murairo "Fx” Izvi zvichavhura hwindo nyowani, kwaunofanira kusarudza “isa basa”. Ipapo menyu yekudonha ichaonekwa, kwaunofanirwa kusarudza chikamu "ABS”, hwindo idzva richavhurika ipapo pazasi paro.
Wobva wadzvanya bhatani rekuti "cell reference" yemunda "nhamba” wosarudzazve sero B3. Ipapo iwe uchafanirwa kudzvanya pa "OK", nenzira iyo ruzivo ruchawedzerwa. ABS inoshanda mukati mespredishiti. Mune izvo iwe uchaona kuti sero B4 ikozvino ichatora kukosha kwe3454.
Kana iwe uchida, iwe unogonawo kuwana iyo yakakwana kukosha kwehuwandu hwemasero, neiri basa rimwechete, nekuwedzera ABS column mukati mespredishiti. Ipapo iwe unogona kuisa iyo ABS basa kune iyo column, nekupinda iyo equation = SUM, musero pazasi pekoramu, nenzira iyo iwe unogona zvakare kuwedzera iwo mhedziso tsika dzakawanikwa.
Uye ndizvozvo.Zvakareruka, handiti? Nenzira iyoyo unenge uine isa kukosha kwakazara mukati meexcel sheet.
Kusanganiswa kweABS nebasa reSUMPRODUCT kuisa kukosha kwakakwana muExcel
Basa reABS, muchidimbu, rinonyanya kubatsira pakuverenga kukosha kwakakwana uye rinogonawo kusanganiswa nemamwe mabasa, munyaya iyi tiri kutaura nezve SUMPRODUCT basa, iyo inotibvumira kupa mitsara yakaipa kana yakanaka kune yakakwana kukosha.
Kuti uwane isa kukosha kwakazara muexcel, uchishandisa aya maviri mabasa, iwe unofanirwa kuita zvinotevera:
Iwe unofanirwa kutanga wavhura pepa reExcel nyowani. Uye wozoizadza neyakagadzirwa data. Iwe unogona kuisa kukosha 4, 4 uye 7 mumasero A2, A3 uye A4. Ipapo iwe unofanirwa kusarudza cell A5 uye tinya, mukati mebhawa inonzi "effects". Ipapo unofanira kupinda mu basa =SUMPRODUCT(A2:A4), mune imwechete "effects" bar mushure mekunge wasarudza "OK"Kana kuti"Intro”, izvi zvichaita kuti sero A5, ive nhamba 7, iyo isiri iyo chaiyo kukosha.
Ipapo iwe unofanirwa kuwana iyo yechokwadi chaiyo kukosha, nekuda kweizvi isu tinofanirwa kujoina iyo ABS basa nematanho apfuura, saka basa rine equation yaro yepakutanga rinofanira kuchinjirwa kune izvi. =SUMPRODUCT(ABS(A2:A4)). Izvo zvichaita kuti A5 ive gumi neshanu, kureva, 15 + 4 + 4, kuitira kuti sero renji, ripe mhedzisiro yakananga.
Ready! Kunyangwe iyi sarudzo ingaite seyakaoma kupfuura yekutanga, kana iwe ukaiisa mukuita, iwe unozoona kuti iri nyore sei.
Iyo SUMIF basa rekutsvaga kukosha kwakazara muExcel
Iri basa rinobvumira vashandisi veExcel kuti vawedzere kukosha zvinosangana nenhevedzano yemaitiro chaiwo. Nayo isu tinogona zvakare kuwana iyo mhedziso kukosha, kune yakapihwa huwandu hwemasero, isu tinofanirwa kuwedzera inotevera equation. SUMIF(range, maitiro,[sum_range]). Nenzira iyo iwe unogona kuwana iyo yakakwana kukosha, otomatiki.
Kune rimwe divi, kana iwe uchida kuti oparesheni iitwe neimwe nzira yemanyorero, isa basa mu "kukanganisa”. Kusarudza cell A6, wobva wapinda data pinda =SUMIF(A2:A4,»>0″)-SUMIF(A2:A4,».
Uye izvozvo zvingava zvose, nyore zvisingabviri.
Iyo Kutools plugin
Ichi, kune rumwe rutivi, chishandiso chekunze, asi chinoshanda zvakanaka pamwe chete neExcel, nayo unogona kuita mashandiro akasiyana uye pakati pavo, tsvaga kukosha kwakakwana, inotibatsirawo kushandura zviratidzo zvehukoshi, kubva kune yakaipa kusvika kune yakanaka nhamba, mukati meExcel sheet yedu.
Kana iwe uchida kuwana mabasa ayo ese uye mabhenefiti, zvese zvaunofanirwa kuita kuiisa pakombuta yako uye wotanga kushanda nayo.
Mhedziso
Pane chaizvo nzira shoma dzekuwana kukosha kwakazara kwehuwandu hwehuwandu mukati meExcel spreadsheet. Asi chimwe nechimwe cheavo vakatsanangurwa pamusoro apa, chinokwanisa kuzadzisa icho chinodiwa basa, iro isa kukosha kwakazara mukati meexcel.
Padivi pako, chasara kutsvaga uye kuona iyo yakakuitira nyore uye, zviri pachena, iyo inonyatso kuenderana nezvinodiwa iwe semushandisi weExcel.
Kune vamwe, isu tinongovimba kuti wakafarira chinyorwa uye kuti unotoziva kuisa kukosha kwakazara muExcel.