Excel Expert Needed for Spreadsheet Creation
Budget: ₹1,500 – ₹12,500 INR
I am in need of an Excel professional who can help me create a comprehensive spreadsheet. The ideal candidate should have robust experience with Excel and deep understanding of its features and functionalities.
Key Responsibilities:
- Create an efficient and user-friendly spreadsheet.
- Implement various formulas and calculations.
- Design and incorporate charts and graphs for data visualization.
- Set up data validation rules to ensure data integrity.
- Assist with data entry.
Required Features in Excel File:
1. Smart Admission Sheet
• Auto-generate unique Student IDs
• Dropdowns for fields like Gender and Class
• Data validation to prevent duplicate entries
2. Fee Management System
• Fields for Total Fee, Fee Paid, Due Amount
• Automatically mark status as Paid, Due, or Overpaid
• Color-coded status indicators for quick visibility
3. Marks Entry Sheet
• Chapter-wise or test-wise marks entry system
• Drop-down selection for Subjects, Test numbers, and Classes
• Validation to restrict marks between 0 and full marks
4. Student Report Generator
• Automatically pull student-wise marks from entry sheet
• Calculate subject-wise averages and total performance
• Generate performance tags like Excellent, Good, Average, or Needs Improvement
• Color-coded performance (Green, Yellow, Red)
• Display student name, ID, class, subject, performance % and tag
5. Attendance Tracker
• Track daily attendance per student
• Calculate monthly attendance %
• Highlight students below 75% attendance
6. WhatsApp-Ready Report Field
• A text field auto-filled with summary that can be copied and sent via WhatsApp
• Includes marks, fee status, and attendance in a compact message
⸻
Final Deliverables:
• A fully working Excel file with all the above modules and automation
• Clear structure, formatting, and easy dropdown inputs
• Formula-driven sheets — no manual calculations required
• Optionally include charts or graphs for student performance
Ideal Skills:
- Proficient in Excel with strong spreadsheet creation skills.
- Experience with data analysis and automation with macros.
- Ability to design visually appealing and informative charts and graphs.
- Attention to detail for setting data validation rules and data entry.
Key Responsibilities:
- Create an efficient and user-friendly spreadsheet.
- Implement various formulas and calculations.
- Design and incorporate charts and graphs for data visualization.
- Set up data validation rules to ensure data integrity.
- Assist with data entry.
Required Features in Excel File:
1. Smart Admission Sheet
• Auto-generate unique Student IDs
• Dropdowns for fields like Gender and Class
• Data validation to prevent duplicate entries
2. Fee Management System
• Fields for Total Fee, Fee Paid, Due Amount
• Automatically mark status as Paid, Due, or Overpaid
• Color-coded status indicators for quick visibility
3. Marks Entry Sheet
• Chapter-wise or test-wise marks entry system
• Drop-down selection for Subjects, Test numbers, and Classes
• Validation to restrict marks between 0 and full marks
4. Student Report Generator
• Automatically pull student-wise marks from entry sheet
• Calculate subject-wise averages and total performance
• Generate performance tags like Excellent, Good, Average, or Needs Improvement
• Color-coded performance (Green, Yellow, Red)
• Display student name, ID, class, subject, performance % and tag
5. Attendance Tracker
• Track daily attendance per student
• Calculate monthly attendance %
• Highlight students below 75% attendance
6. WhatsApp-Ready Report Field
• A text field auto-filled with summary that can be copied and sent via WhatsApp
• Includes marks, fee status, and attendance in a compact message
⸻
Final Deliverables:
• A fully working Excel file with all the above modules and automation
• Clear structure, formatting, and easy dropdown inputs
• Formula-driven sheets — no manual calculations required
• Optionally include charts or graphs for student performance
Ideal Skills:
- Proficient in Excel with strong spreadsheet creation skills.
- Experience with data analysis and automation with macros.
- Ability to design visually appealing and informative charts and graphs.
- Attention to detail for setting data validation rules and data entry.