Hanya mai sauƙi
Zaɓi kewayon tare da kwanakin akan takardar kuma zaɓi akan shafin Gida - Tsarin Yanayi - Dokokin Zaɓin Cell - Kwanan wata (Gida - Tsarin Yanayi - Haskaka Dokokin Wayoyin salula - Kwanan Watan da ke faruwa). A cikin taga da ke buɗewa, zaɓi zaɓin hasken da ake so daga jerin abubuwan da aka saukar:
Wuya amma kyakkyawar hanya
Yanzu bari mu bincika matsalar mafi wuya kuma mafi ban sha'awa. A ce muna da babban tebur wadata na wasu kayayyaki:
Da fatan za a lura da ranar jigilar kaya. Idan a baya ne, to an riga an kawo kayan - ba lallai ne ku damu ba. Idan ya kasance a nan gaba, to dole ne mu kiyaye batun a karkashin iko kuma kar a manta da tsara bayarwa ta kwanan wata da aka ƙayyade. Kuma a ƙarshe, idan ranar jigilar kaya ta zo daidai da yau, to kuna buƙatar sauke komai kuma ku magance wannan rukunin musamman a wannan lokacin (mafi fifikon fifiko).
Don bayyanawa, zaku iya saita ƙa'idodin tsara sharuɗɗa guda uku don cika layin gaba ɗaya ta atomatik tare da bayanan tsari cikin launuka daban-daban dangane da ranar jigilar kaya. Don yin wannan, zaɓi tebur gaba ɗaya (ba tare da kai ba) kuma zaɓi kan shafin Gida - Tsarin Yanayi - Ƙirƙiri Doka (Gida - Tsarin Sharadi - Ƙirƙiri Doka). A cikin taga da ke buɗewa, saita nau'in ƙa'ida ta ƙarshe Yi amfani da dabara don tantance waɗanne sel don tsarawa (Yi amfani da dabara don tantance tantanin halitta don tsarawa) kuma shigar da dabara mai zuwa a cikin filin:
Wannan dabarar tana ɗaukar abubuwan da ke cikin sel E5, E6, E7… a jere daga ginshiƙin kwanan jirgi kuma tana kwatanta wannan kwanan wata da kwanan wata a cikin tantanin halitta C2. Idan kwanan watan jigilar kaya ya riga ya wuce yau, to jigilar kaya ya riga ya faru. Yi la'akari da alamun dala da ake amfani da su don daidaita hanyoyin haɗin gwiwa. Maganar $C$2 dole ne ya zama cikakke - tare da alamun dala biyu. Maganar tantanin farko na ginshiƙi tare da kwanan watan jigilar kaya yakamata ya kasance tare da gyara ginshiƙi kawai, amma ba jere ba, watau $ E5.
Bayan shigar da dabara, za ka iya saita cika da font launi ta danna maballin tsarin (Format) sannan a yi amfani da dokar mu ta danna maballin OK. Sa'an nan kuma sake maimaita tsarin don duba abubuwan da aka kawo da kuma isarwa na gaba na ranar da ake ciki. Don batches da aka aika, alal misali, zaku iya zaɓar launin toka, don umarni na gaba - kore, kuma na yau - ja na gaggawa:
Maimakon kwanan wata na yanzu, zaka iya saka aikin cikin cell C2 TODAY (YAU), wanda zai sabunta kwanan wata a duk lokacin da aka buɗe fayil ɗin, wanda zai sabunta launuka ta atomatik a cikin tebur.
Idan irin wannan hasken ba koyaushe ake buƙata ba, amma kawai don wani lokaci na aiki tare da tebur, to, zaku iya ƙara nau'in canzawa zuwa abin da aka riga aka yi. Don yin wannan, buɗe shafin developer (Mai haɓakawa). Idan ba a gani ba, sai a fara kunna shi Fayil - Zaɓuɓɓuka - Keɓance Ribbon Kuma danna Saka (Saka):
A cikin jerin kayan aikin da ke buɗewa, zaɓi Akwati (Checkbox) daga saman saitin Gudanar da tsari kuma danna wurin da ke kan takardar inda kake son sanya shi. Sannan zaku iya saita girman rubutun kuma canza rubutun (danna-dama - Canja rubutu):
Yanzu, don amfani da akwatin rajistan don kunna haske ko kashewa, kuna buƙatar haɗa shi zuwa kowane tantanin halitta akan takardar. Danna-dama akan akwati da aka zana kuma zaɓi umarni daga menu na mahallin Tsarin Abu (Format Abu) sannan a cikin taga da ke buɗewa, saita kowane tantanin halitta mai dacewa a cikin filin Sadarwar salula (Hanyar salula):
Duba yadda komai ke aiki. Tantanin halitta mai alaƙa E2 yakamata ya fitar da GASKIYA lokacin da aka kunna akwati, ko KARYA lokacin da aka kashe.
Yanzu ya rage don ƙara ƙa'ida ɗaya zuwa tsarin yanayin yanayi domin akwatin bincikenmu ya kunna da kashe kwanan wata. Zaɓi teburin mu gabaɗaya (ban da taken) kuma buɗe shi a cikin shafin Gida - Tsarin Yanayi - Sarrafa Dokoki (Gida - Tsarin Sharadi - Sarrafa Dokoki). A cikin taga da ke buɗewa, dokokin da muka ƙirƙira a baya don haskaka kwanan baya, na gaba da na yanzu a cikin launuka daban-daban yakamata su kasance a bayyane a sarari:
Danna maɓallin Ƙirƙiri Doka (Sabon Doka), zaɓi nau'in ƙa'ida ta ƙarshe Yi amfani da dabara don tantance waɗanne sel don tsarawa (Yi amfani da dabara don tantance tantanin halitta don tsarawa) kuma shigar da dabara mai zuwa a cikin filin:
Ba mu saita tsarin kuma danna OK. Ya kamata a ƙara ƙa'idar da aka ƙirƙira zuwa jeri na gaba ɗaya. Yanzu kuna buƙatar ɗaga shi zuwa layin farko tare da kibiyoyi (idan ba a can ba) kuma kunna akwatin rajistan da ke gabansa a dama. Dakata idan gaskiya ne (Dakata Idan Gaskiya ne):
Siga tare da m suna Dakata idan gaskiya ne yana yin abu mai sauƙi: idan dokar da ta tsaya akai gaskiya ce (watau tutar mu Haskakawa tsarin lokaci a kan takardar an kashe), sannan Microsoft Excel ya dakatar da aiwatar da ƙa'idodin, watau baya ci gaba zuwa ƙa'idodi na gaba a cikin tsarin tsara yanayin kuma baya ambaliya tebur. Wanda shine abin da ake bukata.
- Tsarin yanayi a cikin Excel 2007-2013 (bidiyo)
- Layukan tebur mai ratsin zebra
- Yadda Excel a zahiri ke aiki tare da kwanaki da lokuta