I will create google sheets and excel formulas and dashboards
Landing pages, Russian English translation and spreadsheets
About this Gig
I fix broken formulas and build Google Sheets and Excel files for small businesses and individuals.
I can:
- write formulas such as XLOOKUP, VLOOKUP, SUMIFS, IF, QUERY and ARRAYFORMULA
- find and fix errors in your existing file
- build trackers for budgets, inventory, sales, projects or clients
- add pivot tables, summary tables and charts on a dashboard tab
- clean data: remove duplicates, fix formatting, split or merge columns
In Standard and Premium you also get short instructions, so you can keep using the file on your own. I revise the file until it works the way you need.
I don't write VBA macros or scripts, and I don't build Power BI reports or complex financial models.
Please message me with your file or task before ordering so I can confirm the scope.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Dashboard
•
Cleaning
FAQ
Do you work with Google Sheets and Excel?
Yes, both. Tell me which one you use and which version of Excel, if relevant.
Can you fix formulas in my existing file?
Yes. Send me a copy of your file and describe what is not working, and I will fix it.
Do you create VBA macros or scripts?
No, I work with formulas, pivot tables, charts and dashboards. Macros and scripts are not included.
