I will fix formulas and build trackers in excel or google sheets
About this Gig
Broken formulas? A spreadsheet that's grown into a mess? A tracker you keep meaning to build?
I fix and build Excel and Google Sheets files carefully, and I explain every change so you can maintain it yourself.
What I can do:
- Fix #N/A, #REF!, #VALUE! and wrong totals
- XLOOKUP, VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, FILTER, QUERY
- Trackers for budgets, stock, jobs, bookings, invoices or habits
- Dropdowns, conditional formatting, protected input cells
- Simple summary dashboards and charts
How I work:
1. You send the file (or a copy with dummy data) and describe the problem.
2. I confirm exactly what's included before you order.
3. I test every formula against your data and check the edge cases.
4. You get the file plus a short change log explaining what I did and why.
Please message me before ordering so I can confirm the scope. Not included: macros/VBA, Apps Script, live calls or work inside your systems.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
VLOOKUP
Expertise:
Fixing
•
Formulas
•
Functions
•
Dashboard
•
Data validation
FAQ
Excel or Google Sheets?
Either. Tell me which one you use, and which version of Excel if you know it, because some functions (like XLOOKUP) don't exist in older versions.
Do you need my real data?
No. A copy with names and figures chanegd works fine, as long as it has the same layout.
Can you write macros or Apps Script?
Not in this gig. I build with formulas so the file keeps working without code.
What if my request if bigger than a package?
Message me and I'll send a custom offer with a fixed price and delivery date before you pay anything.
Can we talk on a call?
I work in writing only, which also gives you a record of everything agreed.

