Ayyuka sharuddan a cikin Excel Suna iya zama kayan aiki mai amfani sosai lokacin aiki tare da shirin maƙunsar rubutu na Microsoft. Zai iya taimaka mana, alal misali, don gano alamu ko abubuwan da ke faruwa a cikin maƙunsar rubutu ta hanyar gani sosai.
Excel Yana ba mu damar yin lissafin bisa wani yanayi wanda dole ne a cika shi. Wannan hanya ce mai amfani don yin lissafin mafi sassauƙa da daidaitawa. Duk waɗannan na iya zama ɗan ƙaramin abu, amma an fi fahimtar shi idan aka kwatanta da misalai. A lokacin ne za mu gano ainihin yuwuwar ayyuka na sharadi.
El Excel yanayin tsarawa Yana da matukar amfani lokacin yin nazari na gani na bayanan. Ana haskaka sel ta ma'aunin launi, sandunan bayanai, da gumaka. Amma duk wannan ba kawai kayan ado ba ne, a fili, amma hanya ce ta sauƙaƙe gano alamu, yanayin, da kuma matsaloli.
Kafin mu shiga cikin batun, mun ɗan yi bayanin yadda ake amfani da tsarin sharaɗi a cikin ɗiyar lissafi. Da farko, dole ne mu zaɓi sel ɗin da muke son yin amfani da wannan tsari. Don yin haka, bari mu fara "Fara", sai mu zabi group "Salo" kuma a can mu danna kan tsarin da aka tsara, zabar ɗaya daga cikin da yawa da ke akwai.
"IF" aiki
Sharuɗɗan Excel sun dogara ne akan IF aiki, wanda ke ba mu damar yin kwatancen ma'ana tsakanin ƙima da sakamako. Kamar koyaushe, yana da sauƙin fahimtar kowane ra'ayi na Excel ta hanyar a amfani fiye da ma'anar fasaha na yau da kullum. Haka lamarin yake. Bari mu kalli tebur mai zuwa:
A cikin wannan misalin misalin, mun gani Aikace-aikace mai amfani na aikin IF na Excel: A shafi na B muna ganin jerin adadin da aka tsara don aiwatarwa, alal misali, jerin ayyuka. A gefe guda, shafi na C yana nuna abin da aka kashe a ƙarshe akan kowane ɗayan waɗannan ayyukan. Ta yin amfani da aikin IF za mu iya ƙayyade ko ainihin adadin ya wuce adadin da aka tsara da kuma abin da za a yi da bambanci. Ma'anar wannan aikin shine:
=SI(C2>B2;"Mai kasafin kuɗi da ya wuce";"A cikin kasafin kuɗi")
Muhimmi: A duk lokacin da muka yi amfani da rubutu a cikin tsarin mu, dole ne mu rubuta rubutun a cikin ƙididdiga, ban da amfani da GASKIYA ko KARYA, wanda aka riga an haɗa shi a cikin Excel.
Tantanin halitta inda muke amfani da dabara shine D2, wanda a cikinsa muke son sakamakon da ya dace ya bayyana. Amma idan muna so a aiwatar da lissafin bambancin kuma an nuna shi a wani wuri na tebur (misali, a cikin E2), za mu yi amfani da wannan aikin:
=SI(C2>B2;C2-B2;0)
Ana karanta wannan kamar haka: IF (ainihin adadin C2 ya fi girma a cikin kasafin kuɗi a B'; to dole ne a cire adadin B2 da aka tsara daga ainihin adadin C'; in ba haka ba, ba a dawo da komai ba).
Har ila yau, dole ne a faɗi cewa, kodayake Excel yana ba mu wasu ayyuka masu ban sha'awa ta hanyar tsoho (SUMIF, COUNTIF, da dai sauransu), kowane mai amfani zai iya ƙirƙirar aiki mai mahimmanci daga aikin IF.
Hakanan ya kamata a lura cewa Excel yana ba mu damar yin amfani da shi hade sharuddaninda dole ne a cika sharuɗɗa biyu ko fiye. Ana bayyana ma'anar waɗannan lokuta ta hanyar amfani da aikin AND. Za mu bayyana shi kamar haka, muna bin misalin da ya gabata tare da alkalumman da aka ɗauka bazuwar:
=SI(Y(C2=1>1oooo);C2-B2;0)
Yadda ake bayyana sharadi a cikin Excel
Muna yin bita a ƙasa nau'ikan ayyuka na sharadi daban-daban waɗanda za mu iya amfani da su a cikin maƙunsar rubutu na Excel: don haskaka sel, don manyan ƙima da ƙananan ƙima, sandunan bayanai, ma'aunin launi, da saitin gumaka.
haskaka Kwayoyin
A cikin maballin Tsarin Yanayi na Excel, mun fara samun zaɓi don Dokoki don haskaka sel, a cikin abin da za mu iya amfani da launi daban-daban, shaci da nau'in rubutu dangane da kowane hali:
- Ya fi.
- Yana da ƙasa da.
- Daga cikin.
- Daidai yake da.
- Rubutun ya ƙunshi.
- Kwanan wata.
- Kwafin dabi'u.
babba da ƙananan dabi'u
Shi ne zabi na biyu da muka samu a cikin Maɓallin Tsarin Yanayi. Ana amfani da shi don kafa launuka daban-daban don ƙimar tantanin halitta inda sakamakon aikin yanayin ke nunawa bisa ga wasu jeri:
- saman 10.
- kasa 10.
- 10% na ƙimar mafi girma.
- 10% ƙananan ƙima.
- Sama da matsakaici.
- Kasa matsakaici.
Sandunan bayanai da ma'aunin launi
Ana amfani da su don kafa a kwatancen gani tsakanin sel. Wannan zaɓi yana ba mu damar yin wasa tare da launuka da salo na sandunan bayanai, kamar yadda aka nuna a hoton da ke sama (a hannun dama). Magani ne mai tasiri sosai kuma yana ƙara ƙaya da ƙari ga maƙunsar bayanan mu idan za mu yi amfani da shi don gabatarwa.
ikon saita
Zaɓin ƙarshe wanda da shi zaku iya tsarawa daga jeri uku zuwa biyar na ƙima, sanya kowane ɗayan su takamaiman gunki. Baya ga kiban kibau na sama ko ƙasa, muna kuma da wasu gumaka waɗanda ke wakiltar siffofi, alamomi da alamun ƙima.