I will create an excel template, inventory tracker or dashboard

South Korea

I speak Korean, Japanese, English

Excel Dashboards, Google Sheets Automation and Python Data Cleaning

I build Excel tools that do the math for you, and Python scripts that turn messy CSV exports and PDF invoices into clean Excel reports. My portfolio shows demo projects with fictional data: a sales da...
About this Gig

Tell me how you track sales, stock or quotes today, and I'll turn it into an Excel file that does the math for you. You enter data once; totals, lookups, reorder flags and the monthly dashboard update automatically.


Good fits:

  • Sales or expense log with a monthly dashboard
  • Inventory tracker with low-stock flags and reorder quantities
  • Quote and invoice template with a price-list drop-down
  • Fixing broken formulas or tidying up an existing sheet

Formulas only (no macros), with drop-down lists, input checks, colored input cells, a How to Use tab and print-ready pages. The gig images show demo projects with fictional data.


Need Google Sheets instead? Message me before ordering: a few features work differently in Sheets.


How I work: the formulas are built and tested with Claude, an AI agent on my PC (wrong inputs and totals checked against a separate calculation) before delivery. I review the results and handle all messages. I build with sample data; your real data doesn't go into AI tools unless you agree. Updates by message, no calls needed.

Platform:

Excel

•

Google Sheets

Development technology:

Excel

•

VLOOKUP

Expertise:

Fixing

•

Formulas

•

Dashboard

•

Charts

•

Data validation

Other Data Processing Services I Offer