I will create custom school spreadsheets gradebooks attendance trackers and dashboards
Excel and Google Sheets Specialist,Automation and Dashboards
About this Gig
Are you tired of managing student grades, attendance and school records across messy spreadsheets that take too much time to update?
I help teachers, tutors, schools and training centers turn confusing manual records into organized, easy-to-use spreadsheet systems.
Whether you need a simple gradebook, automated attendance tracker, student record sheet or complete school dashboard, I will build a custom solution around the way you already work.
I can create:
- Custom gradebooks and grade calculators
- Daily, weekly or monthly attendance trackers
- Student record and class management sheets
- Automated averages, percentages and performance tracking
- Exam result and score sheets
- Student progress reports
- School performance dashboards
- Charts, summaries and automated calculations
Every spreadsheet is built to solve your specific workflow problem not as a one-size-fits-all template. I focus on making your system clean, accurate, easy to update and simple to use.
Available in Microsoft Excel or Google Sheets.
Send me your requirements, existing spreadsheet or sample, and I will create a solution that makes managing your school data easier and more organized.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Charts
•
Data validation
FAQ
Can you create a spreadsheet specifically for my school's system?
Yes. I build every spreadsheet around your specific workflow, including your classes, subjects, grading system, attendance method, reports and other requirements.
My current spreadsheet is confusing and difficult to use. Can you improve it?
Yes. I can reorganize, redesign and improve an existing spreadsheet to make it cleaner, easier to use and more efficient. I can also add formulas, validation and automated calculations where needed.
Can you automatically calculate grades and student performance?
Yes. I can create formulas for totals, averages, percentages, grades, pass/fail results, rankings and other calculations based on your grading system.
Can you create an attendance tracker that calculates attendance automatically?
Yes. I can create daily, weekly, monthly or term-based attendance trackers that calculate attendance totals, percentages and absence records automatically.
Can you combine grades, attendance and student records into one system?
Yes. Depending on your package and requirements, I can create connected sheets that organize multiple parts of your school records in one structured system.
Can you create a dashboard for school or student performance?
Yes. I can create a custom dashboard with summaries, key statistics, charts and performance information to help you understand your data more easily.
I don't know exactly how the spreadsheet should be structured. Can you still help?
Yes. Simply explain what you currently do and the problem you want to solve. I can help structure the spreadsheet around the information you need to track.
Can you work with my existing Excel or Google Sheets file?
Yes. You can provide your current file, and I can improve, fix, organize, automate or redesign it based on your requirements.

