Expected duration: 3 - 4 weeks We are seeking an experienced Excel and automation specialist to take over, troubleshoot, and enhance an existing data management tool, as well as implement automation for invoicing and customer communications.
This project involves improving an Excel-based system currently used to manage student course data, alongside building a streamlined workflow for generating invoices and sending confirmation emails.
An Excel-based tool has already been developed to extract and organise course sales data. It captures key student information, including:
* Full name * Date of birth * Address * Enrolled course * Course start and end dates
**Current functionality includes:**
* Generating student name lists for class registers * Exporting student data for certification purposes * Structuring data for upload to a governing body platform
**Current issue:** The data refresh function is not working correctly. When attempting to update the dataset with the latest orders, an error alert appears and the refresh fails.
**Requirements:**
* Diagnose and fix the refresh/data connection issue * Review and optimise the existing tool * Ensure reliable and efficient data updates * Improve usability where necessary
**Part 2: Invoice & Email Automation**
We also require automation of our invoicing and confirmation email process.
**Current workflow:**
* Order/customer data is exported from our WordPress website * Invoices and confirmation emails are created and sent manually
**Requirements:**
* Automatically generate invoices using order data * Create professional invoice templates (PDF format preferred) * Automatically send confirmation emails to customers * Emails must include accurate course and student details (course name, dates, etc.) * Attach invoices to emails where applicable
**Integration & Workflow:**
* The solution must work with our existing WordPress data exports (CSV format) * We are open to the best technical approach (Excel, Power Automate, VBA, Zapier, Make, or other solutions) * The system should be reliable, easy to use, and suitable for ongoing operational use
**Deliverables:**
* Fully functional and stable Excel tool with working data refresh * Automated invoice generation system * Automated email confirmation system * Clean templates for invoices and emails * Documentation or handover instructions
Please Include in Your Proposal:
* Relevant experience (Excel automation, Power Query, VBA, APIs, or workflow tools) * Examples of similar projects * Your proposed approach/tech stack * Estimated timeframe * Cost estimate
We are looking for someone who can take ownership of this project, resolve existing issues, and deliver a reliable, long-term solution.
Academic Research & Writing in Education/Social Sciences Category: Academic Research, Academic Writing, Data Analysis, Editing, Project Management, Proofreading, Qualitative Research, Research, Research Writing, Statistical Analysis Budget: $30 - $250 USD
31-May-2026 21:48 GMT
AEO / GEO Expert Needed to Increase AI Search Visibility Category: AI Content Creation, AI Development, AI Model Development, AI Research, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO Budget: $15 - $25 USD
31-May-2026 21:47 GMT
30-Hour Daycare Training Course Category: Content Development, Education & Tutoring, Educational Research, Instructional Design, Learning Management Systems (LMS), Teaching / Lecturing, Training, Training Development Budget: $10 - $30 USD
31-May-2026 21:47 GMT
Scrolling Web Page Development Category: CSS, HTML, HTML5, JavaScript, Parallax Scrolling, Web Design, Web Development Budget: €750 - €1500 EUR
31-May-2026 21:44 GMT
Family Law Motions Filing Category: Employment Law, Family Law, Legal, Legal Analysis, Legal Assistance, Legal Consultation, Legal Research, Legal Writing, Paralegal Services Budget: $30 - $250 USD
31-May-2026 21:43 GMT
Chico-based Document Verification Task Category: Admin Support, Customer Service, Data Entry, Documentation, Local Job, Public Relations, Report Writing, Research, Time Management Budget: $30 - $250 USD