Nzira yekutumidza sero mune excel spreadsheet. Mazita emhando muExcel

Kuti uite zvimwe zviito muspredishiti, chiziviso chakasiyana chemaseru kana huwandu hwawo hunodiwa. Mumwe nomumwe wavo anogona kupiwa zita, basa racho rinobatsira purosesa yespredishiti kunzwisisa kuti ichi kana icho chinhu chiri pairi pepa rebasa. Chinyorwa chichabata nzira dzese dzekupa zita kune sero mutafura.

Kutumidza

Iwe unogona kupa zita kune chikamu kana renji muspredishiti uchishandisa nzira dzinoverengeka, dzatichakurukura pazasi.

Nzira 1: tambo yezita

Kuisa zita mumutsara wezita ndiyo nzira iri nyore uye iri nyore. Mutsara wemazita unowanikwa kuruboshwe rwemunda wekupinda mafomula. Nhanho-ne-nhanho yekuraira inoita seizvi:

1. Isu tinosarudza huwandu kana chikamu chimwe chetafura.

2. Mumutsara wemazita tinotyaira muzita rinodiwa renzvimbo yakasarudzwa. Paunenge uchipinda, unofanirwa kufunga nezvemitemo yekupa zita. Mushure mekuita zvese manipulations, tinya bhatani rekuti "Enter" pane keyboard.

3. Ready! Tatopedza kupa zita sero kana mutsara wemaseru. Kana ukaasarudza, ipapo zita ratakapinda richaonekwa mumutsara wemazita. Zita renzvimbo yakasarudzwa rinogara richiratidzwa mumutsetse wezita, pasinei nokuti zita racho rinopiwa sei.

Nzira 2: menyu yemamiriro ezvinhu

Menyu yemamiriro ekunze chinhu chinobatsira pakushandisa mazita emasero. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza nzvimbo yatinoronga kupa zita. Isu tinodzvanya RMB. Menyu diki yemamiriro ekunze inoonekwa pachiratidziri. Isu tinowana chinhu "Govera zita ..." uye tinya pairi.

2. Iwindo diki idzva rakaonekwa pachiratidziro chinonzi "Kugadzira Zita". Mumutsara we "Zita" unofanira kuisa zita raunoda kuisa nzvimbo yakasarudzwa.
3. Mumutsara we "Region" tinoratidza nzvimbo iyo, kana ichitaura kune zita rakapiwa, nzvimbo yakasarudzwa yezvikamu ichasarudzwa. Nzvimbo yacho inogona kunge iri gwaro rose kana mamwe mapepa ekushanda mugwaro. Kazhinji iyi parameter inosiiwa isina kuchinjwa.
4. Mutsara we "Cherechedza" une zvinyorwa zvakasiyana zvachose zvinotsanangura nzvimbo yakasarudzwa yedata. Munda unogona kusiiwa usina chinhu sezvo ichi chivakwa chisingatariswe sechinodikanwa.
5. Mumutsara we "Range", pinda marongero enzvimbo yedata yatinopa zita. Izvo zvinorongeka zvemhando yakasarudzwa pakutanga inoiswa mumutsara uyu otomatiki.
6. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

7. Ready! Isu takapa zita kune iyo data array tichishandisa iyo Excel spreadsheet mamiriro menyu.

Method 3: Govera zita uchishandisa bhatani riri paribhoni

Nekubatsira kwezvishandiso zvakakosha zviri paribhoni, unogona kutsanangura zita renzvimbo yedata. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza nzvimbo yatinoronga kupa zita. Isu tinotamira kune "Formulas" chikamu. Isu tinowana block yemirairo "Mazita Akatsanangurwa" uye tinya pane chinhu "Isa zita" pane ino panhi.

2. Chidzitiro chakaratidza hwindo diki rainzi "Gadzira zita", iyo yatinoziva kubva kune yakapfuura nzira. Isu tinoita zvese manipulations zvakafanana nemuenzaniso wambotaurwa. Dzvanya "OK".
3. Ready! Isu takapa zita renzvimbo yedata tichishandisa zvinhu zviri paribhoni rekushandisa.

Nzira 4: Zita Maneja

Kuburikidza nechinhu chinonzi "Zita Maneja", unogona zvakare kuseta zita renzvimbo yakasarudzwa yedata. Iyo yekufamba inotaridzika seiyi:

1. Isu tinotamira kune "Formulas" chikamu. Tsvaga iyo "Defined Names" yekuraira block uye tinya pane "Zita Maneja" chinhu pane ino panhi.

2. Idiki "Zita Maneja ..." hwindo rakaratidzwa pachiratidziro. Kuti uwedzere zita idzva renzvimbo yedata, tinya pane "Gadzira ...".

3. Chiratidziro chakaratidza hwindo rinozivikanwa rakanzi "Ipa zita." Sezvakaita nzira dzakatsanangurwa pamusoro apa, tinozadza minda yose isina chinhu nemashoko anodiwa. Mumutsara we "Range" isa macoordination enzvimbo kuti upe zita. Kuti uite izvi, unofanirwa kutanga wadzvanya pamunda usina chinhu padhuze nerunyoro "Range", uye wozosarudza nzvimbo yaunoda pane pepa pacharo. Mushure mekuita zvese manipulations, tinya pane chinhu "OK".

4. Ready! Isu takapa zita kunzvimbo yedata tichishandisa "Name Manager".

Teerera! Kushanda kwe "Name Manager" hakugumiri ipapo. Maneja haangoiti chete kugadzirwa kwemazita, asi zvakare anobvumidza iwe kuti uatore, pamwe nekuadzima.

Bhatani re "Shandura ..." rinokutendera kuti ugadzirise zita. Kuti uite izvi, iwe unofanirwa kutanga wasarudza chinyorwa kubva pane iyo rondedzero, tinya pairi, uye wobva wadzvanya "Edit ...". Mushure mekuita zvese zviito, mushandisi achaendeswa kune yakajairika "Ipa zita" hwindo, umo zvichave zvichigoneka kugadzirisa iyo iripo paramita.

Bhatani re "Delete" rinokutendera kuti udzime chinyorwa. Kuti uite izvi, sarudza iyo yaunoda kupinda, uye wobva wadzvanya pane "Delete" chinhu.

Mushure mekupedza matanho aya, hwindo diki rekusimbisa richaonekwa. Tinya "OK".

Kune vamwe vese, pane yakakosha sefa muZita Maneja. Inobatsira vashandisi kuronga uye kusarudza zvinyorwa kubva pane zvinyorwa zvemazita. Kushandiswa kwesefa kunodiwa kana uchishanda nenhamba huru yemazita.

Kutumidza Constant

Kupa zita kune rinogara richidiwa kana riine chiperengo chakaoma kana kushandiswa kakawanda. Iyo yekufamba inotaridzika seiyi:

1. Isu tinotamira kune "Formulas" chikamu. Isu tinowana block yemirairo "Mazita Akatsanangurwa" uye sarudza chinhu "Ipa zita" pane ino panhi.
2. Mumutsara we "Zita" tinopinda iyo inongogara pachayo, semuenzaniso, LnPie;
3. Mumutsara we "Range" isa fomura inotevera: =3*LN(2*MUDZI(PI()))*PI()^EXP(1)

4. Ready! Takapa zita kune anogara aripo.

Kutumidza sero uye formula

Iwe unogona zvakare kutumidza formula. Iyo yekufamba inotaridzika seiyi:

1. Isu tinotamira kune "Formulas" chikamu. Isu tinowana block yemirairo "Mazita Akatsanangurwa" uye tinya pane chinhu "Isa zita" pane ino panhi.
2. Mumutsara we "Zita" tinopinda, semuenzaniso, "Zuva_revhiki".
3. Mumutsara we "Region" tinosiya zvigadziriso zvose zvisina kuchinjwa.
4. Mumutsara "Range" pinda ={1;2;3;4;5;6;7}.
5. Dzvanya pane "OK" chinhu.
6. Ready! Zvino, kana tikasarudza masero manomwe akachinjika, tinonyora =Zuva revhiki mumutsara wemafomula uye tinya "CTRL + SHIFT + ENTER", ipapo nzvimbo yakasarudzwa ichazadzwa nenhamba kubva kune imwe kusvika kune manomwe.

Kutumidza Range

Kupa zita kune ruzhinji rwemasero hakuna kuoma. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza huwandu hunodiwa hwezvikamu.
2. Isu tinotamira kune "Formulas" chikamu. Isu tinowana block yemirairo "Mazita Akatsanangurwa" uye tinya pane chinhu "Gadzira kubva pakusarudza" pane ino panhi.
3. Tinotarisa kuti cheki chakatarisana ne "Mumutsara uri pamusoro."
4. Tinya pa "OK".
5. Nerubatsiro rweagara ajaira "Maneja Wezita", unogona kutarisa kurongeka kwezita.

Naming Tables

Iwe unogona zvakare kupa mazita kune tabular data. Aya ndiwo matafura akagadzirwa nerubatsiro rwemanipulations anoitwa nenzira inotevera: Isa/Matafura/Tafura. Iyo spreadsheet processor inovapa iwo akajairika mazita (Tafura1, Tafura2, zvichingodaro). Unogona kugadzirisa zita racho uchishandisa Tafura Inovaka. Iro zita retafura harigone kudzimwa neimwe nzira kunyangwe kuburikidza ne "Zita Maneja". Zita riripo kusvika tafura pachayo yadonha. Ngatitarisei muenzaniso mudiki wemaitiro ekushandisa zita retafura:

1. Semuenzaniso, tine ndiro ine makoramu maviri: Chigadzirwa uye Mutengo. Kunze kwetafura, tanga kuisa fomula: =SUM(Tafura1[mutengo]).
2. Pane imwe nguva mukupinza, spreadsheet ichaita kuti usarudze zita retafura.

3. Tapedza kupinda =SUM(Tafura1[, Iyo purogiramu ichaita kuti usarudze nzvimbo. Dzvanya "Mutengo".

4. Muchigumisiro chekupedzisira, takawana mari mu "Cost" column.

Mitemo yeSintakisi yemazita

Iro zita rinofanirwa kuenderana neinotevera syntactic mitemo:

• Mavambo anogona kungova vara, chidimbu, kana kuti underscore. Nhamba uye mamwe mavara akakosha hazvibvumidzwe.
• Nzvimbo hadzigone kushandiswa muzita. Vanogona kutsiviwa nemhando ye underscore.
• Zita harigone kutsanangurwa sekero yesero. Mune mamwe mazwi, hazvibvumirwi kushandisa "B3: C4" muzita.
• Hurefu hwemusoro wezita ndeye 255 mavara.
• Zita racho rinofanira kunge rakasiyana mufaira. Zvakakosha kunzwisisa kuti mavara mamwechete akanyorwa nemavara makuru nemadiki anotsanangurwa seakafanana nespredishiti processor. Semuenzaniso, "mhoroi" uye "mhoro" ndiro zita rimwe chete.

Kutsvaga nekutarisa mazita anotsanangurwa mubhuku

Pane nzira dzakati wandei dzekuwana nekutarisa mazita mune rimwe gwaro. Nzira yekutanga inosanganisira kushandisa "Name Manager" iri muchikamu che "Defined Names" chechikamu che "Formulas". Pano unogona kuona kukosha, makomendi, uye kuronga. Yechipiri nzira inosanganisira kushandiswa kweinotevera algorithm yezviito:

1. Isu tinotamira kune "Formulas" chikamu.
2. Enda ku "Defined Names" block
3. Dzvanya pakanzi "Shandisa mafomula".
4. Dzvanya "Isa Mazita".
5. Hwindo rakanzi "Isa Zita" rinoonekwa pachiratidziri. Dzvanya "All Names". Iyo skrini icharatidza ese anowanikwa mazita mugwaro pamwe chete nerenji.

Nzira yechitatu inosanganisira kushandisa "F5" kiyi. Kudzvanya kiyi iyi kunomutsa chishandiso cheJump, chinokutendera kuti ufambe uchienda kumaseru ane mazita kana maseru.

Name Scope

Zita rimwe nerimwe rine nzvimbo yaro. Nzvimbo yacho inogona kunge iri pepa rekushanda kana gwaro rose zvaro. Iyi parameter yakaiswa muhwindo rinonzi "Gadzira zita", iro riri mu "Defined names" block ye "Formulas" chikamu.

mhedziso

Excel inopa vashandisi nhamba hombe yesarudzo dzekutumidza sero kana huwandu hwemasero, kuitira kuti munhu wese asarudze nzira iri nyore yekupa zita kana uchishanda muspredishiti.