I will create and fix google sheets formulas and spreadsheet errors

Indonesia

I speak English

Data Analyst, Excel, SQL, Retail Analytics, Inventory Analytics

Data Analyst with 3+ years of experience I work with: Excel, Google Sheets, SQL, Power Query and Power Pivot. My focus: Sales analytics, inventory analysis, assortment analytics, SKU performance, st...
About this Gig

Need help with broken formulas or time-consuming calculations in Google Sheets?


I will create, fix and test formulas so your spreadsheet delivers clear, reliable results.


I can help with:

  • IF, IFERROR, SUMIFS and COUNTIFS
  • VLOOKUP, XLOOKUP and INDEX/MATCH
  • FILTER, QUERY and ARRAYFORMULA
  • Date, text and lookup calculations
  • Dropdowns, data validation and conditional formatting


Packages:

BASIC Up to 3 simple formulas in one file, with testing and a brief explanation.

STANDARD Up to 7 formulas in one file, with data validation and usage notes.

PREMIUM Up to 15 formulas across tabs in one file, with validation, conditional formatting and a user guide.


You will receive an editable Google Sheets file with working formulas.


Each unique formula counts as one; copying it down multiple rows does not count as additional formulas. Revisions cover adjustments to the agreed requirements.


Apps Script, dashboards and external integrations are outside this gig's scope.


Please message me with a sample file and your expected result before ordering, especially for complex formulas or large existing spreadsheets.

Platform:

Google Sheets

Development technology:

VLOOKUP

Expertise:

Formatting

•

Fixing

•

Formulas

•

Functions

•

Data validation

My Portfolio

Other Data Processing Services I Offer