Category: MS EXCEL LAB MANUAL

टू डू लिस्ट (To Do List)

Step-by-Step:

1. Task Name | Due Date | Priority | Status
2. Developer Tab → Insert Checkbox
3. Conditional Format if Status = Done
4. Sort by Due Date

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=

टाइम टेबल

Step-by-Step:

1. Left Column: Days
2. Top Row: Periods
3. Table Fill करें (Subjects)
4. Color Code by Subject
5. 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:

1. Date | Staff Name | Time Slot | Duty
2. Dropdown: Data Validation (Shift 1, Shift 2…)
3. 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:

1. टेबल: Roll No | Name | DOB | Class | Phone | Address
2. Filters → Class Wise View
3. 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:

1. Table: Item | Qty | Rate | Amount | CGST | SGST | Net Total
2. Amount = Qty * Rate
3. CGST = Amount × 9%
4. SGST = Amount × 9%
5. Net = Amount + CGST + SGST

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=

सैलरी शीट (Salary Sheet)

Step-by-Step:

1. टेबल: nginxCopyEditEmp ID | Name | Basic | HRA | DA | Deduction | Net Salary
2. Net Salary:
   =Basic + HRA + DA - Deduction
3. Lock Salary formula cells with protection।

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=

अटेंडेंस शीट (Attendance Sheet)

Step-by-Step:

1. Left में Students के नाम।
2. ऊपर Row में Dates: mathematicaCopyEditName | 1-July | 2-July | 3-July | ... | Total Present
3. “P”, “A” डालें।
4. COUNTIF:
   =COUNTIF(B2:AF2,"P")
5. Conditional Format:
   • Green = P
   • Red = A

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=

स्मॉल डेटा एंट्री शीट

Step-by-Step:

1. टेबल: lessCopyEditID | Name | Address | Phone | Email
2. Use → Ctrl + T to make table.
3. Phone validation:
   Data → Data Validation → Number only
4. Email format के लिए Custom Validation लगाएं।

स्टूडेंट रिपोर्ट कार्ड (Multi Students)

Step-by-Step:

1. एक शीट में सभी छात्रों के डेटा रखें: yamlCopyEditRoll No | Name | Subject1 | Subject2 | ... | Total | Grade
2. Conditional formatting → कम % को Red करें।
3. Data → Filter लगाएं।
4. Sheet को Print View में सजाएँ।

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=

रिपोर्ट कार्ड (Report Card)

Step-by-Step:

1. Heading: स्कूल का नाम + Report Card
2. जानकारी:
   • Student Name, Roll No, Class
3. Subjects के कॉलम: mathematicaCopyEditMaths | Science | English | Hindi | Total | % | Grade
4. Total: =SUM(B2:E2)
5. %: =F2/400*100
6. Grade (IF):
   =IF(G2>=90,"A+",IF(G2>=75,"A",...))

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=