Excel Mein Bill Kaise Banaye
Excel mein bill banana aasan hai — ek table banao, items likho, aur formulas se total khud nikalne do. Microsoft ke mutabik formula hamesha = se shuru hota hai, aur AutoSum se SUM function khud lag jata hai.
Is guide mein kya seekhoge
- Bill ka table banana
- Formulas se total nikalna
- Subtotal ke liye AutoSum use karna
1Bill ka structure banayein
Business details, customer details aur ek table.
- Excel kholein aur nayi blank workbook lein.
- Upar apne business ka naam, bill number aur date likhein.
- Neeche customer ka naam aur details likhein.
- Table ke headings likhein — Item, Quantity, Unit Price, Total.
- Data select karke Insert > Table par jayein, My table has headers tick karke OK karein.
2Formulas se total nikalein
Maths formulas ko karne dein — ek baar likhein, neeche copy karein.
- Har item ki quantity aur price likhein.
- Total wale column mein formula likhein, jaise Quantity × Unit Price, aur Enter dabayein.
- Subtotal ke liye table ke neeche wale cell mein AutoSum use karein — Home ya Formulas tab se AutoSum chunein, phir Enter dabayein.
- Tax lagana ho to subtotal ko tax rate se multiply karein, phir grand total ke liye subtotal aur tax ko jodein.
3Save aur print karein
Print karne se pehle ek baar preview dekh lein.
- File ko save karein aur print karne se pehle ek baar preview dekh lein.
💡 Pro Tip
Total wale formula ko dobara mat likhein — pehle cell ka formula neeche wale cells mein copy kar dein, Excel khud har row ke hisab se adjust kar deta hai.
Aksar pooche jaane wale sawaal
Excel mein formula kaise shuru karte hain?
Har formula = (equal sign) se shuru hota hai, phir numbers aur operators jaise +, −, * ya / aate hain.
SUM function kya karta hai?
SUM ek column ya row ke numbers ko jodta hai — jaise =SUM(A1:A2) A1 aur A2 ko jodta hai.
AutoSum kaise use karte hain?
Jitne numbers jodne hain, unke bilkul neeche wale cell ko select karo, Home ya Formulas tab se AutoSum chuno aur Enter dabao.
Excel mein table kaise banate hain?
Data likho, usmein koi ek cell select karo, Insert > Table par jao, sahi range aur My table has headers check karke OK karo.
Kya Excel mein ready-made bill template milta hai?
Microsoft Support ke page par Download free, pre-built templates ka link diya hai; template se shuru karna bhi ek option hai.