I will fix or build complex excel formulas and custom functions
Great with people and machines, ensuring the machines serve the people
About this Gig
I'll fix, build, or improve Excel formulas, custom functions, and VBA automations to make your spreadsheets faster, cleaner, and error-free.
If you're stuck with a broken formula, circular reference, or confusing logic that refuses to cooperate, Ill diagnose the cause and deliver a simple, working solution whether its one formula or a full-sheet recalculation.
What I can help with:
- Fixing broken or inaccurate formulas
- Designing efficient nested functions and array formulas
- Creating dynamic named ranges, lookup logic, and conditional rules
- Converting or optimizing formulas for Google Sheets
- Automating repetitive tasks using VBA or macros
- Linking data between multiple sheets or files
- Improving speed and layout for large or slow workbooks
What you can expect:
- Clean, reliable solutions no clutter or hidden dependencies
- Work done directly in Excel or Google Sheets
- Clear communication about options and alternatives
- Safe handling of your data local copies or sanitized samples preferred
- Optional post-fix optimization or documentation add-on
If you're not sure whats wrong, just tell me what you expect to happen and what actually happens I'll take it from there.
Platform:
Excel
•
Google Sheets
•
LibreOffice
Development technology:
VBA
•
Python
•
Power BI
Expertise:
Formulas
•
Functions
•
Macros
•
Dashboard
•
Cleaning
FAQ
Can you work with confidential or sensitive data?
Yes. You can share a sanitized version of your sheet (remove names, IDs, or proprietary details). I can also create a mock-up using your structure to test fixes safely. And if, for some reason, there is no getting around exposure to sensitive info, I treat all client info with confidentiality.
Will you sign a Non Disclosure Agreement (NDA)?
Yes.
What if my issue turns out to be more complex than expected?
I’ll let you know right away before doing extra work. We can adjust the scope, price, or package together — no surprises.
Do you also create new spreadsheets or dashboards from scratch?
Yes, I can design new workbooks, automation, or reporting sheets. Just mention that in your request so we can choose the right package or create a custom offer.
Do you test the work you produce?
Every fix is tested and verified before delivery — you’ll receive a working, ready-to-use file.

