I will create a custom excel tracker with formulas and dropdowns
About this Gig
Hi, I'm Alex! I'm a college student who enjoys making spreadsheets organized and easier to use.
I will customize one of my assignment, job-application or inventory trackers with your labels, colors, dropdown choices and simple formulas.
This package includes:
- One .xlsx worksheet with up to 10 columns and 100 prepared entry rows
- Your title, labels and color preference
- Up to 2 dropdown lists, 2 basic calculated columns and 5 summary figures
- Clear status colors and a short usage guide
- One revision within the original agreed scope
Please message me first with what you want to track, your columns and the calculations you need. We will agree on the rules before I begin.
This package customizes an existing sample. Macros, VBA, external connections, email reminders, multiple sheets, data entry and complex dashboards are outside this offer. For Google Sheets or an older Excel version, message me before ordering so we can check compatibility.
I use reusable templates and automation, with AI assistance where permitted. Each order is adapted and reviewed for your requirements.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Functions
•
Data validation
FAQ
Is this a ready-made template or a custom order?
This starter package customizes one of my three sample trackers with agreed labels, colors, dropdown choices and simple calculations. A brand-new structure needs a separate quote. The gallery shows fictional samples, not previous client work.
What does the $15 package include?
One Excel worksheet with up to 10 columns, 100 prepared entry rows, 2 dropdown lists, 2 basic calculated columns, 5 summary figures, conditional formatting and a short guide.
Will it send reminders or connect to other apps?
No. Status indicators appear in the workbook. Email notifications, macros, VBA and external connections are outside this package.
Does it work in Google Sheets?
The delivery is an Excel .xlsx file. Other apps can handle features differently, so tell me before ordering if you need Google Sheets or another spreadsheet app.
Can I add more rows?
The package includes formulas and validation for 100 prepared rows. Larger capacity or a different structure should be agreed before ordering. Simply typing below the prepared range may not update the summaries.
What does a revision include?
One round of changes or corrections within the original agreed requirements. A new workflow, extra sheet or additional features need a separate scope.
Do you use AI or automation?
I use templates and automation, and may use AI assistance where permitted. I review the result and respect any tool restrictions agreed before the order.

