MS Excel me Bill (बिल) kaise banaye in hindi.

Welcom Guys, kya aapki koi shop hai aur aap us shop ke liye bill banana chah rahe hai. Taki koi bhi customer jab aapse koi bhi product kharide to aap use ek bill ya receipt de paye. Taki aapko prodcut ki listing aur product ke paiso ki calculation karne aur paper work me time waste na karna pade. To aaj hum aapke is kaam ko Excel me bill banana sikha kar aur bhi aasan karna batane vale hai.

Computer me bill banane ke liye hum Microsoft excel software ka use karne vale hai. Joki ek bahut hi popular Spreadsheet program hai. Jisse hum badi hi aasani se kisi bhi chija ka list & sheet format ready kar sakte hai. So guys jante hai ki kis tarike se hum computer me badi hi aasani se receipt ya bill bana sakte hai.

Excel me bill kaise banaye?

Apni dukan se saaman kharidne vale customers ko bill provide karke apne business ko professional business ki tarah show kar sakte hai. Jisse customers ka aapki shop ki aur attraction bhi aayega. Jab customer printed bill lega to unhe kis product ke upar kya rate liya gaya hai samjne me aasani hogi. To chaliye ab jante hai ki kis tarike se hum excel me bill bana sakte hai aur apne business ko new look de sakte hai. Aap chae to Bill sheet ka sample download bhi kar sakte hai. Niche humne iska link diya hai.
STEP:-1  Sabse pahle to All Program me jaye aur Microsoft Excel Open kare. Direct excel open karne ke liye aap chahe to Windows key + R press kare jisse Run open ho jayega. Usme "Excel" type karke enter kar dijiye.

STEP:-2  Excel ko open karne ke baad ab hume apni shop ke liye Excel me bill format banana start karna hai. To sabse pahle hum shop ki name ka Heading create karenge. Iske liye aap image me dekh sakte hai. Shop/Business ka name dale aur use font ki size ko badha dijiye aur font Bold kar dijiye. Jab aap Shop ka name likhenge to vo sirf ek hi cell me type hoga. Esliye aapko pas ki dusri cells ko select karna hoga aur multiple cells ko ek me Merge & Center karna hoga.

STEP:-3  Ab dusri line me hume Bill ke liye Bill No. aur date Dalna hogi. Tab Left side me Bill number aur Right Side me Date dalenge. Iske baad Ab hum bill detail ke liye niche cells me Name aur Address, Date, GST no dalenge.

STEP:-4  Ab hum Product list ke liye Serial Number, Product, Rate, Quantity, Amount ke column table create karnge. Ise aap niche image me dekh sakte hai. Saath hi hum inme Price ka calculation karne ke liye, Amount vale cell me Rate aur Quantity ka guna (multiply) karne ke liye = laga kar Price*Quantity ka formula laga denge. Formula kuch is tarah se hoga. Example:  =C7(price cell)*D7(Quantity).

Yeh formula hume Amount ke sabhi cells tak lagana hai jaha tak ki hum multiplication chahte hai. Abhi aapko amount vale columne me 0 dikhai dega kyonki abhi cells me koi value nahi hai. Jab aap koi value enter karneg to uska multiply hokar result show hoga.
STEP:-5  Ab products ki entry ke liye kuch Row ko khali rahne denge aur Product ke niche last vale cell me Total likhenge. Iske paas ke cell me hum Price ka Total karne ke liye Sum formula apply kar denge. Jisse sabhi product ki price ka Total amount nikal jayega.

Ab last me aap chahe to apni signature ke liye Cells create kar sakte hai. Jab aap sabhi product ki entry kar denge aur Excel me bill ban jayega. Tab aap bill print hone par bill me sign kar sakte hai. Iske alva aap chahe to Terms and condition yani ki beche gaye product ke liye Niyam aur sharto ka note bhi de sakte hai.

Jab excel me aapka pura ready ho jayega to kuch is tarike se dikhai dega. Jise humne upar image me bataya hai.

 Download

To dosto is tarike se Aap apne computer/laptop me Excel me bill bana sakte hai. Agar aap is Tutorial ko video ke dvara smjhana chahte hai to niche di gayi video ko dekhe.