स्टाफ वर्क शेड्यूल Step-by-Step: Date | Staff Name | Time Slot | Duty Dropdown: Data Validation (Shift 1, Shift 2…) Conditional Formatting → Same Shift highlight Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=
स्टूडेंट डेटाबेस Step-by-Step: टेबल: Roll No | Name | DOB | Class | Phone | Address Filters → Class Wise View VLOOKUP या INDEX+MATCH → Search Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=
GST कैलकुलेशन Step-by-Step: Table: Item | Qty | Rate | Amount | CGST | SGST | Net Total Amount = Qty * Rate CGST = Amount × 9% SGST =…
सैलरी शीट (Salary Sheet) Step-by-Step: टेबल: nginxCopyEditEmp ID | Name | Basic | HRA | DA | Deduction | Net Salary Net Salary:=Basic + HRA + DA - Deduction Lock…
अटेंडेंस शीट (Attendance Sheet) Step-by-Step: Left में Students के नाम। ऊपर Row में Dates: mathematicaCopyEditName | 1-July | 2-July | 3-July | ... | Total Present "P", "A" डालें। COUNTIF:=COUNTIF(B2:AF2,"P")…
स्मॉल डेटा एंट्री शीट Step-by-Step: टेबल: lessCopyEditID | Name | Address | Phone | Email Use → Ctrl + T to make table. Phone validation:Data → Data Validation → Number…
स्टूडेंट रिपोर्ट कार्ड (Multi Students) Step-by-Step: एक शीट में सभी छात्रों के डेटा रखें: yamlCopyEditRoll No | Name | Subject1 | Subject2 | ... | Total | Grade Conditional formatting…
रिपोर्ट कार्ड (Report Card) Step-by-Step: Heading: स्कूल का नाम + Report Card जानकारी: Student Name, Roll No, Class Subjects के कॉलम: mathematicaCopyEditMaths | Science | English | Hindi | Total…
रसीद (Receipt) Step-by-Step: Heading: “रसीद” (Receipt) कॉलम: pgsqlCopyEditReceipt No | Date | Received From | Amount | Payment Mode | Remarks नीचे Signature line जोड़ें: Receiver Name Signature A4 पेज…
बिल (Bill) Step-by-Step: Invoice जैसा ही बनाएँ। अतिरिक्त कॉलम जोड़ें: mathematicaCopyEditGST (%) | GST Amt | Net Total GST फार्मूला:=Amount*18% Net Total:=Amount + GST Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=