Yadda ake amfani da Excel don lissafin kuɗi

Idan kana neman hanya mai sauƙi da inganci don ƙirƙirar daftari don kasuwancin ku, kun zo wurin da ya dace. A cikin wannan labarin, za mu koya muku yadda ake amfani da Excel ⁢ don daftari. Excel kayan aiki ne mai ƙarfi wanda zai iya sauƙaƙa tsarin lissafin kuɗi, kuma tare da matakan da suka dace, zaku iya ƙirƙirar daftarin ƙwararru cikin mintuna kaɗan. Ba kwa buƙatar zama ƙwararren masani na kwamfuta don ƙware da wannan dabarar, kawai ku bi umarninmu kuma za ku kasance a hanya don sauƙaƙe lissafin kuɗin ku da inganta hoton kamfanin ku ga abokan cinikin ku.

- Mataki-mataki ➡️ ⁢Yadda ake amfani da Excel don biyan kuɗi

• Ƙirƙiri sabon maƙunsar rubutu a cikin Excel. Bude Excel⁤ kuma zaɓi "Sabuwar Faɗakarwa" don farawa.
• Ƙirƙiri kan kai don daftari. A cikin cell A1, rubuta "Daftari" kuma a ƙarƙashinsa, ƙara bayanin mai bayarwa da abokin ciniki.
• Ƙirƙiri tebur⁤ don cikakkun bayanan daftari. A cikin jere na gaba, ƙirƙiri ginshiƙai ⁢ don bayanin, yawa, farashin ɗaya, da jimillar.
• Yi lissafin jimlar. Yi amfani da ƙididdiga don ƙididdige jimlar jimlar, haraji, da jimlar daftari.
• Ajiye daftari. Ajiye fayil ɗin tare da suna mai ma'ana, kamar "Invoice_Customer_Month_Year."
• Keɓance daftari. Ƙara tambarin kamfanin ku, canza launuka ko font don dacewa da alamar ku.
• Yi bitar daftari. Kafin ƙaddamarwa, bincika cewa duk cikakkun bayanai daidai ne kuma ƙididdiga daidai ne.
• Aika da daftar. Ƙarshe ta hanyar haɗa fayil ɗin Excel zuwa imel kuma aika shi ga abokin cinikin ku.

Tambaya da Amsa

Ta yaya zan iya ƙirƙirar daftari a cikin Excel?

1. Bude sabon takaddar Excel.
2. A jere na farko, rubuta taken daftari: lamba, kwanan wata, abokin ciniki, da sauransu.
3. A cikin layuka masu zuwa, shigar da bayanin kowane daftari.
4. Yi amfani da ƙididdiga don ƙididdige jumloli, haraji da jimillar.
5. Ajiye fayil ɗin tare da bayanin suna.

Ta yaya zan iya keɓance samfurin daftari a cikin Excel?

1. Bude samfurin daftari a cikin Excel.
2. Canja kanun labarai da launuka bisa ga fifikonku.
3. Ƙara tambarin ku ko bayanin tuntuɓar ku.
4. Ajiye samfuri tare da takamaiman suna don sauƙin shiga.

Ta yaya zan iya lissafta jimlar ta atomatik a cikin daftari a cikin Excel?

1. Shigar da farashin rukunin da adadin kowane samfur ko sabis.
2. Yi amfani da dabarar ⁤=farashi*yawa' don ƙididdige jimlar kowane abu.
3. Ƙara duk cikakkun bayanai don samun jimlar daftari.

Ta yaya zan iya ƙara haraji a cikin daftari na a cikin Excel?

1. Ƙirƙiri tantanin halitta don jimlar ⁤ ba tare da haraji ba.
2. A ninka jimlar ba tare da haraji ba bisa kaso na harajin da ake so.
3. Ƙara wannan ƙimar zuwa jimlar ba tare da haraji ba don samun jimlar tare da haraji.

Ta yaya zan iya tsara lissafin kuɗi na a cikin Excel?

1. Ƙirƙiri sabon maƙunsar rubutu don adana duk daftarin ku.
2. Tsara ginshiƙai ta lambar daftari, kwanan wata, abokin ciniki, da adadin kuɗi.
3. Yi amfani da tacewa don warware daftari ta kwanan wata, abokin ciniki, da sauransu.

Waɗanne dabaru zan iya amfani da su don ƙididdige adadin jimlar daftari a cikin Excel?

1. Yi amfani da dabara = farashin* yawa don ƙididdige jumloli na kowane abu.
2. Ƙara duk jumloli don samun jimillar daftari subtotal.

Ta yaya zan iya kare daftari na a cikin Excel don guje wa canje-canjen bazata?

1. Zaɓi sel ɗin da kuke son karewa.
2. Danna-dama kuma zaɓi "Format Cells."
3. Duba akwatin “Kulle” sannan ka kare maƙunsar bayanai da kalmar wucewa.

Ta yaya zan iya ƙara rangwame a cikin daftari na a cikin Excel?

1. Ƙirƙiri tantanin halitta don jimlar ba tare da ragi ba.
2. Rage rangwamen daga jimlar da ba a rangwame ba don samun jimillar rangwamen.
3. Aiwatar da dabara = jimla-( jimla* kashi) don ƙididdige sabon jimlar.

Ta yaya zan iya buga daftari na a cikin Excel?

1. Bude fayil ɗin daftari a cikin Excel.
2. Danna "File" kuma zaɓi "Print."
3. Zaɓi zaɓuɓɓukan bugu da ake so kuma danna "Buga."

Ta yaya zan iya aiko da daftari na imel daga Excel?

1. Bude fayil ɗin daftari a cikin Excel.
2. Danna"Fayil" kuma zaɓi "Aika ta imel".
3. Cika mahimman bayanai kuma danna "Submit."

⁤