I will fix excel formulas, xlookup and pivot tables
Excel Automation, Dashboard Specialist , Power Query, VBA, Power BI
About this Gig
Formula giving #N/A, #VALUE or wrong totals? Send me your sheet and I'll fix it.
I work with Excel and Google Sheets every day as an ERP and reconciliation analyst, on files with 50,000+ rows.
I can help with:
- XLOOKUP, VLOOKUP, INDEX MATCH
- - SUMIFS, COUNTIFS, IF, nested formulas
- - Pivot tables and summary reports
- - Duplicate checks and data validation
- - Power Query cleanup
You get the fixed file plus a short note explaining what was wrong.
Message me with your file before ordering.
Platform:
Excel
•
Google Sheets
•
Power BI
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Functions
•
Dashboard
My Portfolio
FAQ
What counts as one formula for the $5 package?
One formula logic, even if it is copied down thousands of rows. Message me your file first and I'll confirm the right package.
Do you work in Google Sheets too?
Yes. Excel (365 and older versions) and Google Sheets. Share a view-only copy or upload the file.
Can you work with large files?
Yes. I regularly handle 50,000+ row stock and transaction files, and use Power Query when formulas get too slow.
