Maitiro Ekuronga nearufabheti muExcel

Nzira 1: Kurumidza Sort Buttons

Excel ine mabhatani ane mutoro wekukasira kuronga kweiyo yakatsaurwa data. Kushandisa kwavo kuchave kwakakwana mumamiriro ezvinhu aya apo masero anofanirwa kuongororwa kamwe chete, ambotaurwa zvakakodzera.

1. Bata bhatani rekuruboshwe bhatani uye sarudza ese maitiro ayo anozoenderera mberi nekugadzirisa.



2. Pamhepo tabu, vhura "kurongedza" kudonha-pasi menyu.



3. Mariri, shandisa iyo "rudzi uye kusefa" block nekusarudza iyo yekuraira iyo yaunoda kuisa tsika.



4. Kana iyo yambiro pane yekuona data kunze kwehurongwa hunoonekwa, iwe uchafanirwa kusarudza, kuwedzera kana kuronga chete mukati mekusarudzwa kwakataurwa. Funga kutanga sarudzo yekutanga.



5. Paunenge uchiishandisa, masero aipota zvichienderana neyakafanana tafura inogadziriswa pasi pehurongwa hwechinyorwa, kureva kuti uri pamberi pechitokisi "august" kukosha kweizvozvo "27", rinosara pakatarisana neshoko rimwe chete.



6. Iyi yechipiri sarudzo ndeye "simbisa mukati meiyo sarudzo yakatarwa."



7. Saka chete iwo mavara akataurwa anotamiswa, uye masero anotarisana nawo anoramba akasimba. Izvi zvinoreva kuti kudzikiswa kwedata kuchaitika kana paine kubatana pamberi pavo.

Kana iwe usati wasarudza kana iwe uchida kugadzirisa chete huwandu hwakataurwa

Nzira 2: Inogadziriswa Kugadzirisa

Yakasarudzika kurongedza inokubvumira kuti uwedzere kuwedzere kuvaka nzvimbo yezvinhu zviri patafura, yakapihwa huwandu hwakawanda uye dzakasiyana data. Kuti uzvigadzirire, menyu yakakosha inoshandiswa, iyo yatinotarisira zvakare.

1. Isu tinokurudzira pakarepo tafura yese kana kuwedzera kune iyo yekurongedza alfabheti yaunoda kuwedzera mashoma mashoma mazinga.



2. Zvadaro, muchikamu chimwe chete "kurongedza", sarudza chinhu "chinowanzogadziriswa kurongedza".



3. Mukudonha-pasi menyu "Ronga ne", taura chinyorwa chinokanganisa kurongeka.



4. Mhando ye "sero tsika" inosarudzwa semhando yerudzi.



5. Inoramba ichingoratidzira kuraira "kubva kuZ" kana "kubva kwandiri kusvika kune".



6. Kana iwe uchida kuronga uye mamwe makoramu, wedzera iwo maseru uye ita zvakafanana mamiriro.



7. Dzokera patafura uye uve nechokwadi chekuti zviito zvese zvakagadzirirwa nemazvo.

Nzira 3: Ronga formula

Zvinokuvadza zvimiro zvekare ndezvekuti ivo vanongoita chete sosi, uye vane simba tafura haichinje kana zvachinja. Kana iwe ukasafanirwa nesarudzo iyi, iwe uchazoda kuti uite maoko kugadzira formula yekugadzirisa iyo, kana uchiwedzera kana kubvisa zvinhu, zvinongozvidzokorora uye kuisa mune yaunoda kurongeka. Iyo mafomulas ichave imwe, nekuti nekure kwekuvandudza vasina kuwedzera basa rakakosha raizozviita pasina kushandisa aubetsero kuverenga. Iyo yese imwe nzira inoenderana nezvikamu akati wandei kunyatsonzwisisa musimboti wekugadzirisa maererano nearufabheti.

Nhanho 1: Kugadzira Auxileary Fomula

Basa guru nderekugadzira fomu rebetsero rinoongorora mazwi ari mumasero uye anotsanangura nhamba yavo yekutarisa mune ramangwana rakarongedzwa neyakagadziriswa mavara. Izvi zvinoitika kana zvichienzaniswa neakanyorwa excel exgorithms inoshanda pane iyo nheyo yekuongorora kuongororwa. Zvakazadziswazve kuti abvise basa remufananidzo uyu, hatizongoratidza chisikwa chayo.

1. Kuti ushande pamwe neramangwana computer, iwe uchafanirwa kuumba boka kubva kumasero, ravanoda kugoverwa uye mune imwe nzvimbo yakasarudzika yakasarudzwa kubva kumusoro yakatsvaga zita idzva.



2. Iye zvino masero emasero akasarudzwa ane zita rayo iro rine mhosva yezvirimo - kuti isu riine michero. Kana iwe ukaisa mazwi mashoma mumusoro, usaise nzvimbo, asi shandisa pasi pasi pasi pachinzvimbo: "(muenzaniso_text)."



3. Muchidimbu chitsva, isu tichagadzira formula yeakaunti, iyo inofunga cell inogutsa mamiriro acho. Senge huwandu, taura boka richangobva kugadzirwa, ipapo sero rekutanga rekuenzanisa. Semhedzisiro, iyo yekutanga mhando ye formula ndeye: = yakaverengerwa (michero; A1).



4. Iye zvino mhedzisiro yefomla iyi ichave "1"

   

5. Tambanudza formula, inonamatira kumucheto kwechitokisi, kusvika pakupera kwerunyorwa ruramangwana rekugadzirisa.



6. Dzosera iyo mhando nemapoka ari muboka - zvichave zvakakosha paunenge uchidhirowa iyo inotevera formula.

Nhanho yechipiri: Kugadzira fomu yekugadzirisa

Iyo Auxillary Formula yakagadzirira uye inoshanda nemazvo, kuti iwe ugone kuenderera mberi nekugadzira basa rekutanga, iyo ichave iri mukugadzirisa kuonga kune iripo otomatiki chinzvimbo chinongedzo.

1. Muchitokisi chitsva, tanga kupinda = kutsvaga board (tambo yekutsvaga (A1)



2. Tevere, kungowedzera anonzi marangi, enda ku "Formulas", Wedzera "Mamwe mazita" menyu uye sarudza "Shandisa" fomu fomu ".



3. Wedzera mhando neAuxileary formula uye taura "mutambo wakakwana" mabvi chiratidzo icho mune yekudonha-pasi rondedzero, iyo ichaonekwa mushure mekuwedzera ";".



4. Pedzisa kusikwa kwefomula iyo yakazviputira muIndex inoshanda iyo ichashanda nehurongwa hwemazita.



5. Tarisa uone mhedzisiro uye wobva watambanudza fomula sezvazvinoratidzwa pamusoro apa.



6. Iye zvino iwe uchagamuchira chaiyo inoshanda Dynamic rondedzero yakarongedzwa nearufabheti.

Kuti urerutsa kunzwisisa, kupatsanurwa kupatsanura fomu yakazara:

=

Nhanho 3: Modeling formula yemazita akadzokorora

Iyo chete yekudhirowa yeiyo ichangobva kugadzirwa formula ibasa risiriyo pamberi pemazita anodzokororwa aunoona pane Screenshot yakapihwa pazasi. Izvi zvinokonzerwa nenyaya yekuti basa rekubetsera harisi kugona kuita mazwi anodzokorora mazwi, saka ichafanirwa kuvandudzwa zvishoma kana iwe uchida kushandisa kudzokorora mune rondedzero.

1. Vhura iyo Auxillary formula uye bvisa chiratidzo "

   

2. Wedzera chikamu chechipiri - + kuverengerwa ($ $ 1: A1; A1), ichikubvumira kuti unyore mazwi akafanana nenzira yekutevera kazhinji.



3. Tambanudza fomula zvakare kuti yakachinja pamasero ese.



4. Wedzera zita rakatsvuka kune rondedzero kuti utarise yavo yakajairika kuratidza.