I will build an automated excel reconciliation and data comparison tool

Indonesia

I speak English, Indonesian
I have an experience on using excel for a daily basis and can be a great way to be your admin that using excel for your needs. I used to expose on some basic and intermediate level of formula on excel...
About this Gig

Do you manually cross-check two lists in Excel orders vs. deliveries, planned vs. actual, budget vs. spend and waste hours copy-pasting and eyeballing mismatches?

I build automated Excel tools that compare two datasets and instantly flag every discrepancy missing items, quantity mismatches, unexpected entries color-coded and ready to review. No manual VLOOKUP-ing row by row.

What you get:

  • A working Excel file with your real data structure
  • Automatic matching between two sheets (any two lists you need compared)
  • Clear status flags (e.g. Matched / Missing / Under / Over / Unexpected)
  • Color-coded results so issues jump out visually
  • Compatible with Excel, LibreOffice, and WPS Office no special add-ins needed
  • A simple instructions tab so your team can use it without me

I have hands-on experience in retail inventory control and internal audit, so I understand messy real-world data partial deliveries, duplicate entries, missing references not just clean textbook examples.

Platform:

Excel

Development technology:

Python

Excel

VLOOKUP

Expertise:

Pivot tables

Formulas

Dashboard

Cleaning