Learn aur earn

Google Sheets basics: mobile se hisaab-kitaab aur sharing

Google Sheets free hai aur phone par bhi chalta hai. Sheet banana, formule, filter, aur team ya family ke saath share karna: dukaan ke roz ke hisaab ka example.

Sandeep Mittal 2 min read

Google Sheets basics: mobile se hisaab-kitaab aur sharing
Short mein
  • Google Sheets free hai; sirf Google (Gmail) account chahiye.
  • Sheet share karke kai log ek saath, alag phones se, likh sakte hain.
  • Har badlaav apne aap save hota hai, aur purana version wapas laaya ja sakta hai.
Is post mein
  1. 1. Nayi sheet banaiye
  2. 2. Columns tay kariye
  3. 3. Total ka formula
  4. 4. Filter aur sort
  5. 5. Share kariye, sahi permission ke saath
  6. 6. Galti ho gayi? Version history
  7. Mobile par kaam ki baatein

Google Sheets, Excel jaisa hi free spreadsheet hai jo browser aur phone app dono par chalta hai. Sabse badi khoobi: ek hi sheet par kai log alag-alag phones se ek saath kaam kar sakte hain, aur sab kuch apne aap save hota hai. Yahan dukaan ki roz ki bikri ka hisaab banana seekhte hain.

1. Nayi sheet banaiye

Computer par sheets.google.com kholiye ya phone par Google Sheets app install kariye, aur "+" (Blank) dabaiye. Upar naam dijiye, jaise "Dukaan bikri 2026".

2. Columns tay kariye

Pehli row mein: Date | Cash | UPI | Udhaar | Total. Pehli row ko mota (bold) kariye, aur View → Freeze → 1 row, taaki neeche jaane par heading dikhti rahe.

3. Total ka formula

Cell E2 mein: =B2+C2+D2 ya =SUM(B2:D2). Phir E2 ke kone ke chhote dot ko neeche kheenchiye; har row mein formula apne aap lag jaata hai. Mahine ka total: =SUM(E2:E31). (Formule ki shuruaat ke liye padhiye: Excel Day 1; Sheets mein yeh sab waise hi chalte hain.)

4. Filter aur sort

Heading row chuniye → Data → Create a filter. Ab kisi bhi column ko chhota-bada kar sakte hain, ya sirf kisi ek din ya hafte ka data dekh sakte hain.

5. Share kariye, sahi permission ke saath

  • Upar Share dabaiye aur staff ya family ka Gmail daaliye.
  • Editor: likh aur badal sakte hain (jo roz entry karta hai).
  • Viewer: sirf dekh sakte hain (jaise partner ya CA).
  • "Anyone with the link" tabhi kariye jab data mein kuch bhi nijee na ho.

6. Galti ho gayi? Version history

File → Version history → See version history. Kisi ne galti se data mita diya ho, to purana version wapas laa sakte hain.

Mobile par kaam ki baatein

  • Cell par double-tap karke likhiye; neeche "fx" se formula.
  • App mein sheet ko "Available offline" kar sakte hain; net aane par sync ho jaati hai.
  • Phone par lambi sheet ke liye pehle columns freeze kar lijiye.

Sheet mein grahakon ke phone number jaisa nijee data ho, to share sirf zaroori logon ke saath kariye.

Share karein

Comments

Be the first to comment

Comments appear after review. For advice on your own situation, please contact us directly.

Aur padhein

Excel Day 2: percentage, $ ka jaadu aur pehla chart (free mini-course)

Excel Day 2: percentage, $ ka jaadu aur pehla chart (free mini-course)

Excel Day 3: VLOOKUP, XLOOKUP aur IF, interview mein poochhe jaane wale formule

Excel Day 3: VLOOKUP, XLOOKUP aur IF, interview mein poochhe jaane wale formule

Excel Day 1: rows, columns aur pehla formula (free mini-course)

Excel Day 1: rows, columns aur pehla formula (free mini-course)