I will create an excel template, inventory tracker or dashboard
Excel Dashboards, Google Sheets Automation and Python Data Cleaning
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
FAQ
Can you build it in Google Sheets instead of Excel?
Yes, on request. A few features work differently in Sheets, so message me before ordering and I will confirm what carries over.
Can I edit it myself later?
Yes. Input cells are colored, a How to Use tab explains each part, and nothing is password-locked unless you ask.
Do you use macros or VBA?
No. Formulas only, so there are no macro security warnings. If a task really needs automation, I will tell you before you order.

