
Create an Excel or Google Sheets tracker
- Views 2
What you get with this Offer
I can create a clear, practical Excel or Google Sheets tracker designed around your specific workflow, with formulas, dropdowns, conditional formatting and automated status indicators where needed.
For example:
- Staff training trackers
- Training/compliance matrices
- Appointment trackers
- Follow-up trackers
- Task management
- Client databases
- Stock/inventory trackers
- Deadline trackers
- Simple dashboards
- Data organisation
Basic (included in price):
- 1 spreadsheet
- Up to 2 worksheets
- Up to 50 rows of existing data
- Basic formulas
- Basic formatting
- Filters
- 1 revision
Get more with Offer Add-ons
-
I can add an additional worksheet
Additional 1 working day
+$13 -
I can add advanced automation - more complex formulas, status calculations, or date-based logic
Additional 1 working day
+$20 -
I can add automatic colour coding for dates, statuses, or criteria
Additional 1 working day
+$13 -
I can include a built in dashboard, showing summaries, key figures or progress
Additional 1 working day
+$20 -
I can convert the spreadsheet into both platforms
Additional 1 working day
+$13 -
I can organise, standardise, and remove obvious inconsistencies from your existing data before adding it
Additional 1 working day
+$20 -
I can transfer existing information from another spreadsheet/document into the new tracker
Additional 1 working day
+$20 -
I can customise the spreadsheet using your organisations colours, logo, and preferred style
Additional 1 working day
+$13 -
I can deliver all work in 1 working day
+$67
What the Freelancer needs to start the work
Please provide the following information so I can create your tracker:
1. Platform
Would you prefer your tracker in Microsoft Excel or Google Sheets?
2. Purpose
What will the spreadsheet be used to track?
3. Information & Columns Required
Please list the information you need included. If you have an existing spreadsheet, form, template, or example, you can upload it instead.
4. Workflow/Rules
Please explain what should happen when information changes. For example:
- What should signal a colour and/or symbol change?
- When should something become overdue?
- Are there deadlines or follow-up periods?
- Should completed items change status?
- Should anything be hidden or flagged?
5. Preferred Colours
If you have any specific colours or meanings for statuses, please provide them.
6. Example Data
Please provide a small sample of the information the tracker will contain.
*please don't send sensitive or personally identifiable information unless it is necessary and an appropriate secure method has been agreed.
7. Existing Branding
- If you'd like the tracker to match your organisation branding, please provide your logo, colours, or style guide.
8. What would you like the finished tracker to make easier for you?
If you're unsure how the spreadsheet should be structured, that's okay. Send me your existing information/process and explain what you're trying to achieve. I can suggest a practical structure before building it.