I will build excel or google sheets formulas, dashboards and automation
MetaTrader MQL4 and MQL5 EA Developer
About this Gig
Tired of copying data by hand, broken formulas, or a spreadsheet only you understand?
I build clean, working spreadsheets in Microsoft Excel and Google Sheets:
Fix or write formulas: XLOOKUP/VLOOKUP, INDEX/MATCH, SUMIFS, FILTER, QUERY, IF logic, date maths
Dashboards with KPIs, charts and drop-down filters
Trackers and templates: sales, inventory, budgets, invoices, time sheets, CRM lists
Data cleanup: duplicates, split/merge columns, consistent formats
Automation: Google Apps Script or Excel macros/Power Query where suitable
Conditional formatting, data validation and protected input cells
How I work: you send the file (or a copy with sample data) and what you need. I confirm the scope, build it, test it and deliver it with short notes on how to use it.
Simple, documented and easy to maintain. No hidden sheets you can't understand.
Not sure which package fits? Message me with your file and goal before ordering.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Fixing
•
Formulas
•
Macros
•
Dashboard
•
Charts
FAQ
Do you work with my existing file?
Yes. Send a copy and I'll work on it without changing your original structure unless you ask me to.
Do you write Apps Script / VBA macros?
Yes, for automation that formulas cannot handle. Google Sheets uses Apps Script; Excel uses VBA or Power Query.
Is my data kept private?
I only use your file for your order and don't share it. You can send dummy data if you prefer.
What if I need changes later?
Revisions are included per package; bigger new features can be a custom offer.
Can you convert Excel to Google Sheets (or the reverse)?
Yes. I'll flag any feature that doesn't transfer and replace it with an equivalent.
Do you do data entry?
Small cleanup is included; large manual data entry is quoted separately.
