Browse categories
Explore
Fiverr Pro
English
$
USD
I will fix excel errors, repair power query connections, and optimize dax
Modern Excel and Automation Specialist
Welcome! I am a Modern Excel & Automation Specialist. I don't just build spreadsheets.
As an Excel Specialist and Data Analyst, I design scalable data models and automated pipelines.
Instead of slo...
About this Gig
Excel Troubleshooting, Formula Repair & Error Fixing:
Is your Excel sheet throwing #REF!, #VALUE!, or #N/A errors? Is your Power Query refresh crashing, or is your Power Pivot Data Model running painfully slow?
I will diagnose, repair, and optimize your broken Excel workbooks, queries, and data models to get them running smoothly and accurately.
What I Can Do For You:
- Fix Broken Queries & Paths: Repair broken source paths and data source errors in Power Query.
- Formula & DAX Repair: Debug complex XLOOKUP, SUMIFS, INDEX/MATCH, and broken DAX expressions.
- Performance Optimization: Optimize heavy data models and DAX measures to eliminate lag and speed up workbook recalculations.
- Data Integrity & Audit: Identify hardcoded overrides, fix formula inconsistencies, and add data validation rules to prevent future errors.
Platform:
Excel
Development technology:
Power Query
•
Excel
•
DAX
Expertise:
Formatting
•
Pivot tables
•
Formulas
•
Functions
•
Power Query
FAQ
Why is my Power Query throwing a "Privacy Levels" error on refresh?
This happens when merging data across different sources with conflicting security settings. I reconfigure query privacy rules to fix this safely.
Can you fix slow workbook calculations and freezing?
Yes. I replace heavy array formulas with fast Power Query calculations and optimize DAX measures to restore speed.
How do we get started if my sheet contains sensitive company data?
You can anonymize sensitive client names or figures with dummy data before sending the file.
