Yadda za a yi amfani da Dokokin Tsarin Yanayi na Yanki na Yanki a cikin Excel

Ƙara yanayin tsarawa zuwa tantanin halitta a cikin Excel ba ka damar amfani da zaɓuɓɓukan tsari daban-daban, kamar launi, lokacin da bayanai a cikin tantanin halitta sun haɗu da yanayin da ka saita.

Don yin amfani da sauƙaƙƙin yanayin yanayin ƙwaƙwalwar akwai samfuran da aka riga aka saita wanda ke rufe lokuttan da aka yi amfani da su, kamar:

• Dates
• Duplicate data
• Darajar sama ko ƙasa da matsakaicin adadi a cikin kewayon sel

A cikin kwanakin kwanakin, zaɓuɓɓukan da aka riga aka saita zai sauƙaƙe don duba bayanan ku don kwanakin kusa da kwanan wata, kamar jiya, gobe, makon da ya gabata ko wata mai zuwa.

Idan kana so ka duba kwanakin da suka fadi a waje da zaɓuɓɓukan da aka zaɓa, duk da haka, zaku iya siffanta tsarin tsarawa ta hanyar ƙara nauyin da kuka yi amfani da ɗaya ko fiye na ayyukan kwanakin Excel.

01 na 06

Binciken kwanaki 30, 60, da 90 da suka gabata

Ana tsara tsarin tsara yanayin ta amfani da matakai ta hanyar kafa sabuwar doka wanda Excel ke biyo bayan yin nazarin bayanai a cikin tantanin halitta.

Misali na gaba daya a nan ya kafa dokoki uku na tsari na yanayin da zasu bincika idan kwanakin da aka shiga cikin jinsunan da aka zaba sun wuce kwanaki 30, kwanaki 60 da suka gabata, ko kwanaki 90 da suka gabata.

Tsarin da aka yi amfani da su a cikin waɗannan dokoki suna cire wasu kwanakin daga kwanan nan a cikin kwayoyin C1 zuwa C4.

An ƙayyade kwanan wata ta amfani da aikin yau da kullum .

Don wannan koyaswa don aiki dole ne ka shigar da kwanakin da suka fada cikin sigogi da aka jera a sama.

Lura : Excel yana aiwatar da tsarin tsarawa a cikin tsari, har zuwa ƙasa, cewa an tsara dokoki a cikin akwatin zance na Kwaminis na Yanayi wanda aka gani a cikin hoton da ke sama.

Ko da yake ka'idodi masu yawa suna iya amfani da wasu kwayoyin halitta, doka ta farko da ta hadu da yanayin tana amfani da kwayoyin.

02 na 06

Ana dubawa don Dates 30 Harshen Kwanan baya

1. Karkatar da sassan C1 zuwa C4 don zaɓar su. Wannan shi ne kewayon da za mu yi amfani da ka'idojin tsara yanayin
2. Danna maɓallin shafin shafin rubutun .
3. Danna maɓallin Yanayin Yanayi don buɗe jerin zaɓuka.
4. Zaɓi zaɓi Sabuwar Dokar . Wannan yana buɗewa da akwatin maganganun Sabuwar Sanya.
5. Latsa Amfani da Formula don ƙayyade wane ɓangaren zaɓin tsarin .
6. Shigar da wannan maƙala cikin akwatin da ke ƙasa da Matsayin dabi'u inda wannan darajar zaɓin gaskiya ne a cikin rabin ƙasa na akwatin maganganu:
   = Yau () - C1> 30
   Wannan samfurin yana duba idan kwanakin a cikin kwayoyin C1 zuwa C4 sun wuce kwanaki 30 da suka gabata
7. Danna maɓallin Tsarin don buɗe akwatin maganganun Siffofin Siffar.
8. Danna Fill shafin don ganin bayanan cika launi.
9. Zaɓi samfuri mai cikawa-don daidaita misali a cikin wannan koyawa, zabi mai haske.
10. Danna maɓallin Font don ganin zaɓuɓɓukan tsarin tsarin
11. A karkashin launi launi, saita launin launi zuwa fari don daidaita wannan koyawa.
12. Danna Ya yi sau biyu don rufe akwatin maganganu kuma komawa cikin takardun aiki.
13. Sakamakon launi na sel C1 zuwa C4 zai canza zuwa launi mai launi wanda aka zaba, ko da yake babu bayanai a cikin sel.

03 na 06

Ƙara Dokar don Dates Fiye da kwanaki 60 da suka gabata

Amfani da Sarrafa Dokokin Yanki

Maimakon sake maimaita matakan da ke sama don ƙara dokoki biyu na gaba, za mu yi amfani da Zaɓin Sarrafa Dokoki wanda zai ba mu damar ƙara ƙarin dokoki a lokaci ɗaya.

1. Karkatar da sassan C1 zuwa C4, idan ya cancanta.
2. Danna kan shafin shafin shafin rubutun.
3. Danna kan maɓallin Yanayin Yanayi don buɗe jerin zaɓuka.
4. Zabi Sarrafa Sarrafa Dokokin don buɗe Magana da Magana Tsarin Magana Mai sarrafa fayil.
5. Danna maɓallin Sabuwar Dokar a cikin kusurwar hagu na akwatin maganganu
6. Latsa Amfani da Formula don ƙayyade wane ƙwayoyin don tsara tsarin daga jerin a saman akwatin maganganu.
7. Shigar da wannan maƙala cikin akwatin da ke ƙasa da Matsayin dabi'u inda wannan darajar zaɓin gaskiya ne a cikin rabin ƙasa na akwatin maganganu :
   = Yau () - C1> 60

   Wannan tsari yana duba idan kwanakin a cikin kwayoyin C1 zuwa C4 sun fi kwanaki 60 da suka wuce.

8. Danna maɓallin Tsarin don buɗe akwatin maganganun Siffofin Siffar.
9. Danna Fill shafin don ganin bayanan cika launi.
10. Zaɓi launi cika cika; don daidaita misali a wannan koyawa, zabi rawaya.
11. Danna Ya yi sau biyu don rufe akwatin maganganu kuma komawa cikin Magana na Tattaunawa na Dokokin Gudanarwa.

04 na 06

Ƙara Dokar ga Dates Fiye da kwanaki 90 da suka gabata

1. Yi maimaita matakai 5 zuwa 7 a sama don ƙara sabuwar doka.
2. Ga ma'anar amfani:
   = Yau () - C1> 90
3. Zaɓi launi cika cika; don daidaita misali a wannan koyawa, zabi orange.
4. Saita launin launi zuwa fari don daidaita wannan koyawa.
5. Danna Ya yi sau biyu don rufe akwatin maganganu kuma komawa cikin Magana na Tattaunawa na Dokokin Gudanarwa
6. Danna Ya sake don rufe wannan maganganun kuma komawa zuwa aikin aiki .
7. Sakamakon launi na sel C1 zuwa C4 zai canza zuwa ƙarancin layin da aka zaɓa.

05 na 06

Gwada Dokokin Tsarin Yanayi

Kamar yadda za a iya gani a cikin hoton koyaushe, zamu iya gwada ka'idojin yanayin yanayin cikin kwayoyin C1 zuwa C4 ta shigar da wadannan kwanakin:

• Yawan kwanan nan-tantanin salula ya kamata ya canza zuwa tsoho mai tsabta tare da rubutun baki, tun da babu wani tsarin dokokin tsarawa.
• Kwanaki 40 kafin kwanan wata-tantanin halitta ya canza zuwa wani haske mai haske kore tare da rubutu na fari.
  
  (Lura: Idan kana da matsala a kirga irin wannan kwanan wata, kamar yadda aka gani a cikin hoton da ke sama, ƙirar = Yau () - 40 za su shiga kwanakin kwanaki 40 kafin kwanan wata.)
• Kwana 70 kafin kwanan wata-tantanin halitta ya canza zuwa launin rawaya tare da rubutu na fari.
• Kwanaki 100 kafin kwanan wata-tantanin halitta ya kamata ya canza zuwa launin ja duhu tare da rubutu na fari.

06 na 06

Dokokin Sauya Maɗaukaki

Idan aikinka ya riga ya nuna alamar kwanan wata-kuma mafi yawan ayyukan rubutu-wata hanya madaidaiciya ga waɗanda ke sama zasu iya amfani da tantanin halitta zuwa tantanin halitta inda aka nuna kwanan wata a maimakon yin amfani da aikin yau.

Alal misali, idan an nuna kwanan wata a tantanin halitta B4, ƙayyadadden da aka shigar a matsayin mulkin zuwa yanayin kwanakin yanayin da ya wuce kwanaki 30 da suka wuce zai iya zama:

= $ B $ 4> 30

Alamun Dollar ($) kewaye da tantanin halitta tantanin halitta B4 ya hana ƙirar tantanin halitta daga canzawa idan an kaddamar da tsarin tsara tsarin yanayin zuwa wasu kwayoyin a cikin takardun aiki.

Ƙididdigar dollar sun haifar da abin da aka sani da cikakken tunani game da salula .

Idan an kawar da alamun dollar kuma an kwashe sararin samaniya, ma'anar mafita ko sel zai iya nuna wani #REF! saƙon kuskure.