MS EXCEL LAB MANUAL

टू डू लिस्ट (To Do List) Step-by-Step: Task Name | Due Date | Priority | Status Developer Tab → Insert Checkbox Conditional Format if Status = Done Sort by Due…

टाइम टेबल Step-by-Step: Left Column: Days Top Row: Periods Table Fill करें (Subjects) Color Code by Subject Merge "Lunch Break" cell Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=

स्टाफ वर्क शेड्यूल 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=

सैलरी शीट (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…