Nzira Yokujekesa Zita Rinoitwa muExcel

Ipa mazita anotsanangura kumasero ega kana mapurisa emasero

A zita rakarongeka , zita remhando , kana zita rinotsanangurwa zvose rinoreva chinhu chimwechete muExcel. Iri zita rinotsanangura - rakadai saJan_Sales kana June_Precip - iyo yakabatanidzwa pane imwe sero kana kuti mazamu emasero mune pepa rekushanda kana bhuku rebhuku .

Zita rakatumidzwa rinoita kuti zvive nyore kushandisa nekuona dhidhiro paunenge uchitora chati , uye nenzira dzakadai se:

= SUM (Jan_Sales)

= June_ Chando + July_ Chando + Aug_ Precip

Uyewo, sezvo zita rakarongedzwa risina kuchinja apo rondedzero inyorerwa kune mamwe masero , inopa imwe nzira yekushandisa zvachose masero ezvinyorwa mumashonga.

Kutsanangura Zita muExcel

Nzira nhatu dzakasiyana dzekutsanangura zita mu Excel ndeyi:

• Kushandisa Zita Bhokisi (peji iri pasi apa)
• Kushandisa Izwi idzva rebhokisi bhokisi
• Kushandisa Mutariri Wezita

Kurondedzera Zita rine Zita Bhokisi

Imwe nzira, uye zvichida nzira iri nyore yekutsanangura mazita iri kushandisa Bhokisi Razita , riri pamusoro pevharamu A mune pepa rekushanda.

• Shandisa iyi nzira yekuumba mazita akasiyana-siyana anozivikanwa nepadhi rimwe nerimwe mubhuku rebhuku.

Kugadzira zita uchishandisa Zita Bhokisi sezvaratidzwa mumufananidzo uri pamusoro apa:

1. Simbisa mazamu emasero akadikanwa mubasa rekushanda.
2. Nyora zita raunoda kuti iro rive muzita rebhokisi, rakadai saJan_Sales.
3. Dhinda pikicha inopinda mubhokisi.
4. Zita rinoratidzwa muZita rebhokisi.

Cherechedza : Zita racho rinoratidzwawo muZita rebhokisi pose apo mamwe mazana emasero anotsanangurwa mubasa rekushanda. Inoratidzwawo muMutungamiriri Wezita.

Kutumidza Mitemo uye Zvipingamupinyi

Izwi rinonyanya kushandiswa kuronga kuyeuka kana kugadzira kana kugadzirisa mazita emakero ndeokuti:

1. Zita harigoni kuva nezvivako.
2. Mhando yekutanga yezita inofanira kunge iri
   • tsamba
   • underscore (_)
   • kudzokera shure (\)
3. zvinyorwa zvinosara zvinogona kuva
   • tsamba kana nhamba
   • nguva
   • kudzokorora mifananidzo
4. Zita rakareba mazita ndezvenhamba makumi mashanu.
5. Tsamba dzekunyora uye dzezasi dzisinganzwisisiki kune Excel, saka Jan_Sales uye jan_sales vanoonekwa sezita rimwechete neEexcel.

Mamwe mazita Mitemo ndeyi:

• Cell reference haigoni kushandiswa sezita rakadai seA25 kana R1C4.
• Imwe maitiro mazita anobvumirwa kunze kwe "C", "c", "R", kana kuti "r" nokuti anotsigirwa kune imwe nhare uye musero sekare zvinyorwa se R1C4.

01 ye 02

Mazita anotsanangurwa uye Maonero muExpcel

Zvose mazita ane ruzivo rwunoreva nzvimbo iyo zita rimwe rinozivikanwa neExcel.

Zita remazita rinogona kuva re:

• mapepa ega ega - anotumidzwa sehuwandu hwemashizha emunharaunda
• bhuku rose rebhuku - pasi rose rebhuku rebhuku rebasa

Zita rinofanira kunge risina kukwana mukati maro, asi zita rimwechete rinogona kushandiswa mumamiriro akasiyana.

Cherechedza : Kugara kusina mazita matsva ndiyo nhamba yebhuku rebasa rose. Pane imwe nguva yakatsanangurwa, kuwanda kwezita hakugoni kuchinjwa nyore. Kuti uchinje uwandu hwezita, tsvina zita muMutungamiriri weZita uye uritaurire zvakare nehuwandu hwezvakanaka.

Nharaunda Yebasa Rokushanda Nhamba

Zita rine nhamba yepamusoro yebasa rinoshanda chete nokuda kwebasa raakatsanangurwa naro. Kana zita rokuti Total_Sales rine ruzivo rwepadhi 1 yebhuku rebhuku, Excel haichazivi zita pa peji 2, peji 3, kana imwe pepa mubhuku rebhuku.

Izvi zvinoita kuti zvikwanise kutsanangura zita rimwechete rekushandiswa pamashizha akawanda emahofisi - chero bedzi kuwanda kwezita rimwe nerimwe kunongowanikwa kune rimwe pepa pepaji.

Kushandisa zita rimwe chete pamashizha akasiyana-siyana kunogona kuitwa kuti kuve nekuenderera mberi pakati pemashizha uye kuve nechokwadi kuti mafomu anoshandisa zita rokuti Total_Sales anogara achireva mazana emamwe masero mumashizha akawanda emabhuku mukati mebhuku rimwe chete rebhuku.

Kusiyanisa pakati pemamwe mazita akasiyana nemazero akasiyana nemafomu, tanga zita racho nezita rebasa rekushanda, rakadai se:

Sheet1! Total_Sales, Sheet2! Total_Sales

Cherechedza: Mazita akashandiswa kushandisa Bhokisi Razita acharamba aine nhamba yebhuku rebhuku rino pasi rose kunze kwekuti zita rose repaiti uye zita rezita rakapinda muzita rebhokisi apo zita rinotsanangurwa.

Muenzaniso:
Zita: Jan_Sales, Maitiro - pasi rose rebhuku rebasa
Zita: Sheet1! Jan_Sales, Maitiro - nzvimbo yepaji yepaji yepamusoro

Bhuku Rebasa Rekushanda Nhamba

Zita rinotsanangurwa nehuwandu hwebhuku rebhuku rinozivikanwa pamashizha ose mubhuku rebhuku iroro. Bhuku rebhuku rebhuku rebasa rinogona kushandiswa kamwe chete mubhuku rebhuku, kusiyana nemazita emazita epasiti anokurukurwa pamusoro apa.

Bhuku rebhuku rebasa rezita harisi, zvisinei, rinozivikanwa nemumwe mabhuku ebhuku, saka mazita ezvepasi rose anogona kudzokororwa mumafuta akasiyana eExpcel. Somuenzaniso, kana zita reJan_Sales rine ruzivo rwepasi pose, zita rimwe chete rinogona kushandiswa mumabhuku edzidziso akasiyana nere 2012_Revenue, 2013_Revenue, uye 2014_Revenue.

Kuwirirana Kusawirirana uye Maonero Akaitika

Zvinokwanisika kushandisa zita rimwechete pane zvose zviri mukati pezhizha uye bhuku rebhuku rebasa nokuti rutivi rwemaviri rwaizove rwakasiyana.

Mamiriro ezvinhu akadaro, zvisinei, aizoumba kupesana pose apo zita racho raishandiswa.

Kuti ugadzirise kukakavadzana kwakadaro, muExcel, mazita anotsanangurwa pamwero wepasiro webasa rinoendesa mberi pamusoro pehuwandu hwebhuku rebasa rose.

Mumamiriro ezvinhu akadaro, zita rezhizha re2014_Revenue raizoshandiswa pane zita rebhuku rebhuku rebasa re 2014_Revenue .

Kuti uwedzere kutonga kwekutangira, shandisa zita rebhuku rebhuku rekushandisa pamwe chete nedzimwe ruzivo rwemasiti-yepamusoro sa 2014_Revenue! Sheet1.

Chimwe chete kunze kwekupfuurira mberi kune imwe nzvimbo yepaji yepamusoro yepaji yepasiti yepamusoro ine chikamu chepadhi 1 yebhuku rebhuku. Nzvimbo dzakabatana nepepanti 1 yebhuku chero ripi zvaro rekushandisa haigoni kuvharwa nemazita emazinga enyika.

02 of 02

Kusarudza uye Kutarisa Mazita ane Mutungamiriri Wezita

Kushandisa Bhokisi reDhiyabhorosi reNew Name

Nzira yechipiri yekutsanangura mazita ndeyokushandisa Zita idzva rebhokisi dialog . Iri bhokisi rebhokisi rinoshandiswa uchishandisa zita rinonzi Define Name riri pakati peMafomu tab yebhoni .

Iyo Zita Idzva dialog box inoita kuti zvive nyore kutsanangura mazita ane mazinga ekushanda kwemashizha.

Kugadzira zita uchishandisa Zita Rokutanga dialog box

1. Simbisa mazamu emasero akadikanwa mubasa rekushanda.
2. Dzvanya paMafomu tab yebhoni.
3. Dzvanya paZita Rokufananidza sarudzo kuti uzarure Zita idzva rebhokisi rebhokisi.
4. Mubhokisi rebhokisi, unofanirwa kutsanangura:
   • Zita
   • Maonero
   • Range yezita idzva - mazano ndezvokuda
5. Kana wakambopedzwa, sarudza OK kuti udzoke kubasa rekushanda.
6. Zita racho richaratidzwa muZita reBhokisi pose apo tsanangudzo yakasarudzwa inosarudzwa.

Mutariri Wezita

Mutungamiri weZita anogona kushandiswa kune zvose zviri zviviri kutsanangura nekutarisa mazita akange aripo. Inowanikwa pedyo neZita Rokufananidza sarudzo paFormulas tab yebhoni.

Kutsanangura Zita uchishandisa Mutariri Wezita

Pakutsanangura zita muMutungamiriri weZita rinotanga Zita Rokutanga rebhokisi bhokisi rakataurwa pamusoro apa. Rwendo rwakakwana rwe matanho nde:

1. Dzvanya maTramulas tab yebhoni.
2. Dzvanya paZita reMeneja weZita mukati mebhoni kuti uzarure Mutariri Wezita.
3. MuMutungamiri weZita, tora paNew button kuti uzarure Zita Rokutanga rebhokisi.
4. Muchikamu chino, iwe unofanirwa kutsanangura:
   • Zita
   • Maonero
   • Range yezita idzva - mazano ndezvokuda
5. Dzvanya OK kuti udzoke kune Mumiririri weZita uko zita idzva richarongwa muhwindo.
6. Dzvanya Pedyo kuti udzoke kushizha remabasa.

Kuchenesa kana Kugadzirisa Mazita

NeMutungamiriri weZita akazaruka,

1. Muhwindo rine mazita emazita, chengeta kamwechete pane zita kuti ribviswe kana rigadziriswe.
2. Kuti ubvise zita racho, chengeta paBhura bhokisi riri pamusoro pewindo rewindo.
3. Kuti uone zita racho, enda pane Bhokisi rekudisa kuti uzarure Hora Name rebhokisi rebhokisi.

MuIndaneti Zita Raiti dialog box, unogona:

• shandura zita racho.
• ronga kana kuwedzera mhinduro pamusoro pezita racho.
• shandura rondedzero yezita rezita racho. Izvi zvinogona kuitwa kuburikidza nekusimbisa urongwa huripo mubhokisi rebhokisi uye nekusarudza hutsva hutsva mubasa rekushandura.

Cherechedza: Uwandu hwezita raivepo hugoni kuchinjwa uchishandisa zvingasarudzwa. Kuti uchinje huwandu, svina zita uye uritaurire zvakare nehuwandu hwezvakanaka.

Kunyora Mazita

Bhatani reFuta muMutungamiriri weZita rinoita kuti zvive nyore ku:

• tsvaga mazita ane zvikanganiso - zvakadai sechirwere chisina kumira,
• chengetedza nzvimbo yezita-ingava yepamusoro pepaji yebasa kana bhuku rebasa, uye
• mararamiro uye mafiritsi akarongedza mazita - anotsanangurwa (mazita) mazita kana mazita ematafura.

Tsvina yakanyatsoratidzwa inoratidzwa muhwindo rendaneti muMutungamiriri weZita.