I will fix complex excel formulas, vlookup, and index match

Australia

I speak English

Excel and Project management

With over 30 years of experience in business transformation and migration, I am a Senior Program Manager and Excel Expert dedicated to solving complex data challenges. I specialize in delivering high-...
About this Gig

Are you struggling with messy data, broken formulas, or repetitive manual tasks in Excel?

Look no further! I specialize in turning complex data into clean, efficient, and fully automated Excel solutions designed to save you hours of work.

What I Can Do For You:

  • Formulas & Functions: VLOOKUP, XLOOKUP, INDEX/MATCH, nested IFs, SUMIFS, dynamic array formulas, and error fixing.
  • Automation & VBA: Custom Macros, User Forms, automated workflows, and one-click data cleaning.
  • Interactive Dashboards: Dynamic charts, KPIs, slicers, pivot tables, and visual reporting for executive presentations.
  • Data Cleaning & Formatting: Removing duplicates, splitting/merging cells, text-to-columns, conditional formatting, and standardizing layouts.
  • Templates & Financial Models: Invoice generators, inventory trackers, budget templates, sales trackers, and project management sheets.
  • Data Integration: Importing/exporting CSVs, connecting external data sources, and Power Query transformations.

Why Choose Me?

  • Clean & Well-Organized: User-friendly design that anyone on your team can navigate easily.
  • Fast & Reliable: Clear communication and prompt delivery.
  • Post-Delivery Support: Free minor adjustments.

Platform:

Excel

Development technology:

VBA

Excel

VLOOKUP

Expertise:

Formulas

Functions

Macros

Dashboard

Modeling

My Portfolio

Related tags