Mashandisiro Aungaita Maitiro Maitiro Ekufambisa Mitemo Kwemazuva mu Excel

Kuwedzera mafomu ekugadzirisa kune imwe sero muExcel inokubvumira kushandisa maitiro akasiyana-siyana ekufambisa, zvakadai semuvara, kana data iri mumasekero inosangana nemitemo yawakagadza.

Kuita kushandisa kushandiswa kwekugadzirisa mafaira nyore nyore kune zvakagara zvarongwa zvinoshandiswa zviripo izvo zvinowanzoshandiswa mumamiriro ezvinhu, zvakadai se:

• Dates
• Duplicate data
• Mitemo iri kumusoro kana pasi pevhareji inokosha mumasero akawanda

Mune misi yezvisikwa, zvisarudzo zvinotanga kushandiswa zvinoita kuti zvive nyore kutarisa deta yako yemazuva ari pedyo nezuva ranhasi, sezuro, mangwana, vhiki rakapera kana mwedzi unotevera.

Kana iwe uchida kutarisa mazuva anowira kunze kwezvakanyorwa zvarongwa, zvisinei, iwe unogona kugadzirisa mafomatiro akadai nokuwedzera yako purogiramu uchishandisa rimwe kana kupfuura mamwe mabasa ezuva reExcel.

01 of 06

Kutarisa Kwemazuva 30, 60, uye 90 Mazuva Akawedzerwa

Kugadzirisa mafomu ekugadzirisa maitiro uchishandura kunoitwa nekuisa mutemo mutsva uyo Excel unotevera kana uchitarisa deta iri muchitokisi.

Muenzaniso wedanho netsoka pano unogadzirisa mitemo mitatu yemitemo yakagadziridzwa iyo inotarisa kuti ione kana zuva rakapinda mumakamuri masarudzo akasarudzwa apfuura mazuva makumi matatu, mazuva makumi matanhatu apfuura, kana mazuva makumi mapfumbamwe apfuura.

Nzira dzinoshandiswa mumitemo iyi dzinobvisa imwe nhamba yemazuva kubva panguva yazvino iri mumasero C1 kusvika C4.

Zuva ranhasi rinotaridzika uchishandisa MAZUVA ezuva.

Nokuda kweikudzidzisa iyi kushanda iwe unofanirwa kupinda mazuva anowira mukati memiganhu yakanyorwa pamusoro apa.

Cherechedza : Excel inoshandiswa mamiriro ezvinhu zvakagadzirirwa mune zvakarongeka, kumusoro kusvika pasi, kuti mitemo yakanyorwa muGwaro reMitemo yekuGadzira Mutemo webhokisi rebhokisi sezvinoonekwa mumufananidzo uri pamusoro.

Kunyange zvazvo mitemo yakawanda inogona kushandiswa kune mamwe masero, mutemo wekutanga unosangana nemamiriro ezvinhu unoshandiswa kumasero.

02 of 06

Kuchengetedza Kwemazuva 30 Mazuva Akare Akaitika

1. Simbisai masero C1 kusvika C4 kuti muvasarudze. Iyi ndiyo mhando yatinoshandisa nayo mitemo yekugadzirisa mafaira
2. Dzvanya paImba yebhu ye menu yebhoni .
3. Dzvanya mufananidzo weChimiro chekugadziridza kuti uzarure menyu inodonha.
4. Sarudza Mutemo Wutsva. Izvi zvinovhura iyo New Formatting Rule dialog box.
5. Dzvanya Kushandisa Mutemo kuti uone kuti masero anogadzirisa sei sarudzo.
6. Isa inotevera inomira mubhokisi riri pasi apa Mafomu ekufambisa uko ikoku kwechokwadi ndeyechokwadi pane chikamu chepakati chebhokisi rebhokisi:
   = Nhasi () - C1> 30
   Iyi fomu inotarisa kuona kana mazuva acho mumasero C1 kusvika C4 anopfuura mazuva makumi matatu apfuura
7. Dzvanya bhiiyo Fomu kuti uzarure maBhokisi eDaiti maBhokisi.
8. Dzadzazazazazadza tab kuti uone maruva anozadza mavara mavara.
9. Sarudza mutsara wakazadza-kuti uenzane nemuenzaniso mune iyi tutori, sarudza chiedza chemavara.
10. Dzvanya muTepa yeTesita kuti uone zvasarudzo zvepafaira
11. Pasi pechikamu chemuvara, shandisa marudzi epavara kuchena kuti uenzane nemudzidzi uyu.
12. Dzvanya OK kechipiri kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
13. Mucherechedzo wemasero eC1 kusvika kuC4 huchashandura kusvika muvaraza wakazara wakasarudzwa, kunyange zvazvo pasina deta mumasero.

03 of 06

Kuwedzera Mutemo Kwemazuva Mazuva Anopfuura makumi matanhatu Akapfuura

Kushandisa Mutemo Wemitemo Option

Panzvimbo pokudzokorora matanho ose ari kumusoro kuti uwedzere mitemo miviri inotevera, tichashandisa Kushandisa Mitemo chisarudzo chichaita kuti tiwedzere mitemo yakawedzerwa kamwechete.

1. Simbisai masero C1 kusvika C4, kana zvichifanira.
2. Dzvanya paImba yebhu yeribhoni menu.
3. Dzvanya paChirongwa chekuumba Zvigadziro kuti uzarure menyu inodonha.
4. Sarudza Mutemo Wemitemo sarudzo yekuzarura Mutemo Wemitemo yeMitemo yeMagetsi yebhokisi rebhokisi.
5. Dzvanya paNew Rule sarudzo muhope yepamusoro yebhokisi rebhokisi
6. Dzvanya Kushandisa Mutemo kuti uone kuti masero chii kuenzanisira sarudzo kubva pane urongwa uri pamusoro pebhokisi rebhokisi.
7. Isa inotevera inomira mubhokisi riri pasi apa Mafomu ekufambisa uko ikoku kwechokwadi ndeyechokwadi pane chikamu chepakati chebhokisi rebhokisi :
   = Nhasi () - C1> 60

   Iyi fomu inotarisa kuona kana mazuva acho ari masero C1 kusvika C4 anopfuura makumi matanhatu apfuura.

8. Dzvanya bhiiyo Fomu kuti uzarure maBhokisi eDaiti maBhokisi.
9. Dzadzazazazazadza tab kuti uone maruva anozadza mavara mavara.
10. Sarudza ruvara rwemuvara wakazara; kuti uenzane nemuenzaniso mune iyi tutori, sarudza tsvuku.
11. Dzvanya OK pane kaviri kuti uvhare bhokisi rebhokisi uye dzokera kuDhipatimendi reMitemo yeMitemo yeMabhuku Gwaro rebhokisi.

04 of 06

Kuwedzera Mutemo Kwemazuva Mazuva Anopfuura makumi mana akapfuura

1. Dzokorora matanho 5 kusvika ku7 kumusoro kuti uwedzere mutemo mutsva.
2. Pamusoro pemashandisi ekushandisa:
   = Nhasi () - C1> 90
3. Sarudza ruvara rwemuvara wakazara; kuti uenzane nemuenzaniso mune iyi tutori, sarudza orange.
4. Isa mutsara wepeti kuchena kuti uenzane neyikudzidzisa.
5. Dzvanya OK pane kaviri kuti uvhare bhokisi rebhokisi uye dzokera kuDhipatimendi reMitemo yeMitemo yeMabhuku Gwaro rebhokisi
6. Dzvanya OK zvakare kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda .
7. Mucherechedzo wemasero eC1 kusvika kuC4 huchashandura kusvika pakuzadzwa kwemavara akasarudzwa.

05 of 06

Kuedza Mitezo yeMitemo yeMitemo

Sezvo zvinogona kuonekwa mumufananidzo wekudzidzisa, tinogona kuedza mitemo yekugadzirisa maitiro mumasero C1 kusvika kuC4 nekupinda mumazuva anotevera:

• Zuva ranhasi-sero rinofanira kuchinja kune zvisikwa zvitsvene zvakasvibiswa nemashoko matsvuku, sezvo pasina mitemo yekugadzirisa maitiro inoshandiswa.
• Mazuva makumi mana zuva risati rapera-sero rinofanira kuchinja kune chitubu chemavara nemuchena mavara.
  
  (Cherechedza: Kana uri nechinetso chekuverenga zuva rakadaro, sezvinoratidzwa mumufananidzo uri pamusoro, chirevo = MAZUVA () - 40 achapinda zuva racho mazuva makumi mana asati apera zuva ranhasi.)
• Mazuva makumi manomwe isati yasvika zuva rekuti-sero inofanira kuchinja kune ruvara rwemutsvuku nemagwaro akachena.
• Mazuva zana tisati tasvika zuva rekuti-sero inofanira kuchinja kumusi mutsvuku mutsvuku nemagwaro akachena.

06 of 06

Zvimwe Mamiriro Ezvakanyorwa Zvinyorwa

Kana pepa rako rekushandisa rave richiratidzira zuva razvino-uye mafirimu akawanda anoita-imwe nzira yepamusoro kune avo vari kumusoro inogona kushandisa sero rinoreva sero iyo zuva razvino riri kuratidzirwa pane kushandisa SODA basa.

Somuenzaniso, kana zuva racho rakataridzirwa muchitokisi B4, chirevo chacho chakapinda sechirevo chekuita maitiro emamiriro ezvinhu anopfuura mazuva makumi matatu apfuura nokuti angave:

= $ B $ 4> 30

Dhora rinoratidza zviratidzo ($) rakakomberedza sero rinoreva B4 rinodzivirira kushandiswa kwesero kubva pakuchinja kana mutemo wekugadzirisa maitiro kunyopirwa kune mamwe masero mupepa rekushanda.

Zviratidzo zvemadhora zvinogadzira izvo zvinonzi se absolute seferensi .

Kana dhodhi zviratidzo zvisingabvumirwi uye mutemo wekugadzirisa maitiro wakakopiwa, sero rekuenda kana masero zvingangodaro inoratidza #REF! error message.