Yadda za a yi amfani da dabarar Excel? Idan kun kasance sababbi ga duniyar Excel ko kuma kawai kuna neman haɓaka ƙwarewar ku da wannan kayan aikin, sanin dabarun yana da mahimmanci. Tare da dabarun Excel, zaku iya yin lissafi, bincika bayanai, da sarrafa ayyuka ta hanya mai sauƙi da inganci. A cikin wannan labarin, za mu koya muku duk abin da kuke bukatar ku sani Yi amfani da hanyoyin Excel kamar gwani na gaskiya. Daga ainihin dabara zuwa mafi ci gaba, kuna shirin gano duk abin da wannan kayan aiki mai ƙarfi zai iya yi muku!
- Mataki-mataki ➡️ Yadda ake amfani da dabarun Excel?
- Yadda ake amfani da dabarar Excel?
- Mataki na 1: Bude Microsoft Excel akan kwamfutarka.
- Mataki na 2: Zaɓi tantanin halitta inda kake so sakamakon dabarar ya bayyana.
- Mataki na 3: Rubuta alamar daidai (=) sannan tsarin da kake son amfani dashi. Misali, =JIMAR(A1:A5) don ƙara ƙima a cikin sel A1 zuwa A5.
- Mataki na 4: Danna maɓallin "Shigar" don ganin sakamakon dabarar a cikin tantanin da aka zaɓa.
- Mataki na 5: Don gyara dabarar data kasance, danna sau biyu tantanin halitta mai ɗauke da dabara kuma yi canje-canje masu dacewa.
- Mataki na 6: Yi amfani da ayyuka daban-daban na Excel, kamar su YAU(), COUNT() o MATSAKACI(), don yin takamaiman ƙididdiga.
- Mataki na 7: Koyi yadda ake amfani da cikakku (tare da alamar $) da ma'anar tantanin halitta na dangi, don haka tsarin ku na nade daidai lokacin da aka kwafi zuwa wasu sel.
Tambaya da Amsa
1. Yaya ake amfani da ƙa'idodin asali a cikin Excel?
- Rubuta alamar daidai (=) a cikin tantanin halitta inda kake son sakamakon ya bayyana.
- Rubuta dabarar da ake so, misali: * = SUM(A1:A10) *.
- Danna Shigar don ganin sakamakon.
2. Yadda ake kwafi formulas a Excel?
- Zaɓi tantanin halitta wanda ya ƙunshi dabarar da kuke son kwafa.
- Sanya siginan kwamfuta a kan ƙananan kusurwar dama na tantanin halitta da aka zaɓa har sai siginan crosshair ya bayyana.
- Ja ƙasa ko gefe don kwafi dabarar zuwa wasu sel.
3. Yadda ake amfani da ayyukan bincike a cikin Excel?
- Buga aikin nema, misali: * = VLOOKUP(B2,A2:D20,4,KARYA)*.
- Yana ƙayyadaddun hujjoji na aikin, kamar kewayon bayanai da ƙimar da za a nema.
- Danna Shigar don ganin sakamakon binciken.
4. Yadda ake amfani da dabarun sharaɗi a cikin Excel?
- Rubuta dabarar da ake so, misali: * =IF(C2>10,»An wuce»,»Ba a yi nasara ba») *.
- Yana ƙayyade yanayin da ƙimar da za a nunawa idan yanayin ya cika ko a'a.
- Latsa Shigar don ganin sakamakon tsarin tsari.
5. Yaya ake amfani da ƙididdiga don ƙididdige kashi a cikin Excel?
- Rubuta dabarar kashi da ake so, misali: * = B2*10% *.
- Sauya "B2" tare da tantanin halitta wanda ya ƙunshi lambar da kuke son ƙididdige yawan adadin.
- Danna Shigar don ganin sakamakon lissafin kashi.
6. Yaya za a yi amfani da ƙididdiga don ƙididdige ƙididdiga a cikin Excel?
- Rubuta dabarar don lissafta matsakaici, misali: * = MASIRA(B2:B20) *.
- Ƙayyade kewayon sel waɗanda kuke son ƙididdige matsakaici don su.
- Danna Shigar don ganin sakamakon matsakaicin lissafin.
7. Yadda ake amfani da dabara don ƙarawa a cikin Excel?
- Rubuta dabarar jimlar, misali: * = SUM(B2:B10) *.
- Ƙayyade kewayon sel da kuke son ƙarawa.
- Danna Shigar don ganin sakamakon ƙari.
8. Yaya ake amfani da dabara don cirewa a cikin Excel?
- Rubuta dabarar ragi, misali: * = B2-B3 *.
- Ƙayyade sel ɗin da kuke son cirewa daga juna.
- Danna Shigar don ganin sakamakon ragi.
9. Yadda za a yi amfani da ninka-yawa da tsarin rarrabawa a cikin Excel?
- Rubuta dabarar don ninkawa, misali: * = B2*B3 *.
- Ƙayyade sel ɗin da kuke son haɓaka tare.
- Danna Shigar don ganin sakamakon yawaitar.
10. Yadda ake amfani da formulas don lissafin sha'awa a cikin Excel?
- Rubuta dabara don lissafin riba, misali: * = BIYAYYA (B2/12,24, B3) *.
- Yana ƙayyade ƙimar da ake buƙata don ƙididdige riba, kamar ƙimar riba, adadin lokuta, da ƙimar yanzu.
- Danna Shigar don ganin sakamakon lissafin sha'awa.
Ni Sebastián Vidal, injiniyan kwamfuta mai sha'awar fasaha da DIY. Bugu da ƙari, ni ne mahaliccin tecnobits.com, inda nake raba koyaswar don sa fasaha ta fi dacewa da fahimtar kowa ga kowa.