I will fix excel formulas, xlookup and pivot tables

India

I speak English

4 orders completed

Excel Automation, Dashboard Specialist , Power Query, VBA, Power BI

Excel & data automation specialist. I turn messy, large-scale data into clean, automated dashboards and reports — using Power Query, VBA, advanced formulas, and Power BI. My background is in enterpris...
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