I will fix excel and google sheets formulas, automate spreadsheets
Excel Automation, Dashboards and WordPress Specialist
About this Gig
Need help fixing a broken spreadsheet or automating repetitive work?
I will troubleshoot, repair and automate Microsoft Excel or Google Sheets files using formulas, functions and advanced spreadsheet tools.
Depending on your package, I can help with:
- Fix #N/A, #REF!, #VALUE!, #DIV/0! and incorrect results
- XLOOKUP, VLOOKUP, INDEX MATCH, IF, IFS, SUMIFS, COUNTIFS and dynamic formulas
- Cross-sheet calculations and complex formula logic
- Data validation, dropdowns and conditional formatting
- Pivot tables, charts and reports
- VBA macros and Excel automation
- Google Apps Script and Google Sheets automation
- Power Query imports, merges and transformations
- Buttons, forms and custom menus
- Data source connections and recurring workflows
- Spreadsheet troubleshooting and performance improvements
- Documentation for advanced systems
Every solution is built to be practical, reliable and easy to maintain, with clear logic and a clean structure tailored to your workflow and goals and future use.
Python, Power BI or DAX support may be available through a custom offer when relevant.
Please send your file, error details and required result before ordering complex work.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Power Query
Expertise:
Fixing
•
Formulas
•
Functions
•
Macros
•
Power Query
My Portfolio
Other Data Processing Services I Offer
FAQ
What types of Excel or Google Sheets problems can you fix?
I can fix broken or incorrect formulas, lookup errors, cross-sheet calculations, validation issues, PivotTables, VBA macros, Apps Script, Power Query workflows and other spreadsheet automation problems depending on complexity.
What counts as one formula in a package?
One formula means one distinct formula or calculation requirement. The same formula copied across many rows or cells normally counts as one formula unless each row requires different logic.
Can you fix formulas that already exist in my workbook?
Yes. You can send your existing Excel or Google Sheets file and explain the error or expected result. I can troubleshoot and repair the existing formulas instead of rebuilding everything from scratch.
Can you create VBA macros, Apps Script, buttons or forms?
Yes. Depending on your package, I can create or repair VBA macros, Google Apps Script, buttons, forms, controls and custom menus for spreadsheet automation. Complex systems may require a custom offer.
Can you use Power Query and connect external data sources?
Yes. I can use Power Query to import, clean, merge, append and transform data from supported files, folders, tables and compatible sources. Complex connections or external APIs should be discussed before ordering.
Do I receive the VBA or Apps Script source code?
Yes. If custom VBA or Apps Script code is created for your order, the relevant source code is included with the delivery.
Can you work with PivotTables, charts and data validation?
Yes. I can create or repair PivotTables, charts, dropdowns, validation rules, conditional formatting and related spreadsheet features when they are part of the agreed scope.
Can you help with Python, Power BI or DAX?
Potentially, yes. These are not the main focus of this Gig, but related Python, Power BI or DAX work may be available through a custom offer after reviewing the requirements.
What should I send before you start?
Please send the spreadsheet, describe the problem, show any error messages, explain the expected result and provide sample output if available. For complex automation, contact me before ordering.
Can you work on a Google Sheet that is already online?
Yes. You can share the relevant file or an accessible Google Sheets link through Fiverr. Please provide only the access needed for the project and keep all project communication on Fiverr.

