Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Revamp Excel code to speed up leave tracking and modernise the dashboard.
- Company: A dynamic workplace seeking Excel whizzes to optimise workflows.
- Benefits: Flexible hours, remote work, and a chance to enhance your coding skills.
- Why this job: Make a real difference by streamlining processes and showcasing your Excel expertise.
- Qualifications: Proficiency in Microsoft Excel, VBA, and experience with Excel Online.
- Other info: Short-term contract with potential for future projects.
The predicted salary is between 500 - 1500 £ per month.
My worksheet tracks leave but the formula is slow because I have unintentionally designed it to reprocess the same large datasets repeatedly. Every time Excel loops through a staff member or a date, it runs multiple FILTER operations across the entire leave table. The logic itself is correct, but Excel ends up scanning the same ranges thousands of times, and it isn’t built to cache or optimise that kind of repeated work inside nested MAP and MAKEARRAY functions.
On top of that, I’ve added a lot of text-cleaning and matching steps such as LOWER, TRIM, SUBSTITUTE, TEXT, MATCH and all of those get recalculated inside the same loops. None of that work is reused, so Excel does far more computation than necessary. The slowdown isn’t caused by the complexity of the idea; it’s caused by Excel being forced to redo heavy operations instead of calculating them once and referencing the results.
My skills are limited, therefore I need the code rewriting to make it quicker and also possible for it to be for Excel Online. Finally, I want my monthly leave table redesigning to make it look more modern, but I can do that if time is constrained.
There are two tables: leave table and staff table. The leave table has macros and an entry input form. The formula makes the leave dashboard by:
- Determining the month
- Building a weekday-only calendar
- Filtering staff
- Extracting and processing leave records
- Building a day-by-day leave matrix
- Inserting weekend gaps
- Adding headers
- Outputting a complete table
It’s a full calendar generator + leave engine built entirely inside a single formula. I have attached samples of what I would like the dashboard to look like but I am able to do this if it is too much work. I also have macros which filter the table.
Contract duration of less than 1 month.
Mandatory skills: Microsoft Excel, Visual Basic for Applications, Excel online
My excel A/L spreadsheet code is too slow, need it making faster employer: FreelanceJobs
Contact Detail:
FreelanceJobs Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land My excel A/L spreadsheet code is too slow, need it making faster
✨Tip Number 1
Network like a pro! Reach out to your connections and let them know you're on the hunt for a new gig. You never know who might have the inside scoop on a job that’s perfect for you.
✨Tip Number 2
Nail that interview prep! Research the company, practice common interview questions, and think about how your skills can solve their problems. Confidence is key, so get ready to shine!
✨Tip Number 3
Show off your skills! If you’ve got a portfolio or examples of your work, bring them along to the interview. It’s a great way to demonstrate what you can do and make a lasting impression.
✨Tip Number 4
Don’t forget to follow up! After an interview, shoot a quick thank-you email to express your appreciation. It keeps you on their radar and shows you’re genuinely interested in the role.
We think you need these skills to ace My excel A/L spreadsheet code is too slow, need it making faster
Some tips for your application 🫡
Show Off Your Excel Skills: Make sure to highlight your experience with Microsoft Excel and VBA in your application. We want to see how you've tackled similar challenges before, especially if you've optimised spreadsheets or created dashboards.
Be Clear About Your Approach: When describing how you'd improve the current spreadsheet, be specific about your strategies. We love seeing a clear thought process, so don’t hesitate to share your ideas on caching data or reducing repetitive calculations.
Keep It Relevant: Tailor your application to focus on the skills and experiences that are most relevant to this role. If you’ve worked on projects involving leave tracking or calendar generation, make sure to mention those!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep everything organised and ensures your application gets the attention it deserves!
How to prepare for a job interview at FreelanceJobs
✨Know Your Excel Inside Out
Make sure you brush up on your Excel skills, especially around formulas and VBA. Understand how to optimise functions like FILTER and how to avoid unnecessary recalculations. Being able to discuss specific strategies for improving performance will show that you're not just familiar with the tool, but that you can also think critically about its use.
✨Showcase Your Problem-Solving Skills
Prepare to discuss how you've tackled similar challenges in the past. Think of examples where you've optimised a slow spreadsheet or improved a process. This will demonstrate your ability to analyse problems and come up with effective solutions, which is exactly what the company needs.
✨Bring Examples of Your Work
If possible, bring along examples of your previous Excel projects, especially those involving complex formulas or VBA. This will give you a chance to showcase your skills and provide tangible evidence of your capabilities. Just make sure to explain your thought process behind each project.
✨Ask Insightful Questions
Prepare some thoughtful questions about the role and the company's approach to Excel and data management. This shows your genuine interest in the position and helps you understand their expectations better. For instance, ask about their current challenges with Excel or how they envision the ideal candidate contributing to their team.
