Freelance Excel Consultant – Event Dashboard Audit & Optimisation | 2-4 weeks
Posted 1 week ago by Threshold Sports
Negotiable
Undetermined
Remote
United Kingdom
Summary: The role of Freelance Excel Consultant involves auditing and optimizing a Public Event Dashboard used for tracking participant numbers and revenue in mass participation events. The consultant will address formula inconsistencies and data integrity issues while enhancing usability for non-technical users. The position is remote and is expected to last between 2 to 4 weeks. The consultant should have proven experience in advanced Excel modeling and data reconciliation.
Key Responsibilities:
- Conduct a comprehensive audit of the Excel-based dashboard
- Identify and fix broken formulas, logic errors, and structural weaknesses
- Improve data integration from the registration platform
- Enhance usability for non-technical users (e.g. colour coding, error flags)
- Optionally recommend automation to improve efficiencies and accuracies (Power Query, VBA, or Google Sheets)
Key Skills:
- Proven experience in advanced Excel modeling
- Strong understanding of cross-tab logic, financial dashboards, and data reconciliation
- Experience working with event registration data or e-commerce-style reporting
- Familiarity with Power Query, VBA, or Google Sheets scripting (bonus)
- Clear communication and documentation skills
Salary (Rate): undetermined
City: undetermined
Country: United Kingdom
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
We're Hiring: Freelance Excel Consultant – Event Dashboard Audit & Optimisation
Location: Remote
Contract: Short-term freelance
Start Date: ASAP
Duration: 2–4 weeks
Sector: Events / Sports / Charity / Data Analytics / Finance
The Opportunity
We’re looking for an experienced Excel consultant or data analyst to audit and optimise our Public Event Dashboard, a critical tool used to track participant numbers, revenue, and projections across our flagship mass participation endurance events. This dashboard integrates data from our registration platform and supports monthly reconciliation with our finance system (Xero). Since transitioning platforms, we’ve encountered formula inconsistencies and data integrity issues that need expert attention.
What You’ll Do
- Conduct a comprehensive audit of our Excel-based dashboard
- Identify and fix broken formulas, logic errors, and structural weaknesses
- Improve data integration from our registration platform
- Enhance usability for non-technical users (e.g. colour coding, error flags)
- Optionally: Recommend automation to improve efficiencies and accuracies (Power Query, VBA, or Google Sheets)
What You’ll Need
- Proven experience in advanced Excel modelling
- Strong understanding of cross-tab logic, financial dashboards, and data reconciliation
- Experience working with event registration data or e-commerce-style reporting
- Bonus: Familiarity with Power Query, VBA, or Google Sheets scripting
- Clear communication and documentation skills
Deliverables
- A written audit report with findings and recommendations
- An updated version of the dashboard with improved structure and logic
- A handover guide or Loom walkthrough for internal teams
How to Apply
Please email careers@ThresholdSports.co.uk with:
- An up-to-date CV
- A short cover letter / introduction highlighting relevant experience
- Examples of similar work (screenshots or links welcome)
- Your availability and rate (fixed or hourly)
- Any initial thoughts on how you’d approach the audit
This is a great opportunity to work with a purpose-driven team delivering mass participation events with impact. If you love solving data puzzles and making spreadsheets sing, we’d love to hear from you.